COURSES UPDATE:
NEW JOB ORIENTED CAREER COURSES STARTING FROM 10th Aug 2019. ANY GRADUATE CAN DO THIS. GRAB THIS OPPORTUINITY NOW. WE WILL GIVE GUARANTEE OF YOUR JOB. | OTHER WEEKEND BATCH SCHEDULES |  HADOOP  (02:00:PM)  |    APPIUM And REST ASSURED  (05:00:PM)  |  AWS AND DEVOPS  (05:00:PM)  |  ADVANCED SELENIUM, JAVA AND DEVOPS PIPELINE  (04:00:PM)  |  ANGULAR 6  (10:00:AM)  |   LINUX SHELL SCRIPTING / ADMIN  (11:00:AM)  |  More Information Click Here..  
+91 7588262721 / 9665875790 / 9923488942 info@orilent.com / orilenttap@gmail.com


Lesson 1: MSBI and SSIS Architecture Overview 
In this module, you will understand the need for an Integration tool and its significance in real world. You will learn the importance of SSIS as an integration tool and get a birds-eye-view on the overall architecture. 
o    Understand the Need of Business Intelligence
o    Traditional Technologies Used
o    Panacea - Business Intelligence
o    Understand the Microsoft Business Intelligence
o    Architecture  Understand SSIS Architecture and its High Level
o    Components  Installation of SQL Server 2014 and SSDT- BI     

Lesson 2: SSIS Control and Data Flow 
o    In this module, you will understand the SSIS designing environment and gain in-depth knowledge on the SSIS Control flow & Data flow.
o     Understand SSIS Architecture
o    Control Flow & its Components (Tasks, Containers, Precedence Constraints)  Data Flow & its Components (Source and Destination Connections, different types of Transformations)  Scenarios by combining Control Flow and Data
o    Flow components  System Variables and User defined variables

Lesson 3: SSIS (Transactions, Error Handling) 
In this module, you will understand how the objects of the core SSIS workflow work and interact with each other to help in security, restartablity and other key functions. 
o    Parameters
o    Expressions
o    Event Handling
o    Transaction Options
o    CheckPoints
o    Logging options (5 types)
o    Configure Error Output and OnError event  Package Security: Package Protection Levels     

Lesson4: SSIS (Configuration, Deployment and Scheduling) 
In this module, you will learn advanced SSIS programming features which will help in handling custom requirements using .Net code. Also you will learn the way to configure and deploy SSIS projects.
o    Custom code using Script Task
o    Script Component
o    Package Configurations (5 types)
o    Debugging
o    Troubleshooting  Executing packages – DTExec and DTExecUI
o    Package Deployment
o    Package Scheduling using SQL Agent 

Lesson 5:  SSIS Advance Topics & DWH Basics 
In this module you will learn SSIS advanced concepts such as SSIS Performance Tuning & its Best Practices. You will also learn Introduction to Data Warehouse and its Architecture, Loading Data into DW using SSIS as well as Introduction to Dimensional Modeling. This will be base for understanding SSAS features. 
o     Package Performance Tuning
o    SSIS Best Practices
o    Need for DW
o    & Business Intelligence  OLTP vs. OLAP
o    DW Architecture
o    Dimensional Modeling
o    Schemas: Star, Snowflake     

Lesson 6: SSAS Cube 
This module will help you in understanding SQL Server Analysis Services Overview and its Architecture. It also covers various types of SSAS models along with designing dimensions and measure groups. You will also learn about SSAS Administration with prime focus on deployment and processing.
o    Tabular Model and Multidimensional Model
o    Data Sources
o    Data Source Views
o    Identify the Fact and Dimensions
o    Named Calculation and Named Queries
o    Designing Dimensions
o    Dimension Hierarchies
o    Designing Measure Groups
o    Dimension Usage with Measure Group,Attribute
o    Relationships  Storage Modes: MOLAP, ROLAP, HOLAP
o    Partitions  Aggregations,KPIs
o    Actions
o    Translations and Perspectives

Lesson 7: SSAS Deployment and MDX, DAX 
In this module you will learn basics of MDX & DAX and get step by step approach of basic SSAS Performance Tuning and Troubleshooting. You will also learn the concepts of Adhoc-Reporting and creation of a report against SSAS as a data source.
o    SSAS Deployment and Cube Processing
o    Different Processing Options
o    Loading Data into DW using SSIS
o    MDX queries
o    DAX Queries
o    Performance Optimization of cube and Dimension
o    Best Practices
o    Schedule the Cube processing     

Lesson 8: SSRS Reporting
In this module you will understand Reporting Services, its Architecture and how to configure it. You will also learn about the environment where reports are created and also about server where the reports are deployed. 
o    Reporting Services Architecture
o    Lifecycle  Report Parameters and MultiValued
o    Cascading Drop down Parameters
o    Types of Reports: Table, Matrix
o    Sub Report
o    Chart Report (Bar, Pie, Line)
o    Drill-Down Report
o    Drill Through Report
o    Creating Groups
o    Filters
o    Expressions Sort and Interactive Sort
o     Alternate Row Colors
o    Repeating Row Headers and Column Headers
o    Exporting Reports to different formats 

Lesson 9: SSRS: Report Manager
In this module you will learn about different kinds of reports and their functionalities along with best practices to be followed. You will also learn about various SSRS Administrative activities. 
o    Report Manager
o    Deploying Reports and Data Sources
o    Securing Access to Reports (Role based Security
o    Data Source Security
o    Caching Report and Snapshot Report
o    Report Subscriptions: Standard
o    Data-Driven
o    Managing Subscriptions
o    Ad-Hoc Reporting with Report Builder    

Lesson 10: Putting the Pieces Together
In this module you will understand how MSBI ecosystem components work together in a Business Intelligence environment to solve the Organizations data problems. This module covers end to end implementation from Data Retrieval --> Data Transformation --> Data Loading into DWH --> Data Modeling --> Report Delivery 
o    End to End Business Intelligence case study involving SSIS
o    SSAS
o    SSRS and MDX