mdep business intelligence (bi) project kick-off john gagnon oit senior programmer / analyst...

MDEP BUSINESS INTELLIGENCE (BI) PROJECT KICK-OFF

John GagnonOIT Senior Programmer / Analyst

John.R.Gagnon@Maine.gov

“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