What you'll learn
- Perform Power BI Desktop data transformation and modelling
- Create Power BI Desktop visualisations
- Implement the Power BI Service and connect to Excel and other data stores
- Describe how to collaborate with Power BI data
- Describe the Power BI developer API and the Power BI mobile app
Course outline
Introduction to Self-Service BI Solutions
- Introduction to Business Intelligence
- Introduction to Data Analysis
- Introduction to Data Visualization
- Overview and Considerations for Self-Service BI
- Microsoft Tools for Self-Service BI
Introducing Power BI
- Power BI
- The Power BI Service
Data Management
- Using Excel as a Data Source for Power BI
- The Power BI Data Model
- Using Databases as a Data Source for Power BI
Shaping and Combining Data
- Power BI Desktop Queries
- Shaping Data
- Combining Data
Modeling Data
- Relationships
- DAX Queries
- Calculations and Measures
Interactive Data Visualizations
- Creating Power BI Reports
- Managing a Power BI Solution
Direct Connectivity
- Cloud Data
- Connecting to Analysis Services
The Developer API
- The Developer API
- Custom Visuals
Power BI Mobile App
- Power BI Mobile Apps
- Using the Power BI Mobile App
- Power BI Embedded