Course Description
Module 1: Power BI Desktop Data Transformations
This module describes how to import fata into Power BI.
Lessons
- What is Power BI?
- Power BI data
- Transformations
Lab : Import Data to Power BI
- Import data to Power BI desktop
- Import data from CSV files
- Import data from a less structured file
After completing this module, students will be able to:
- Describe what Power BI is and what it does.
- Describe the types of data.
- Perform data transformations.
Module 2: Power BI Desktop Modeling
This module introduces Power BI desktop modeling.
Lessons
- Optimizing data models
- Calculations
- Hierarchies
Lab : Manage Power BI data
- Manage table relationships
- Last year comparison
- Year to date
- Market share
- Optimize the data model
After completing this module, students will be able to:
- Optimize data models.
- Perform calculations with Power BI data.
- Describe and create hierarchies.
Module 3: Power BI Desktop Visualization
At the end of this module students will be able to create a Power BI desktop visualization.
Lessons
- Visualizing your data
- Working with multiple visualizations
Lab : Create reports with visualizations
- Cross-tabular reports
- Part-to-Whole reports
- Relationship reports
- Trend reports
- Rank reports
After completing this module, students will be able to:
- Visualize data using Power BI
- Work with multiple visualizations.
Module 4: Power BI Service
This module describes how to implement the Power BI service.
Lessons
- Working with the Power BI service
- Configuring a dashboard
- Viewing a Power BI Dashboard
Lab : Implementing the Power BI service
- Upload a Power BI report
- Share a Power BI dashboard
- Configure data refresh
After completing this module, students will be able to:
- Work with the Power BI service.
- Configure a Power BI dashboard.
- View a Power BI dashboard.
Module 5: Working with Excel
This module describes how to connect to Excel as a source of data.
Lessons
- Importing data from excel
- Analyzing data in Excel
Lab : Working with Excel
- Uploading an Excel file with an Excel table
- Uploading an Excel file with a data model
After completing this module, students will be able to:
- Import data from excel.
- Analyze data in Excel.
Module 6: Organization Content Packs, Security, and groups
This module describes how to collaborate with Power BI data.
Lessons
- Collaboration
- Content packs
Lab : Working with Organization Content Packs
- Create a content pack
- Edit a content pack
- Share a content pack
After completing this module, students will be able to:
- Share data for collaborative purposes.
- Create, edit, and share content packs.
Module 7: Direct Connectivity
This module describes various connectivity options using Power BI.
Lessons
- Cloud data
- Connecting to analysis services
Lab : Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
After completing this module, students will be able to:
- Access data in SQL Azure.
- Connect to SQL Server Analysis Services.
Module 8: Developer API
This module describes the developer API within Power BI.
Lessons
- The developer API
- Custom visuals
Lab : Using the developer API
After completing this module, students will be able to:
- Describe the developer API.
- Use the developer API to create custom visuals.
Module 9: Power BI mobile app
This module describes the Power BI mobile app.
Lessons
- The Power BI mobile app
- Using the Power BI mobile app
- Power BI embedded
After completing this module, students will be able to:
- Describe the Power BI mobile app.
- Download and use the Power BI mobile app.
- Describe Power BI embedded and when you would want to use it.
Module 1: Power BI Desktop Data Transformations
This module describes how to import fata into Power BI.
Lessons
- What is Power BI?
- Power BI data
- Transformations
Lab : Import Data to Power BI
- Import data to Power BI desktop
- Import data from CSV files
- Import data from a less structured file
After completing this module, students will be able to:
- Describe what Power BI is and what it does.
- Describe the types of data.
- Perform data transformations.
Module 2: Power BI Desktop Modeling
This module introduces Power BI desktop modeling.
Lessons
- Optimizing data models
- Calculations
- Hierarchies
Lab : Manage Power BI data
- Manage table relationships
- Last year comparison
- Year to date
- Market share
- Optimize the data model
After completing this module, students will be able to:
- Optimize data models.
- Perform calculations with Power BI data.
- Describe and create hierarchies.
Module 3: Power BI Desktop Visualization
At the end of this module students will be able to create a Power BI desktop visualization.
Lessons
- Visualizing your data
- Working with multiple visualizations
Lab : Create reports with visualizations
- Cross-tabular reports
- Part-to-Whole reports
- Relationship reports
- Trend reports
- Rank reports
After completing this module, students will be able to:
- Visualize data using Power BI
- Work with multiple visualizations.
Module 4: Power BI Service
This module describes how to implement the Power BI service.
Lessons
- Working with the Power BI service
- Configuring a dashboard
- Viewing a Power BI Dashboard
Lab : Implementing the Power BI service
- Upload a Power BI report
- Share a Power BI dashboard
- Configure data refresh
After completing this module, students will be able to:
- Work with the Power BI service.
- Configure a Power BI dashboard.
- View a Power BI dashboard.
Module 5: Working with Excel
This module describes how to connect to Excel as a source of data.
Lessons
- Importing data from excel
- Analyzing data in Excel
Lab : Working with Excel
- Uploading an Excel file with an Excel table
- Uploading an Excel file with a data model
After completing this module, students will be able to:
- Import data from excel.
- Analyze data in Excel.
Module 6: Organization Content Packs, Security, and groups
This module describes how to collaborate with Power BI data.
Lessons
- Collaboration
- Content packs
Lab : Working with Organization Content Packs
- Create a content pack
- Edit a content pack
- Share a content pack
After completing this module, students will be able to:
- Share data for collaborative purposes.
- Create, edit, and share content packs.
Module 7: Direct Connectivity
This module describes various connectivity options using Power BI.
Lessons
- Cloud data
- Connecting to analysis services
Lab : Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
After completing this module, students will be able to:
- Access data in SQL Azure.
- Connect to SQL Server Analysis Services.
Module 8: Developer API
This module describes the developer API within Power BI.
Lessons
- The developer API
- Custom visuals
Lab : Using the developer API
After completing this module, students will be able to:
- Describe the developer API.
- Use the developer API to create custom visuals.
Module 9: Power BI mobile app
This module describes the Power BI mobile app.
Lessons
- The Power BI mobile app
- Using the Power BI mobile app
- Power BI embedded
After completing this module, students will be able to:
- Describe the Power BI mobile app.
- Download and use the Power BI mobile app.
- Describe Power BI embedded and when you would want to use it.
Agenda
Module 1: Power BI Desktop Data Transformations
This module describes how to import fata into Power BI.
Lessons
- What is Power BI?
- Power BI data
- Transformations
Lab : Import Data to Power BI
- Import data to Power BI desktop
- Import data from CSV files
- Import data from a less structured file
After completing this module, students will be able to:
- Describe what Power BI is and what it does.
- Describe the types of data.
- Perform data transformations.
Module 2: Power BI Desktop Modeling
This module introduces Power BI desktop modeling.
Lessons
- Optimizing data models
- Calculations
- Hierarchies
Lab : Manage Power BI data
- Manage table relationships
- Last year comparison
- Year to date
- Market share
- Optimize the data model
After completing this module, students will be able to:
- Optimize data models.
- Perform calculations with Power BI data.
- Describe and create hierarchies.
Module 3: Power BI Desktop Visualization
At the end of this module students will be able to create a Power BI desktop visualization.
Lessons
- Visualizing your data
- Working with multiple visualizations
Lab : Create reports with visualizations
- Cross-tabular reports
- Part-to-Whole reports
- Relationship reports
- Trend reports
- Rank reports
After completing this module, students will be able to:
- Visualize data using Power BI
- Work with multiple visualizations.
Module 4: Power BI Service
This module describes how to implement the Power BI service.
Lessons
- Working with the Power BI service
- Configuring a dashboard
- Viewing a Power BI Dashboard
Lab : Implementing the Power BI service
- Upload a Power BI report
- Share a Power BI dashboard
- Configure data refresh
After completing this module, students will be able to:
- Work with the Power BI service.
- Configure a Power BI dashboard.
- View a Power BI dashboard.
Module 5: Working with Excel
This module describes how to connect to Excel as a source of data.
Lessons
- Importing data from excel
- Analyzing data in Excel
Lab : Working with Excel
- Uploading an Excel file with an Excel table
- Uploading an Excel file with a data model
After completing this module, students will be able to:
- Import data from excel.
- Analyze data in Excel.
Module 6: Organization Content Packs, Security, and groups
This module describes how to collaborate with Power BI data.
Lessons
- Collaboration
- Content packs
Lab : Working with Organization Content Packs
- Create a content pack
- Edit a content pack
- Share a content pack
After completing this module, students will be able to:
- Share data for collaborative purposes.
- Create, edit, and share content packs.
Module 7: Direct Connectivity
This module describes various connectivity options using Power BI.
Lessons
- Cloud data
- Connecting to analysis services
Lab : Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
After completing this module, students will be able to:
- Access data in SQL Azure.
- Connect to SQL Server Analysis Services.
Module 8: Developer API
This module describes the developer API within Power BI.
Lessons
- The developer API
- Custom visuals
Lab : Using the developer API
After completing this module, students will be able to:
- Describe the developer API.
- Use the developer API to create custom visuals.
Module 9: Power BI mobile app
This module describes the Power BI mobile app.
Lessons
- The Power BI mobile app
- Using the Power BI mobile app
- Power BI embedded
After completing this module, students will be able to:
- Describe the Power BI mobile app.
- Download and use the Power BI mobile app.
- Describe Power BI embedded and when you would want to use it.