1 / 27

LogiXML Business Intelligence

LogiXML Business Intelligence. 7900 Westpark Drive, Suite T107 McLean, VA 22102 | www.logixml.com. Format. How Old is BI?. 1958 – Hans Peter Luhn – “Business Intelligence”. 1960’s – Decision Support Systems Born. 1969 – Edgar Codd “invents” relational database.

seda
Download Presentation

LogiXML Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LogiXML Business Intelligence 7900 Westpark Drive, Suite T107 McLean, VA 22102 | www.logixml.com

  2. Format

  3. How Old is BI? 1958 – Hans Peter Luhn – “Business Intelligence” 1960’s – Decision Support Systems Born 1969 – Edgar Codd “invents” relational database 1970’s – Model Driven DSS, VisiCalc ~1974 – P&G Implements MRP & EIS Systems 1980’s – Rise of the ERP and Data Driven DSS Systems 1985 – Edgar Codd writes rules for OLTP 1989 – Howard Dresner Predicts Rise of BI 1990’s – Essbase, Microstrategy, & Business Objects 1993 – Edgar Codd writes rules for OLAP 2000’s – Columnar DBs, Tableau, ETL & MDM 2010’s – Cloud, Big Data, Predictive Analytics (???)

  4. How Old is BI?

  5. Business Intelligence “the ability to apprehend the interrelationships of presented facts in such a way as to guide action towards a desired goal.” • Hans Peter Luhn, 1958 “concepts and methods to improve business decision making by using fact-based support systems.” - Howard Dresner, 1989

  6. The Promise of BI By 2000, Information Democracy will emerge in forward-thinking enterprises, with Business Intelligence information and applications available broadly to employees, consultants, customers, suppliers, and the public. The key to thriving in a competitive marketplace is staying ahead of the competition. Making sound business decisions based on accurate and current information takes more than intuition. Data analysis, reporting, and query tools can help business users wade through a sea of data to synthesize valuable information from it - today these tools collectively fall into a category called "Business Intelligence.“ - The Gartner Group, 1996

  7. How Does Technology Work? • Any process will have a “bottle-neck” or constraint • Process Improvement = removing the existing constraint (sometimes) • Removing the existing constraint = technology (sometimes)

  8. BI’s Goal • Better Decisions -> Better Performance

  9. BI’s Core Assumption

  10. What was the Goal?

  11. What has BI Focused On?

  12. BI = Decision Support • Decision Sciences • How do we make decisions? • How can we make “better” decisions?

  13. BI = Better Information (Kinda’) • Business Intelligence: “…application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions.”

  14. BI = A Set of Use Cases • Reporting • Dashboard • Ad Hoc Query • MS Office Integration • Search-based BI • OLAP • Interactive Visualization • Predictive Modeling and Data Mining • Scorecards • Alerts • Workflow Processing

  15. BI = A Set of Technologies • Data Storage and Computing Hardware • Applications and Data Sources • Data Integration (ETL) • Relational Database Engines • OLAP Engines • Data Modeling / Profiling / Quality Tools • Metadata • Analytic / BI Applications • Information Presentation and Delivery

  16. The BI Team

  17. Better Information = “One Version of the Truth”

  18. Dimensional Models Order Date Ship Date July 18, 2011 July 20, 2011 $13.12 Tracking Number ISBN 1ZW2144Y0316363368 0762436093

  19. Dimensional Models Order Date Dimension Product Category Dimension FY 2011 Books Q3 2011 Fact (Price) Cooking, Food & Wine July 2011 Outdoor Cooking July 18, 2011 July 20, 2011 Barbecuing & Grilling $13.12 0762436093 1ZW2144Y0316363368 Wiviott, Gary Low & Slow:… Step away from the propane tank. Surrender…

  20. Sales in Q3 2011 for Outdoor Cooking Books? Order Date Dimension Product Category Dimension FY 2011 Books Q3 2011 Fact (Price) Cooking, Food & Wine July 2011 Outdoor Cooking July 18, 2011 July 20, 2011 Barbecuing & Grilling $13.12 0762436093 1ZW2144Y0316363368 Wiviott, Gary Low & Slow:… Step away from the propane tank. Surrender…

  21. Sales in Q3 2011 for Outdoor Cooking Books? Order Date Dimension Product Category Dimension FY 2011 Books Q3 2011 Fact (Price) Cooking, Food & Wine July 2011 Outdoor Cooking July 18, 2011 July 20, 2011 Barbecuing & Grilling $13.12 0762436093 1ZW2144Y0316363368 Wiviott, Gary Low & Slow:… Step away from the propane tank. Surrender…

  22. Sales in 2011 2nd Half of Year for All Products Related to Traditional Southern Cooking? Order Date Dimension Product Category Dimension FY 2011 Books Q3 2011 Fact (Price) Cooking, Food & Wine July 2011 Outdoor Cooking July 18, 2011 July 20, 2011 Barbecuing & Grilling $13.12 0762436093 1ZW2144Y0316363368 Wiviott, Gary Low & Slow:… Step away from the propane tank. Surrender…

  23. Classification (Taxonomy)

  24. Evolution and Emerging Topics • Query the Source System • OLAP • ROLAP • Dimensional Data Warehouse + RDBMS • Columnar / Analytical DBs • Visual & Predictive Analytics • NoSQL, Map Reduce & Big Data

  25. Quiz • Technology works by… • The BI Industry is focused on better… • What types of constraints does BI remove… • We’ve been working on BI since… • The primary information model used by BI is… • The “oldest” example of writing records… • When asked how to accomplish an outcome, the answer should always start with…

  26. Questions

More Related