This MS PowerPivot & Power Query training course provides skills to combine the functionality of Power View, PowerPivot, Power Query, and Power BI into graphs, charts, KPIs, reports, and other visualizations for use in your business.
By attending MS PowerPivot & Power Query workshop, delegates will learn to:
- 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
- Working knowledge of Excel
The MS PowerPivot & Power Query class is ideal for:
- Business analysts, business intelligence developers, and reporting professionals.