Description
Duration: 5 days
This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
The primary audience for this course is database professionals who need to fulfill a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.
After completing this course, students will be able to:
Describe key features of data modeling within business intelligence
Describe various report services data sources and how these are configured
Create reports with report designer and/or report designer
Configure reports with report designer and /or report builder
Create SQL Server mobile reports
Prerequisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
20761A: Querying Data with Transact-SQL
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/25/2023 | 12/27/2023 | ||||
| 1/15/2024 | 1/17/2024 | ||||
| 2/5/2024 | 2/7/2024 | ||||
| 2/26/2024 | 2/28/2024 | ||||
| 3/18/2024 | 3/20/2024 | ||||
| 4/8/2024 | 4/10/2024 | ||||
| 4/29/2024 | 5/1/2024 | ||||
| 5/20/2024 | 5/22/2024 | ||||
| 6/10/2024 | 6/12/2024 | ||||
| 7/1/2024 | 7/3/2024 | ||||
| 7/22/2024 | 7/24/2024 | ||||
| 8/12/2024 | 8/14/2024 | ||||
| 9/2/2024 | 9/4/2024 | ||||
| 9/23/2024 | 9/25/2024 | ||||
| 10/14/2024 | 10/16/2024 | ||||
| 11/4/2024 | 11/6/2024 | ||||
| 11/25/2024 | 11/27/2024 | ||||
| 12/16/2024 | 12/18/2024 | ||||
| 1/6/2025 | 1/8/2025 |
Curriculum
Module 1: Introduction to Business Intelligence and Data Modelling
In this module, students will be introduced to the key concepts in business intelligence and the Microsoft BI product suite.
Lessons
Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services
Lab: Exploring an enterprise BI solution
After completing this module, you will be able to:
Describe key concepts in business intelligence
Describe the Microsoft BI platform
Describe key concepts in reporting services
Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.
Lessons
Data connections
Connection strings
Filters and parameters
Lab: Configuring a data connection
After completing this module, you will be able to:
Describe data connections and connection strings
Describe filters and parameters
Module 3: Implementing reports
Create reports with report designer or report builder.
Lessons
Creating a report with the report wizard
Creating a report
Showing data graphically
Lab: Creating a report
After completing this module, you will be able to:
Create a report using the report wizard
Show data graphically
Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.
Lessons
Implementing filters and parameters
Implementing sorting and grouping
Publishing a report
Lab: Creating a map report
After completing this module, you will be able to:
Implement filters and parameters
Implement sorting and grouping
Publish a report
Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.
Lessons
Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab: Mobile reports
After completing this module, you will be able to:
Describe SQL Server mobile reports
prepare data for mobile reports
Publish mobile reports
