Description

In building effective spreadsheets and organizing one’s thoughts, it is useful to consider the efforts you make to follow a data ‘life cycle.’ In this workshop, we build your skillset for each of the major phases of this cycle, and help to focus your attention on relevant tools for various scenarios.

Topics include:

Planning and executing ETL operations with Power Query

Managing the Excel Data Model with Power Pivot

Building relationships between tables in the Data Model

Writing DAX expressions to analyze data

Creating dynamic reports and dashboards with Pivot Tables

Illustrating and highlighting relevant insights with data visualization best practices

Creating compelling presentations from Excel charts