FR
EN
LU
DE
Details
Goals
Present data with Power View
Prerequisite
Very good Excel knowledge
Contents
Display data from an Excel table in a Power View report
- Make data compatible with Power View
- Using the various views
- Table
- Matrix
- Cards
- Charts
- Maps
- Slicers
- Using tiles
- Formatting the report
- Adding new elements to the reports
- Filter a report in Power View
- Adding a simple calculation
Adding data: the data model
- The PowerPivot tab and window
- Importing data: overview of the various data sources available.
- Importing data from a relational database.
- Create a quick analysis
Going further in the analysis
- Aggregation principles
- Subtotals and grand totals
- Filtering displayed data
- Simple calculations
- Elementary layout
Data Model manipulation
- ‘Data View’, ‘Diagram View’
- Hiding tables / columns (make the model simpler)
- Adding new tables to an existing data model
- Sorting a column based on the contents of another column
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!