FR
EN
LU
DE
Details
Goals
Manage Data Models. Create DAX columns and Measures.
Prerequisite
Very good knowledge of Excel and basics of PowerPivot
Contents
Managing data sources
- Various data types
- Choosing a data source
- Databases
- Multi-dimensional databases
- Data feeds
- Principles and OData protocol
- OData feeds
- Azure Data Market
- Restricting data feeds
- Remarks on Open Data
- Files
- SharePoint
- Clipboard
- Excel table
- How to prepare data
Linking data
- Problem
- Using relationships
- Formatting Data
- Initial formatting
- Integrating data in PowerPivot
- Creating the first PivotTable report
- Creating a relationship
Calculation
- Use of calculated elements, difference between “Calculated column” and “Measure”
- Creating calculated columns (including the use of the “RELATED” function)
- Creating hierarchies
- Creating measures
- Function categories
- Contextual filter
- Using DAX to adapt calculations
- Using DAX to modify the context for filters
- What is required to use the DAX ‘Time Intelligence’ functions
- Managing sets
- Totals (ALLSELECTED)
Reporting
- Interactive Dashboard
- Adding PivotChart
- Linking slicers
- Filtering and sorting labels
- Formatting Contents
- Adding a KPI (Key Performance Indicator)
- Page Layout
- Managing groups
Sign up
Next session(s)
This training is exclusively on request. Contact us to get a personalized offer.
Sessions available in
- FR
- DE
- EN
- LU
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!