Microsoft recently added a new tool called the Excel Data Model, which allows sophisticated database tools like the creation of tables, joining multiple tables together, data analysis expressions, and office data connections. These tools can be combined with Excel PivotTables/PivotCharts or Microsoft Power BI to create real time business information. We will also briefly discuss the use of Power Query to extract, transform, and integrate data into the Excel data model, as well as using Office Data Connections (ODC) files to enable ad hoc analysis of data stored in the cloud.
Upon completion of the session, the participant should be able to:
• Define an Excel table, what is means to join two tables together, and a data analysis expression (DAX),
• Explain how these tools are used with the Excel data model
• Explain why using Power BI content packs and Office Data Connections (ODC) may simplify the process of getting data out of cloud systems