DATA WAREHOUSE IMPLEMENTATION
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.
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.
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