1 / 18

Business Intelligence

Learn about the value of data and successful BI solutions like Harrah’s Casino and Sisters of Mercy Health System. Understand key concepts, tools, and best practices for building a scalable, flexible, and auditable BI solution in your organization. Explore case studies, key strategies, and quality assurance in data repositories.

nimmons
Download Presentation

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. Business Intelligence Greg Myers Jennifer Parker Tom Smith 11/17/2009 MIS 261

  2. Introduction Value Proposition • Harrah’s Casino- The Value of Data • Rewards Program - 2x Revenue Growth • Retailer- Tesco • Reward Program - 22% Revenue Growth in 2 Years (+£5 b)

  3. Business Intelligence Overview

  4. Determining What Data is Needed Balanced Scorecard

  5. Determining What Data is Needed Strategy Map Balanced Scorecard

  6. Addressing Data Quality • Data Definitions • Consistent Processes • Data Monitoring/Cleaning • System • Enforcement • Configuration/Patching • Integration Eckerson , 2002

  7. Establishing Meta- Data • Dimensions vs. Facts • Dimension- is an attribute that displays total counts/amounts of a fact • Fact- key additive measurement of business performance • Document • Definitions, Process, Systems, Formats • Agreed upon data sources

  8. Extract, Transfer, and Load (ETL)

  9. Relational Database -OLTP

  10. Star Schema - OLAP Data Warehouse

  11. How to Successfully Build a BI Solution • BI implementation is a company wide project and should not be owned strictly by IT. • Allow developers to have access to the business owners and subject-matter experts. • Create manageable steps in the implementation and a reasonable time-line in which to complete them.

  12. How to Successfully Build a BI Solution • Create teams of small amounts of people with some experienced members. • Manage the installation or upgrade of hardware capable of supporting fast processing of data to enable tight development cycles. • Supply data to populate test versions of the data repository and test for expected outcomes

  13. Signs of a Successful Data Repository Data repositories must be • Scalable • Flexible • Backwards compatible • Auditable • Experienced Developers

  14. BI Solutions for SAP Users

  15. Presentation Tools • Reports • Microsoft Excel • Queries • Microsoft Access / Sun MySQL • Dashboards • Executive Information Systems (EIS) • http://now.sprint.com/widget/

  16. SAP Presentation Tools SAP BusinessObjects • BEx Analyzer • http://www.cnblogs.com/images/cnblogs_com/crazybugcn/AdHoc029.JPG • BEx Query Designer • http://www.expert-team.com/images/scr_BW_QueryDesigner.gif • Crystal Reports • http://www.fileguru.com/images/b/crd_subscription_information_managers_information_database-9250.jpeg • Xcelsius • http://myxcelsius.com/wp-content/uploads/2008/TOC/TOC_Calci.swf

  17. Case Study: Sisters of Mercy Health System (Mercy) • Situation – major delays in report delivery • Task - implement an enterprise wide business intelligence (BI) solution with a single overarching reporting structure • Action – research, select and install a BI solution • Results – • Business Objects was the favored vendor as users especially liked the interface’s intuitiveness and ease-of-use • Mercy was able to consolidate legacy data and make it fully accessible to authorized users • Mercy is now able to utilize metrics that allow comparisons between internal entities • Mercy staff now able to roll up financial statements and rapidly publish them following month-end close, with all information available online via a consistent and secure Web-based portal • Data accuracy and consistency has reached unprecedented high levels

  18. Q&A Segment • Discussion Questions: • BI examples in your workplace • Software • User Access of final reports • Ideas for BI utilization

More Related