MOC 10989 - Analyzing Data with Power BI (MOC10989)
Course Length: 2 days
Delivery Methods:
Available as private class only
Course Overview
This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.
The primary audience for this course is BI professionals who need to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users.
Course Benefits
- Learn to describe key features of a self-service BI solution.
- Learn to describe Power BI and its data sources.
- Learn to model, shape, and combine data.
- Learn to describe Power BI data visualizations.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Introduction to Self-Service BI Solutions
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service BI
- Considerations of self-service BI
- Microsoft tools for self-service BI
- Lab : Exploring an enterprise BI solution
- Introducing Power BI
- Power BI
- The Power BI service
- Power BI mobile apps
- Lab : Cresting a Power BI dashboard
- Power BI Data
- Using Excel as a Power BI data source
- Using databases as a Power BI data source
- The Power BI service
- Lab : Import data into Power BI
- Shaping and Combining Data
- Power BI desktop queries
- Shaping data
- Combining data
- Lab : Shaping and combining data
- Modelling Data
- Relationships
- DAX queries
- Calculations and measures
- Lab : Modelling data
- Module 6: Interactive Data Visualizations
- Creating Power BI reports
- Managing a Power BI solution
- Lab : Creating a Power BI report
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this class:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
- Some exposure to basic programming concepts (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.