SQL Server Business Intelligence Bootcamp

Code: 50008
Course duration: 2 days

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.


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

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

Module 2: Integration Services

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

Module 3: Core Analysis Services

  • 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

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

Module 5: Client Reporting Tools

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

Module 6: Custom OLAP Clients

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

Module 7: Analytical MDX

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

Module 8: Data Mining

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

Module 9: Extending Integration Services

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

Guaranteed to Run

2020-03-18 09:00 to 2020-03-20 17:00
Newark, New Jersey (Virtual Instructor-Led)
2020-03-18 09:00 to 2020-03-20 17:00
Attend Online
2020-03-09 09:00 to 2020-03-13 17:00
Attend Online
2020-03-04 09:00 to 2020-03-06 17:00
NYC-23rd Street (Virtual Instructor-Led)
2020-03-02 09:00 to 2020-03-06 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
09:00 to 17:00
Secaucus, New Jersey (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review