Help with project design
I work in a basic research lab. We have generated reams of in-vivo and in-vitro data over the past 10 years. My job is to compile all of the data into filemaker pro from 100's of Excel files. The goal is two fold; to have everything in one data set and to be able to select a project number (there are thousands of them) and have all the data about that particular project be availablle for visualization i.e. graphic with summary statistics. I'm at the very start of this journey and would like feedback from you experts on how this should be approached. I am really new to filemaker pro., know Python and Excel macro's, using version 11 on a mac.
You could start by dropping one of the Excel files onto FileMaker and converting it.