Call us on 07035368449 or Request a call back Today !

Microsoft BI (Reporting, Integration & Analysis Services)

14 Days Microsoft BI Stack Intensive Course – Create, Deploy and Manage

What is Microsoft Business Intelligence Stack ?

Microsoft provides a complete set of Business Intelligence tools as part of Microsoft SQL Server. The Microsoft BI stack includes products for data integration (SSIS), analytics (SSAS) and business intelligence (SSRS), and visualisation.

About the course

This course is designed for IT Professionals who are interested in leaning how to implement Business Intelligence solutions on the Microsoft BI Stack.
The course will focus on teaching IT Professionals the best practices and skills required to successfully design and build and operate a business intelligence solutions using SQL Server 2012 Integration Services, Analyisis Services and Reporting Services.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Business Intelligence.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems.

Course Schedule: 14 Days, 88 Academic Hours

 

Course Syllabus:

Day 1
Introducing Reporting Services (SSRS)

  • Who uses SSRS
  • BIDS and Report Manager
  • Reporting Fundementals
  • Business Intelligence Reporting Solutions
  • Data Sources and Data Stages
  • Reporting Engine Architecture
  • Basic Report Design and Delivery

Day 2
Reporting Services Installation and Architecture

  • SSRS Tools: Report Designer, Power View, Report Builder, Report manager, SharePoint Libraries, Reporting Services Configuration Manager, SQL Server Management Applications
  • SSRS Windows Service
  • SSRS Processors & Extensions: Processing & Rendering Extensions (HTML, CSV, XML, Image, PDF, Excel, Word)
  • SSRS Delivery Extensions
  • SSRS Databases: ReportServer, ReportServerTempDB

Day 3
Report Planning and Design

  • SSRS Report Planning
  • Data Sources & Options
  • Optimizing Data Sources
  • Dynamic Expressions and Optins
  • Reporting Functions and Formatting
  • Images and Textbox
  • Report Headers and Footers
  • Enterprise and Ad-hoc Reports

Report DataSets and Joins

  • Working with Multiple DataSets
  • Joining Local and Shared Datasets
  • Configuring Dynamic DataSets
  • Working with Remote Datasets
  • Reusing XML based Datasets

Report Design and SubReports

  • Designing Wizard based Reports
  • Designing Custom Reports
  • Using Tables and Matrix
  • Chart Based Reports and Images
  • Using SSRS Expressions & Globals

Day 4
Report Layout & Formatting

  • Report Layout Types: Table, Matrix, List, Chart, Gauge and Dashboard, Maps
  • Tablix Regions
  • Tablix Properties
  • Table Groups
  • Group Expressions
  • Interactive Sort
  • Page Breaks
  • Drill Down & Dynamic Visibility
  • Formatting Report Data
  • Dynamic Formatting
  • Multicolumn Reports
  • Gauge Reports

Report Parameters & Usage

  • Parameters and Properties
  • Dynamic Parameters & Usage
  • Dependant Parameters & Usage
  • Multivalued Nullable Parameters
  • Report Filters in Data Sets
  • Report Filters in Tollbox
  • Sub Reports and Parameters
  • Parent-Child Report Parameters

Enterprise Report Styles

  • Gauge Reports, Indicator Reports
  • Pie Charts and Data Bars
  • Rectangle and List Reports
  • Report Testing and auto Refresh
  • Map Reports and Dashboads
  • Report Scorecards with T-SQL
  • Exporting Reporting Data
  • LOOKUP Functions and Options

SSRS using OLAP Cubes

  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries in Cube Reports
  • Report Scorecards with MDX

Day 5
SQL Integration Services (SSIS)

Introduction to SQL Server Integration Services (SSIS)

  • SSIS Overview
  • SSIS Architecture

Introduction to Control Flow

  • Overview of Control Flow in Integration Services
  • Elements in Control Flow
  • Control Flow Tasks
  • Working with Workflow Tasks
  • Precedence Constraints

Introduction to Data Flow

  • Data Flow Overview
  • Data Flow Pipeline
  • Data Flow Sources
  • Data Flow Destination
  • Data Viewers
  • Data Transformations

Variables and Configurations

  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Understanding Property Expressions
  • Using Property Expressions
  • Understanding Configurations
  • Using Configurations
  • Using Variables and Configurations between Packages

Package Deployment

  • Overview of Deploying Packages
  • Deployment Challenges
  • Create a Package Deployment Utility
  • The Package Installation Wizard
  • Deploy a Package to the File System
  • Deploy a Package to SQL Server
  • Importing a Package Using Management Studio
  • Redeploying Update Packages

Day 6
Introduction to SQL Server Integration Services (SSIS)

  • SSIS Overview
  • SSIS Architecture
  • Exploring SQL Server Data Tools
  • Creating a SSIS Solution and Project
  • Creating a Basic SSIS Package
  • Moving Data with the Import Export Wizard

Introduction to Control Flow

  • Overview of Control Flow in Integration Services
  • Connecting Control Flow with Precedence Constraints
  • Manipulating Files with File System Task
  • Coding Custom Script Tasks
  • Control Flow Tasks
  • Working with Workflow Tasks
  • Using Execute SQL Task
  • Using Execute Process Task
  • Using File System Task
  • Using Send Mail Task
  • Using FTP Task
  • Elements in Control Flow
  • Creating a Data Flow

