CLIENT STORY
Suzuki Auto South Africa
An Innovative approach to streamlining network aftersales reporting
Suzuki Auto South Africa, one of the fastest growing automotive brands in South Africa, required an innovative approach to their monthly dealer workshops reporting. They approached One Power Cloud to develop a national reporting application which would allow workshop managers across the country to capture critical data. This, along with integrations to multiple systems for data collation, has allowed them to utilise a hybrid solution consisting of a bespoke web application and Power BI, developed and maintained by One Power Cloud, to help further strengthen their position in the market and improve on their reporting efficiencies from external franchisees as well as internal reporting.
A strategic initiative that effectively improves dealer reporting.
Read the story:
Three different data sources and individual workshop manager reports from over 100 workshops spread across the country, provide the basis for regular reporting which enables the business to drive strategic client retention initiatives.
Traditionally the business would spend large numbers of man hours, both internally and at their retail branches across the country, to capture and collate the data.
One Power Cloud developed a custom web application that allows the dealers across the network to capture critical business data. At the same time a data platform was created that collects, stages and stores data from three additional data sources with multiple data tables and fields in each. Over the data a Power BI reporting platform was created and in turn deployed by securely embedding inside the same web application.
Technologies deployed
- Azure Data Lake Gen 2
- Azure SQL database
- Azure Application service
- Azure Synapse analytics
- SharePoint
- Power BI
The solution has been successful and allows for future integration as required.
CLIENT STORY
Tavcor Motor Group
Data and analytics program
A rapidly growing business with a forward-thinking board, the group decided to pursue a data and analytics program to support the strategic goal of improved customer retention, efficiency improvements on reporting and data transparency at executive level.
Read the story:
The Tavcor Motor Group, a leading retailer of new and used motor vehicles, with several brands, has a muti decade history on the South African South Coast, servicing clients across the country.
The business runs a central DMS (ERP) solution for their primary Stock, POS and Accounting needs. It runs other systems to serve their CRM needs, HR needs and digital requirements.
With multiple systems and multiple users, the business generates large volumes of data in silos.
They approached One Power Cloud to develop a data lake solution for storage and data staging along with a Power BI analytics solution for report consumption.
The following technologies were deployed:
- Azure Synapse analytics – Data collection. Data pipelines.
- Azure Gen 2 Data Lake – Data storage and staging.
- Power BI – Service – Data visualizations and Report Consumption.
The combination of these technologies, configured and supported by One Power Cloud has enabled the Tavor Motor Group to rapidly add additional data sources, scale on the number of business units and utilize their advanced reporting platform daily from executive to line manager levels. The business uses the platform for Operational and Financial reporting.
Their Marketing department uses the platform for data collation, customer record cleaning and deep analysis of customer activity across the group. The platform supports the strategic business objective of enhancing and improving client retention strategies and improved reporting efficiencies and data transparency at executive level.
Our Location
No 7, Corobrick Street, Meadowdale, Germiston,
Johannesburg 1614.
Contact
