Excel 2: Data Modeling - Workshop
Excel 2: Data Modeling in Excel
Description
If you are an advanced user of Pivot Tables, Power Pivot is a very useful upgrade to your skillset. Power Pivot was built as a component of Power BI, but Microsoft added it to Excel using an Add-in. With it, you can create relationships between data tables, and add new DAX functions to existing analyses. Topics include: Converting existing lists into Excel Tables Creating relationships between tables Using the Excel Data Model in Pivot Tables Writing DAX functions for use in summaries