Free SQL Server Training Webinars

We provide an array of sessions for those needing introduction, mid-level and even expert topics. Over 300 SQL Server data platform topics are covered including topics great for DBA’s and BI/Analytics professionals.   

Enhance your SQL Skills with Pragmatic Works 2 times a week.


Speaker Description
Devin Knight Devin Knight

Creating Real World PowerPivot Models

Instructor: Devin Knight

Date/Time: 6/18/2013 11:00 AM

The popularity of PowerPivot has grown rapidly since being introduced. With so many different features it’s hard to determine where to focus your learning. In this session we will quickly create a data model then move on to making it more useful in the real world. Importing data from a warehouse, Excel or even the web can add great value to your existing data model. Creating relationships, setting up your dates and creating hierarchies are all key to a robust model, are necessary to leverage the full power of DAX and provide maximum usability with Power View. We will also show you how to build calculations and KPIs (Key Performance Indicators) right into the model to help produce more actionable reports.

Copyright 2014 by Pragmatic Works