MSBI 5/5 (2)

Review (0)


Our Program is designed by the industry experts. These skills fulfil the requirements of jobs related to data. Now days there are huge requirements of advance analytics skills with R in the industry.

    24 Sessions
    72 Hours

    Skills you will master

    SQL Server Integration Services
    SQL Server Analysis Services
    SQL Server Reporting Services


    10:00 AM - 01:00 PM
    04:00 PM - 07:00 PM
    04:00 PM - 07:00 PM
    Mob : +91-9810600764
    Address : M8, Lower ground Floor, Sector 14 OLD DLF Gurgaon 122001
    Email : info@palin.co.in


    About The Program

    MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite and is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization.

    During the training participants will get hands on

    and will be going through

    This tool uses Visual studio along with SQL server and offers different tools for different processes which are required in Business Intelligence (BI) solutions.

    Please rate this

    Career Advisor
    Vinit Kumar, Consultant
    Palin Delivers real world relevance with activities and assignments that helps students build critical thinking and analytic skills that will transfer to other courses and professional life.
    Program Description
    During the MSBI training program we'll cover SSIS, SSAS, SSRS to understand Business Intelligence Solution, including multi-dimensional database models and the role of data transforms and data analytics
    Click Here to Preview

       Session 1 - SSIS Architecture and DW Concepts

    Need of SSIS for ETL Operations, Data Warehouse Design and SSIS, DW Components and SSIS Tools, SSIS Configuration and Catalog DB, Control Flow Tasks Architecture, Data Flow Tasks Architecture, Data Pipelines and Buffer Usage, SSIS Data Types and Conversions, SSIS Local & Global Variables, Dynamic Precedence Constraints, Dynamic Connection Managers, Handling Enumerations in SSIS, Expressions and Iterations, SCRIPT Task usage in SSIS

       Session 2 - SSIS Expressions & Debugging

    Conditional Precedence Expressions, SSIS Parameters Usage and Variable, Control Flow Breakpoints

       Session 3 - Data Flow Transformations

    Row and Column Transformations, Combining and splitting datasets, Performing database operations, MERGE Vs UNION ALL Transformations, Lookup, Fuzzy Grouping, OLE-DB Command, SORT Vs AGGREGATE Transformations, Custom Code Handling in DW, Event Notifications and Emails, Data Sampling and Data Delta, Type I and Type II SCDs, Performing PIVOT operations, SSIS Transactions & Isolation Levels, CHECKSUM Transformation in DW, Iterating XML nodes and Data, CACHE Transformation & Performance, Applying Configuration Options, Parent – Child Parameters & Options, Data Flow Transformations usage, Data Flow Data Viewers and Audits

       Session 4 - Event Logging and Event Handling

    Configurations and benefits, System Events and Audits, Package Event Handling, Limitations of Event Handling, Event Bubbling Escalations, Benefits of SSIS Logging, Environment Variables Usage, Windows Event Logs and SSIS, SQL Server Logging Limitations, Choosing correct log providers, Package Execution Audits

       Session 5 - Deployment Procedures

    Deployment Versioning & Options, SSIS Deployment Phases & Manifest Files, Project Packaging and ISPAC Files, Validation & Verification Techniques, SSIS Checkpoints and Usage, Data Analytics and Debugging, Data Profiler & ADO Connections

       Session 6 - Deployment Options & Utilities

    Package Execution OptionsFile System Security Limitations, SSIS Deployment & DB Engine, SSIS Catalog Project Files, Package Migration Utilities, Command-Line Deployments, TDS Sizing and Tuning Options

       Session 7 - SSIS Package Security and Upgrades

    Encrypting SSIS CatalogsPackage Store and SSISDB, Security Audits and Reports, Container and Package Logging, DTS packages to SSIS migration, Upgrading 2008 Packages to 2012, MSDB and SSIS Catalog Files, Comparing SSIS 2008 R2 & 2012, ISPAC Files & Package Migrations

       Session 8 - Introduction to SSAS and DW Storage

    Need of OLAP Databases and DW Store, Tabular & Multidimensional Modes, Need for Cubes and Measures, Identifying Facts and Dimensions, Identifying Measures and Aggregates, Identifying Attributes and Hierarchies

       Session 9 - SSAS Design Entities & Cube Usage

    Data Source and Data Source Views, Computed and Named Queries, Building Entity Relationships, Deciding Data Warehouse Schema, Creating Dimensions and Builds, Attributes and Member Names, Choosing Dimension Templates, Applying Time Based Dimensions, Need for Hierarchies and Limitations, Attribute Relations and Uses, Building Levels and Hierarchies, Need for Composite Attribute Keys

       Session 10 - KPI Calculations and Partitioned Aggregations

    Identifying Cube Entries for FASMI Rules, Measures and Additives (Full and Semi), Defining Measure Groups and Measures, Cube Customizations and Options, BI Enhancements and Granularity, Building Fact Less Cube Dimensions, Calculations and Conditional Colors, MDX Scripting for Calculations, Defining KPIs and Goals using MDX, Perspectives using MDX Expressions, SSAS Actions with MDX and XMLA, Need for Cube Partitions and Query Binding, Local and Remote Server Partitions, Need for Storage Models – MOLAP and ROLAP, Generation of Aggregations on Partitions, Storage Modes and Proactive Caching, Hierarchies and Relations in Tabular Mode, TIME Dimensions in Tabular Mode

       Session 11 - MDX Functions, FILTERS and JOINS

    MDX Language Syntax & Statements, MDX Functions & JOINS, Complex MDX Queries & FILTERS, PARALLELPERIOD, TIME Functions, Conditional FILTERED JOINS in MDX, Cube and Dimension Write backs, MDX Transactions & Limitations

       Session 12 - Data Mining and Forecast

    Need for Data Mining Structures, Data Mining Algorithms and Rules, DMX Queries and Forecast Reports, Data Mining Scope and Ranking, Prediction Functions and Analysis

       Session 13 - Deployment (Tabular & Multidimensional)

    Deployment Options and Tools, Creating OLAP (SSAS) Databases, Processing Options and stages, SSAS Database and Cube Audits, Managing SSAS Log Providers, OLAP & Tabular Database Backups, Restore Options and Partitions, Scripting DB Backups and XMLA, Scheduling Backups and Jobs, DB Synchronizations and XMLA, Managing Partitions & Aggregations

       Session 14 - OLAP Management (Tabular & Multidimensional)

    Need for Optimizations and Audits, Designing Aggregations using UBO, OLAP Restore Options and XMLA, SSAS Security Roles and Scope, Object Level Access and MDX, Drill-Through Security and MDX, Item Level Security and DAX Filters, Dynamic Security Implementation, Security Audits and Cube Access Logs, Upgrading OLAP Databases (DW), OLAP DB Synchronization Script

       Session 15 - Reporting Services Architecture

    Introduction to Reporting Services, Three-Phase Report Life Cycle, Reporting Engine Architecture, SSRS 2012 and Web Service URLs, SSRS 2012 Configuration & Ports

       Session 16 - Report Design with Data Sets & Aggregates

    Report Designer Usage and Scope, Report Builder Usage and Scope, Report Manager and Options, Report Delivery & Layout Planning, Enterprise and Ad-hoc Reports, Working with Multiple Datasets, Configuring Dynamic Datasets

       Session 17 - Sub Reports – Parameters & Filters

    Designing Wizard based Reports, Designing Custom Reports, Using Tables and Matrix, Chart Based Reports and Images, Using SSRS Expressions & Global Fields, Sub Reports and Report Options, Report Testing and auto Refresh, BUILD and DEPLOY Options, Parameters and Dynamic Populations, Report Filters in Data Sets, Sub Reports and Nested Reports, Gauge Reports, Indicator Reports, Pie Charts and Data Bars, Exporting Reporting Data

       Session 18 - Cube Reports and Report Models

    Designing Reports using OLAP DBs, Identifying KPIs and Measures, MDX Queries in Cube Reports, Report Models and parameters, Identifying Report Entities, Identifying different Attributes, Aggregations Based Expressions Calculations, Remote Data Sources & Data Sets, Linked Reports and Graphs

       Session 19 - Report Builder Usage & Schedules

    Using Report Builder Wizards, Map Reports with UI and Site Settings, Report Parts and Web Services,Report Designer Vs Report Builder, Report Server Configurations Tools, Report Migrations and Precautions

       Session 20 - Delivering SSRS Reports

    Report Delivery Options & Schedules, Accessing and controlling reports, Leveraging RS Web services, Choosing between Rendering Formats

       Session 21 - Managing Reports

    Report Manager Configurations, Managing Data Sources Security, Exporting and Importing Reports, Creating Global Schedules – Site Level, Snapshot Management & Schedules, Regenerating Snapshots for Tuning Options, Report Server Temp database Usage, Tuning Reports with Caching Options

       Session 22 - Scheduling and Subscriptions

    Creating Standard Subscriptions, Data-Driven Subscriptions, Subscription & Logging Options

       Session 23 - SSRS Report Security

    Report Data Source Security, Report Server Security Levels, Report Server DB Security

       Session 24 - SSRS Configurations

    Report (RDL) Configurations, Email Based Report Subscriptions, Managing Configurations Files, Choosing correct Configuration Values, RDL Reports Upgrades & Downloads, Scale out Deployments in SSRS, Execution Accounts and SSRS Schedules

    Read More
    Program Highlights
    Instructor led training is the live and interactive training by the industry experts
    Live Case Study
    Helps you work on industry specific data so as to get an hands on experience.
    Assignments which helps in conceptual understanding, Prepared for interview training & techniques.
    Lifetime Access
    Access to all the recording for the lifetime and avoid notes maintaining chios.
    24 X 7 Support
    Consultants are available online for proper guidance about the course.
    After successful completion of the training and case study Palin will certify you as Palin certified Analyst.
    Career Counselor
    Avail career guidance and Professional guidance for resume building, unlimited opportunities and interviews.

    Highly motivated with leadership skills having Master’s Degree in Statistics. Holds good working experience in different domains like Retail, Banking, Healthcare FMCG, Marketing analytics using SAS, R, Python, STATA.


    There are no reviews yet.

    Be the first to review “MSBI”

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

    Latest News

    Emerging Future of Data Scientists
    Data scientists will live one of the accomplished and encouraging careers prospective of all IT employment through 2020. Healthcare, Banking and Telecom industries are the...Read More
    Average Salary of A data scientist and related profiles
    The national average salary offered to data scientists and their related position is ₹ 6,50,000.Read More
    Benefits of Data Science using SAS & R
    Banking and Healthcare industry has been using SAS for years because SAS is licensed software which guarantees the accuracy of its results and its safer...Read More
    Python Overtakes R
    Python overtakes R, becomes the leader in Data Science, Machine Learning platforms. While in 2016 Python was in 2nd place ("Mainly Python" had 34% share...Read More
    What are benefits of python
    Simple and easy to learn and understand. Performance is very fast and attractive. Python works with all different data formats. We can directly import SQL...Read More
    Python Data Scientists Average Salary
    The average salary offered to data scientists in the past year was £47,000, with Python being the most desirable programming language, according to an analysis...Read More
    Python Vs Julia
    Python vs Julia Python is a general-purpose computing language that is easy to learn, and that has developed into a leading language for scientific computing....Read More
    Quick Enquiry
    close slider