Code never lies, comments sometimes do [Ron Jeffries]

Visitors Map

Follow on Twitter

@ZammaCode
Powered by Blogger.

Monday, June 12, 2023

What is Data Modeling in Power BI


  • 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