Learning Power BI Desktop
2h 23mBeginner2025-04-07
Authors
Gini von Courter
Teaching computer classes on Microsoft Office for 20+ years
Course details
Power BI Desktop—the powerful data analysis and visualization software from Microsoft—can help you get more insights from your data, whether that data is stored on your computer or in the cloud. In this course, discover how to leverage this easy-to-use tool to model and visualize data more efficiently. Learn how to connect various data sources, including Excel, databases, and web data sources like Wikipedia. Explore how to search and transform your data using the built-in Query Editor. Plus, instructor Gini von Courter shows how to build and arrange visualizations, create interactive reports, share your work, manage your published files in the Power BI service, and more.
Skills covered
Power BI DesktopData VisualizationBusiness AnalyticsBusiness IntelligenceData AnalysisLearningData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Model and visualize your data with Power BI Desktop
- 02 - What you need for this course
1. Get Started with Power BI Desktop
- 03 - Power BI tools
- 04 - Install Power BI Desktop
- 05 - Launch Power BI Desktop
2. Get Data
- 06 - Power BI data sources - The basics
- 07 - Connect to a file - Excel
- 08 - Connect to a file - CSV
- 09 - Connect to databases
- 10 - Connect to a web data source
- 11 - Connect to a SharePoint list
- 12 - Connect to Microsoft Dataverse
- 13 - Advanced connection types - DirectQuery and live connections
- 14 - Open a PBIX file or Excel data model
- 15 - Change the data source for a PBIX file
3. Transform Data with the Power Query Editor
- 16 - Rename columns in the Query Editor
- 17 - Remove rows and columns and change data types
- 18 - Reduce rows
- 19 - Filter, set data types, and replace values
- 20 - Unpivot columns
- 21 - Transform columns
4. Combine, Append, and Merge Data
- 22 - Prep to combine multiple tables
- 23 - Append data to a query
- 24 - Add an index column
- 25 - Clean up data
- 26 - Relate tables in your model
- 27 - Hide or display queries
- 28 - Merge data
5. Create a Report with Visualizations
- 29 - Use the Power BI Desktop Report view
- 30 - Format visualizations and apply themes
- 31 - Filter with slicers and report and page filters
6. Share Your Work
- 32 - Sharing - The basics
- 33 - Publish from Power BI Desktop
- 34 - Get a PBIX file from the Power BI service
- 35 - Display Power BI content in Microsoft Teams
Conclusion
- 36 - Next steps