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.

 

BI Quick Start Bootcamp

Duration: 5 Days
  • Learn all about Data Sources
  • Building Reports and Cubes
  • Data Model & ETL Tools
  • Presentation Layer and lots more

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 2012, along with the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI. 

  • Learn the Microsoft BI platform from top to bottom.
    1. SSIS, SSRS, SSAS, PowerPivot
    2. PerformancePoint
  • 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.

Scheduled Classes

Class Date/Time Location Cost Details Purchase
BI Quick Start Bootcamp St. Louis, MO Edition 5/12/2014 - 5/16/2014
9:00 AM - 5:00 PM
Microsoft Office
3 City Place Dr., Suite 1100
St. Louis, MO 63141 

$1,995.00
BI Quick Start Bootcamp Charlotte, NC Edition 6/23/2014 - 6/27/2014
9:00 AM - 5:00 PM
Microsoft Office
8055 Microsoft Way
Charlotte, NC 28273

$1,995.00
BI Quick Start Bootcamp Jacksonville, FL Edition 8/18/2014 - 8/22/2014
9:00 AM - 5:00 PM
Pragmatic Works
400 College Dr. 
Suite 216
Middleburg, FL 32068

$1,995.00

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 Multidimensional

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

Day 4: Power Pivot / Tabular and Presentation Layer

Start the day learning about the other Analysis Services with Power Pivot and Tabular.  Then, start a tour of the many data presentation options that are available in the Microsoft stack.  Build a sample SSRS report(s) using the cube and data warehouse. Connect SharePoint BI Dashboard with KPI’s to Cube and fact tables. Excel pivot tables for ad hoc analysis. Generate solution documentation set.

Day 5: Presentation Layer and Review

Demonstrate other presentation layer options like Power View.   Review Best practices and Planning a BI project.

Key Features and Benefits

  • Post Boot Camp assistance:  You are provided a USB with 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

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.
Copyright 2014 by Pragmatic Works