Automotive organisation|Professional services
Automotive organisation improves reporting accuracy
Our client, an automotive organisation, has always aimed to put their customers first. This attitude has enabled them to gain millions of clients, but with all this growth comes a challenge of a new kind – data.
Summary
Objective
Following a Coeo training course, this organisation made the decision to move to Power Apps and Power BI. We were tasked with designing and building these solutions, making sure they supported the company’s high-priority procurement processes.
Solution
- Power Apps
- Power BI
- Rebuilding existing data from Excel spreadsheets
Results
- Reports can be run daily to make sure policies and processes are implemented
- Simpler reporting, resulting in higher accuracy and greater accountability
- The client has continued to work with Coeo for post[1]deployment support and service transition
- More areas of improvement have been identified, including the potential for an enterprise data lake
Learning & understanding
The challenge
The organisation had built a complicated series of Excel spreadsheets that required full-time management to run their contracts, budgets and forecasts for their procurement team.
This caused numerous manual errors and was not auditable. The team knew that there were better options available and wanted to understand them. So, they attended a public delivery of Coeo’s ‘Introduction to Power BI’ training course, which teaches attendees how to load, transform and visualise data using Microsoft’s Power BI platform.
Following the training, they approached Coeo to run a two-day private Power BI training course, which opened discussions about how they process and manage their data. With the guidance of Coeo and Microsoft, they made the business decision to move to Power Apps and Power BI.
Implementation
The solution
Coeo worked with the automotive organisation to design and build a service map solution that encompassed their high[1]priority procurement processes. This created a way for them to manage suppliers, contracts, supplier details, budgets and forecasts.
We rebuilt the complex set of Excel spreadsheets using simple-to-use Power Apps, with the reporting being handled by Power BI. Power Apps greatly reduces the time and effort required for data entry and the Power BI report provides easier and more interactive analysis of the data, helping the business users and leaders to make more informed decisions.
“The organisation had built a complicated series of Excel spreadsheets that required full-time management to run their contracts, budgets and forecasts for their procurement team.”
Outcomes
The results
The new series of reports can be run on a daily basis to ensure that all policies and processes have been implemented and highlight exceptions where this has not been maintained. The new process is simpler to use and has resulted in higher accuracy and greater accountability when entering and using data.
Coeo have continued to work with the client to provide post-deployment support and service transition to ensure a successful adoption of the app and reports.
As this was a pilot solution, the next step is to integrate this system fully into the client’s Enterprise Data Lake. This will ensure that all data is housed in one area to make sure there is a single version of the truth and reduce shadow IT.
Coeo have also identified that there are other significant business processes that can be further automated to reduce errors and to ensure that their team is more efficient within day-to-day tasks.
case study
Providing a trusted technology partner ongoing support, as Marque Group Solutions (MGS) transitions to a global, scalable cloud solution
MGS use advanced data integrations to deliver truly best-in-class automotive solutions, helping dealers, OEMs and mobility providers to optimise sales and aftersales performance, sustainably boosting retention and profitability.
case study
Energy conscious solutions
Thanks to SQL Server specialist Coeo, energy conscious Valpak is benefiting from significant cost and efficiency savings with a database solution that combines Microsoft Hyper-V and Microsoft SQL Server to cut the number of servers in use and provide 100% availability of business critical systems.
