Course duration
- 2 days
Course Benefits
- Navigate the Power View interface.
- Utilize Power View reports.
- Work with tables.
- Understand aggregations.
- Utilize matrix.
- Configure drill through.
- Use cards as a visualization.
- Apply filters.
- Create charts.
- Utilize tiles.
- Add slicers to reports.
- Utilize themes.
- Navigate the PowerPivot interface.
- Load data.
- Examine and configure relationships.
- Configure calculated columns are calculated fields.
- Create PivotTables.
- Understand and utilize DAX.
- Use KPIs.
- Work with hierarchies.
- Manage perspectives.
- Navigate the Power Query interface.
- Load data.
- Filter data.
- Merge datasets.
- Manage modifications.
- Perform data cleaning.
- Navigate the Power Map interface.
- Use Bing maps.
- Examine map data.
- Configure tours, scenes, and layers.
- Add time to a presentation.
- Navigate the Power BI interface.
- Utilize data sources.
- Understand querying with natural language.
Course Outline
- Power View
- Exploring the Power View Interface
- Visualizing Power View Reports
- Working with Tables
- Understanding Aggregations
- Utilizing Matrix
- Configuring Drill Through
- Using Cards
- Applying Filters
- Creating Charts
- Examining Tiles
- Adding Slicers to Reports
- Theming Reports
- Lab: The Business Intelligence Stack
- Power View Interface
- Working with Tables
- Aggregations
- Matrix
- Drill Through
- Cards
- Filters
- Charts
- Tiles
- Adding Slicers to Reports
- PowerPivot
- Exploring the PowerPivot Interface
- Loading Data
- Examining Relationships
- Configuring Calculated Columns and Calculated Fields
- Creating PivotTables
- Understanding DAX
- Utilizing DAX Functions
- Using KPIs
- Working with Hierarchies
- Managing Perspectives
- Lab: PowerPivot
- Introduction to the PowerPivot Interface
- Importing Data
- Importing Large Datasets
- Importing Data with a Query
- Creating Relationships
- Creating a Cascading Relationship
- Hiding Columns, Change Data Type, Sorting, and Filtering
- Calculated Columns and Calculated Fields
- KPIs
- Hierarchies
- Perspectives
- Power Query
- Exploring The Power Query Interface
- Loading Data
- Managing Modifications
- Examining Data Cleaning
- Lab: Power Query
- Getting External Data
- Data Filtering
- Merging Datasets
- Power Map
- Exploring The Power Map Interface
- Using Bing Maps
- Examining Map Data
- Reviewing Map Types and Presentation
- Lab: Power Map
- View Power Map in Action
- Geocoding
- Tours, Scenes, and Layers
- Adding Time
- Introduction to Power BI
- Introducing Power BI
- Explaining Excel and Power BI
- Examining Data Sources
- Querying with Natural Language
- Lab: Introduction to Power BI
- Introduction to Power BI
- Data Sources
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Power Platform class:
- Working knowledge of Excel
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.