MSBI Online Training

MSBI Online Course Summary

Unit 1:

• What Is Microsoft Business Intelligence – MS BI?
• Fundamental Aspects – BI is UDM or Cube…
• Excel Pivot Table
• MS BI’s Analysis Services on the SQL Server
• SQL Reporting Services with Cube as the Data Source

Unit 2:

OLAP Modelling:

• Modelling Schemas – Snow Flakes and Stars
• Dimensional Modelling— Dimension Type 1, 2, or 3 or changing swiftly
• Fact (measures)
• Cube modelling
• Modelling and its types — Data Mining etc…

Unit 3:

SSAS in BIDS:

• Comprehend the Development Environment
• Create Data Source View and Data Sources
• Create Cubes – with the help of :

1. Cube Build Wizard and
2. UDM

• Fine tuning the Measures and Dimensions in BIDS

Unit 4:

SSAS – an Intermediary Stage

• KPIs
• Currency Localization and Cube Metadata conversions
• Varied Actions like drill-through, regular and reporting

 

Unit 5:

Head way to SSAS – Advanced Level!

• Use of Diverse Fact Tables
• Modelling the Intermediate Fact Tables
• Modelling the following dimensions:

1. M:M Dimensions
2. Write Back Dimensions
3. Fact (degenerate) Dimensions
4. Role-Playing Dimensions

• Modelling Modifying Dimensions – Dimension Intelligence w/ Wizard
• Make Use of the Add Business Intelligence Wizards such as

1. Write Back
2. Time Intelligence
3. Semi Additive Measures
4. Account Intelligence

Unit 6:

Cube Storage and Aggregation:

• Storage Topics –

1. Basic Aggregations
2.  MOLAP

• Advanced Storage Design

1. MOLAP,
2. HOLAP
3. ROLAP,

• Partitions

1. Relational and
2. Analysis Services Partitions

• Customizing Aggregation Design

1. Processing Design

• ROLAP Dimensions or Rapidly Changing Dimensions
• Real Time – Proactive Caching
• Cube Processing Possibilities

Unit 7:

MDX – the Beginning:

• Syntax
• MDX Query Editor in SQL Server Management Studio – its usage!
• Functions and the Common Tasks
• Innovative MDX Functions

Unit 8:

Intermediate MDX

• Add the Calculated Members, Named Sets and Scripts
• .NET Assemblies

Unit 9:

SSAS Administration

• Pre - Eminent Practices – Monitor the Health
• High Availability of Clustering
• XMLA Scripting (SQL Management Studio)
• Other Documentation Methods – Add on’s
• Set - backs can be recovered with the Restore and Backup options!!!
• Roles and Permissions – Security

Unit 10:

Curtain Raiser - Data Mining

• What is Data Mining?
• Use of every (9) algorithm  with examples:

          a)      MS Clustering,

          b)      Naïve Bayes,

          c)       MS Decision Trees,

          d)      MS Association Rules,

          e)      MS Sequence Clustering,

          f)       MS Time Series,

          g)      MS Neural Network

• Data Mining Dimensions
• Processing Mining Models
• Data Mining Clients

Unit 11:

Preface to Reporting Clients

• SQL RS & Report Builder
• Excel 2003 Pivot Tables
• SPS RS Web Parts
• .NET 2.0 report viewer controls
• Business Scorecards 2005
• ProClarity

Unit 12:

Future Directions – Amalgamation with Office 12

• SharePoint 12 and AS
• Report Center  - variety of dashboard uses the following –

          a)      Excel Web,

          b)      KPIs,

          c)       Excel Services 12 and AS (Web Services)

          d)      Reports,

          e)      Filter

Unit 13:

• SQL Server 2005 Integration Services
• Prolegomenon to the SQL Server Integration Services

Unit 14:

• History of the Product
• Development and Management Tools
• Source Control for SSIS Packages and its Architecture Synopsis
• Posting and Managing the SSIS Packages

Unit 15:

SSIS for DBAs: SQL Server Management Studio

• Export  and Import Wizard
• Exporting  and Importing Data
• Working with Packages
• Examining Database Maintenance Plan Packages
• Create Database Maintenance Plans using SSMS
• Database Maintenance Plans
• Scheduling and Executing the Plans
• Changes in the SQL Server 2005 Service Pack 2

