Power BI for End Users – Part 2
Duration: 1 Day
About: This 1-day course will build on the knowledge from Power BI for End Users – Part 1. Students will learn that to enhance results by integrating disparate data sources and add simple calculations using DAX functions and queries. Participants will create visualizations and incorporate them into dashboards that can provide up to the minute reporting.
Prerequisites: Power BI for End Users – Part 1
Using the Query Editor
- Opening the Query Editor
- The Query Editor Interface
- Using the Query Settings Pane
- Using Merge Queries
- Using Append Queries
Working with Data - Transforming and Sanitizing Data
- Using Data View
- Cleaning Irregularly Formatted Data
- Managing Columns
- Sorting Table Data
Data Modeling
- What is DAX?
- Creating a New Table
- Creating a New Calculated Column
- Creating a New Measure
Managing Relationships
- Using the Relationships View
- Creating Relationships
- Editing Relationships
- Deleting Relationships
- Using the Manage Relationships Dialog
Matrixes, Tables, and Charts
- Creating a Table
- Creating a Matrix
- Overview of Chart Types
- Creating Charts
Slicers
- Creating a Slicer
- Using Slicers
- Customizing Slicer Display
- Changing Slicer Mode
- Changing Slicer Orientation
Introduction to the Power BI Web App - Getting Started
- Opening the Power BI Web App
- The Web App Interface
- Web App Building Blocks
- Key Differences
Using App Workspaces, Dashboards, and Reports
- Viewing and Managing Power BI Content
- Viewing a Workspace
- Viewing Dashboards and Reports
- Managing Reports
Creating Custom Dashboards
- Creating a Dashboard
- Pinning Visualizations to a Dashboard
- Adding Custom Tiles
- Managing Dashboards
Power BI Web App Features
- Using Insights