Show as: Mobile

SQL Server 2019 Business Intelligence: Integration Services and Analysis Services

Hands On Technology Transfer, Inc.
Training overview
Professional Course
Webinar, Self-paced Online, Virtual Classroom
35 hours (live)/30 days (on-demand)
From 1,495 USD
Start dates
1,495 USD
Inquire for more information

1,495 USD
Start anytime

1,495 USD
Start anytime

Course description

SQL Server 2019 Business Intelligence: Integration Services and Analysis Services

SQL Server 2019 provides a rich environment for business intelligence development. The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing. During class, students will build Multidimensional and Tabular models to use as reporting data sources.Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts. Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Cubes will be customized to include Key Performance Indicators (KPIs), Calculated Members, Named Sets, Navigational Hierarchies, and Perspectives.

Comprehensive hands on exercises provide the students with extensive practice applying the concepts presented.

Who should attend?

Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.

Training content

  • Business Intelligence Framework Overview
  • Common SSIS Tasks
  • Advanced SSIS Tasks
  • SSIS Administration and Automation
  • Creating and Populating Data Warehouses
  • Multidimensional (MDX) Essentials
  • Customizing Cubes
  • Adding Custom Calculations
  • Subdividing Cubes Using Perspectives
  • Creating and Customizing Tabular Models
  • Working with Data Mining Structures
  • Integration Services Architecture
  • Data Transformations
  • Advanced Data Transformations
  • Data Warehouse Design
  • Creating and Managing Cubes
  • MDX Functions
  • Cube Deployment and Administration
  • Deploying and Processing Cubes
  • Connecting to Cubes from Excel and Other Clients
  • Understanding the Data Mining Process
  • Using the Semantic Models in the Presentation Layer

Course delivery details

Delivery Options: Attend face-to-face in the classroom,remote-live or via on-demand training.

Certification / Credits

  • Structure and function of a data warehouse or data mart
  • Data warehouse design to support enterprise reporting
  • The role of SSIS within the business intelligence framework
  • Developing SSIS Extract Transform Load (ETL) processes to populate data warehouses
  • Functionality of all SSIS Control Flow tasks
  • Deploying SSIS projects to SSIS Catalogs
  • Configuring SSIS environments, runtime variables and parameters
  • BI Semantic Model
  • Multidimensional Expressions (MDX) syntax
  • Developing SSAS Multidimensional models
  • Data Analysis Expressions (DAX)
  • Developing SSAS Tabular models
  • Deploying and securing Multidimensional and Tabular models
  • Implementing SSAS Data Mining models for predictive analysis
  • Consuming the BI Semantic Model in reports and dashboards

About HOTT

Hands On Technology Transfer, Inc.

Hands On Technology Transfer (HOTT) was established in 1995 and has always had the same mission: to provide the best possible IT training and always assure that students attain competence and confidence in the skills being taught. HOTT’s innovative approach...

Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about SQL Server 2019 Business Intelligence: Integration Services and Analysis Services.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Hands On Technology Transfer, Inc.

 Show phone number

Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search? offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote