Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning.  We target major cities providing affordable SQL training courses sure to be near your local home base. 

Microsoft SQL industry experts delivering quality training. 

Hone Your SQL Expertise

Remote SQL Server, SharePoint and Performance Tuning training classes saving you time and money.  We offer morning and afternoon sessions providing less time away from work at a fraction of the cost.   

 

Increase BI Knowledge in 1 Week

The Pragmatic Works BI Quick Start provides hands on labs teaching you how to build a fully functional prototype data warehouse using SQL Server. We train you on the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI in 5 days. Our  Business Intelligence courses are taught in major cities throughout the United States.

 

Master SSIS Workshop
I have taken probably 50 training classes in my career and this one was, by far, the best one I've taken. Perfect match for what I was looking for. Great job!

- Peter Tassmer, ConnectiCare

Performance Tuning Workshop
Thank you guys so much for coming to Denver. That was the best DBA class I have taken. I really hope you're coming back next year to talk 2014!

- Michael Husler, NOAA Federal

Performance Tuning Workshop
If you have the time and money, please take the workshop. You might even learn something like this old IT guy did.

-John F Miner III, Senior SQL Developer at Total Quality Management
Performance Tuning Workshop
Class was overflowing with value delivered by extremely competent professionals and instructors and I have walked away truly enriched by it.

- Zoran Cvijetic
Sr. SQL Server DBA /
Database Systems Architect
20th Century Fox
Virtual Training

"This is the class that got me going on SSRS. The format: a unique combination of an online class where you still could interact personally with the instructor. The class content: Starting from scratch so everyone can keep up. The instructor: I have also taken other Pragmatics webcasts and these people are specialized in BI"

-Philip Leduc

Virtual Training

"I'm impressed by the number of examples involved in the training, the affordability of the class, and more than anything, the fact that I can keep a video recording of the training after it's over. Pragmatic Works is the first place I look to and recommend for SQL training. "

Jason Hurley

Virtual Training
If you have become or expect to become responsible for SQL Server Analysis Services in your shop you owe it to yourself to take this course.

Bryant Byrd,
Sr. BI Systems Analyst
Eastman Chemical Company

Virtual Training

"The best providers of high quality Microsoft BI related virtual and on-site classes. Their assistance during class, hands-on approach as well as post-class help made for a great experience"

Cosmin Ioan
Sr. Data Architect at Acquinity Interactive

Denver SSAS Workshop

Duration: Two Days
Location: Microsoft Office
7595 Technology Way
Suite 400
Denver, CO 80237

SSAS Training

  • Dimension Modeling
  • Cube Design
  • MDX Calculation
  • Data Mining in Depth
  • Administering SSAS

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

During this 2 day course, you will learn how to use SSAS 2008 or SSAS 2012 in your enterprise. This class takes you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users. This class is presented in SQL Server 2008 and SQL Server 2012 but is appropriate for those using SQL 2005 as well (with a few screen changes). Some of the topics covered in this class are: How to develop a data warehouse for your company, how to develop a repeatable methodology for a successful SSAS project, how to create and configure a cube and dimensions, how to write MDX (the querying language for cubes), how to define calculations, Key Performance Indicators (KPIs) and perspectives, implementing dynamic security, how to administer and deploy SSAS, defining actions, implementing data mining, how to build office-based BI applications and dashboards, and administering SSAS. If you would like to use a computer to follow along with the demos, please bring your own laptop, we do not provide them.

Training Course Prerequisites

Hardware and Software requirements:

  • Microsoft Windows 2000 Professional,or Microsoft Windows XP Professional, Microsoft Windows ,Windows 7
  • Server 2003/2008, Microsoft Vista operating system
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSRS.
  • AdventureWorks2008 and AdventureWorksDW2008 databases installed on the instance
  • Excel 2007 to do parts of the data mining and user interface labs
  • Download the class files (email will be sent to you with this link).
  • This file contains the labs for the class and the module files. Please print the file SSAS 2008 Class
  • Labs.doc in the root of this zip file if you think you’d like to have the labs in hard copy form. Unzip
  • the SSAS2008Class.zip file into a C:\. The end result should be C:\SSAS2008Class

Please Note:Every Workshop has a vegetarian lunch option

Terms & Conditions

A full refund will be provided with seven days advanced written notice prior to the event. Cancellations less than seven days prior to the event will receive Pragmatic Works credit towards another Workshop, Advanced Online Training or Software purchase.

Training Course Outline

Day 1 – SSAS Introduction and The Cube In-Depth

  1. Dimension Modeling
    • Basics of data warehouse design
    • Metric Decomposition Data Profiling
    • Hands-on Lab: How to design a data warehouse example
  2. SSAS Overview
    • MOLAP vs. Tabular Models in SQL Server 2012
    • Data Source Views
    • Cubes
    • Dimensions and Measures
    • Aggregates
    • Hands-on Lab: Creating the project and DSV.
  3. Cube Design and Browsing
    • Creating the cube
    • Processing the cube
    • Exploring the various tabs
    • Browsing the cube
    • Hands-on Lab: Creating and Exploring the SSAS cube
  4. Dimension and Cube Editors
    • Formatting measures
    • Creating hierarchies
    • Dimension and attribute properties
    • Varying types of dimensions in SSAS
    • Defining dimension, attribute and hierarchy properties
    • Creating attribute relationships
    • Hands-on Lab: Modifying your Dimension and Cube Properties
  5. Adding New Facts and Dimensions
    • Adding a new dimension table
    • Adding a new measure group and measure
    • Creating relationships between facts and dimensions
    • Hands-on Lab: Creating relationship between attributes and adding multiple fact tables
  6. MDX and Calculations
    • The basics of MDX
    • Using the Business Intelligence Wizard to ease MDX creation
    • Creating calculations to simply querying of your cube
    • Hands-on Lab: Creating calculations for your end users
  7. Building a Tabular Report
    1. Creating a cube with non-relational data
    2. Creating a KPI
    3. Using DAX to extend your cube

Day 2 – Data Mining In Depth and SSAS User Interface and administration

  1. Data Mining Basics
    • The methodology needed for a data mining project
    • Creating a mining model
    • Training the mining model
    • Validating and testing the mining model
    • Predicting sales using the model
    • Hands-on Lab: Creating, testing and querying a mining model
  2. Using Excel to Data Mine
    • Installing the Excel Data Mining Addin
    • Allowing business users to easily mine their data with Excel and SSAS 2007
    • Advanced mining in Excel
    • Hands-on Lab: Using Excel to easily data mine
  3. Actions
    • Drilling through to data with actions
    • Opening a Reporting Services report
    • Using action to execute custom scripts
    • Hands-on Lab: Adding actions to your cube
  4. Reporting Services with SSAS
    • Creating a report using MDX
    • Creating a data mining report
    • Hands-on Lab: Building a cube report
  5. Using Excel to Build Cube Interfaces
    • Using Office to view cube and data mining data
    • Basics of creating a thin client to show data. Students will be given a basic solution that can be used license-free to display cube data
    • Creating an offline cube experience for users
    • Hands-on Lab: Using Excel 2007 to display data
  6. Using SharePoint as an Interface for SSAS
    1. See how to use Performance Point to build a dashboard
    2. See how to use Pivot Viewer to build a self-service environment
    3. Administering SSAS
      • Administrating your SSAS server
      • Scheduling the processing of your cube
      • Partitioning your cube
      • Migrating changes in your cube
      • Where to store your cube’s data
      • How to secure your cube
      • Hands-on Lab: Deploying and scheduling processing of your cube
Copyright 2014 by Pragmatic Works