Home | Data Warehousing

Data Warehousing

Data Warehousing development
A data warehouse is a unique system that centralizes all strategic and operational data of your company. Access to information is simple, secure and user-friendly.

PCG offers end-to-end services for designing and developing all the information access tools required to meet your data management needs.

Our design approach is based on the rigorous methodology developed by Ralph Kimball. We bring added value by designing your scorecard first, thus ensuring that our design responds to your strategic needs and priorities. 

The data warehouse includes data drawn from your internal data sources, as well as reference data drawn from external data sources such as Statistics Canada, Industrial Standards, etc.

Data mining tools make it possible for you to extract all of the strategic potential of your company's data. These specialized programs analyze data and identify the tendencies as well as the links within your data. We also use OLAP (On-Line Analytical Processing) tools which allows performance indicators to be analyzed very easily according to several dimensions that you will have predetermined.