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?
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
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.