Enquiry Now !      

MSBI Training in Pune - Technogeeks - MSBI Institutes in Pune, MSBI Classes Pune , MSBI Course Pune.

    Duration of Training: 9 weekends

    Training includes : 40+ assignments, 4POCs

    and 1 Real time Project


    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

    MDX

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

    Security

    • 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 Builder
msbi
MSBI


Enquiry Now !