Day 7
Introduction to Data Flow

  • Data Flow Overview
  • Data Flow Pipeline
  • Extracting Data from Sources
  • Loading Data to a Destination
  • Changing Data Types with the Data Conversion Transform
  • Creating and Replacing Columns with the Derived Column Transform
  • Rolling up Data with the Aggregate Transform
  • Ordering Data with the Sort Transform
  • Joining Data with Lookup Transform
  • Auditing Data with the Row Count Transform
  • Combining Multiple Inputs with the Union All Transform
  • Cleansing Data with Script Component
  • Seperating Data with Conditional Split Transform
  • Alternating Rows with OLE DB Command Transform
  • Handling Bad Data with the Fuzzy Lookup Transform
  • Removing Duplicating with the Fuzzy Grouping Transform
  • Data Viewers
  • Data Transformations

Variables and Configurations

  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Understanding Property Expressions
  • Using Property Expressions
  • Understanding Configurations
  • Using Configurations
  • Using Variables and Configurations between Packages

Day 8
How to make SSIS Packages Dynamic

  • Making a SSIS Package Dynamic with variables
  • Making a Connection Dynamic with Expressions
  • Making a Task Dynamic with Expressions

Containers

  • Using Sequence Containers to Organize a Package
  • Using for Loop Containers to Repeat Control Flow Tasks
  • Using the Foreach Loop Container to Loop through a collection of objects

Trouble Shooting SSIS

  • Logging Package Data
  • Using Event Handlers
  • Troubleshooting Errors
  • Using Data Viewers
  • Using Breakpoints

Day 9
SSIS Package Deployment

  • Overview of Deploying Packages
  • Deployment Challenges
  • Create a Package Deployment Utility
  • The Package Installation Wizard
  • Deploy a Package to the File System
  • Deploy a Package to SQL Server
  • Importing a Package Using Management Studio
  • Redeploying Update Packages

Administering SSIS

  • Creating and Configuring the SSIS Catalog
  • Deploying Packages to the SSIS Catalog
  • Securing SSIS Packages
  • Running SSIS Packages
  • Scheduling Packages

Wrap up and Review

  • Bringing it all Together
  • SSIS Component and Crib Notes
  • Problem and Solution Crib Notes

Day 10
Introduction to SQL Server Analysis Services

  • Business Intelligence Overview
  • What is Microsoft Business Intelligence?
  • Overview of SQL Server Analysis Services
  • Introduction to SQL Server Data Tools
  • Understanding and Configuring Visual Studio
  • Overview of OLAP and OLTP
  • Data Warehouse Design
  • Creating a SSAS Project
  • Creating an Analysis Services Database

Understanding Data Sources and Data Source Views

  • Supported SSAS Data Sources
  • How to create a Data Source using the Data Source View Wizard & Designer
  • How to create a Data View

Day 11
Understanding SSAS Cubes

  • What are Cubes
  • Creating Cubes with the Cube Wizard
  • Creating Cube Dimensions
  • Relationship Types:No Relationship, Regular, Fact, Many to Many
  • Measure and Measure Groups
  • Formatting Measures
  • Calculated Members: Creating Calculations
  • Formatting Calculations
  • Creating Perspectives
  • Creating Translations
  • Browsing Perspectives and Translations
  • Deploying Browsing a Cube
  • How to query a cube in SQL Server Management Studio

Dimension Design

  • The Dimension Wizard
  • Working with the Dimension Designer:Attributes, Attribute Relationships ,User Hierarchies
  • Role Playing Dimensions
  • Referenced Dimensions
  • Browsing a Dimension
  • Defining Translations in Dimensions
  • Creating Snowflake Dimensions
  • Deploying Dimensions

Day 12
Introduction to MDX Queries

  • What is MDX
  • Understanding MDX Syntax
  • Using MDX Query editor in SSMS
  • Understanding MDX Functions and Tasks
  • Understanding Measures and Measure Groups
  • Hierarchies & Hierarchy Levels
  • Members
  • Cells
  • Tuples
  • Sets
  • MDX Queries

SSAS Administration

  • Implementing SSAS Security
  • Implementing XMLA Scripts in SSMS
  • Processing SSAS Objects
  • Managing Partitions
  • Understanding SSAS Database Backup and Restore

Day 13
Managing Deployment

  • Deployment Overview
  • Deployment Mechanics
  • Deployment using SQL Server Data Tools
  • Deployment using Deployment Wizard
  • Understanding Deployment Scripts

Managing Partitions and Database Processing

  • Understanding Dimension Storage Modes
  • Understanding Partition Storage Modes
  • Processing a Dimension
  • Processing a Cube
  • Working with Partitions
  • Creating Partitions

Day 14
Implementing Security

  • Understanding Roles
  • Securing Administrative Access
  • Assigning Database level administrative Access
  • Securing Data Access
  • Granting Access to Cubes
  • Restricting Access to Dimension Members
  • Restricting Access to Cells

Advanced Monitoring and Management Tools

  • Monitoring Analysis Services using Windows Reliability and Performance Monitor
  • Monitoring Analysis Services using SQL Server Profiler

Retrieving Data and Analysing Cubes with Microsoft tools

  • Accessing Analysis Services using Excel 2007
  • Creating Reporting Services Reports
  • Analysing Data in Excel
  • Analysing Data in PowerPivot

Your Trainer

Our international certified trainers are highly experienced Microsoft practitioners who have real-world expertise.

Key Information

I – All course material including a copy of will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed SQL Server 2012 and SQL Server Data Tools.

III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire using the form above or call 07035368449

Your Name (required)

Company Name

Phone Number

Your Email (required)

Courses

Your Message

Microsoft BI Stack

₦600,000per course