Data Warehouse Implementation 2018-05-07T15:45:29+00:00


We offer a full range of data engineering and data science services to build you a data-driven culture unique to your organisation, from reporting to advanced analytics and machine learning. Become data-smart with our extended team of data scientists and machine learning experts.

Customer Profile

Stockland is one of the largest diversified property groups in Australia. Stockland owns, manages and develops a range of assets including shopping centres, office and industrial assets, residential communities and retirement villages.

Business Situation

Stockland wanted to do a better job of analysing customer and finance data so it could determine opportunities for additional sales, improve financial reporting, and also improve its customer insights.


An Enterprise DW and BI solution was designed and build based on Microsoft SQL Server Business Intelligence (BI) capabilities. This was a phased approach based on Agile delivery method with a tangable businesss value outcome at the end of each itertaion. The new solution empowers business users to service their own reporting needs.


  • Single version of the fact with consolidated view on cusomter and financial data

  • Provides BI users with self-service reporting capabilities

  • Reduces ICT staff’s report development workload

  • Offers broader use of data at a lower cost

Software, Developmet Tools and Process

  • Microsoft SQL Server

  • Microsoft SQL Server Integration Services

  • Microsoft SQL Server Analysis Services

  • Team Foundation Server (TFS)

  • ERwin Data Modeller