An enterprise data warehouse and the corresponding departmental data marts represent significant corporate investments. As with all OSI Value Engineering engagements, these projects start from a clear understanding of the business objectives. Through a series of workshops, we lead the project team through the analysis and design of the essential conformed dimensions, hierarchies, and measures. The logical database design is then transformed into an optimized physical dimensional database implementation.
In addition to the understanding of the target data warehouse, an analysis of the source data systems forms the basis for the design of the extract, transform, and load (ETL) workflows and mappings. OSI business intelligence consultants are experts with leading tools including Informatica PowerCenter, Informatica Cloud Integration, Oracle Data Integrator (ODI), and Microsoft SQL Server Integration Services (SSIS). Unlike other consulting companies that simply focus on the technical implementation, we build a robust system of management processes, monitoring procedures, and automated technology to ensure a platform that is scalable and sustainable.