MSBI Online Training

MSBI Online Training


    MicroSoft – Business Intelligence (SSIS, SSAS, SSRS) Course Content:

    SQL Server 2008 – Analysis Services

    1.What is Microsoft BI?

    • Core concept – BI is the cube or UDM
    • Example cube as seen using Excel pivot table
    • MS BI is comprehensive – more than Analysis Services on SQL Server
    • Demonstration of SQL Reporting Services with cube as data source

    2.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
    • Other types of modeling—data mining etc…

    3.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

    4.Intermediate SSAS

    • Perspectives
    • Translations – cube metadata and currency localization
    • Actions – regular, drill-through and reporting

    5.Advanced SSAS

    • Using multiple fact tables
    • Modeling intermediate fact tables
    • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
    • Modeling changing dimensions – Dimension Intelligence w/ Wizard
    • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

    6.Cube Storage and Aggregation

    • Storage topics – basic aggregations, MOLAP
    • Advanced Storage Design – MOLAP, ROLAP, HOLAP
    • Partitions – relational and Analysis Services partitions
    • Customizing Aggregation Design – Processing Design
    • Rapidly changing dimensions / ROLAP dimensions
    • Welcome to the Real Time – Proactive Caching
    • Cube processing options

    7.Beginning MDX

    • Basic syntax
    • Using the MDX query editor in SQL Server Management Studio
    • Most-used Functions & Common tasks
    • New MDX functions

    8.Intermediate MDX

    • Adding calculated members
    • Adding scripts
    • Adding named sets
    • .NET Assemblies

    9.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

    10.Introduction to Data Mining

    • What and why?
    • Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
    • Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
    • Data Mining dimensions
    • Data Mining clients
    • Processing mining models

    11.Introduction to Reporting Clients

    • Excel 2003 Pivot Tables
    • SQL RS & Report Builder
    • SPS RS web parts & .NET 2.0 report viewer controls
    • Business Scorecards 2008& ProClarity

    12.Future Directions – Integration with Office 12

    • SharePoint 12 and AS
    • Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
    • Excel Services 12 and AS (Web Services)

    13.SQL Server 2008 Integration Services

    14.Introduction to SQL Server Integration Services

    • Product History
    • SSIS Package Architecture Overview
    • Development and Management Tools
    • Deploying and Managing SSIS Packages
    • Source Control for SSIS Packages

    15.SSIS for DBAs: Using SQL Server Management Studio

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

    16.Business Intelligence Development Studio

    • Launching BIDS
    • Project templates
    • The package designer
    • The Toolbox
    • Solution Explorer
    • The Properties window
    • The Variables window
    • The SSIS menu

    17.Introduction to Control Flow

    • Control Flow Overview
    • Precedence Constraints
    • The Execute SQL Task
    • The Bulk Insert Task
    • The File System Task
    • The FTP Task
    • The Send Mail Task

    18.Advanced Control Flow

    • Containers – grouping and looping
    • The Web Service Task
    • The WMI tasks
    • The Analysis Services tasks
    • The Execute Process Task
    • The Execute Package Task

    19.Introduction to Data Flow

    • Data Flow Overview
    • Data Sources
    • Data Destinations
    • Data Transformations
    • The Copy Column Transformation
    • The Derived Column Transformation
    • The Data Conversion Transformation
    • The Conditional Split Transformation
    • The Aggregate Transformation
    • The Sort Transformation
    • Data Viewers

    20.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
    • Configuration discipline

    21.Debugging, Error Handling and Logging

    • 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

    22.Advanced Data Flow

    • Revisiting data sources and destinations
    • The Lookup Transformation
    • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
    • The Multicast Transformation
    • The Merge and Merge Join Transformations
    • The Data Mining Query Transformation
    • The Data Mining Model Training Destination
    • The Slowly Changing Dimension Transformation

    23.Extending SSIS through Custom Code

    • Introduction to SSIS scripting
    • The SSIS script editor
    • The SSIS object model
    • Script in Control flow: The Script Task
    • Script in Data flow: The Script Component
    • Introduction to SSIS component development

    24.SSIS Package Deployment

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

    25.SSIS Package Management

    • The SSIS Service
    • Managing packages with DTUtil
    • Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

    26.SQL Server 2008 Reporting Services

    27.Introduction to SQL Server Reporting Services

    • Tour of Features
    • Reporting Services Architecture
    • Reporting Services Terminology
    • Reporting Services Editions
    • Taking Reporting Services for a Spin

    28.Creating Reports

    • Deconstructing Reporting Services
    • Shared Data Sources
    • Creating Reports from Scratch

    29.Calculations and Formatting

    • Creating Expressions
    • Using the Global Collections
    • Formatting Items
    • Conditional Formatting

    30.Grouping and Sorting

    • Creating Groups
    • Calculating Totals and Percentages
    • Interactive Sorting
    • Creating Drill-Down Reports

    31.Report Parameters

    • Creating Report Parameters
    • Creating Drop-Down Parameters
    • Multi-Valued Parameters
    • Debugging Parameter Issues

    32.Creating Matrix Reports and Charts

    • Creating a Basic Matrix Report
    • Matrix Subtotals
    • Creating a Basic Chart
    • Exploring the Charting Possibilities

    33.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

    34.Reporting Services Security

    • Two Parts to Reporting Services Security
    • Securing Access to Reports
    • Data Source Security

    35.Programming Reporting Services

    • The Many Reporting Services APIs
    • Integrating Reporting Services into Applications using URL Access
    • Using the Report Viewer Controls

    36.Advanced Reporting Services Programming

    • Using the Reporting Services Web Service
    • Working with Custom Assemblies

    37.Snapshots and Subscriptions

    • Caching and Snapshots
    • Creating Standard Subscriptions
    • Creating Data-Driven Subscriptions
    • Managing Subscriptions

    38.Ad-Hoc Reporting with Report Builder

    • The Report Builder Architecture
    • Creating Report Model Projects
    • Running Report Builder

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies