• +91-9160950025

MSBI Training in Hyderabad

MSBI Training in Hyderabad

Best MSBI Training in Hyderabad

Krishna Technologies is providing MSBI (Microsoft Business Intelligence) designed by Experienced Professionals in Microsoft. You will be master in MSBI , if you complete course in Krishna Technologies. Krishna Technologies specifically designed MSBI course to clear your interviews and to work on your project from day one, if you are moving from other technologies to MSBI and Certifications which are related to MSBI. As part of MSBI Course, we will train you SQL Server, SSIS to integrate data, SSRS to visualize the data and SSAS to analyze the data.

What is MSBI?

Microsoft Business Intelligence is complete set of BI tools from Microsoft Corporation to transform DATA(which can understand by Machine) into Information(which can be understood by Human being). MSBI can extract, transform and load data. MSBI can be used to make reports to visualize the data. MSBI can be used to do analytics by creating time based calculations like MTD(Month to Date), QTD(Quarter to Date), YTD (Year to Date), Prior, YoY(Year over Year) and %YoY(Percentage of Year over Year).

The complete MSBI stack here is

  • SSIS (SQL Server Integration Service)
  • SSAS(SQL Server Analysis Service)
  • SSRS(SQL Server Reporting Service)

SSIS (SQL Server Integration Services)

It is used to extract data from various data sources, transform data based on business requirement and load into destination. There are various transformations to transform data. The following are the transformation activities

  • Removing unwanted data
  • Deriving new data definitions based on business requirement
  • Merging data either horizontally or vertically based on business requirement
  • Aggregating data
  • Sorting data
  • Converting data types from other types based on requirement.

SSRS (SQL Server Reporting Services)

SQL Server Reporting is reporting tool to create reports to the users. SSRS is part of MSBI. SSRS can create various types of reports like Table, Matrix, List, Parameter(s) reports, Cascading Parameter reports, Drill Down Reports and Drill through reports based on Business requirement. SSRS Developers can deploy/publish reports to SQL Server Reporting Service to make it available for the users. User can connect from any system which is connected to corp network and can access the report, if they have access to the SQL Server Reporting Services. SSRS is also have Report Builder, which is used to do ad-hoc changes in the server itself. Reports will be scheduled based on Business requirement.

SSAS (SQL Server Analysis Services): It is analytical tool which is used to create Multidimensional Cube and Tabular Model. In Multidimensional, can create Data Source view, Named Calculations, Named Queries and logical keys to create relationships. Cube(s) will be created in Multidimensional Model and can create partitions and Measures as part of the Cube. Time Intelligence can be applied based on requirement either in Multidimensional Model or Tabular Model. MDX(Multidimensional Expression) as SSAS Data sources will be available for the users, once it is deployed.

MSBI Course Content

Introduction Data Warehouse
  • OLTP
  • OLAP
  • Differences between OLTP and OLAP
  • MSBI Architecture (SSIS, SSRS and SSRS)
Introduction to SSIS Project Environment
  • Solution Explorer
  • Properties
  • Event Handler
  • Package Explorer
  • Control Flow
  • SSIS Toolbox
  • Data Flow (ETL) - Sources, Destinations and Transformations
  • Connection Managers
Types of Transformations
  • Synchronous Transformations (Non-Blocking Transformations)
  • Asynchronous Transformations
    1. Full Blocking Transformations
    2. Partial Blocking Transformations
SSIS - Synchronous Transformations
  • Audit
  • Character Map
  • Conditional Split
  • Copy Column
  • Data Conversion
  • Derived Column
  • Lookup
  • Multicast
  • Percent Sampling
  • Row Count
  • Export Column
  • Import Column
  • OLE DB Command
  • Data Viewers
SSIS - Partial Blocking Transformations
  • Merge Join Transformation
  • Merge Transformation
  • Union All Transformation
SSIS - Full Blocking Transformation
  • Aggregate Row Sampling
  • Sort
  • Term Extraction
SSIS - Types of Variables in SSIS
  • Predefined Variables
  • System Defined Variables
SSIS - Various Sources
  • OLEDB Source
  • Flat File Source
  • Raw File Source
  • Excel Source
  • XML Source
SSIS - Various Destinations
  • OLEDB Destination
  • Flat File Destination
  • Raw File Destination
  • Excel Destination
  • SQL Server Destination
SSIS - Connection & Expression
  • Creating Dynamic Connection
  • Creating Dynamic Expressions
SSIS - Control Flow
  • Data Flow Task
  • Execute SQL Task
    1. None
    2. Single row
    3. Full result set
    4. XML
  • Bulk Insert Task
  • Execute Process Task
  • File System Task
  • FTP Task
  • Expression Task
  • Script Task
  • Send mail Task
  • Execute Package Task
  • Execute T-SQL Statement Task
