Call us at 1-800-413-0939
Hands On Technology Transfer
gsa

Hands On SQL Server Business Intelligence Training in the USA

Attend courses for training on SQL Server Reporting Services, Analysis Services, and Integration Services

Looking for a complete Class Index instead? Click here.

SQL Business Intelligence Courses (SSRS, SSIS, and SSAS)

The Hands On Technology Transfer SQL Server Business Intelligence training curriculum offers a task-oriented, cost effective approach to learning the SQL Server BI suite: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS). Comprehensive hands on exercises are integrated throughout our SQL Server BI training to reinforce learning and develop real competency. All courses consist of 50% hands-on lab exercises during class time. SQL Business Intelligence courses may be attended in-person in the classroom, online from your home via live remote attendance, or through on demand training at your convenience.

SQL Server Business Intelligence Duration Price: Live DeliveryPrice: On-Demand
SQL Server 2019
SQL Server 2019 Reporting Services 3 days / 21 hours $1695$1495
SQL Server 2019 Business Intelligence: Integration Services and Analysis Services 5 days / 35 hours $2495$1495
SQL Server 2019 Business Intelligence Application Development (SSRS, SSIS, SSAS) 5 days / 35 hours $2495$1495
SQL Server 2017
SQL Server 2017 Reporting Services 3 days / 21 hours $1695$1495
SQL Server 2017 Business Intelligence: Integration Services and Analysis Services 5 days / 35 hours $2495$1495
SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS) 5 days / 35 hours $2495$1495
SQL Server 2016
SQL Server 2016 Reporting Services 3 days / 21 hours $1695$1495
SQL Server 2016 Business Intelligence: Integration Services and Analysis Services 5 days / 35 hours $2495$1495
SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS) 5 days / 35 hours $2495$1495
Power BI
Analyzing Data with Power BI 3 days / 21 hours $1695$1495
Analyzing Data with Power BI, DAX, and Power Query M 5 days / 35 hours $2495$1495

Which Course Best Fits Your Needs?

SQL Server Reporting Services Training

The 3-day SQL Server 2019 Reporting Services course (as well as the SQL 2017 and SQL 2016 versions) includes an overview of SQL Server business intelligence architecture, and then focuses on the role of Reporting Services. Students will design, develop, and deploy database reports utilizing both Visual Studio and SQL Server Management Studio. Reports created during class will be able to consume data from relational, multi-dimensional, and tabular data sources.

Before taking this SQL Reporting Services training course it is highly recommended, though not required, that students already have knowledge of being able to read and understand basic SQL SELECT queries and JOIN statements, so that they can understand the queries for data that are used by their reports. HOTT's SQL Programming course provides an excellent option for learning this skill, as well as teaching about many more useful & fundamental SQL database topics. Information and Pricing on multi-class training passes is available here.

Attendees who are also interested in Integration Services and Analaysis services should follow up this Reporting Services course with our 5-day SQL Server 2019 Business Intelligence: Integration Services and Analysis Services course (or the SQL 2017 and SQL 2016 versions). Information and Pricing on multi-class training passes is available here.

SQL Server Integration Services Training and SQL Server Analysis Services Training

The 5-day SQL Server 2019 Business Intelligence: Integration Services and Analysis Services course (as well as our SQL 2017 and SQL 2016 equivalent offerings) focus on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server. Students work with complex SSIS data migration projects that import/export data between multiple formats including: Access, SQL Server, Oracle and other databases, XML files, Excel spreadsheets and flat files. Students will learn how to use SSAS to design, build and populate data warehouses to stage data for use by data cubes, and will perform hands-on exercises to design and build a data warehouse. The SSIS/SSAS training course also includes an overview of data mining and the tools available to do this in SSAS, supported by a hands-on exercise that walks through the process of defining a data mining structure to predict future sales. Administration topics related to data cubes are covered, including exercises that deploy and secure cubes, process and manage cubes.

Before taking this SQL Integration and Analysis Services training course it is highly recommended, though not required, that students already are capable of being able to read and understand basic SQL SELECT queries and JOIN statements, so that they have foundational querying knowledge that will better prepare them for MDX data cube querying. HOTT's SQL Programming course provides an excellent option for learning this skill, as well as teaching about many more useful & fundamental SQL database topics. Information and Pricing on multi-class training passes is available here.

