business intelligence anthony decerbo meaghan duffy steve smith warren scoville
TRANSCRIPT
Agenda
History of Business Intelligence
Description of Business Intelligence
Where Business Intelligence is going
Relevance of Business Intelligence to institutions of higher learning
Short-comings of UD’s current BI and data warehouse solution
Benefits of new ERP based data warehouse and BI
How the new data warehouse is setup
History of Business Intelligence
Early End Users Computing Era During the 1970s Early tools used for “do-it-yourself” solutions
Waiting long period of times for reports User friendly languages surfaced to offer a
connection between end users and the hostile IT environment
History of Business Intelligence
Information Centers Early 1980s Central support organization to provide support for
end users Relationship between non-technical user and IT
Leads to an increase of productivity for the end users
Relational Databases Data stored in rows and columns
History of Business Intelligence
Mainframes lean toward Client Servers Late 1980’s Organizations moved from mainframes
to client servers Personal Computers Office Applications
Excel, Word, and Access
History of Business Intelligence
Data Warehousing/Business Intelligence (1990s) Data Warehousing is a reorganization of data, a
cleaner version of existing data Accurate way to store and analyze data.
Web-based BI allowed The web-based Business Intelligence has allowed tools to be organized across corporate intranets and extranets
Why Use Business Intelligence?
Compiles information from current and legacy systems
Data can be formatted to show specific information
End users have the ability to customize reports as needed
Provides the functionality of spreadsheet programs for customization of reports
Centralized data, integrated performance metrics and timely controls
Strategic modeling to understand how to move forward
Tools for users
Scorecards Replaces the excel-based spreadsheet form of
management Integrate data from different sources: spreadsheets,
databases and flat files.
Data Cubes Two dimensional over time to a multi-dimensional
hypercube Drill down, slice and dice, pivot, modeling
Queries Modify existing queries Create new Manipulate results
Tools for users – Dashboards
Allows non-technical end users to make standard queries with minimal effort
What’s new - Corporate Performance Management
Sarbanes-Oxley
Operational tools for real-time decisions
Detailed timely information
Faster query response time
More ad hoc querying capability
Access to lowest granularity data
A scalable model that can roll up to the executive dashboards or scorecards
What’s new - Semantic
Web
Provides the context of the information in addition to the information
Folksonomy vs. taxonomy
Five layer model Resource layer – data structured- unstructured, dynamic-static Data conversion layer - map various databases into the data warehouse Data storage and data management layer – manage data cubes, user
accounts, and calendar management. Knowledge/trend/pattern layer – manipulate data cubes, data mining, and
statistical modules. User process layer – reports, web functions
Relevance in Higher Education
Adoption of Business Intelligence tools in education lags corporate adoption In May 2008 survey, only 29% institutions reported they
were using BI 51% planned to implement in 6 to 24 months
Offers insight on the business side Admissions, Finance, Advancements Balancing new students evenly among faculty and
facilities Are we performing our best, while keeping costs down
Relevance in Higher Education
Can also report on the academic side “Institutional Intelligence” Are classes being offered at the right time Helping to identify and offer help to at-risk students
Short-comings of Current BI tools at UD
Technical Data Warehouse only stores data from one system ETL specialized to pull data from student information
system
Organizational Was an IT project No Executive Sponsor
Currently being used for daily reporting
Does not help with data mining or trending
Benefits of ERP based BI Tools
Data warehouse will have information from all systems, which are currently separate
New ODS and EDW will offer daily reporting, as well as trending
Several executive sponsors for the whole project
Not just an IT project
Getting the right information to the right people
How ODS and EDW are setup
Three different databases Operational System (Banner) Operational Data Store Enterprise Data Warehouse
ETL Process from Banner to ODS Denormalized
ETL Process from ODS to EDW Star-schema for trending