Microsoft SQL Server Business Intelligence

Microsoft SQL Server Business Intelligence

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

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...