analytics for enterprise efficiency and effectiveness
DESCRIPTION
Analytics for Enterprise Efficiency and Effectiveness. Gordon Wishon, John Rome and Leah Lommel Arizona State University (ASU). About Us. Leah Lommel AVP, Development/BI. John Rome Deputy CIO and BI Strategist. Gordon Wishon Chief Information Officer. Institutional Landscape. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/1.jpg)
Analytics for Enterprise Efficiency and Effectiveness
Gordon Wishon, John Rome and Leah LommelArizona State University (ASU)
![Page 2: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/2.jpg)
About Us
![Page 3: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/3.jpg)
Gordon WishonChief Information Officer
Leah LommelAVP, Development/BI
John RomeDeputy CIO and BI Strategist
![Page 4: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/4.jpg)
Institutional Landscape
![Page 5: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/5.jpg)
Change Imperatives at Our Institutions
![Page 6: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/6.jpg)
Shrinking/Flat Budgets
![Page 7: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/7.jpg)
Drowning in Data
![Page 8: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/8.jpg)
Want our ERPs to Deliver MORE Value
![Page 9: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/9.jpg)
Increased Demand for Accountability
Arizona Board of Regent Scorecard
![Page 10: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/10.jpg)
Struggling to Create Insight from Data
![Page 12: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/12.jpg)
Headlines Point to Analytics/BI!
![Page 13: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/13.jpg)
![Page 14: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/14.jpg)
Hot IT Skills for 2012
![Page 15: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/15.jpg)
About ASU
![Page 16: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/16.jpg)
Arizona State University
![Page 17: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/17.jpg)
![Page 18: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/18.jpg)
2011 ASU Total Headcount Enrollment
2002 2003 2004 2005 2006 2007 2008 2009 2010 20110
10,000
20,000
30,000
40,000
50,000
60,000
70,000
80,000
55,49157,543 58,156
61,03363,278 64,394
67,082 68,06470,440
72,254
58,404 Undergraduates
![Page 19: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/19.jpg)
Analytic Products
![Page 20: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/20.jpg)
Enterprise Data Warehouse
(EDW)
![Page 21: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/21.jpg)
ASU Pioneers in Data Warehousing
![Page 22: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/22.jpg)
EDW Started in Early 1990’s
ASU Data Warehouse Team from the “Early Years”
![Page 23: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/23.jpg)
Educause Publication - 1995
![Page 24: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/24.jpg)
ASU Treats Data as Strategic Asset
![Page 25: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/25.jpg)
*Choice of Data Warehouse Build or Buy - ~400 Respondents
ASU Both Built & Bought Data Warehouse
![Page 26: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/26.jpg)
Shameless Plug for Core Data Services
![Page 27: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/27.jpg)
“MyReports”
![Page 28: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/28.jpg)
We Have Rocket Scientists at ASU
Dr. Phil Christensen - ASU
![Page 29: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/29.jpg)
…And Student Rocket Scientists
![Page 30: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/30.jpg)
MyReports –Tool for Rocket Scientist
Oracle/Hyperion Interactive Reporting (formerly Brio)
![Page 31: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/31.jpg)
Example Query – Ad Hoc Capability
![Page 32: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/32.jpg)
*Apologies to Gary Larson
Not Everyone is a Rocket Scientist!
![Page 33: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/33.jpg)
Dashboards
![Page 34: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/34.jpg)
![Page 35: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/35.jpg)
http://dashboard.asu.edu
Non-Rocket Scientist Query Tool
![Page 36: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/36.jpg)
ASU’s Main Portal Page
Part of Unified Web Experience
http://my.asu.edu
![Page 37: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/37.jpg)
Tracking Student Progress
From ASU’s eAdvisor Dashboard
![Page 38: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/38.jpg)
Monitoring Class Enrollment
From ASU’s Course Enrollment Management Dashboard
![Page 39: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/39.jpg)
Mashups
From ASU’s Faculty Dashboard
![Page 40: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/40.jpg)
From ASU’s Research Dashboard
Single Version of Truth
![Page 41: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/41.jpg)
From ASU’s Financial/SuperReport Dashboard
What is My “Burn-Rate”?
![Page 42: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/42.jpg)
Early Warning/Retention Tool
From ASU’s Retention Dashboard
![Page 43: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/43.jpg)
From ASU’s Retention Dashboard
![Page 44: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/44.jpg)
From ASU’s Retention Dashboard
![Page 45: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/45.jpg)
From ASU’s Retention Dashboard
![Page 46: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/46.jpg)
Dashboard Links Directly to ERP System Like Several Others
![Page 47: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/47.jpg)
Gains in Freshman Retention Rates
2006 2007 2008 2009 2010
77.2%
79.5%
81%
84% 84%
First-Time Full-Time Freshman
![Page 48: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/48.jpg)
eadvisor.asu.edu
![Page 49: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/49.jpg)
Students Know How They Stand
![Page 50: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/50.jpg)
Best Practices for Analytics
![Page 51: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/51.jpg)
Leadership Support
Dr. Michael CrowPresident of ASU
One of “America’s Top 25 Thinkers”
Dr. Elizabeth CapaldiProvost of ASU
Creator of eAdvisor Dr. Morgan Olsen
CFO of ASUData Driven
![Page 52: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/52.jpg)
“Data Driven” Culture
![Page 53: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/53.jpg)
Policies/Appropriate Security In Place
Data Policies Circa 1992
![Page 54: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/54.jpg)
Dedicated BI Team
BI ToolsData Warehouse
Dashboard/Reporting Team (6)Data Warehouse Team (6)
• Oracle 11G RAC Hosted• Both Buy (EPM)and Build • 400 GB • ETL – Ascential/DataStage• Hosted
Director (1) and Student Workers (4)
13BI Staff
4%
~700 Hits/Day
~4000 Queries/Day
• Hosted at ASU
![Page 55: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/55.jpg)
Including Student BI Developers
Student Developers in the “Cave”
![Page 56: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/56.jpg)
Dashboards Make for Easy Consumption
Focus on Data/Information Delivery, Not Beautifully Built Data Warehouse
![Page 57: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/57.jpg)
Data/Information Actionable
![Page 58: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/58.jpg)
From ASU’s Dashboard Information Dashboard
BI on Top of Your BI
ASU’s Dashboard are Featured in Chapter
of this Book
![Page 59: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/59.jpg)
From ASU’s Dashboard Information Dashboard
Helps Monitor Adoption/Usage
![Page 60: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/60.jpg)
What’s Next
![Page 61: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/61.jpg)
Better Predictive Analytics
![Page 62: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/62.jpg)
Deeper Dive Into LMS Analytics
From ASU’s Blackboard Dashboard
![Page 63: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/63.jpg)
More Mobile
Including Location Awareness/Voice Recognition, etc.
![Page 64: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/64.jpg)
Better Visualization/Infographics
![Page 65: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/65.jpg)
Incorporating Purchased/External Data
![Page 66: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/66.jpg)
Big Data
![Page 67: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/67.jpg)
Hadoop Output of Web Log Data
![Page 68: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/68.jpg)
![Page 69: Analytics for Enterprise Efficiency and Effectiveness](https://reader035.vdocuments.us/reader035/viewer/2022062521/56816918550346895de0333b/html5/thumbnails/69.jpg)
Questions?