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

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

"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

BI Quick Start Bootcamp New York, NY Edition

Duration: 5 Days
Location: Microsoft Office
1290 Avenue of the Americas,
Sixth Floor
New York, NY 10104
  • Learn all about Data Sources
  • Building Reports and Cubes
  • Data Model & ETL Tools
  • Presentation Layer and lots more

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

The Pragmatic Works BI Boot Camp provides a hands on lab environment. In five days you’ll build a fully functional prototype data warehouse using SQL Server 2008R2 and the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI.

  • Learn the Microsoft BI platform from top to bottom.
    1. SSIS, SSRS, SSAS, Power Pivot
    2. Performance Point
  • 100% hands on, you will be designing. You will be building with Pragmatic Works mentors.
  • Learn Best Practices : tips and tricks.
  • Become proficient with the BI developer tools that will accelerate your projects and improve your solutions
  • Return home ready to undertake the toughest BI projects for your organization.
  • Receive an email containing the BI solution you have built, including all components and a complete documentation set of the solution.

Terms & Conditions

Cancellation or rescheduling with less than 1 week email notice is subject to a cancellation/reschedule fee of 100% of the total price. Please contact Sales at sales@pragmaticworks.com or call at 904-638-5743 if you need to cancel or reschedule a class.

Training Course Outline

Day 1: Discovery and Design

Review the data sources in our Boot Camp Lab and establish presentation layer goals for the week’s BI solution. Design conceptual database diagram for data warehouse.

Day 2: Data Model & ETL

Design the data model and physical database for fact tables and related dimensions. Build an SSIS framework to load the data warehouse. Integrate/enhance warehouse with public data sources.

Day 3: Cubing With SSAS

Learn OLAP cube technology with SSAS on top of the data warehouse and KPI functionality. Design the cube and load it.

Day 4: Presentation Layer

Build a sample SSRS report(s) using the cube and data warehouse. Connect Share Point BI Dashboard with KPI’s to Cube and fact tables. Excel pivot tables for ad hoc analysis. Generate solution documentation set.

Day 5: Advanced topics

Data Mining and predictive analytics. Power Pivot; Best practices review; Planning a BI project.

Key Features and Benefits

  • Post Boot Camp assistance: We’ll email you the full solution and the key data sources. Plus the boot camp includes an hour of our VM services for follow-up assistance.
  • Tools: To increase our productivity you’ll be using our best of breed BI developer tools to build the ETL and cube.
  • Lunch is included every day

Every BI Boot Camp also includes:

  • Solution documentation set
  • BI xPress 3 month term license
  • Post Boot camp Virtual Mentoring (1 hour)

Please Note: You do not need to bring a Laptop

Copyright 2014 by Pragmatic Works