MSBI 2012 - SSIS,SSRS,SSAS Course Content and Online Trainings.

                                                   MSBI Course Content

1. SSIS (SQL Server Integration Services)
2. SSAS (SQL Server Analysis Services)
3. SSRS (SQL Server Reporting Services)

1.    Introduction:

a.    Import and Export Wizard

b.    SQL Server Data Tools

2.    Installation and Getting Started

a.    Moving Data with the Import and Export Wizard

b.    Installing SQL Server Integration Services

c.     Installing the Sample Databases

d.    Creating a Solution and Project

e.    Exploring SQL Server Data Tools

f.     Creating Your First Package

3.    Control Flow

a.    Using Precedence Constraints

b.    Manipulating Files with the File System Task

c.     Coding Custom Script Tasks

d.    Using the Execute SQL Task

e.    Using the Execute Process Task

f.     Using the Expression Task

g.    Using the Send Mail Task

h.    Using the FTP Task

i.      Creating a Data Flow

4.    Data Flow

a.    Extracting Data from Sources

b.    Loading Data to a Destination

c.     Changing Data Types with the Data Conversion Transform

d.    Creating and Replacing Columns with the Derived Column Transform

e.    Rolling Up Data with the Aggregate Transform

f.     Ordering Data with the Sort Transform

g.    Joining Data with the Lookup Transform

h.    Auditing Data with the Row Count Transform

i.      Combining Multiple Inputs with the Union All Transform

j.     Cleansing Data with the Script Component

k.    Separating Data with the Conditional Split Transform

l.     Altering Rows with the OLE DB Command Transform

m.   Handling Bad Data with the Fuzzy Lookup

n.    Removing Duplicates with the Fuzzy Grouping Transform

5.    Configuring Packages

a.    Easing Deployment with Configuration Tables

b.    Easing Deployment with Configuration Files

c.     Configuring Child Packages

6.    Troubleshooting SSIS

a.    Logging Package Data

b.    Using Event Handlers

c.     Troubleshooting Errors

d.    Using Data Viewers

e.    Using Breakpoint

7.    Introduction

a.    Define Business Intelligence

b.    Understand the Cube Structure

c.     Deploy and View a Sample Cube

d.    View a Cube by using Excel

e.    View a Cube by using SQL Reporting Services

8.    OLAP Modeling

a.    Understand Basic OLAP Modeling (star schema)

b.    Understand Dimensional Modeling (stars and snowflakes)

c.     Understand Measure (fact) and Cube Modeling

9.    Introduction to SQL Server Data Tools (SSDT)

a.    Create Data Sources

b.    Create Data Source Views

c.     Create Cubes by using the Cube Wizard

d.    Understand the Development Environment

10.  Intermediate SSAS

a.    Learn how to Create Key Performance Indicators (KPIs)

b.    Discover how to Create Perspectives

c.     See how to Create Translations for Cubes and Dimensions

11.  Cube Storage and Aggregation

a.    View Aggregation Designs

b.    Customize Aggregation Designs

c.     Implement Proactive Caching

d.    Use Relational and SSAS Partitions

e.    Customize Cube and Dimension Processing

12.  Introduction to MDX Queries

a.    Understand Basic MDX Syntax

b.    Use the MDX Query Editor in SSMS

c.     Understand Common MDX Functions and Tasks

d.    Review MDX Functions New to SSAS 2012

13.  SSRS Overview and Tools

14.  Creating Basic Reports

a.    What is a Data Source?

b.    What is a Dataset?

c.     Using the Report Wizard

d.    What is Tablix?

e.    Creating a Tabular Report

f.     Creating a List Report

g.    What is a Matrix?

h.    Deploying a Project

15.  Formatting Reports

a.    Working with Text Boxes

b.    Rich Text Formatting

c.     Managing Text Boxes

d.    Drawing Lines and Boxes

e.    Images

f.     Page Headers and Footers

g.    Adding a Document Map

h.    Rendering Reports

16.  Custom Expressions

a.    Understanding Expressions

b.    Defining Expressions

c.     Working with Report Variables

d.    Understanding Lookup, LookupSet, and Multilookup Functions

e.    Expression Samples

17.  Summarizing and Sorting

a.    Creating Groups

b.    Parent/Child vs. Adjacent Groupings

c.     Adding Totals and Aggregations

d.    Creating Aggregates of Aggregates

18.  Add Flexibility with Parameters

a.    Adding Parameters to a Report

b.    Report Parameters vs. Query Parameters

c.     Manage Report Parameter Properties

d.    Use Parameters with SQL Queries and Stored Procedures

e.    Work with Cascading Parameters

f.     Sort Based on a Parameter Setting

g.    Filtered Reports

19.  Enhanced Report Items

a.    Charts

b.    Gauges

c.     Add a Map to a Report

d.    Data Bar, Indicator, and Sparkline Report Items

e.    Nesting Data Regions

f.     Subreports and Drillthrough Reports

g.    Working with Drillthrough Reports

20.  Using Report Manager

a.    Deployment

b.    Navigating Report Manager

c.     Understanding Permissions

d.    Viewing Reports

e.    Working with Shared Data Sources

f.     Managing Reports