Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to do data model in proper way...
Thanks ,
Vijay...
You have to follow one of the Data Modelling concept like
1. Star Schema
2. Snow Flake Schema
And this are depends on your database that contains tables and views
Regards
Anand
HI Vjay,
as mentioned above there are the 2 types of data model, you may want to look at this post as it containes some useful information Data modeling
Also for more details please go through the attached documents for the Data Modelling concepts
Regards,
Anand
Hi,
Check this
Regards
ASHFAQ
Hi,
Star schemas are optimized for querying large data sets and are used in data warehouses and data marts to support olap cubes, business intelligence and analytic applications, and adhoc queries.
A star schema may be partially normalized snowflaked, with related information stored in multiple related dimension tables, to support specific data warehousing needs.
Of courses fewer tables will make Qlikview perform faster but within QV as long as you avoird circuar referenes and resolve synthetic keys, every kind of modeling is possible, think "associative", one selection in a QV model impact the whole schema then organize your data to meet performances and business requirements that's the best I can advise you.
Rgds,
Michael.
Hi,
Before starting creating the Datamodel, do some rough work like
- Identify the Fact tables
- Identity the Dimension tables and their relation with Fact tables
- Identity the columns to be loaded into the datamodel, don't load unnecessary columns into your datamodel
- Restrict your datamodel to Star schema, because it has a good performance, during runtime less number of joins required.
- Do all possible calculations in the script itself.
- Load only the required data, ie.,, if user wants to analyse last 5 year transactions load only that data by using where condition.
- Using KEEP remove dimension values which has no transactions.
Hope this helps you.
Regards,
Jagan.