Attendees who are also interested in Reporting Services should precede this Integration/Analysis Services course with our 3-day SQL Server 2019 Reporting Services course (or the SQL 2017 and SQL 2016 versions), and then move on to the appropriate Integration and Analysis services course afterwards. Information and Pricing on multi-class training passes is available here.

Reporting Services, Integration Services, and Analysis Services Training in 1 Week

For students that want to learn about all three SQL BI services (Reporting Services, Integration Services, and Analysis Services) but can only dedicate one week for training, HOTT does offer a 5-day SQL Server 2019 Business Intelligence Application Development (SSRS, SSIS, SSAS) course which covers everything in the 3-day Reporting Services course, as well as providing a 1-day introduction to Integration Services and a 1-day introduction to Analysis Services. HOTT also offers SQL 2017 and SQL 2016 equivalents.

Before taking the SQL Server 2019 Business Intelligence Application Development (SSRS, SSIS, SSAS) training course it is highly recommended, though not required, that students already have knowledge of being able to read and understand basic SQL SELECT queries and JOIN statements, so that they have a preexisting knowledge base that will make learning Reporting Services and Analysis Services easier. HOTT's SQL Programming course provides an excellent option for learning this foundational base of knowledge, as well as teaching about many critical SQL database topics. Information and Pricing on multi-class training passes is available here.

Power BI

Though not part of the SQL Server Business Intelligence suite, Power BI provides a way to unify creation and management of reports that can draw in data from a wide range of data sources including SQL Server, Excel, Access, Azure, and many more (click here for a full list of eligible data sources). In the Analyzing Data with Power BI course, students will learn to use the Power BI Desktop and Power BI online service to import, analyze, and visualize business data, and to share business intelligence.

Before taking the Analyzing Data with Power BI training course it is recommended, but not required, that students already have previous basic familiarity with some kind of relational database product or system. HOTT's SQL Programming course provides an excellent option for learning this foundational base of knowledge, as well as teaching about many important SQL database topics. Information and Pricing on multi-class training passes is available here.

Power BI, DAX, and Power Query M Training

The Analyzing Data with Power BI, DAX, and Power Query M course covers everything in the 3-day Power BI course, but also includes an additional 2 days of training specifically providing coverage of Data Analysis Expressions (DAX) and Power Query M. Students will learn DAX fundamentals, as well as practice using DAX to solve common data modelling problems. Attendees will also learn how to utilize the Power Query M language to write advanced data queries.

Before taking the Analyzing Data with Power BI, DAX, and Power Query M training course it is recommended, though not required, that students should already have previous basic familiarity with some kind of relational database product or system. HOTT's SQL Programming course provides an excellent option for acquiring this foundational base of knowledge, and also teaches about numerous fundamental SQL database topics. Information and Pricing on multi-class training passes is available here.

Students who are interested in Power BI but not DAX and Power Query M may instead be better served by taking the shorter 3-day Analyzing and Presenting Data with Power BI course offered by HOTT.


HOTT offers competency-based SQL Business Intelligence courses in more than 100 cities across North America. HOTT also offers additional Microsoft SQL Server training such as SQL Server Administration training, Transact-SQL training, and Power BI courses. Our training emphasizes a hands on, task-oriented curriculum. When students train with HOTT they are guaranteed small class sizes, expert instructors, and comprehensive hands on exercises. HOTT offers a wide selection of discount programs to accommodate individuals as well as groups both small and large. Choose from face-to-face in the classroom, remote-live, on-demand or group training options.

If you need additional assistance in choosing a course, contact our helpful Customer Service staff at 800-413-0939, or fill out a Contact Form here. For a comprehensive list of all our course offerings, visit our full Course Index here.

Multiple Training Options - Convenience and Cost Control


Prefer training from home or the office?


Courses are available via scheduled live Remote Attendance or On Demand Training at your convenience

Looking for face-to-face training?


Attend Regularly Scheduled Courses in More than 100 Cities Across North America: