Introduction to Microsoft Business Intelligence

1

• View MSBI course details at https//www.gangboard
  .com/business-intelligence-training/msbi-training

2
Microsoft Business Intelligence

• Business Intelligence is a process or set of
  activities such as extracting the business data
  from various operational sources, transform, and
  load the data into consolidated database or data
  ware house systems.
• That consolidated data should be reported and
  analyzed to make better decisions in order to
  improve the organization.

3
Learn MSBI step by step

• MSBI stands for Microsoft Business Intelligence.
  The powerful suite tool developed by Microsoft
  which offers best solutions for BI (Business
  Intelligence and Data-Mining Quries. This tool
  uses microsoft visual studio data tools sql
  server. It provides different processes for
  different tools for BI solutions.
• MSBI is divided into 3 entities -
• SSIS - SQL Server Integration Services.
• SSAS - SQL Server Analytical Services.
• SSRS - SQL Server Reporting Services.

4

• SSIS is basically a integration service it
  integrates the data from differnt format like
  Sybase, Oracle, Text, Excel, Mysql into one
  format, while doing integration it first
  refreshes data and cleans data. This integration
  process is done with the help of OLTP (Online
  Transaction Processing) component of MS SQL
  Server.
• SSAS is analyze service, It analyzes the stored
  data. SSAS use use OLAP (Online Analytical
  Processing) component and data mining
  capabilities.For analyze process it build
  multi-dimensional structures called CUBES and
  build mining models to perform data analysis and
  to get valuable information.
• SSRS is reporting service, Now represent analyze
  data in a graphical way SSRS is used, SSRS
  generates reports of analyze data, Reports,
  Plans, Dashboards, Scorecards, Excel etc.

5
Highlights of MSBI Technologies

• MSBI Training solutions are built on an
  enterprise data platform, fully integrated with
  the tools you are using today to manage your IT
  operations and infrastructure.
• By leverage that IT infrastructure in place today
  with SQL Server, you provide your users with the
  trust in the information the demand, the
  integration they require, and the insight they
  need to drive better business decisions.
• All done in an environment that is highly
  scalable and ready to meet the most demanding
  requirements of thousands of users throughout
  your enterprise.
• Importantly, in a dynamic development environment
  that your IT department knows and uses today,
  allowing them the rapidly develop, author, and
  publish key BI deliverables to the end users.

6
Why MSBI?

• MSBI allows data storing and fetching for elegant
  processing and fast decisions in business
• It consists resource tools provides the solutions
  for business intelligence
• The most of the companies are searching for
  expert  business intelligent workers and require
  for SSAS, SSIS and SSRS Professionals is
  increasing recently
• We can learn complete package as mentioned SQL
  server and data tools

7
Conclusion

• In this article we explored the basic idea of
  Microsoft Business Intelligence.

8
Thank You