Tabular and PowerPivot for Developers (Online)
Duration:
3 Days
Location:
Online
Training Course Sections
| Instructor |
Date/Time |
Cost |
Registration Link |
|
Anthony Martin
|
06/19/13 - 06/21/13
2:00 PM - 5:00 PM EST
|
$545.00
|
Register Now!
|
|
Anthony Martin
|
10/23/13 - 10/25/13
9:00 AM - 12:00 PM EST
|
$545.00
|
Register Now!
|
Training Course Overview
Tabular and PowerPivot for Developers is an intensive three-day course that is designed to get you up to speed using PowerPivot quickly and productively. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data. It includes plenty of hands on labs designed to give you practical experience using PowerPivot and creating tabular data models.
IMPORTANT: When you purchase a seat in this class you also receive 1 hour of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.
Training Course Prerequisites
The target audience of this class is the database developer or DBA who is tasked with providing a self-service BI environment to the rest of the business. A background in database development is required, but no previous knowledge of PowerPivot, DAX or SQL Data Tools is assumed. Some experience using pivot tables and formulas in Excel may be helpful but is not required.
System Requirements
- AdventureWorksDW2012 database installed on an accessible instance of SQL Sever
- 1 GB of available RAM (recommended 4 GB or more)
- GHz CPU (recommended 2 GHz or faster)
- Windows XP Professional, Windows Server 2003, Windows Vista, Windows Server 2008, Windows 7, Windows Server 2012, Windows 8 or Windows RT
- Microsoft SQL Server 2012 SQL Server Data Tools
- Excel 2010 or greater
Terms & Conditions
Class Recordings
A class recording will be available via the web for a limited time for students who missed a session. Recordings are copyright protected and may not be distributed to others.
One Student Per Seat
We limit the number of students in each class to maintain a proper student to instructor ratio. Each purchased seat in a Virtual Training class is for use by one student only.
Cancellation/Rescheduling Policy
Students must provide at least 14 days’ notice to reschedule or withdraw from a class. In the case of withdrawal a credit will be issued for another Virtual Training class of similar value. Cancellation/reschedule with less than 14 days’ notice is subject to a fee of 100% of the total price.
We reserve the right to cancel or reschedule a class up to 2 weeks prior to the start date. Any students in a cancelled or rescheduled class have the option of a refund or credit to be used for another Virtual Training class of similar value.
Training Course Outline
Day 1:
-
Module 1: Introduction to PowerPivot (30min)
- Why use PowerPivot?
- Data Compression and query processing with the Vertipaq engine
- Installing PowerPivot
- Exploring Data with PowerPivot
- Hands On Lab – Installing and Exploring Data with PowerPivot
-
Module 2: Importing Data into PowerPivot (30min)
- Importing Data from a Database
- Importing Data from a File
- Importing Data from an SSAS Cube
- Importing Data from a Data Feed
- Refreshing the Data
- Hands On Lab – Loading Data into PowerPivot
-
Module 3: Creating the Data Model (60min)
- What is a Data Model?
- Creating Table Relations
- Combining Tables
- Linked Tables
- Creating Hierarchies
- Hands On Lab – Updating a Data Model in PowerPivot
-
Module 4: Creating Calculations with DAX (60min)
- Introduction to DAX
- Adding Calculated Columns
- DAX Operators
- Working with Text
- Using Date and Time Functions
- Using Conditional and Logical Functions
- Navigation Functions
- Hands on Lab – Adding Calculated Columns with DAX
Day 2:
-
Module 5: Creating Measures with DAX (60min)
- Measures
- Filter Context
- Creating Aggregates
- Using the Calculate Function
- Miscellaneous Functions
- Hands on Lab – Adding Measures with DAX
-
Module 6: Incorporating Time Intelligence (60min)
- Creating Date Tables
- Time Intelligence Functions
- Comparing Data over Time
- Semi-Additive Measures
- Hands on Lab – Adding Time Intelligence
-
Module 7: Working with PivotTables (30min)
- Pivot Table Fundamentals
- Sorting, Filtering, and Formatting
- Adding Calculations
- Using Sets and Adding Banding
- Hands on Lab – Building a PivotTable Report
-
Module 8: Visualizing Data (30min)
- Working with PiivotCharts
- Using Multiple Charts and Tables
- Managing Data Refresh
- Hands on Lab – Visualizing the Data
Day 3:
-
Module 9: Creating Tabular Data Models in SSAS (60min)
- Advantages of using Tabular Data Models
- Installing SSAS Tabular Mode
- Creating Tabular Model Projects in SQL Server Data Tools
- Importing Data
- Table Relations
- Hands On Lab – Loading Data into a Tabular Model
-
Module 10: Understanding Context in DAX (30min)
- Identifying the Row Context
- Query and Filter Contexts
- Functions that Alter Context
- Hands On Lab - Exploring Row and Filter Contexts
-
Module 11: Advanced Data Analysis (30min)
- Creating KPI’s
- Parent - Child Relationships
- Many to Many Relationships
- Hands on Lab – Creating KPIs and Parent-Child Hierarchies
-
Module 12: Managing and Securing Tabular Data Models in SSAS (60 min)
- Implementing Perspectives
- Creating Partitions
- Employing Role Based Security
- Implementing Row Level Security
- Testing Security Roles
- Deploying a Tabular Model
- Hands On Lab – Securing a Tabular Model