Technical Skills / Computer Applications, Software and Infrastructure

Developing Dashboards with Microsoft Excel

PET002169

Presenting business intelligence with style and clarity

Course overview

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.

  • 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

Course 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 dates and fees

Date
When is it?
Location
Where do I go?
Duration
How long is it?
Availabilty
Remaining space?
Member
Fees + VAT
Non-Member
Fees + VAT
  Book
Add delegate(s)
Date: 25 Jan 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)
Date: 1 Jun 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)

Please note

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

Enquire about this course.