Business Intelligence (BI)

Overview

Page 2

What is Business Intelligence?

Business Intelligence enables the business to make intelligent, fact-based decisions

Aggregate Data

Database, Data Mart, Data Warehouse, ETL Tools,

Integration Tools

Present Data

EnrichData

Inform a Decision

Reporting Tools, Dashboards, Static

Reports, Mobile Reporting, OLAP Cubes

Add Context to Create Information, Descriptive Statistics, Benchmarks, Variance to Plan or LY

Decisions are Fact-based and Data-driven

Page 3

CPU – Content, Performance, Usability

► Content► The business determines the “what”, BI enables the “how”

► Performance► Minimize report creation and collection times (near zero)

► Usability

► Delivery Method Push vs Pull► Medium Excel, PDF, Dashboard, Cube, Mobile Device► Simple churning/ Extraction► Complexity

Page 4

How Important is BI? (1/3)

Top 10 Business and Technology Priorities for 2015:

1. Computing Everywhere

2. The Internet of Things

3. 3-D Printing

4. Advanced, Pervasive and Invisible Analytic (BI)

5. Context-Rich Systems

6. Smart Machines

7. Cloud/Client Computing

8. Software-Defined Applications and Infrastructure

9. Web-Scale IT

10. Risk-Based Security and Self-Protection

Source: Gartner’s Top 10 Strategic Tech Trends for 2015

Page 5

How Important is BI? (2/3)

Source: Forrester's Top 15 Emerging Technologies

Page 6

Why is Business Intelligence So Important? (3/3)

Time

With Business Intelligence, we can get data in a timely manner.

Making Business Decisions is a Balance

Data Opinion

(aka Best Professional Judgment)

In the absence of data, business decisions are often made in haste without grounds

Page 7

Major BI Trends

► Visual data discovery and self-service:

► Cloud-based BI:

► Mobile BI:

► Big data and little data:

Page 8

BI technologies will be the most important to any organization in the next 3 years?

1. Predictive Analytics2. Visualization/Dashboards3. Master Data Management4. The Cloud5. Analytic Databases6. Mobile BI7. Open Source8. Text Analytics

…. as per TDWI Executive Summit

Page 9

TDWI Analytics Maturity Model

Page 10

Advanced Analytics / Predictive Analytics

► Data Mining► Regression► Monte Carlo Simulation► “Statistically Significant”► Predicting Customer Behavior

► Churn/Attrition► Purchases► Profiling

Page 11

BI Today vs Tomorrow

► “BI today is like reading the newspaper”

► BI reporting tool on top of a data warehouse that loads nightly and produces historical reporting

► BI tomorrow will focus more on real-time events and predicting tomorrow’s headlines

Page 12

Retail Analytics

► Market Basket Analytics► Text Analytics► Customer Segmentation/Clustering► Tailored Product Assortments► Inventory Forecasting

Page 13

Examples of BIAmazon.com and NetFlix

Collaborative Filtering tries to predict other items a customer may want to purchase based on what’s in their shopping cart and the purchasing behaviors of other customers

Page 14

What is Text Analytics?

…turning unstructured customer comments into actionable insights

…finding nuggets of insight in text data that will improve our business

From Wikipedia:… a set of linguistic, statistical, and machine learning

techniques that model and structure the information content of textual sources for business intelligence, exploratory data

analysis, research, or investigation

Page 15

Unstructured Text Processing?

Customer Sat Survey

Comments

Facebook Page

Blogs

Competitors’ Facebook

Pages Public Web Sites, Discussion Boards, Product Reviews

Alerts, Real-time

Action

TwitterPage

Services

Quality Cost Friendliness

Email

Adhoc Feedback

Call Center Notes, Voice

Page 16

What is Information Governance?

Information Governance

•Data Stewardship• Data Quality

•Data Governance• Master Data Management• Data Stewards for Master Data “Hubs”• Customer, Vendor, Product, Location, Employee, G/L Accounts

PREVENTS

Garbage In

Garbage Out

BY ENCOMPASSING

•Report Governance

•Metric Governance

CREATING SIGNIFICANT BUSINESS VALUE

Page 17

BI Technologies

► Analytic Databases

BI is a consolidating industry► Oracle: Siebel, Hyperion, Brio, Sun► SAP: Business Objects, Sybase► IBM: Cognos, SPSS, Coremetrics, Unica, Netezza► EMC: Greenplum► HP: Vertica► Teradata: Aster Data

►Independent vendors: MicroStrategy, Informatica, SAS

►Reporting standards determined mainly by Microsoft, Apple and Adobe

TeradataNetezza

DB2OracleSQL Server

VerticaAster DataPar AccelGreenplum

Semantic Databases(TIDE)

Thank You

Q&A