After completing this course, students will be able to:
- Describe self-service BI.
- Describe the Power BI suite of products.
- Connect to data sources and optimize data models.
- Shape and combine data from different sources.
- Model data.
- Create reports and manage solutions.
- Describe the Power BI developer API.
- Describe the Power BI mobile app.
This course prepares for the Microsoft exam 70-778.
Module 1: Introduction to Self-Service BI Solutions
- Introduction to Business Intelligence
- Introduction to Data Analysis
- Introduction to Data Visualization
- Overview of Self-Service BI
- Considerations for Self-Service BI
- Microsoft Tools for Self-Service BI
Module 2: Introducing Power BI
- Power BI
- The Power BI Service
Module 3: Power BI Data
- Using Excel as a Data Source for Power BI
- The Power BI Data Model
- Using Databases as a Data Source for Power BI
- The Power BI Service
Module 4: Shaping and Combining Data
- Power BI Desktop Queries
- Shaping Data
- Combining Data
Module 5: Modeling Data
- Relationships
- DAX Queries
- Calculations and Measures
Module 6: Interactive Data Visualizations
- Creating Power BI Reports
- Managing a Power BI Solution
Module 7: Direct Connectivity
- Cloud Data
- Connecting to Analysis Services
Module 8: Development with Power BI
- The Power BI API
- Custom Visuals
Module 9: Power BI Mobile
- Power BI Mobile Apps
- Using the Power BI Mobile App
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.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- 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.
