Building PivotTable Reports Using Excel’s Data Model in Power Pivot with DAX formulas

Data Modeling Steps in Excel Power Pivot

1.Import data into Power Pivot Data Model

2.Create relationships between the Dimension Tables and Fact Tables

3.Create DAX formulas (Data Analysis Expressions)

  • DAX Measures are used in the Values area of a PivotTable
  • Calculated Columns are used in the criteria for Rows, Columns, and Slicers

4.Hide Tables and Fields not to be used in the PivotTables reports

5.Create PivotTables & PivotCharts

6.Refresh when source data changes

7.Update the Data Model if necessary






About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s