EXCL-DSB

Microsoft Excel - Dashboard design and data visualisation

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

Today, in a world of incredibly fast information flow, it can often feel like the essence is lost in a sea of data. The challenge is no longer getting the data, but displaying it effectively and visually. In the age of big data, data visualisation is playing an increasingly important role in our daily work.

Dashboards, data visualisation techniques that are becoming increasingly popular these days, can provide a solution and contribute greatly to efficient and rapid decision-making.

The 1-day Excel course aims to introduce the participants to the simpler and more complex methods and practical applications of data visualisation.

Outline

PowerPivot

  • Statements, multiple source tables in one statement
  • DAX: the PowerPivot modelling language
  • Dashboard
  • Using slicers

Charts

  • Chart types and their use
  • Dashboard design
  • Creating a combined graph

Alternative data visualisation tools

  • Conditional formatting: data bars, icons
  • Tables and graphs as tools for effective communication
Outline (PDF)

Prerequisites

Participants should be routine Excel users: they should be able to create formulas, be proficient in basic function usage, use of multi worksheets, charting. Analytical and problem-solving thinking.