< Back to R&D Portfolio

DWPSS Project: Data Warehousing of Industrial DataPermalink

For this project, I architected and developed a complete OLTP database + ETL process + data warehouse + OLAP solution for managing and visualizing various types of industrial data (such as temperature, pressure, and count series) for a company in southern Germany.

In particular, I implemented a custom ETL process using Oracle PL/SQL, which ingested data from a clustered OLTP Oracle database, loaded data into tables into another Oracle database (containing the data warehouse with a star schema developed using the Kimball approach), and then cleaned and transformed data into a form suitable for ingestion by MS Analysis Services which, in turn, was used to build OLAP cubes for analysis in Excel and its PivotTable and Chart components.

The figure below shows the schematics of this data warehousing solution.

Additional details available upon request.

Back to top