What is Data Analytics Business Intelligence

What is Data Analytics / Business Intelligence?

Reach - Deploying Information to the Masses Q: What landmark device was invented in 1452? A: The Printing Press (Johannes Gutenberg)

What is DA/BI? • DA/BI has two main dimensions: – Richness – Reach Richness describes the usefulness of information Reach describes the availability of information

Richness = Information Intelligence • Useful information is information that allows one to make decisions! Data • Disparate facts Information • Data with meaning (who, what, where, when) Knowledge (DA/BI) • Information that affords action (how, why)

Reach = Information Availability • Useful information is information that is available to people making decisions! • DA/BI tools bridge the gap between users and knowledge. . . delivering richness & reach • Puts power in the hands of users • IT department no longer gatekeeper to information

DA/BI Philosophy “Give one a fish and they will eat for a day. Teach one to fish and they will eat for a lifetime!” - Chinese Proverb

DA/BI Defined • DA/BI is a Process: – that identifies the KPIs driving your business – is delivered through an intuitive analytical interface – is readily available to business users on a consistent and timely basis – information adapts to changing business needs

The Data Warehouse (DW) • The foundation for enterprise DA/BI • Provides a single, clean, standardized repository of enterprise information Data Marts • • Separate environment from Transactional Systems Specially designed for DA/BI reporting & analysis Data Warehouse

ETL – Extraction, Transformation, & Loading “The DW building tool” DBMS ERP Flat Files SOURCE EXTRACTORS ETL Tool DATA ASSETS SHARED DIMENSIONS COORDINATED DATA MARTS WITHIN DATA WAREHOUSE

Enterprise Reporting • Allows reporting across all areas of the enterprise • Allows reporting across multiple systems and platforms • Allows transaction-level reporting • Enables operational-level decision-making Enterprise Reporting

OLAP (On-Line Analytical Processing) (that “cube” thing) • Multidimensional Analysis (OLAP) – Easy, fast access to KPIs across one or many dimensions – View your organization’s information from endless perspectives – An information delivery framework, not “canned” reports – Designed for self-service by information users

The OLAP Cube • Enterprise data organized into business terms & dimensions • Presents information in top-down format • Ideally focused on one subject area • Optimized for fast navigation • Use to look at information from endless perspectives

Slice & Dice Your Data with OLAP! Any Database Data Warehouse EXCEL Spreadsheets Industry Reports/ Secondary Data

Data Mining (the “unasked” question) • Discover hidden trends and patterns in your data • Identify unsuspected correlation to target results • Supports predictive modeling and “what if” analysis • Supports the LEAST structured questions & decisions

Visualizations (a picture is worth a thousand words) Visualization • Highest level view of information • “Dashboard” of multiple data sources • Geographic Information Systems (GIS) Benefits • Fast intuitive knowledge transfer of complex data • Pattern and Trend Analysis • Consolidated view of cross functional KPI’s

Corporate Performance Management (CPM) § “Scorecard” of highly visual metrics § Use cubes, queries or spreadsheets as data sources § Drill-Thru to underlying details § Management by Objectives (MBO) § Enterprise-wide monitoring & management of KPIs

Information Distribution Extranet / Portals (Customers, Suppliers, Partners) Third Parties BI (Business Intelligence) Enterprise Architecture CPM (Corp. Performance Management) ETL (Extraction, Transformation, & Loading) Data Mining OLAP Transactional Systems (ex. ERPs) Data Marts Data Warehouse GIS Enterprise Reporting Tactical Databases Operational Web-Based Transactions Strategic Transactional

Global Customers using DA/BI Heinz Avon Marriott PECO Smith. Kline Dreyfus Union Bank AT&T James River American Express OSRAM SYLVANIA Hamilton Beech French Navy United Airlines NASA Analog Devices Heineken Pepsi Omnicom Allied Signal Land Rover Estee Lauder All America L. A. Times Consumers Gas US Department of Energy EMI Records Telia Sweden US Post Office Vanguard Chevron Siemens Corporation Procter & Gamble EMI Records Abbot Labs Chrysler Engineering PTT Holland Paramount Pictures Proctor Silex York International Cisco Systems Host Marriott Boston Scientific Southern California Edison Johnson & Johnson MCI Air Products

Pittsburgh Customers using DA/BI Marconi Ariba (formerly Free. Markets) US Steel Robert Morris University Westinghouse Peak Technical Butler Health System Kane Magnetics EDMC GNC CPS Daily Juice Crown Castle USA PPG Industries Duquesne Light Bush Industries Hillman Company Eat’n Park Union Switch & Signal Copperweld National Draeger ITXM Lord Corporation Highmark Blue Cross Sunrise Medical (De. Vilbiss) Cutler-Hammer American Textile Penn State University Federated Investors APTECH Blair Corporation Starwood Hotels Heinz USA Mine Safety Appliance Allegheny Power American Eagle Outfitters SAE International Giant Eagle INRANGE Management Science Associates Carbide Graphite Robicon UPMC Anderson Equipment PNC Bank FNB Corp

Thank You!