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!