Deep Dive into Business Intelligence in Excel 2013's PowerPivot and Power View

Total Running Time: 196 min

Excel 2013 includes built-in self-service business intelligence functionality that allows you to delve deeper into your data. You can use Excel to start analyzing data as a simple data model, and then progressively add more data from a variety of data sources to enrich your analysis. Using the PowerPivot add-in, you can fine-tune the structure of the model to better support exploration and enrich the model with calculations and key performance indicators. You can then add Power View sheets into your workbook to develop interactive data visualizations using your model as a source. This three-part series will show you how best to use these business intelligence features to transform raw data into powerful insights.

Session 1: Creating Models for Data Analysis

Session 2: Working with DAX Formulas to Enhance Your Data Model

Session 3: Using Power View to Explore Data for Insight