Please enable JavaScript.
Coggle requires JavaScript to display documents.
Power BI - Coggle Diagram
Power BI
Data modeling
What
Data modeling is the process of creating a data model for the data to be stored in a database.
Use For
To assist business analysts, programmers, testers, manual writers, IT package selectors, engineers, managers,....
To manage data as a resource
To design databases/data warehouses
Methods
Bottom-up
The bottom-up approach begins with the specific details and moves up to the general.
top-down
The top-down method starts from the general and moves to the specific
Type
Hierarchical Data Modelling
Relational Data Modelling
Entity-Relationship (ER) Data Modelling
Object-Oriented Data Modelling
Dimensional Data Modelling
Star Schema
the fundamental schema among the data mart schema and it is simplest
Fact Table: It contains all the primary keys of the dimension and associated facts or measures
Dimension Table: It is a table that collects fields containing descriptions of business elements and is referred by multiple fact tables
Snowflake Schema
a variant of the star schema
Data source & Relationship
Power Query & DAX
Chart
Power BI Service