OceanakADFG Commercial Fisheries

Data Warehouse and Business Intelligence Project

project backgroundThe history

Regional management of ITData entry applications everywhere

The issuesMultiple applications doing the

same thingNew electronic reporting availableMultiple technologiesIT staffing shortagesDisconnected, disparate datasets

Single reporting tool for allWeb based with scheduling toolsAbility to serve ‘reports’ to public websiteProgrammers all use the same toolsetEnd users all use the same tool

Data warehouse as the sourceExtract, transform, load from transactional

databasesCreate user-friendly reporting structuresProvide a ‘home’ for data rescue

the idea

the challengesThe usual

MoneyLimited resourcesOther prioritiesMoneyTrainingMoneyBuy in

how?Developed product selection

criteriaWeb InterfaceExport formats (Excel, PDF, HTML,

RTF)Large scaleInterface with multiple database

typesEase of use for end usersSupport custom and ad-hoc

reportingNo down time to deploy new

reportsScheduling and multiple delivery

options

the solutionOracle Business Intelligence (OBI)

common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad- hoc analysis and reports

Oracle Data WarehouseOracle Data Integrator (ODI):

comprehensive data integration platform

who does it

• Project Manager• OBI Lead Developer• ODI Lead Developer• Infrastructure Manager• Subject Area Experts

= “big”

nowCommercial Harvest DataDuplication and reporting

next

One source for reporting

user experience

where are we?Development and test

infrastructure completeETL in test for first subject area

Scoping two other subject areasOracle BI upgrade from

development versionReady to start end user reporting

requirementsWaiting funding for production

server

okay – let me see it!!