June 12, 2023 asghars
- A Data model is a collection of data, tables, relationship between different tables, formatting rules, calculations/measures, and hierarchies.
- Power Pivot is used for data modeling in Power BI.
- The first step of data modeling is loading of data from Power Query, which are stored in tables in the form of columns.
- A single column usually primary key column is used to define relationships, in Power BI only one-to-many and one-to-one relationships are supported. In Power BI relationships are used for filtering rather than for normalization.
- Formatting rules are used to format the imported data as per our required format for reporting and analysis.
- Measure is a calculated value or expression that performs some calculation on the data to derive meaningful insights.
- Hierarchies in Power BI are a way to organize data in a hierarchical structure. This allows users to drill down from parent levels to lower levels in a specific order. A common hierarchy might be over date data that creates a three-level hierarchy over year, month, and day.
0 comments:
Post a Comment