DEXUS Property Group is one of the largest property groups listed on the Australian Securities Exchange (ASX:DXS) with $13 billion of assets under management. Producing Sector Reports at DEXUS required significant business analyst resources. The data was collated from The JDE ERP and Argus planning systems through advanced Excel models, which served as a platform for core reporting. Crossjoin.Net, was commissioned to automate the data loads, centralise transformations, centralise business rules and establish a business focused reporting framework. The solution was built using Microsoft SQL Server, SharePoint and Excel Business Intelligence tools and included timely extracts data from JDE and Argus DW source systems thus making it available in a centralised data repository for all reporting and analysis. Visibility on the data was delivered to users via online reports, ad hoc analysis tools and interactive dashboards. |
|
The solution has meant that
|