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 flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
10 - 11 Mar
9:00 AM - 4:30 PM GMT
Online (AnyWare)
23 - 24 Jun
9:00 AM - 4:30 PM BST
Online (AnyWare)
1 - 2 Sep
9:00 AM - 4:30 PM BST
Online (AnyWare)
1 - 2 Dec
9:00 AM - 4:30 PM GMT
Online (AnyWare)
26 - 27 Apr
2:00 PM - 9:30 PM BST
Online (AnyWare)
25 - 26 Oct
2:00 PM - 9:30 PM BST
Herndon, VA / 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 TrainingAnalysing Data with Excel Training (20779)
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.