MSBI Training | Microsoft Business Intelligence online training-GOT

1
Global Online Trainings

• MSBI TRAINING
• info_at_globalonlinetrainings.com
• https//www.globalonlinetrainings.com/msbi-trainin
  g

2
Welcome to MSBI Training
3
Introduction

• MSBI is also known as Microsoft business
  intelligence .Basically SQL BI data ware house
  concepts are used in this.
• The technique of this MSBI is transforming data
  into information. where it is able to handle the
  unstructured data .Directly data understanding to
  user its not possible because data is in form of
  SQL SERVER, EXCEL so MSBI is used to transform
  raw data to information in that way only users
  can understand the information .The main purpose
  of MSBI is storing data and fetching for
  processing

4
MSBI Training TOOLS

• SSIS (SQL Server Integration Services)
• SSAS (SQL Server Analysis Services)
• SSRS (SQL Server Report Services)
• SSIS (SQL server integration services)
• It is a tool loading different data sources and
  at final it will get as single data source. There
  was a different components are there in SSIS to
  get into single data.
• SSAS (SQL Server Analysis Services)
• It is an tool and services provided by Microsoft
  and it is an multidimensional database engine .It
  is an scalable, reliable, and secure enterprise
  class multidimensional database server.
• SSMS (SQL server Management Studio)
• This is used for administration of Analysis
  Service Database.
• SSRS (SQL Server Reporting Services)
• SSRS is an comprehensive and extendable
  reporting platform it includes integrated sets of
  different processing components ,tools and
  interfaces .it used to design , develop ,test and
  deploy .reports can be ranted in different format
  like document format , pdf format etc . Report
  can be containing relation sources and multi
  dimension sources.

5
overview

• Data collected from various source and stored in
  various database cant be directly visualized.
• Data first needs to be integrated and then
  processed before visualization takes place.
• WHAT IS DATA WAREHOUSE A central location
  where consolidated data from multiple databases
  are stored. Data warehouse is maintained
  separately from an organization operational
  database. Data warehouse is not loaded every time
  new data is added to databases. Data warehouse is
  faster and more accurate.

6
Why MSBI Training Important

• MSBI Training is a better management. It has some
  tools which are the SSIS SSAS SSRS are there to
  where the one tool will is to integrate that data
  that means large data to single data, and the
  another tool is to analysis that data and finally
  report will given to that . Its the best
  solution for problems of business .Who have
  interest in MSBI Training should also have some
  key knowledge of SQL, Data ware house

7
OLTP and OLAP Training

• OLTP and OLAP
• OLTP (Online Transaction processing) Where OLTP
  used as large number of small transaction. OLTP
  performs day to day operations. Current data will
  only store ,history data will also useful, but it
  not stored in OLTP.OLTP not mean to analyze the
  data they are just to perform the current data,
  we shouldnt load for analyze purpose .Read and
  write both are involved.
• OLAP (Online Analytical Processing) Where data
  will be stored in data warehouse it will store
  the history of data from OLTP system this we can
  get the data of any years like that .We can
  analyze the data .OLAP provides different types
  of users. Reading only involved. It uses the
  multidimensional data model.

8
THANK YOU
info_at_globalonlinetrainings.com India 91 90300
10123 Whatsapp[phone] India 91 40 6050
1418 USA 1 909 233 6006 UK 44 (0)203 371 0077