Unit 16:

Business Intelligence Development Studio (BIDS):

• Initiating BIDS
• Project Templates
• Toolbox
• Package Designer
• Solution Explorer
• Variables and Properties Window
• SSIS menu

Unit 17:

Control Flow

• Overview of Control Flow
• Precedence Constraints
• The Tasks are:

          a)      Bulk Insert

          b)      Execute SQL

          c)       File System

          d)      Send Mail

          e)      FTP

Unit 18:

Advanced Control Flow

• Containers – Looping and Grouping 
• The Tasks are:

          a)      Web Service

          b)      Execute Package

          c)       Analysis Services

          d)      WMI

Unit 18:

Data Flow:

• Data Destinations and Transformations
• Transformation Types are:

          a)      Copy Column

          b)      Derived Column

          c)       Data Conversion

          d)      Conditional Split

          e)      Aggregate

           f)       Sort

Unit 19:

Configurations and Variables

• Variables Overview and Scope
• SSIS system variables
• Variables in Data and Control Flows
• Pass Information between Packages – using Variables
• Property expressions
• Configuration Overview, Discipline and Options

Unit 20:

Error Handling, Debugging and Logging

• SSIS Debugging Out line and its Windows
• Break points in SSIS
• Control Flow: On Error Event Handler
• Error Data Flow
• Configuring Package Logging
• In - Built Log Providers

Unit 21:

Data Flow

• Revisiting data sources and destinations
• Data Mining Model Training Destination
• The Transformations are:

          a)      Lookup

          b)      Multicast

          c)       Data Mining Query

          d)      Slowly Changing Dimension

          e)      Merge and Merge Join

          f)       Fuzzy Lookup and Grouping

Unit 22:

SSIS - Custom Code:

• SSIS Scripting and Editor
• SSIS Object
• SSIS Component Development
• Script Task and Component

Unit 23:

SSIS Package Deployment:

• Configurations and Deployment
• Deployment Options, Security and Utility
• DTExec
• DTExecUI

Unit 24:

SSIS Package Management

• SSIS Service
• Manage packages with DTUtil
• Handle packages with SQL Server Management Studio Scheduling packages with SQL Server Agent
• Introduction to SQL Server Reporting Services

 

Unit 25:

Features:

• Reporting Services Architecture, Terminology and Editions
• Take Reporting Services for a Spin

Unit 26:

Create Reports

• Deconstruct Reporting Services
• Shared Data Sources
• Create Reports from Scratch

Unit 27:

Calculations/ Formatting

• Create Expressions
• Global Collections
• Format Items
• Conditional Formatting

Unit 28:

Grouping/ Sorting

• Create Groups, Drill-Down Reports
• Calculate Totals, Percentages
• Interactive Sorting

Unit 29:

Parameters

• Create Report, Drop-Down and Multi-Valued Parameters
• Debug Parameter Issues

Unit 30:

Create Matrix Reports and Charts

• Create Matrix Report and Chart
• Matrix Subtotals
• Charting Possibilities

Unit 31:

Reporting Services

• Deploy Reports and Data Sources
• Export Reports and Printing
• Web-Based Report Manager
• SQL Server Management Studio-based Reporting Services Manager

Unit 32:

Reporting Services Security

• Securing Access to Reports
• Data Source Security

Unit 33:

Programming Reporting Services

• APIs
• Integrating Reporting Services
• Report Viewer Controls

Unit 34:

Advanced Reporting Services Programming

• Reporting Services Web Service
• Working with Custom Assemblies

Unit 35:

Snapshots and Subscriptions

• Caching and Snapshots
• Standard, Data-Driven and Manage the Subscriptions

Unit 36:

Ad-Hoc Reporting:

• Report Builder Architecture
• Make Report Model Projects
• Run Report Builder

 

The career for an MS BI Developer is on a roll! MS BI is the company’s reliable product! Recession or no recession the Best Talent will be retained to either expand the Business or get it back to its glory days!!! Moreover little experience would be enough provided you are ready to head on with the challenges!!! The pay is as well not a constraint as at the minimum it starts with INR 202, 947 and goes up to INR 859, 405 (approx)... so go on and check the latest features at Shiksha Tarang...

Frequently Asked Questions