SQL Server 2019 Business Intelligence: Integration Services and Analysis Services
Hands On Technology Transfer, Inc.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...
Contact this provider
Contact info
Hands On Technology Transfer, Inc.
Have a question about this course? Fill out this form and the provider will get in touch with you shortly
No reviews available
Need help with your search?
findcourses.com offers a free consultancy service to help compare training for you and your team