1 / 22

Getting Started with Business Intelligence at Michigan

Getting Started with Business Intelligence at Michigan. Shane Fortune, Ross School of Business and MAIS John Gohsman, MAIS November 19, 2008 MAIS Connection Conference 10:15 session. BI at U-M What is BI? What’s Happening on Campus? BI at MAIS Organization Products Services. Agenda:.

elaina
Download Presentation

Getting Started with Business Intelligence at Michigan

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. Getting Started with Business Intelligence at Michigan Shane Fortune, Ross School of Business and MAIS John Gohsman, MAIS November 19, 2008 MAIS Connection Conference 10:15 session

  2. BI at U-M • What is BI? • What’s Happening on Campus? • BI at MAIS • Organization • Products • Services Agenda:

  3. What is Business Intelligence?

  4. Operational Efficiency Strategic Business Transformation Various Business Drivers of BI Investments Based on Gartner Research Align with and track against strategy and objectives Internal/External compliance Information Self-service model of information delivery To speed up and improve decision-making ability Timely response to data needs To share information with customers and partners Technology Higher Business Agility and Scale Lower TCO Enabling Contributing

  5. Operational Efficiency Strategic Business Transformation Examples LSA Key Performance Indicators Internal Control Reports Information Pre-defined Reports and Queries M-Dash Data Sets in the Data Warehouse M-Marketsite Technology Higher Business Agility and Scale Lower TCO Enabling Contributing

  6. Information Hierarchy/Maturity Information Maturity

  7. BI on Campus Educate and build awareness via BI Community

  8. Resources on Campus • BICE Community Events • Networking opportunities • BI Website • www.bi.umich.edu • Online Tutorial • Case studies, testimonials • BI Wiki • Projects, Tools, Training

  9. BI at U-M • What is BI? • What’s Happening on Campus? • BI at MAIS • Organization • Products • Services Agenda:

  10. MAIS BI Division: Mission • Partner • Understand business need • Leverage data for decision-making • Expertise • Competency center • Solutions • Information, Content, Tools, Analysis

  11. MAIS BI Division: Organizational Structure John Gohsman, Director Holly Nielsen, BI Products & Services Peggy Bennett, Data Admin, Research & Strategy Rapid Deployment Team Analysts Data Administration BI Community Tools Applications Data Sets

  12. Everyone has Different Information Needs

  13. Just as you choose a channel for personal information needs…. Most popular national and international stories in just 30 minutes Business news programming In-depth analysis of current events

  14. … you choose a channel for U-M information needs Leadership, Faculty & Managers (Guided Analysis) (~10,000 Users) Power Users (~3,000) Operational Users (~5,000) Operational Applications(e.g., M-Pathways, eResearch) Power Tools(e.g., Business Objects Webl, Proclarity) M-Reports “CNBC” “News Hour” “Headline News”

  15. Content comes from different locations with appropriately-designed content Operational Data • Online Transaction Databases (OLTP) • Real Time • Designed for transaction processing • Used for operational reporting • Operational Data Stores (ODS) • Day old copy of OLTP • Created for performance purposes HE Prod, HE ODS , Fin Prod, Fin ODS

  16. Content comes from different locationswith appropriately-designed content • Dimensional Models • Designed to answer known business questions • Cubes • Designed for analysis (slice/dice, drill down) Data Warehouse • Different refresh schedules • Fed from OLTP and… • Traditional Datasets • Designed for maximum flexibility HR Metrics

  17. …and delivers information to the right location Local Data Operational Applications(e.g., M-Pathways, eResearch) Power Tools(e.g., Business Objects Webl Proclarity) M-Reports HE Prod, HE ODS, Fin Prod, Fin ODS HR Metrics

  18. M-Reports: Easy-to-Use Information Application Predefined reports DW Grids and graphs (guided analysis) exposed FinProd nVision Data into info DW BusObjs Data into info FinProd HEProd PSQuery Dept Crystal future HEProd FinODS HEODS SQR HEODS

  19. BusinessObjects: Powerful Tool for Ad Hoc Reporting Ad hoc reporting Predefined reports DW Data

  20. Data Administration Services • Policy: Data as an asset that must be managed • Governance model: Stewards, managers • Strategic Use: Enterprise data model • Management: Information Life Cycle • Data Modeling Service: Data Warehouse and operational administrative data

  21. Business Intelligence Services • Deliver application solutions via M-Reports • Provide beginning and advanced training and education • Support BI community efforts • Consulting and support of data and tools • Analytical support for small schools • Build data sets for data warehouse

  22. Finalist for Microsoft’s Pervasive BI Award for M-Reports Recognition… Winner of U-M’s BI Award for M-Reports 2nd place in TDWI’s Award for BI Community Work U-M BI Website is top Google search result and highlighted by CUPA-HR And Outreach. Speaking engagements at: • iStrategy Conference, Educause, Educause Enterprise, HEUG, NCIC, National Consortium for Continuous Improvement in HE, American Strategic Management Institute

More Related