Oceanak ADFG Commercial Fisheries Data Warehouse and Business
Oceanak ADFG Commercial Fisheries Data Warehouse and Business Intelligence Project Statewide Groundfish Meeting – April 2011 Kathy Jones – Chief of Computer Services Scott Johnson – Business Intelligence Lead Developer
what is it? �A single tool for : �ADFG reporting and data analysis �Dynamic data for the public web �Oceanak is the name for the entire project �Two major components � Oracle Business Intelligence (OBI or BI) � Data Warehouse
what is it? �Oracle Business Intelligence (OBI or BI) � Web based front end � ‘Canned’ and ‘Ad-hoc’ analysis/reports � Can feed the ADFG public web – dynamic data �Data Warehouse – central data repository � BI data source � Long term goal– all Commercial Fisheries data � Short term goal - new applications, broken things, dynamic data to the public web, commercial harvest data
why? �The history �Regional management of IT �Data entry applications everywhere �The issues to resolve �Multiple applications doing the same thing �New electronic reporting available �Multiple technologies �IT staffing shortages �Disconnected, disparate datasets
what’s that look like? What you don’t see!
what’s that look like?
What Oceanak Provides �Single reporting tool for all �Web based with scheduling tools �Ability to serve ‘reports’ to public website �Programmers all use the same toolset �End users all use the same tool �Data warehouse as the source �Create user-friendly reporting structures �Provide a ‘home’ for data rescue
the challenges �The usual �Money �Limited resources �Other priorities �Training �Buy in
who does it Agile Project Team • Project Manager • OBI Lead Developer • ODI Lead Developer • Infrastructure Manager • Subject Area Experts = “big”
where are we? �Development, test and production infrastructure complete �Dynamic web reports �In Production: Region I, Salmon Troll �Early May Production: Salmon in-season harvest (Blue. Sheets) �e. Landings �Start: Reporting Requirements: Kodiak �e. Landings data warehouse design in test �Mariner �All in-season Salmon data management reports are in process, Region II
okay – let me see it!!
- Slides: 11