Presented by: Stacia Misner Running Time: 76 min 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.
This video is part of theDeep Dive into Business Intelligence in Excel 2013's PowerPivot and Power View On-Demand Training.
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.