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

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

Request Quotes

Register now
CAPTCHA image

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

Introduction to Business Analysis Training: Defining Successful Projects

Professional Services Professional: Technical Authority Training

Introduction to Kanban Training – Smoothing Development Workflow

Cybersecurity Maturity Model Certification (CMMC) Training Course

Kanban Management Professional Training (KMP-II Certification)

Administering Microsoft Azure SQL Solutions (DP-300)

Deploying Cisco Connected Mobile Experiences (WCMX)

Planning & Designing Databases on AWS

Red Hat OpenStack Administration I (CL110) Training

WebSphere Application Server V9 Administration in a Federated Environment (WA599G)

arالعربية