Introduction
Model and visualize your data with Power BI Desktop
()
What you need for this course
()
1. Getting Started
Power BI tools
()
Install Power BI Desktop
()
Launch Power BI Desktop
()
2. Get Data
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
()
3. Transform Data with the Power Query Editor
Use the Power Query Editor
()
Reduce rows
()
Filter, set data type, replace values
()
Unpivot columns
()
Transform columns
()
4. Combine, Append, and Merge Data
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
()
5. Create Reports and Visualizations
Use the Power BI Desktop Report view
()
Format visualizations and apply themes
()
Create text visuals: Cards, table, matrix
()
Apply conditional formatting
()
Format titles and arrange visualizations
()
6. Use Filters and Q&A in a Report
Use slicers to filter visuals
()
Filter reports and pages
()
Format the Filters pane
()
Add search capabilities with a QA visualization
()
Add suggestions to a QA visualization
()
7. Share Your Work
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
()
Ex_Files_Learning_MS_Power_BI_Desktop.zip
(1.4 MB)