Creating data model from single excel file

[#1]

Hi All,

   I am trying to create a ppm kind of project. As a part of data I have single excel sheet which is not at all normalized.

But what I am trying is to create a data model using that excel data by creating multiple tables.  For few I am kinda successful, but I am stuck now.

I need following tables so that I can effectively do calculation on the data:

Project Table

Resource Table

Project_Resource Table

Project Finance Details

So that I can have 3 tabs in my Qlikview : Project, Resource and Finance

These are the essential tables I have thought of till now from data. I have just created scripts to load data and visualize then in table object.

Can please someone suggest something in this kind of model creation. Where am I going wrong or any better approach I should follow

[othniel2014]

I think the first thing you should do before mounting the qlikview, or at least is what I do, it is that you have to create by hand a entity-relationship model. (This is based on your knowledge database, not in QLIKVIEW)

Then you should consider what you want to know the data ...

If, for example, you have a company that processes and sells fish, it may be that you want to find sales of fish per month, the number of pounds sold, the average cost price, etc. Those objectives which is qlikview graphics are created.

This is still not QLIKVIEW, and is more about the knowledge you of the entity or company from which comes the data you have, and what you want to know about it.

On the Internet there are manuals on business processes, business administration, big data analysis etc.

[krishnacbe]

Hi

Hope de-normalized data will be good to analyze more in Qlikview. Try to pull the data as a single table and try to create the tables.

For transformations you can use resident load.

[#4]

Indeed yes. I did the same as the starting point. That is how  I mentioned the Entity names in the Discussion.

The issue while trying to load data as per the ER diagram is that I am getting mutiple role(as the data is not normalised).

I tried by loading specific column with DISTINCT.  The QVW file has table objects to elaborate the issue I am facing