SQL Server Business Intelligence Bootcamp

Code: 50008
Course duration: 2 days
Location Period
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Secaucus, New Jersey (Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Attend Online
11-30 09:00AM to 12-01 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
11-30 09:00AM to 12-01 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Greenwich, Connecticut (Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Attend Online
12-28 09:00AM to 12-29 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
12-28 09:00AM to 12-29 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Fort Lauderdale, Florida (Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Attend Online
01-25 09:00AM to 01-26 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
01-25 09:00AM to 01-26 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Mid-Town New York City (Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Attend Online
02-22 09:00AM to 02-23 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
02-22 09:00AM to 02-23 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll
Attend Online
03-29 09:00AM to 03-30 05:00PM
enroll
NYC-23rd Street (Instructor-Led)
03-29 09:00AM to 03-30 05:00PM
enroll

SQL Server Business Intelligence

Course 50008: Two Days; Instructor-Led

About this Course

Elements of this syllabus are subject to change.

This two-day instructor-led course provides students with the knowledge of the many new and enhanced Microsoft SQL Server business intelligence (BI) features designed to give a students a competitive advantage. These advantages include integrating multiple data sources with Integration Services; enriching data and building complex business analytics with Analysis Services; and writing, managing, and delivering rich reports with Reporting Services.

Audience Profile

This course is intended for IT professionals.

Prerequisites

Before attending this course, students must have:

  • Basic knowledge of SQL Server

At Course Completion

After completing this course, students will be able to:

  • Explain the elements of SQL Server Business Intelligence.
  • Input and output data, script to branch control, and configure and deploy packages.
  • Create an account and work with measures.
  • Scale Analysis Services.
  • Use Client Reporting Tools and the web service.
  • Create custom OLAP clients.
  • Create queries using Analytical MDX.
  • Create and execute a package using Integration Services.

Course Outline

Module 1: Quick Start Introduction
Lessons

  • Introduction
  • Integration Services
  • Analysis Services
  • Reporting Services
  • SQL Server Management Studio

Module 2: Integration Services
Lessons

  • Introduction
  • Cleanse Data Input
  • Output to Multiple Destinations
  • Script to Branch Control
  • Lookup Fuzzy Values
  • Package Configuration and Deployment

Module 3: Core Analysis Services
Lessons

  • Introduction
  • Explore Analysis Services Objects
  • Create an Account (Parent-Child) Dimension
  • Create Measure Groups
  • Add Time
  • Work with Measures
  • Create AMO

Module 4: Analysis Services Scalability
Lessons

  • Analysis Services Demonstrations
  • Introduction
  • Cube Scalability
  • Aggregates in Natural Hierarchies

Module 5: Client Reporting Tools
Lessons

  • Client Reporting Tools Demonstrations
  • Introduction
  • Use URL Access in Applications
  • Use the Web Service

Module 6: Custom OLAP Clients
Lessons

  • Custom OLAP Clients Demonstrations
  • Introduction
  • Render Cells
  • Render a Flattened Rowset

Module 7: Analytical MDX
Lessons

  • Analytical MDX
  • Introduction
  • MDX Queries: MDX vs. SQL
  • MDX Stored Procedures

Module 8: Data Mining
Lessons

  • Data Mining
  • Introduction
  • Browse Data Mining Models
  • Add DM Viewers to a Web Page

Module 9: Extending Integration Services
Lessons

  • Extend Integration Services
  • Introduction
  • Create and Execute a Package

Guaranteed to Run

2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2017-12-11 09:00 to 2017-12-15 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-11-27 09:00 to 2017-12-01 17:00
Attend Online
2017-11-27 08:00 to 2017-12-01 17:15
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review