Data Warehousing

The Enterprise Data Warehouse is the technological heart of business intelligence. The Enterprise Data Warehouse (E-DWH) can be set up on a database (we have experience with: Oracle, SQL Server, DB2, Netezza ) or on data history models based on QlikView.

However, the main criticality with Data Warehousing projects has to deal with the definition of the uploads and the ETL (Extraction-Transformation-Loading) stages management methodologies, since these are supposed to last longer and need to be maintained repeatedly over time.

iBIC has developed different ways (depending on the businesses’ size and complexity) to rationalize and make the E-DWH planning simpler. These solutions involve a significant time reduction of the implementation process and the following maintenance.

Finally, the technical competences and the knowledge of different ETL products (SAP-Data Services, Qlikview Scripting, Oracle Warehouse Builder, Microsoft Integration Services) and database programming languages increase the success of our projects.