MDEP BUSINESS INTELLIGENCE (BI) PROJECT KICK-OFF
John GagnonOIT Senior Programmer / Analyst
“Introduction”
Who’s excited about attending a three hour BI presentation?
What is Business Intelligence?
Business Intelligence transforms raw data into meaningful and useful information in order to increase knowledge and support the decision making process.
Ross Perot
Hans Rosling
Hans Rosling“Let My Dataset Change Your Mindset”
(TED Talks – June 2009)
What are the attributes of ‘good’ BI?
• Meaningful & Useful• Timely• Accurate• Consistent• Accessible• Flexible
GOAL: Support the decision making process
Who is using BI Systems?
• Finance• Sales & Marketing• Manufacturing• Maine Office of the State Controller• Maine Department of Health and Human Services• Maine Department of Transportation• Maine Department of Education
Q: So why does the DEP need BI?
A: Because we have questions that will be difficult to answer without BI.
The DEP has a lot of data spread over several systems
ATS EFIS
Gravel PitsL&W PBR
MDEP Application Tracking Systems
58,395 apps 13,301 apps
55,341 apps 934 apps
ATS EFIS
Gravel PitsL&W PBR
Add a Data Warehouse
58,395 apps 13,301 apps
55,341 apps 934 apps
127,040 total applications(as of 5/6/2013)
Restructure the data using BI tools & methods
Voilà! The transformation from raw data to actionable information is complete!
The Many Business Domains Within DEP
APPLICATIONS
PERMITS
ENFORCEMENT
LEGISLATIVE
COMPLIANCE
OUTREACH
RESPONSE
REVENUE
BUDGET
OTHERS...
MONITORING
The Many Electronic Systems Within DEP(Partial Listing)
EFIS
ATS
EGAD
Compliance
Enforcement
MAIRIS
Scores of MS Access Databases
Countless MS Excel Spreadsheets
AECTS
eDMR
CTS
PBR
Manifest
Tanks
SSTS
RESCOM
TOXSCANDETOX
Common Billing
Labworks
Gravel Pits
Solid Waste
Others
SWF
CBI
Institutional Controls