Session 1: Creating Models for Data Analysis

RSS

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.

Buy This On-Demand Training Now!

This video is part of the Deep 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.

Already purchased this? to view your content.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Fork in walking path
Aug 28, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context

Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
start here sign
Aug 26, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×