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
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
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
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

"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

"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

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

SharePoint for Business Intelligence (Online)

Duration: 4 Days
Location: Online
  • Creating and deploying Reporting Services 2012 Reports in SharePoint
  • Creating dashboards and scorecards in PerformancePoint
  • Using Office for self-service BI and PowerPivot for Excel in SharePoint
NEW IN 2013: Now includes Virtual Mentor time!

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

During this 4-day (half days) course you will learn how to use SharePoint to bring business intelligence to the forefront for your users and customers. This class is built to take your SharePoint BI knowledge to the next level. Daily hands-on labs will reinforce the concepts learned and help familiarize you with the tools in an actual SharePoint environment. Topics covered include basic SharePoint server architecture, Excel, PowerPivot, Power View, PerformancePoint, SQL Server Reporting Services 2012 and site branding.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours 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 of this class is developers, architects or IT professionals who have basic experience with Excel, Reporting Services and SSAS cube. Very little time is spent in the class ramping up students on the basics of Reporting Services and general cube concepts. End-user experience with SharePoint is beneficial.

System Requirements

All labs are done online through a hosted virtual server. No software is required to be installed locally for labs.

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 – Introduction to SharePoint for Business Intelligence

  1. Architecting a SharePoint Environment
    • Server Architecture
    • SharePoint Authentication
  2. Configuring SharePoint for Business Intelligence
    • Service Applications
    • Secure Store Service
    • Add-ins for Report Services
    • Creating a Business Intelligence Site
    • Hands-on Lab: Setting Up Your First Business Intelligence Site
  3. Working With Excel Services
    • Creating a Data Connected Workbook
    • Creating a Report in Excel
    • Deploying an Excel Workbook
    • Hands-on Lab: Deploy Workbooks with Embedded and External Connections

Day 2 – PowerPivot and Power View

  1. Creating a PowerPivot Model
    • Importing Data
    • Creating Hierarchies
    • Creating Calculations
    • Hands-on Lab: Building Your First PowerPivot Model
  2. Reporting Off a PowerPivot Model
    • Creating a PivotTable
    • Building a Key Performance Indicator
    • Deploying a PowerPivot Model
    • Hands-on Lab: Building a PowerPivot Based Report
  3. PowerPivot in SharePoint
    • PowerPivot in SharePoint Architecture
    • Using the PowerPivot Management Dashboard
    • Configuring PowerPivot Data Refresh
  4. Working With Power View in SharePoint
    • Creating Your First Power View Report
    • Saving and Exporting Power View Reports
    • Power View Reporting with Tabular Models
    • Hands-on Lab: Power View Reporting on PowerPivot

Day 3 – PerformancePoint

  1. Getting Started With PerformancePoint
    • PerformancePoint Inside SharePoint
    • Configuring a Data Source
    • PerformancePoint Report Basics
    • Hands-on Lab: Connecting PerformancePoint to Analysis Services
  2. Creating PerformancePoint Content
    • Building PerformancePoint Reports
    • Building a Scorecard
    • Building a Filter
    • Using Time Intelligence
    • Hands-on Lab: Building PerformancePoint Reports and Filters
  3. Creating a PerformancePoint Dashboard
    • Adding Content to a PerformancePoint Dashboard
    • Making a Dashboard Interactive
    • Deploying a PerformancePoint Dashboard
    • Hands-on Lab: Combining Content on a PerformancePoint Dashboard

Day 4 – Reporting Services and Branding

  1. Creating a SQL Server Reporting Services Report
    • Establishing a Data Connection
    • Creating a Report Using the Wizard
    • Deploying a Report to SharePoint
    • Hands-on Lab: Building a Basic Reporting Services Report
  2. SQL Server Reporting Services in SharePoint
    • SSRS 2008R2 vs. 2012 Architecture
    • Using Report Builder
    • Setting up Report Alerts
    • Setting up Report Subscriptions
    • Hands-on Lab: Creating a Report Alert
  3. Branding Your SharePoint Site
    • Creating and Modifying a Master Page
    • Advanced Layout Features
    • Hands-on Lab: Branding Your Site
Copyright 2014 by Pragmatic Works