Overview
-
Learn how to connect and transform your data with Power BI Desktop, the powerful data analysis and visualization software from Microsoft.
Syllabus
-
Introduction
- Model and visualize your data with Power BI Desktop
- What you need for this course
- Power BI tools
- Install Power BI Desktop
- Launch Power BI Desktop
- Power BI data sources: The basics
- Connect to a file: Excel
- Connect to a file: CSV
- Connect to databases
- Connect to a web data source
- Connect to a SharePoint list
- Connect to Microsoft Dataverse
- Advanced connection types: DirectQuery and live connections
- Open a PBIX file or Excel data model
- Change the data source for a PBIX file
- Use the Power Query Editor
- Reduce rows
- Filter, set data type, replace values
- Unpivot columns
- Transform columns
- Prep to combine multiple tables
- Append data to a query
- Add an index column
- Clean up data
- Relate tables in your model
- Hide or display queries
- Merge data
- Use the Power BI Desktop report view
- Format visualizations and apply themes
- Create text visuals: Cards, table, and matrix
- Apply preset styles and conditional formatting
- Apply formatting to titles
- Use slicers to filter visuals
- Filter reports and pages
- Add search capabilities with a Q&A visualization
- Add suggestions to a Q&A visualization
- Sharing: The basics
- Publish from Power BI Desktop
- Get a PBIX file from the Power BI Service
- Display Power BI content in Microsoft Teams
- Republish a dataset to the Power BI Service
- Next steps
