This course focuses on designing BI Data Models to display in either an interactive Power BI report or an interactive Excel dashboard. This is both a fundamental Power BI course and an advanced Excel course that will take you through a data journey from importing, cleansing, and merging large amounts of data to analyzing the data to presenting strategic data in a PivotTable and a Power BI dashboard. This practical course provides flexibility and empowers you to choose how you want to present your business insights to help management make informed decisions.
Data Models in Excel for Power BI Delivery Methods
In-Person
Online
Data Models in Excel for Power BI Course Benefits
Transform and present sophisticated data to provide Business Intelligence (BI)
Actualize a data model from multiple sources with Power Pivot
Shape and prepare your data with Power Query
Mine and expose hidden information with Data Analysis eXpressions
Communicate business and data insights with Power BI reports and dashboards
Leverage continued support with after-course one-on-one instructor coaching and computing sandbox
Data Models in Excel for Power BI Outline
Important course information
Prerequisites
Experience with Excel at the level of:
Excel Data Analysis Course • course 195
This course is applicable to all versions of Excel, from Excel 2010 to Excel 2021
Module 1: Identifying the Role of Power Pivot in Business Intelligence (BI)
Module 2: Building the Data Model with Power Pivot
Module 3: Shaping Data with Power Query
Module 4: Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language
Module 5: Designing Interactive Power BI dashboards
العربية