What's Included in this Course?
- LIVE expert-led instruction by Microsoft certified instructor
- Free Microsoft exam prep (180-days access) from Kaplan/Transcender - $129 retail value*
- Labs with hands-on experience (6 month access 24x7) in real virtual environments, not simulations**
- Microsoft Official Courseware (digital, lifetime access)
- Six months access to class lecture recordings
- Free class retakes for 6 months (standby basis)
- Distraction free learning environment at our centers: Knoxville, Chattanooga or Tri-Cities or attend virtually
* subject to availability from Kaplan
Course Details
Course Outline
1 - Introduction to Self-Service BI Solutions
Introduction to business intelligenceIntroduction to data analysisIntroduction to data visualizationOverview of self-service BIConsiderations for self-service BIMicrosoft tools for self-service BILab : Exploring an Enterprise BI solution
2 - Introducing Power BI
Power BIThe Power BI serviceLab : Creating a Power BI dashboard
3 - Power BI
Using Excel as a data source for Power BIThe Power BI data modelUsing databases as a data source for Power BIThe Power BI serviceLab : Importing data into Power BI
4 - Shaping and Combining Data
Power BI desktop queriesShaping dataCombining dataLab : Shaping and combining data
5 - Modelling data
RelationshipsDAX queriesCalculations and measuresLab : Modelling Data
6 - Interactive Data Visualizations
Creating Power BI reportsManaging a Power BI solutionLab : Creating a Power BI report
7 - Direct Connectivity
Cloud dataConnecting to analysis servicesLab : Direct Connectivity
8 - Developer API
The developer APICustom visualsLab : Using the developer API
9 - Power BI mobile app
The Power BI mobile appUsing the Power BI mobile appPower BI embedded
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Other Prerequisites
Before attending this course, students must have:
Excellent knowledge of relational databases and reporting.
Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
Some exposure to basic programming constructs (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Familiarity with Microsoft Office applications – particularly Excel.