Developing Dashboards with Microsoft Excel

PET002169

Presenting business intelligence with style and clarity

Who is it for?

For those who need to present data in a visually effective and meaningful way to enable understanding and action to be taken.

Business benefits
  • Preparing and analysing data for a dashboard
  • Building interactive Excel dashboards
  • Using Excel’s data visualisation tools for KPI reporting
Course overview
  • Introduction to dashboard design
  • Advanced charting techniques
  • Enhancing pivot tables and pivot charts
  • Building a power pivot data model with related data
  • Using power view to create reports
  • Using DAX calculations to analyse the data
  • Using hierarchies to enable drilling down through the data

Please note

Those attending should have Intermediate to Advanced skills or relevant experience in Excel and Pivot Tables.


Sponsored option

This course is available as a company sponsored event, delivered at a location, date and time which is mutually agreed. The fees for this event vary depending on the location, number attending and the level of training required and the degree of customisation. Please contact us to discuss your requirements.


Next steps


Course dates and fees
Start date Location Duration Member
+VAT
Non-member
+VAT
Availability  
16 May 2019 Portsmouth 1 day £299.00 £352.00 Spaces Book
21 January 2019 Portsmouth 1 day £299.00 £352.00 Spaces Book
16 May 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £299.00
  • Non-member +VAT: £352.00
  • Availability: Spaces
Book
21 January 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £299.00
  • Non-member +VAT: £352.00
  • Availability: Spaces
Book

Group discounts are available for this course

Take advantage of these discounts when booking this course;

  • 5% off for 2-3 people
  • 8% off for 4-5 people
  • 12% off for 6 or more people
« All Corporate Courses courses


Our Courses and Services