Need advice on the schema created for the given data format

Tue, 28 Oct 2014 06:15:04 GMT

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.

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

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

Re: Need advice on the schema created for the given data format

Tue, 28 Oct 2014 06:45:06 GMT

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

topic Re: Need advice on the schema created for the given data format in QlikView

Need advice on the schema created for the given data format

Re: Need advice on the schema created for the given data format