1 / 9

Data Warehouse

Data Warehouse. Development Engineer Mr. Jorma Sipilä Data and Information Centre, ICT Services Division. Agenda. Data warehouse principles Pilot DW-project, The Compliance Monitoring Data system - VAHTI Reporting examples Future target. Data Marts. Data warehouse principles. O p

estralita-mendez
Download Presentation

Data Warehouse

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. Data Warehouse Development Engineer Mr. Jorma Sipilä Data and Information Centre, ICT Services Division

  2. Agenda • Data warehouse principles • Pilot DW-project, The Compliance Monitoring Data system - VAHTI • Reporting examples • Future target

  3. Data Marts Data warehouse principles O p e r a t i v e D B s Reports OLAP-cube Data Warehouse ETL (Extract, Transform, Load) VAHTI

  4. Pilot DW-project, The Compliance Monitoring Data system - VAHTI • The VAHTI compliance data system • functions as a tool for the 13 Centres • for Economic Development, Transport and the Environment • in their work on monitoring permits. • The data system contains information • on the environmental permits of clients and on their • wastes generated, discharges into water and emissions to air.

  5. Pilot DW-project: VAHTI DW process Data warehouse SQL-SERVER 2008 R2 Reports SharePoint Operative DB SSRS VAHTI_STG SSIS Data checking VAHTI SSIS EDWDataMarts SSAS EDW SSIS SSAS SSIS = SQL Server Integration Services SSRS = SQL Server Reporting Services SSAS = SQL Server Analyses Services EDW = Enterprise Data Warehouse

  6. Reporting examples, How to select search parameters

  7. Reporting examples, To see search results

  8. Reporting examples, To use EXCEL Pivot with OLAP Cubes

  9. Future target Overallaim is to offermethods for effiencyuse of environmental data by: • Using Reporting Tools (SSRS, SSAS) • Expand Enterprise Data Warehouse with other data topics, sothatinformationcanbeeasilycombined and processed for reportingpurposes • Publish Internet services for Environmental data

More Related