Skip to main content

Designing Data Models in Excel for Power BI Reports Training

Code: 1362 Category: Tag:

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



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


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

Request Quotes

Register now

Please type the characters This helps us prevent spam, thank you.

SAFe® Agile Software Engineering Training

Oracle® SQL Training

Are you ready for the EU GDPR?

Impact Mapping Training: Focusing on Business Value in Agile Development

Implementing Cisco Enterprise SD-Branch (ENSDBI)

Advanced Certified ScrumMaster® (A-CSM) Training

Implementing and Operating Cisco Enterprise Network Core Technologies Training

Engineering Cisco Meraki Solutions Bundle (ECMSBC)

The Nutanix Enterprise Cloud Administration (ECA)

CHFI Certification – Computer Hacking Forensic Investigator Training CHFI v10