CASE STUDY | CONSTRUCTION | DATA & ANALYTICS
Smart City Planning Enhanced by Decision Inc.
Solution Overview
Industry
Construction
Solution
Data Integration and Power BI reporting
Technology
Power BI
Location
Middle East
Client
Our client, situated in a planned mega-city in the
middle east, aims to create a futuristic and
technologically advanced urban environment.
Requirement
The initial reporting for the client was driven by SAP extracts and Excel, combined with offline mapping files to accommodate fast-moving changes to business structures. This required significant time investment from the FP&A team and was not a sustainable solution.
Decision Inc. UK empowers planned smart city with comprehensive insight into
their SAP data through a visually engaging suite of Power BI dashboards.
About The Client
Our client, situated in a planned mega-city in the middle east, aims to create a futuristic and technologically advanced urban environment.
Their main priority is sustainability and renewable energy sources. The organisation, is tasked with the delivery of this city and as such must co-ordinate and plan many thousands of construction and nonconstruction projects to deliver on the master plan.
The Challenge
The initial reporting for the client was driven by SAP extracts and Excel, combined with offline mapping files to accommodate fast-moving changes to business structures.
This required a significant time investment from the FP&A team and given the rapidly expanding scale of the mega-city, was not a sustainable solution.
To address these challenges the client engaged with specialist data & analytics consultancy Decision Inc. UK.
The engagement comprised multiple objectives, including:
Automated integration of data from SAP S/4
Flexibility to align this SAP data with budget and forecast information stored in Excel.
Delivery of executive dashboards to clearly
highlight areas of underspend.
Reducing the time to access data for decision making.
The ability for user-led commentary on performance, directly on the dashboard.
Reduction in the reliance on manual spreadsheets, key person dependencies and multiple siloed views of the organisation.
Capability to drill down to individual projects and line-item information to add additional clarity to the performance.
The Solution
Drawing on a wealth of experience in data & analytics, Decision Inc. UK presented Power BI as the platform best suited to the needs of the client.
Power BI is perfectly situated to integrate data from both SAP and non-SAP data sources, blending this information together to produce one holistic view of the organisation.
During the phase one engagement Decision Inc. UK delivered the automated integration with SAP S/4, executive and management level dashboards, and the capability for users to input
commentary directly onto the dashboard
The subsequent phases added additional functionality, including an automated management accounts pack, with the capability to export directly into PowerPoint in a ready-to-send format. In addition, the delivery included a project planning PowerApp, allowing milestone planning on projects, brought to life with Gantt charts and other visuals in Power BI.
The Outcome
The suite is currently being used by over 100 users across the organisation
This provides a single source of information across the organisation, delivered automatically and in a visually engaging format. This ultimately results in time saved and a reduction of redundant tasks, enabling better decision making with accurate information.
Furthermore, there are additional initiatives planned for the year ahead.
ABOUT DECISION INC.
Decision Inc. is a global digital partner that enables businesses to reinvent themselves to realise their full potential.
We deliver agility, resilience, and intelligence to any enterprise, enabling them to adapt quickly and thrive through innovation and opportunity.
Our teams have engaged with more than 400 clients globally over the past 15 years, providing them with the expertise to build, operate, and optimise their digital businesses.
We achieve this by leveraging the world’s best technology to drive our client’s business ambitions forward into tomorrow’s reality.
Our success is ultimately driven by our entrepreneurial culture, industry exposure, and the passion of our people. We have three key cross-functional teams – Functional and Specialist Consulting, Development, and Engineering teams.
Based in four global offices, our exceptional consultants focus on delivering value to clients by keeping them at the centre of our service delivery.