What is Data Analytics / Business Intelligence?

1. What is Data Analytics / Business Intelligence?

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

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

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

5. 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

6. 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

7. 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

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

9. ETL – Extraction, Transformation, & Loading“The DW building tool” COORDINATED DATA MARTS WITHIN DATA WAREHOUSE DATA ASSETS SOURCEEXTRACTORS SHAREDDIMENSIONS DBMS ETL Tool ERP Flat Files

10. 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

11. 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

12. 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

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

14. 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

15. 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

16. 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

17. BI (Business Intelligence)Enterprise Architecture Information Distribution Extranet / Portals(Customers, Suppliers, Partners) Third Parties Transactional Databases CPM(Corp.PerformanceManagement) Web-BasedTransactions Strategic ETL (Extraction, Transformation, & Loading) DataMining Tactical OLAP TransactionalSystems (ex. ERPs) GIS Data Marts Operational Enterprise Reporting Data Warehouse

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

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

20. Thank You!