Email: [email protected]Phone: 080-42041080 +91 9611824441


Satisfied Learners

Our Courses

  • Drop A Query

    Best MSBI Training in Pune

    Duration of Training: 9 weekends

    MSBI Training Syllabus

    Introduction to SQL Server Integration Services

    Datawarehousing Basics

    • Product History

    • SSIS Package Architecture Overview

    • Development and Management Tools

    Business Intelligence Development Studio

    • Launching BIDS

    • Project templates

    • The package designer

    • The Toolbox

    • Solution Explorer

    • The Properties window

    • The Variables window

    • The SSIS menu

    Introduction to Control Flow and Data 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

    • Containers – grouping and looping

    • The Web Service Task

    • The WMI tasks

    • The Analysis Services tasks

    • The Execute Process Task, Execute Package Task

    • 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

    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

    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

    SSIS Using SQL Server Management Studio

    • The Import and Export Wizard

    • Importing and Exporting Data

    • Scheduling and Executing Plans

    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 Slowly Changing Dimension Transformation

    • Transaction Handling in SSI

    • Check Point configurations

    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

    SSIS Package Deployment

    • Configurations and deployment

    • The deployment utility

    • Deployment options

    • Deployment security

    • Executing packages – DTExec and DTExecUI

    SSIS Package Management

    • The SSIS Service

    • Managing packages with DTUtil

    • Managing packages with SQL Server Management Studio

    • Scheduling packages with SQL Server Agent

    Introduction to Microsoft SQL Server Analysis Services

    • Overview of SQL Server Analysis Services

    • Installing 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

    • Other types of modeling—data mining etc…

    Understanding the development environment

    • Creating Data Sources and Data Source Views

    • Configuring Dimensions

    • Defining Attribute Hierarchies

    • Sorting and Grouping Attribute

    • Creating cubes

    • Refining Dimensions and Measures in BIDS

    Intermediate SSAS

    • KPIs

    • Perspectives

    • Translations – cube metadata and currency localization

    • Partitions

    • Storage topics – basic aggregations, MOLAP, ROLAP, HOLAP

    • Aggregations


    • Using the MDX query editor in SQL Server Management Studio

    • Most-used Functions & Common tasks

    • New MDX functions


    • Securing a cube

    Deployment and processing the CUBE

    Introduction to SQL Server Reporting Services

    Tour of 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

    Advanced Reporting Services Programming
    Using the Reporting Services Web Service
    Working with Custom Assemblies

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

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

    •       Exam 463 - Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

    •       Exam 466 - Implementing Data Models and Reports with Microsoft SQL Server   

    •       Exam 467 - Designing Business Intelligence Solutions with Microsoft SQL Server

    Our MSBI Trainers are Microsoft Business Intelligence (MSBI) Certified Experts and 10+ years experienced working professionals with hands on real time multiple MSBI projects knowledge.

    We provide real-time scenarios for each topic covered in each section of msbi training. Our microsoft business intelligence (msbi) course includes basic to advanced level and our msbi course is designed to get the placement in good MNCs in pune as quickly as once you complete the msbi certification training course. Trainer from Real Time Industry .This is completely hands-on training , which covers almost all topics practically. Our msbi trainers are microsoft business intelligence (msbi) certified experts and 10+ years experienced working professionals with hands on real time multiple MSBI projects knowledge. We have designed our msbi course content and syllabus based on student’s and market’s requirements to achieve everyone's career goal.

    -       Power BI

    -       Tableau

    -       Qlikview


    We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

    Quik Enquiry