SSIS - Containers
  • Task Host Container
  • For Loop Container
  • Foreach Loop Container
  • Sequence Container
SSIS - Constraints
  • Debugging, Error Handling and Logging
  • SSIS Debugging Overview
  • Break Points in SSIS
  • SSIS Debugging Windows
SSIS - Real Time Activities
  • SSIS Package Deployment
  • Dynamic Configurations
  • Deployment Options
  • Executing Package with DTExec and DTExecUI
  • Creating SQL Server Agent Jobs
  • Scheduling SQL Server Agent Jobs
    1. Time Based Scheduling
    2. Event Based Scheduling
  • Automating ETL Process based on Event
  • SCD-Type 1 Implementation (Custom)
  • SCD-Type2 Implementation (Custom)
SSRS - (SQL Server Reporting Services) - Introduction
  • SSRS Overview
  • Creating Report Server Project Wizard
SSRS - Creating Project
  • Solution Explorer
  • Report Design Surface
  • Reporting Toolbox
  • Properties
  • Data Source
  • Report Data
  • Dataset
  • Basic Report with Table
SSRS-Types of Filters
  • Query Filter
  • Dataset Filter
  • Report Filter
  • Group Fitter (Row Group & Column Group)
  • Advantages & Disadvantages of Filters
SSRS - Parameters
  • Single Selected Parameters
  • Multi Selected Parameters
  • Cascading Parameters
SSRS - Expressions
  • Using various Functions
  • Displaying User Selected values in the Report
SSRS - Conditional Formatting
  • Foreground Color
  • Background Color
  • Font size etc.
  • Page Breaks
  • Document Map and its usage
SSRS - Types of Report Items
  • Table
  • Text Box
  • Matrix
  • List
  • Image
  • Rectangle
  • Sub Report
  • Data Bar
  • Sparkline
  • Indicator
  • Chart Reports
  • Column Charts
  • Line Charts
  • Bar Charts
  • Area Charts
  • Range Charts
  • Scatter Charts
  • Types of SSRS Reports
  • Cascading Parameter Report
  • Drill-Down Reports
  • Row Based
  • Column Based
  • Drill-Through Reports
  • Sub Reports
  • Linked Reports
SSRS - Managing Reporting Services
  • Deploying Reports and Data Sources
  • Exporting Reports and Printing
  • Creating Standard Subscriptions
  • Data-Driven Subscriptions
  • Managing Subscriptions
  • Ad-hoc Reporting with Report Builder
  • Ad-hoc Changes by Report Builder
  • Uses of Report Builder
  • Real Time Scenarios
SSAS - Modeling - Schemas Introduction
  • OLTP vs OLAP
  • Types of Multidimensional Schemas
  • Star Schema
  • Snow Flak Schema
  • Star Schema
  • Fact Tables
  • Dimension Tables
SSAS - Types of Fact Tables
  • Detailed Fact Table
  • Summary Fact Table
  • Snapshot Fact Table
SSAS - Types of Facts(Measures)
  • What is Measure
  • Additive Facts
  • Semi Additive Facts
  • Non-Additive Facts
SSAS - Types of Dimension Tables
  • Shared Dimensions
  • Referenced Dimension
  • Role Playing Dimension
SSAS - Creating SSAS Project
  • Solution Explorer
  • Data Sources
  • Data Source Views
  • Cubes
  • Dimensions
  • Roles
SSAS - Data Source Views
  • Creating Named Calculations
  • Creating Named Queries
  • Creating keys and Relationship
SSAS - Creating SSAS Cube
  • Using tables
  • Using Empty Cube
  • Creating Relationship if relationship
  • Creating Calculations
  • Creating Measure Groups
  • Creating Role Playing Dimension
  • Creating User Defined Hierarchies
  • Creating Relationships for Hierarchies
    1. Fixed
    2. Rigid
  • Sorting Attribute by another Attribute (important for real time)
  • Translations
  • Actions
  • Perspectives
  • Cube Storages
  • Aggregations
  • Key Performance Indicators (KPI's)
  • Deploying SSAS Cube
SSAS - Cube Processing Options
  • Using Project Solution
  • Using SSIS Package
  • Using SQL Server Management Studio
  • Using XMLA Script or JSON Script
  • Using SQL Server Agent Job
  • Using Synchronization and its usage
SSAS - Others
  • Usage of Role
  • MDX
  • Basic MDX Query
  • MDX Queries with SQL Server Management Studio
  • WHERE Clause
  • Set
  • Tuple
  • Creating Members
  • Displaying Top 10 Customers
  • Displaying Bottom 10 Customers



Get in touch with us

Have a question for us? Just fill the form. We'll get back to you!
+91 9160950025