Msbi Introduction And Its Entities (Ssis, Ssas, Ssrs) – Uses Of Entities In Msbi Platform
MSBI Suite Introduction
MSBI stands for Microsoft Business
Intelligence that is a most effective suite with the collection of a device
which lets in offering best solutions for the Business Intelligence and Data
Mining Queries. MSBI empower customers to gain the access to accurate and up to
date facts for higher decision making in an company. This tool makes use of
Visual studio along with SQL server and offers special tools for distinct
procedures that are required in Business Intelligence (BI) solutions.
MSBI is divided into 3 entities:-
1.
SSIS – SQL
Server Integration Services – Integration tool.
2.
SSAS – SQL
Server Analytical Services -Analysis tool.
3.
SSRS – SQL
Server Reporting Services – Reporting tool.
Uses of SSIS, SSAS andSSRS in MSBI Platform
SQLServer Integration Service (SSIS)
SSIS is a tool used for ETL. ETL stands for Extract
Transform and Load. These are simple day-to-day words we use in our daily
lives. The figure below depicts ETL in real world scenario.
E-Extract Data:
Extract Data
from various homogeneous or non-homogeneous source systems. Data could be
stored in any of the following forms though not limited to them. Flat
file, Database, XML, Web queries etc.
T-Transform Data:
The data are coming from various
sources. We cannot assume that the data is the structure in the same way
across all the sources. Thus, we need to transform the data to a common format
so that the other transformations are done on them. Once we have the data we
need to perform various activities like:
·
Data cleansing
·
Mandatory check
·
Data type
·
Foreign key
constraints
·
Business rules
and apply business rules
·
Creation of
surrogate keys
·
Sorting the data
·
Aggregating the
data
·
Transposing the
data
·
Trim the data to
remove blanks.
L-Load
Data:
Once the transformations were done
and data takes the form as per the rule. We have to load the data to the
destination systems. The destinations can also be as varied as the sources. Once
the data reaches the destination it is consumed by other systems.
This
is the method of changing two dimensional (rows and columns/OLTP) statistics
into multi-dimensional data version (OLTP). This will assist you to research
the massive quantity of statistics.
Benefits of SSAS are as follows:
- Multi-dimensional evaluation
- Key performance Indicator (KPI)
- Slice, cube, drill down functionalities
- Good performance
- Security
Microsoft SQL Server Reporting Services (SSRS) is a
company reporting platform helping conventional and interactive reports
delivered over the net or through custom applications. It supports diverse
statistics sources like two dimensional and multi-dimensional.
The
following are a few functions of SSRS:
- Retrieve information from different source
- Web based access to reports
- Support for Ad-hoc reporting
- Report builder helps to customize the
reports for end user.
- Easy subscriptions alternatives
- Export functionality with masses of format.
- Display reports in diverse ways like
tabular, chart, Gauge and so forth.
IQ Online Training provides MSBI Online
Training course with real time Experts.
· Explains with real time scenarios.
·
Trainers always help you in clearing
doubts
·
Provides Job Support
·
Gives 24*7 customer support
·
30 hours of training with flexible
timings.
·
FREE Live demo
·
Weekday and weekend batches available
·
Refer a friend and get OFFER.
IQ online training is a premier training
portal with a decade of rich experience in web based training and has
established itself as one of the leading online training portals in the world.
We are known for delivering high quality
IT courses with latest technologies. We have customized our teaching methods in
such a way that you can learn online in a simple and easy way.
We cater to all kinds of client needs in
a professional and quicker manner and believe in creating a friendly
environment for learning online. We lay special emphasis on team work and as
such, encourage the learner to interact more and more with the trainer.
Call
Us@
USA: +1 732-593-8450
USA: +1904-304-2519
Mail
Us:
info@iqtrainings.com
Website: http://www.iqonlinetraining.com/
Address:
411 walnut street
Suite #8295
Green Cove Springs
FL- 32043-3443
Comments
Post a Comment