From Data Warehouse to Business Intelligence –

Transcript:From Data Warehouse to Business Intelligence –:
From Data Warehouse to Business Intelligence – Paradigm shift or simply new set of tools? Kamalika Sandell, Associate CIO Joyce Deroy, Director, Information Services Matteo Becchi, BI Program Manager American University American University, Washington DC Private 4-Year University, Chartered by Act of Congress in 1893 13,047 Undergraduate, Graduate, Law Students 6,827 Undergraduates, 5,725 Graduate , 495 Visiting 750 Full-Time Faculty; 430 Adjunct; 1,300 Full-Time Staff 105 Study Abroad Programs in 34 Countries Politically and Socially Active Student Body 2 Objective of this presentation Share our experiences and approach to BI Explore what makes BI implementations different Share lessons learned Hoping to stimulate conversations, learn from you! 3 Where are institutions with their BI implementations? How many of you are actively benefitting from a mature BI implementation? How many of you are in the middle of your first round of BI implementation? How many of you are thinking about starting BI implementations? What are the most common challenges in today’s analytical environment that made you consider BI? 4 AU BI Analytics and Reporting Initiative Timeline AU analytical environment analysis Executive Dashboards Phase 1 Research Grants Financial Reports UG Admissions Reports Pre Awards Financial Reports BI Tool Selection BI Infrastructure Build Development/ Alumni Relations Reports Executive Dashboards Phase 2 Financial Reports - Facilities Financial Reports - GL Pilot Predictive Analytics Self service BI for Finance and Budget Widely used data warehouse Broad set of data Custom reports with prompts Empowered Users Self Service BI BI competency center Additional Domains Rollout self service model 5 Challenges in today’s analytical environment Tons of data Different systems, interpretation challenges Data Quality, gaps in Source Systems Focus on operational reports, Not decision oriented reports! Effort spent “developing” reports Less time to analyze results! Even less time to discuss “what needs to be done different” Every day 15 petabytes of new information are generated. It is estimated that the codified information base of the world is now doubling every 11 hours. Source: TED 2007: Predicting the Next 5000 Days of the Web. IBM analysis 6 The promise of BI Right data Right correlation Right interpretation Right access Right people Right set of analytics Intelligently harnessing data to make better decisions: 7 AU BI Success Stories SIGUCCS Award: Best of Category for Printed Instructional Classroom Materials for "Research Grants Financial Reporting“ User Success Stories: “I use it on a daily basis. Now that I'm familiar with it and