Power BI - Coggle Diagram
Data modeling is the process of creating a data model for the data to be stored in a database.
To assist business analysts, programmers, testers, manual writers, IT package selectors, engineers, managers,....
To manage data as a resource
To design databases/data warehouses
The bottom-up approach begins with the specific details and moves up to the general.
The top-down method starts from the general and moves to the specific
Hierarchical Data Modelling
Relational Data Modelling
Entity-Relationship (ER) Data Modelling
Object-Oriented Data Modelling
Dimensional Data Modelling
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
a variant of the star schema
Data source & Relationship
Power Query & DAX
Power BI Service