Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need advice on the schema created for the given data format

Hi All,

Business users are providing below data format and expecting a Multibar chart from this. For this, my thought is to create a chart with months as Single dimension and columns in Multi expressions.

Excel Data.PNG.png

I have created a database schema with my little SQL knowledge. The output of the schema is shown below.

DB ER Diagram.PNG.png

Please advice me whether this schema follows the data modelling fundamentals or if any changes need to be implemented.

Brief feedback will be highly appreciated.

Regards,

N.Srinivas

1 Reply
Not applicable
Author

For me, the data model is too normalized, you must think of de-normalizing it and creating facts.

Rest other geeks might have more ideas.

Thanks,

Singh