topic Re: Ideas for data model design using excel files in QlikView

Ideas for data model design using excel files

sudhir0538 — Wed, 25 Nov 2020 16:16:04 GMT

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 !!

Re: Ideas for data model design using excel files

vvvvvvizard — Wed, 14 Nov 2018 10:48:55 GMT

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

Re: Ideas for data model design using excel files

sudhir0538 — Thu, 15 Nov 2018 10:52:28 GMT

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.