- Discover data analysis
- Learn about the roles of data
- Learn about the tasks of a data analyst
- Get started building with Power BI
- Learn how Power BI services and applications work together
- Explore how Power BI can make your business more efficient
- Learn how to create compelling visuals and reports
- Get data in Power BI
- Identify and connect to a data source
- Get data from a relational database, like Microsoft SQL Server
- Get data from a file like Microsoft Excel
- Get data from applications
- Get data from Azure Analysis Services
- Select a storage mode
- Fix performance issues
- Resolve data import errors
- Labs: Prepare data in Power BI Desktop
- Clean, transform and load data in Power BI
- Resolve inconsistencies, unexpected or null values, and data quality issues
- Apply user-friendly value replacements
- Profile data so you can learn more about a specific column before using it
- Evaluate and transform column data types
- Apply data shape transformations to table structures
- Combine Queries
- Apply user-friendly naming conventions to columns and queries
- Edit M code in the Advanced Editor
- Labs: Load data in Power BI Desktop
- Design a data model in Power BI
- Create common data tables
- Configure many-to-many relationships
- Resolve circular relationships
- Design star schemas
- Labs: Model data in Power BI Desktop, Part 1
- Introduction to creating measures using DAX in Power BI
- Build quick measures
- Create calculated columns
- Use DAX to build measures
- Discover how context affects DAX measures
- Use the CALCULATE function to manipulate filters
- Implement time intelligence by using DAX
- Labs: Introduction to DAX in Power BI Desktop
- Labs: Time intelligence and measures in DAX
- Optimize a model for performance in Power BI
- Review the performance of measures, relationships, and visuals
- Use variables to improve performance and troubleshoot
- Improve performance by reducing cardinality levels
- Optimize DirectQuery models with table-level storage
- Create and manage aggregations
- Work with Power BI visuals
- Add visualization items to reports
- Choose an effective visualization
- Format and configure visualizations
- Import a custom visual
- Add an R or Python visual
- Labs: Design a report in Power BI desktop
- Create a data-driven story with Power BI reports
- Design a report layout
- Add buttons, bookmarks, and selections
- Design report navigation
- Use basic interactions
- Use advanced interactions and drill-through
- Configure conditional formatting
- Apply slicing, filtering, and sorting
- Publish and export reports
- Comment on reports
- Use a Performance analyzer to tune reports
- Optimize reports for mobile use
- Labs: Enhance Power BI reports with slicers, interaction, and formatting
- Create dashboards in Power BI
- Set a mobile view
- Add a theme to the visuals in your dashboard
- Configure data classification
- Add real-time dataset visuals to your dashboards
- Pin a live report page to a dashboard
- Labs: Create a Power BI dashboard
