MSBI Training

• MSBI Architecture
• Concepts of Transformations in SSIS, ETL, and Multidimensional Modeling. 
• Data modeling, Data transformation and ETL concepts. 
• Architecture of SSAS, SSIS and SSRS and their components.  
• Building effective charts and reports in Business Intelligence. 
• Understand the tables in SSAS and OLAP database  
• Relationship types in SAAS. 
• Developing new cubes and new data sources.

Following are the professionals who get benefited from learning this course:

• Software Architects, 
• Data Analysts
• ETL Developers
• Business Intelligence Professionals
• People who are looking to gain essential skills in MSBI

• Deployment rate of business intelligence tools have grown tremendously and this trend is expected to grow. 
• MSBI is one the widely deployed business intelligence tools and there is a huge demand for the skilled MS  BI professionals.
• According to Indeed.com, the average salary received by a MSBI professional is $107,000. 

To attend this online MSBI course you need to have basic knowledge of DMDW(Data warehouse and Data Mining), RDBMS, and SQL.

Yes, upon the successful completion of the MSBI training you will receive the course completion certificate from SK Trainings. This certificate is valid across all the top MNCs and simplifies your job search process.

Yes, you will get all assistance from the MSBI experts to clear your certification exam. Moreover you will be provided with the experts designed MSBI course material to clear your certification exam.

• SSIS installation
• SSIS Architecture
• Package
• Tasks ,Control Flow , Data Flow

• SSIS Wizard
• SSIS Designer (SQL Server Data Tools)
• Variables and Expressions
• Breakpoints
• Data viewers
• Configuring Error Output

• Events Handling
• Execution Logging
• Data Flow Tasks(ETL)
• Control Flow Tasks
• .Net Scripting Task

• Configuration
• Deployment
• Security
• Manually Executing SSIS Package
• Scheduling SSIS Package
• Importing and Exporting Packages
• Monitoring and Optimizing Packages

• Dimension Tables Data Loading
• Fact Tables Data Loading

• What is SQL Server Reporting Services?
• What can you do with SSRS reports?
• What components does SSRS use?
• Who uses SSRS?

• Basics Of SSRS
• Data Source
• Data Set
• SSRS Expressions
• Reports Formatting

• Parameterized Reports
• Sub Reports
• Drill Down Reports
• Linked Reports In SSRS
• Filters in SSRS
• Actions In SSRS

• Installation and Configuration
• Deployment and Security
• Subscriptions and Rendering
• Caching and Snapshots

• Report Model Project
• Model Designer
• Report Builder

• Dimensions
• Facts
• Data Sources
• Data Source Views

• Cube Designer
• Partitions and Aggregations
• Dimension Usage
• Calculations and Kpis
• Perspectives, Actions

• Axes, Slice
• Tuple and set
• MDX Queries
• MDX expressions

• Installation
• Configuration
• Deployment
• Processing
• Security
• Backup and Restore

Package is a core component of SSIS. Package can be created simple graphical user interphase or programmatically.

It is categorized into Two component a) SSIS Runtime Engine b) Data flow transformation pipeline Engine

Carriage Return and Line Field

        Read Committed
        Read uncommitted
        Repeatable Read
        Serializable
        Snapshot
      

        Execute SQL Task,
        Data flow Task,
        Script Task,
        File system Task

      

The Dataflow transformation pipeline engine completely handles the data flow of the package. The data flow contains, Data flow sources (excel source, flat file, OLEDB etc), Data flow transformations (conditional split transformation) derived column transformation, lookup transformation etc.) and data flow destination.

OLE DB Connection Manager
ODBC Connection Manager
Flat file connection Manager
SMTP connection Manager
Excel Connection Manager

There are FIVE permanent tabs, they are:

Control Flow
Data  Flow
Parameters
Event Handler
Package Explorer

It is Categorized into 3 parts
Changed Attribute (Type I)
Historical Attribute (Type II)
Fixed Attribute (Type III)

On Error
On Warning
On Task Failed
On Post Validate
On pre-Validate

Data conversation is used to convert the data type of a column

SQL Server Reporting Service

1. Data Source: Logical connection between the application (SSRS) and database.
2.  Report Servers: Report server is the core engine that drives Reporting services.
3.  Report Manager: Report Manager is a web-based administrative interface for reporting services.

Linked report is the report with the settings and properties of its own. A linked report can have its own name, description, location, parameter properties, report execution properties etc.

A drill through report will always allow going from summary to detail whereas drill down reports allow you to look to the data in different levels

SQL Server Analysis Services

Online analytical processing

The basic unit of storage and analysis in analysis services is the cube. A cube is a collection of data that is been aggregated to allow Queries to return data quickly. Cubes are ordered into Dimensions and measures comes from the fact table.

Best Way to compare if a specific dimension is at a certain level is by using ‘IS’ operator.