business intelligence overview
Post on 19-Jul-2015
291 Views
Preview:
TRANSCRIPT
Blue BI
Business Intelligence Workshop
Claudio Menozzi
(BI overview – reduced version for slideshare)
December 2014
Blue BIBusiness Intelligence
Blue BI
Agenda
23/12/2014 Blue BI s.r.l 2
What is Business Intelligence? 1
BI Market Analysis3
Enabling BI: Datawarehouse technology4
BI output samples2
Blue BI
Business Intelligence Definitions
Blue BI s.r.l23/12/2014 3
Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes.
- Wikipedia
The BI and analytics platform market is in the middle of an accelerated transformation from BI systems used primarily for measurement and reporting to those that also support analysis, prediction, forecasting and optimization.
- Gartner - 2014
From Data to Knowledge to Action
Blue BI
Data Availability
Blue BI s.r.l
Blue BI
Capabilities
Blue BI s.r.l
Blue BI
BI historical functionalities set
Blue BI s.r.l
Blue BI
BI Evolution: Data Visualization
Blue BI s.r.l
Blue BI
BI Evolution: Prescriptive and Predictive Analysis
Blue BI s.r.l
Fonte: Wikipedia
Predictive analytics answers the question what will happen. This is when historical performance data is combined with rules, algorithms, and occasionally external data to determine the probable future outcome of an event or the likelihood of a situation occurring.
The final phase is prescriptive analytics, which goes beyond predicting future outcomes by also suggesting actions to benefit from the predictions and showing the implications of each decision option.Prescriptive analytics not only anticipates what will happen and when it will happen, but also why it will happen.
Blue BI
From BI to Business Enabling
Blue BI s.r.l
Blue BI
Agenda
23/12/2014 Blue BI s.r.l 10
What is Business Intelligence? 1
BI Market Analysis3
Enabling BI: Datawarehouse technology4
BI output samples2
Blue BI
Reporting
Blue BI s.r.l
Blue BI
Analytical Reporting: Olap Analysis
Blue BI s.r.l
Blue BI
Balance Scorecard/Dashboards
Blue BI s.r.l
The balanced scorecard is a strategic planning and management system that is used extensively in business and industry, government, and nonprofit organizations worldwide to align business activities to the vision and strategy of the organization, improve internal and external communications, and monitor organization performance against strategic goals.
- Balance Scorecard Institute
Blue BI
Balance Scorecard
Blue BI s.r.l
Blue BI
Dashboards
Blue BI s.r.l
Blue BI
Data Visualization (1)
Blue BI s.r.l
Blue BI
Data Visualization (2)
Blue BI s.r.l
Blue BI
Agenda
23/12/2014 Blue BI s.r.l 18
What is Business Intelligence? 1
BI Market Analysis3
Enabling BI: Datawarehouse technology4
BI output samples2
Blue BI
Business Intelligence functionalities
Blue BI s.r.l
Information Delivery• Reporting:
Provides the ability to create highly formatted, print-ready and interactive reports• Dashboards:
A style of reporting that graphically depicts performances measures. • Ad hoc report/query:
Enables users to ask their own questions of the data, without relying on IT to create a report. • Microsoft Office integration:
MS Suite acts as the reporting. Advanced integration includes cell locking and write-back.• Mobile BI:
Enables organizations to develop and deliver content to mobile devices
Fonte: Gartner - 2014 Gartner Magic Quadrant for Business Intelligence and Analytics Platforms
Blue BI
Business Intelligence functionalities
Blue BI s.r.l
Information Delivery• Reporting:
Provides the ability to create highly formatted, print-ready and interactive reports• Dashboards:
A style of reporting that graphically depicts performances measures. • Ad hoc report/query:
Enables users to ask their own questions of the data, without relying on IT to create a report. • Microsoft Office integration:
MS Suite acts as the reporting. Advanced integration includes cell locking and write-back.• Mobile BI:
Enables organizations to develop and deliver content to mobile devices
Fonte: Gartner - 2014 Gartner Magic Quadrant for Business Intelligence and Analytics Platforms
Analysis• Interactive visualization:
Enables the exploration of data via the manipulation of chart images,• Search-based data discovery:
Applies a search index to structured and unstructured data sources• Geospatial and location intelligence:
Specialized analytics and visualizations that provide a geographic, spatial and time context. • Embedded advanced analytics:
Enables users to leverage a statistical functions library embedded in a BI server. • Online analytical processing (OLAP):
Enables users to analyze data and navigate multidimensional drill paths.
Blue BI
Business Intelligence functionalities
Blue BI s.r.l
Advanced BI Functionalities• Scorecard:
Scorecards are primarily delivered by corporate performance management.• Predictive Analysis:
Encompasses a variety of statistical techniques from modeling and data mining that analyze current and historical facts to make predictions about future, or otherwise unknown, events. • Prescriptive Analysis:
Enables users to ask their own questions of the data, without relying on IT to create a report.
Fonte: Gartner - 2014 Gartner Magic Quadrant for Business Intelligence and Analytics Platforms
Blue BI
What BI for end-users?
Blue BI s.r.l
Blue BI
Gartner Analysis
Blue BI s.r.l
Business Intelligence and Analytics Platforms Advanced Analytics Platforms
Blue BI
BI Worlwide Market
Blue BI s.r.l
Fonte: Forbes
Blue BI
BI market trends
Blue BI s.r.l
Fonte: Gartner
Blue BI
Agenda
23/12/2014 Blue BI s.r.l 26
What is Business Intelligence? 1
BI Market Analysis3
Enabling BI: Datawarehouse technology4
BI output samples2
Blue BI
Datawarehouse Definition
Blue BI s.r.l
Data warehousing incorporates data stores and conceptual, logical, and physical models to support business goals and end-user information needs.
A data warehouse (DW) is the foundation for a successful BI program.
Creating a DW requires mapping data between sources and targets, then capturing the details of the transformation in a metadata repository. The data warehouse provides a single, comprehensive source of current and historical information.
- TDWI (The Data Warehousing Institute)
Blue BI
Datawarehousen architecture overview
Blue BI s.r.l
Datawarehouse Components• Data Integration• Quality Management• Master Data Management
DWH Tasks• Aggregate and homogenize
Data• Enable Historical Data• Data Integrity• Data Cleaning
Blue BI
Datawarehouse definition by Bill Inmon
Blue BI s.r.l
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process.
Subject-Oriented: A data warehouse can be used to analyze a particular subject area. For example, "sales" can be a particular subject.
Integrated: A data warehouse integrates data from multiple data sources. For example, source A and source B may have different ways of identifying a product, but in a data warehouse, there will be only a single way of identifying a product.
Time-Variant: Historical data is kept in a data warehouse. For example, one can retrieve data from 3 months, 6 months, 12 months, or even older data from a data warehouse. This contrasts with a transactions system, where often only the most recent data is kept. For example, a transaction system may hold the most recent address of a customer, where a data warehouse can hold all addresses associated with a customer.
Non-volatile: Once data is in the data warehouse, it will not change. So, historical data in a data warehouse should never be altered.
Blue BI
Gartner analysis: Data Integrator Tools
Blue BI s.r.l
Data acquisition for business intelligence (BI), analytics and data warehousing —Extracting data from operational systems, transforming and merging that dataConsolidation and delivery of master data in support of master data management (MDM) — Enabling the consolidation and rationalization of the data representing critical business Data migrations/conversions —replacement of legacy applications during mergers and acquisitions.Synchronization of data between operational applications — ensure database-level consistency across applications, both on an internal and an interenterprise basis Interenterprise data sharing — receive data from, external trading partners Delivery of data services in a service-oriented architecture (SOA) context — Data integration tools will increasingly enable the delivery of many types of data services.Integration involving cloud-based data — Integrating a combination of data residing on-premises or in SaaS applicationsBig data initiatives — Supporting delivery of data to, and accessing data from
Fonte: Gartner - 2014 Gartner Magic Quadrant for Data Integrator tools
top related