1 / 18

MDEP B USINESS I NTELLIGENCE (BI) PROJECT KICK-OFF

MDEP B USINESS I NTELLIGENCE (BI) PROJECT KICK-OFF. “Introduction”. John Gagnon OIT Senior Programmer / Analyst John.R.Gagnon@Maine.gov. Who’s excited about attending a three hour BI p resentation?. What is Business Intelligence?.

chava
Download Presentation

MDEP B USINESS I NTELLIGENCE (BI) PROJECT KICK-OFF

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MDEP BUSINESS INTELLIGENCE (BI) PROJECT KICK-OFF “Introduction” John Gagnon OIT Senior Programmer / Analyst John.R.Gagnon@Maine.gov

  2. Who’s excited about attending a three hour BI presentation?

  3. What is Business Intelligence? Business Intelligence transforms raw data into meaningful and useful informationin order to increase knowledge and support the decision making process.

  4. Ross Perot

  5. Hans Rosling

  6. Hans Rosling “Let My Dataset Change Your Mindset” (TED Talks – June 2009)

  7. What are the attributes of ‘good’ BI? • Meaningful & Useful • Timely • Accurate • Consistent • Accessible • Flexible GOAL: Support the decision making process

  8. 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

  9. Q: So why does the DEP need BI? A: Because we have questions that will be difficult to answer without BI.

  10. The DEP has a lot of data spread over several systems

  11. MDEP Application Tracking Systems ATS EFIS 58,395 apps 13,301 apps L&W PBR Gravel Pits 55,341 apps 934 apps

  12. Add a Data Warehouse EFIS ATS 58,395 apps 13,301 apps 127,040 total applications (as of 5/6/2013) Gravel Pits L&W PBR 55,341 apps 934 apps

  13. Restructure the data using BI tools & methods

  14. Voilà! The transformation from raw data to actionable information is complete!

  15. The Many Business Domains Within DEP

  16. The Many Electronic Systems Within DEP(Partial Listing) Common Billing Manifest MAIRIS EFIS Solid Waste ATS Tanks AECTS Gravel Pits SSTS EGAD eDMR SWF CTS Labworks Compliance RESCOM Others PBR Enforcement TOXSCAN DETOX CBI Scores of MS Access Databases Countless MS Excel Spreadsheets Institutional Controls

More Related