Ideas for data model design using excel files

[sudhir0538]

Hello Community,

I had an excel file where our lab people storing data, for a single day a single sheet has been created and after one month a new excel file is created. Now they wanted to have a dashboard in QV with those excel files. 

Please guide what's the ideal way to fetch the data into using those excel files and building data model for monthwise daywise and yearwise with different analysis in the same excel.

Attached sample excel where they having data of A,B,C,D,E and so on.. Please suggest a way !!

[vvvvvvizard]

Good day

As long as their is a column with the date 01/02 /03 ect on each sheet , all the sheets with numbers  can be looped over and concatenated into one  Fact table . 

Sheets that are non numerical can be concatenated into a DIM_Client ex table. Can be linked by date to the other table

Regards

Yusuf

[sudhir0538]

Hi , Thanx for the info provided. It would be good if you can provide a detail work around with the existing data itself step by step.