Creating interactive dashboards with Microsoft Excel («ME7»)

• Preparing data from different formats or sources and merging the data with Power Query and Power Pivot
• Mastering the presentation of data in a dashboard with pivot tables, charts and special visualisations
• Learning about controls and formula-based techniques for user-friendly and interactive features

1 Introduction to Dashboards

• What are dashboards?
• What needs to be considered to make them look professional?

2 PivotTables

• Static and dynamic areas
• Creating a PivotTable report
• Using data slices and timelines
• Creating functions and formulas
• Sorting and grouping data
• Customizing and formatting layouts
• Updating data

3 Power Query

• Importing data from a variety of sources and locations
• Clean up or prepare data
• View and combine queries
• Visualize data with pivot tables and charts

4 Power Pivot

• Import data from multiple data sources
• Create and apply relationships between tables
• Calculate with PowerPivot (DAX functions)

5 Visual representations

• Create charts
• Special representations with icons, symbols, images
• Formatting

6 Control elements

• Size, position, and formatting
• Protecting controls

7 Key Performance Indicators (KPIs)

• Introduction to KPIs
• Examples of KPIs

8 Creating professional dashboards

• Define target group, period, level of detail, and time frame
• Selecting and defining KPIs
• Visuals
• Protection and printing

• Advanced users who want to display the company's key figures analytically and visually by using dashboards
• People with a basic understanding of business administration who want to keep an eye on the performance of the company
• People that are responsible for having an eye on Key Performance Indicators

You already have some experience with Power Query and Power Pivot. Completion of the following courses or equivalent knowledge is required: