There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
This course focuses on designing BI Data Models to display in either an interactive Power BI report or in an interactive Excel dashboard. This advanced Microsoft Excel/fundamental Power BI course will take you through a data journey from importing, cleansing and merging large amounts of data to analysing the data to presenting strategic data in a Power BI dashboard. This is a practical course designed to provide flexibility and to empower you to choose how you want to present your business insights to help management make informed decisions.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Apr 26 - 27
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Aug 9 - 10
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Oct 25 - 26
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Feb 7 - 8
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.Introducing the Business Intelligence Tools
Familiarisation with Power Pivot
Defining a consolidated view of data
Denormalising data to simplify usage within other BI reporting tools
Querying SQL Server data
Fixing common data issues with Power Query
Defining measures for business performance
Implementing DAX functions in Power Pivot
Exploiting data analytics with aggregation
Mining for information with date and time analysis
Setting key business targets with KPIs
Familiarisation with the Power BI Architecture
Building a Power BI dashboard
The current version (2010) is used in this course.
Excel Data Analysis TrainingAnalyzing Data with Excel Training (20779)
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.