Audience
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence.
Prerequisites
Before attending this course, students must have:
- An understanding of relational database concepts
- Experience of querying a relational database
- A fundamental understanding of reporting and analysis
Duration
5 days. Hands on.
Course Objectives
The course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore it is not necessary to know the SQL Server itself.
After completing this course you will be able to:
- Make your existing data work harder for you
- Integrate diverse data stores to a single repository
- Transform raw data to business intelligence
- Create eloquent reports from raw data
Course Content
Module 1: Introduction to SQL Server Reporting Services – SSRS
Overview of SSRS
Installing Reporting Services
The Reporting Lifecycle
Highlights of Reporting Services
Reporting Services Scenarios
Reporting Services Developer Tools
Module 2: Authoring Basic Reports
Creating a Basic Table Report
Report Definition Language
Accessing Data
Formatting Report Pages
Headers and Footers
Calculating Values
Common Aggregate Functions
Module 3: Enhancing Reports
Interactive Navigation
Use Show/Hide to Provide Drill-Down
Navigate From Report To Report Using Links
Working with Data Regions
Using Report Manager
Distribute and Manage Published Reports
Module 4: Introduction to SQL Server Integration Services – SSIS
What Is SSIS?
When to Use SSIS?
SSIS Architecture
Integration Services Scenarios
Integration Services Developer Tools
Control Flow and Design Flow
Design Surfaces
Migrating data across Excel, Flat Files, XML and database providers
Adding Tasks to a Package
Module 5: SSIS Going Further
Building a Package
Troubleshooting a Package
Deploying a Package to the SSIS Server
Scheduling a Package with SQL Server Agent
Securing a Package in Management Studio
Using Variables, Event Handlers and Configurations
Module 6: Introduction to SQL Server Analysis Services – SSAS
What Is SSAS?
When to Use SSAS?
SSAS Architecture
Analysis Services Tools
Understanding Fact and Dimension tables
Module 7: SSAS Going Further
Creating an Analysis Services Project in Visual Studio
Fact and Dimension Tables
Creating a Data Source
Creating a Data Source View
Creating a Cube Object Definition
Deploy Definitions to OLAP Server and Load in Data
Browse a Cube to Query Data
Creating Key Performance Indicators (KPI’s) to Give Meaning to Data