MSBI Online Training:

Regular Batch: Monday to Friday(1hr per day)

Fast-track Batch: as per student requirements


Introduction to Data warehousing
Data warehousing Overview
Architecture of Data warehousing
Data warehousing Terminologies
Dimensional Modeling

Introduction to SQL Server BIDS / SQL Server Data Tools
BIDS / Data tools Overview
Launching BIDS
Project templates

Introduction to SQL Server Integration Services
Product History
SSIS Package Architecture Overview
Introduction to Control Flow
Control Flow Overview
Precedence Constraints
Control Flow Tasks
Advanced Control Flow

Introduction to Data Flow
Data Flow Overview
Data Sources
Data Destinations
Data Transformations
Data Viewers
Variables and Configurations
Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Using variables to pass information between packages
Property expressions
Configuration Overview
Configuration options
Debugging, Error Handling and
SSIS debugging overview
Breakpoints in SSIS
SSIS debugging windows
Control Flow: The OnError event handler
Data Flow: Error data flow
Configuring Package Logging
Built-in log providers

SSIS Package Deployment
Configurations and deployment
The deployment utility
Deployment options
Deployment security
Executing packages – DTExec and DTExecUI


Introduction to SQL Server Analysis Services

OLAP Modeling
Modeling source schemas-stars and snowflakes
Understanding dimensional modeling-Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Using SSAS in BIDS
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS
KPIs , Perspectives, Translations – cube metadata and currency localization
Actions – regular, drill-through and Reporting
Advanced SSAS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact(degenerate) dimensions, Role-playing dimensions
Modeling changing dimensions –Dimension Intelligence Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures,
      time intelligence, account intelligence

Cube Storage and Aggregation
Customizing Aggregation Design -Processing Design
Partitions – relational and Analysis Services partitions
Welcome to the Real Time – ProactiveCaching

Beginning MDX (All Basics)
Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions
Adding calculated members
Adding scripts
Adding named sets

SSAS Administration
Best practices – health monitoring
XMLA scripting (SQL Mgmt Studio)
Other Documentation methods
Security – roles and permissions
Disaster Recovery – backup / restore
Clustering – high availability

Introducing SQL Server Reporting Services
SSRS  Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin
Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations and Formatting
Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting
Grouping and Sorting
Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports
Report Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
Creating Matrix Reports and Charts
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities
Managing Reporting Services
Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management
Studio-based Reporting Services Manager
Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security
Programming Reporting Services
The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls

Ad-Hoc Reporting with Report Builder
The Report Builder Architecture
Creating Report Model Projects
Running Report Builder







Weekend 7AM - 9PM
Daily 7AM - 9PM
joomla training