MSBI 5/5 (4)

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


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