Excel: Handling the Data Lifecycle - Workshop

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