Presented by Stacia Misner
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
Before you can begin exploring the data, you must build a suitable data model. In this session, you’ll learn how to import data into a data model and how to combine data from multiple sources. You’ll also learn how best to structure your data model to support analysis by adding relationships, hierarchies, perspectives, and simple calculations.
Session 2: Working with DAX Formulas to Enhance Your Data Model
By using DAX formulas, you can enrich your PowerPivot model in multiple ways. In this session, you’ll learn the principles of working with the DAX language through the development of many different types of calculations. You’ll learn how to create calculated columns to compute new values for each row of imported data, such as the concatenation of multiple columns or the replacement of one string for another. You’ll also learn how to create calculated fields to aggregate data for analysis and key performance indicators to measure progress towards goals. In addition, you’ll learn how evaluation context affects query results.
Session 3: Using Power View to Explore Data for Insight
Although you can explore your data model by using pivot tables and pivot charts in Excel, you can use the new Power View features in Excel 2013 to interactively explore and analyze your data by using a variety of data visualization techniques. In this session, you’ll learn how to combine multiple data visualizations into a report that you can filter and highlight to understand the relationships in your data. Throughout this session, you’ll also learn the necessary optimizations you should make to your data model to ensure a better data visualization experience with Power View.