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