Developing Dashboards with Microsoft Excel


Presenting business intelligence with style and clarity

Who is it for?

For those who need to present vital business information and metrics, in a visually effective and meaningful way, enabling clear communications regarding critical business performance measures.

Business benefits

Improved visibility of meaningful business intelligence. Increasing productivity by eliminating manual analysis, allowing early identification of areas where performance is below KPI’s.

Course overview
  • Introduction to dashboard design
  • 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.

On demand course available

This course is available on demand and dates are available on application, please contact us to discuss your requirements.

Next steps

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