Microsoft Business Intelligence

1
MICROSOFT BUSINESS INTELLIGENCE (MSBI)
2
CONTENT

• What is MSBI ?
• Difference between data and information
• MSBI Tools
• Main Functionality of Business Intelligence
• What is SSIS ?

3
What is MSBI ?

• Microsoft Business Intelligence is the set of
  techniques and tools for the transformation of
  raw data into meaningful and useful information
  for business analysis purposes.
• BI technologies are capable of handling large
  amounts of unstructured data to help identify,
  develop and otherwise create new strategic
  business opportunities

4
MSBI TOOLS

• Microsoft provides some tools to transform your
  business data into information. We can use these
  tools with the interface of Visual Studio.With
  the release of SQL Server 2012, Business
  Intelligence Development Studio (BIDS) was
  renamed to SQL Server Data Tools (SSDT).

5
Main Functionality Of Business Intelligence

• Modeling  flexible prototyping of analytical
  models,
•  Self-Service BI  minimizing the involvement of
  the IT department in the process of creating
  reports,
•  Reporting  a full range of reporting
  functionalities,
•  Predictive Analysis  identifying the trends and
  causes of problems in the enterprise,
•  Integration and Data Management  full
  automation of extraction, transformation and
  loading processes (ETL) from many types of data
  sources,
•  Big Data  tracking any kind of data, regardless
  of its type and size,

6

• Data warehouses  fully prepared environment for
  the implementation of highly scalable and
  reliable data warehouses,
•  Teamwork  optimization of cooperation,
  information sharing, resource management and
  rapid data searches,
•  Mobile Access  remote access to reports,
  dashboards, and scorecards on mobile devices,
•  Data in the Cloud  easy usage of the cloud
  computing platform (MS Azure),
•  Availability, performance, and safety high
  availability (Always On service) and performance
  (Columns tore indexes) of the key tasks at the
  optimal cost,
•  Flexible implementation time  solutions adapted
  to the size of the organization and to different
  user expectations from Self-Service BI
  to enterprise applications.

7
What is SSIS ?

• Below three important projects help to complete
  the business intelligence task.
• SSIS SQL Server Integration Services
• SSAS SQL Server Analysis Services
• SSRS SQL Server Reporting Services

8
THANK YOU
For More Information. Visit
https//www.karyatech.com/microsoft-bi.html