From manual to automated reporting with Power BI

With the Power BI based solution from NUMBERO and novaCapta, car dealerships can quickly access their big data sets, easily understand them, add notes and track their goals and optimization potentials even more strategically.

No automated solution available – data is processed manually

No API interfaces in legacy programs

Easy handling even for non-IT-savvy target groups

Solution must be quickly usable without training – focus on a strong UI & UX

Visualization of data sets and reportings with Power BI

Integration of Power App to include a note function in the solution

Azure for data extraction and database for caching data

Storing automatically processed data sets in one centrally located solution

Appealing and comprehensible design – strong UI, UX and usability

Data in the Cockpit is displayed according to access rights – manager get an overview of all data, employees see the data relevant to them

NUMBERO specializes in digital solutions for automotive dealers. In discussions with customers, NUMBERO repeatedly noticed that the car dealers faced the same challenge: preparing data from (process) controlling in a way that it is quickly and easily available for evaluation. Until now, although the data was available, it was

either stored unused in confusing PDF collections or manually consolidated for centralized viewing in Excel. „It was obvious to us: this needs to be done faster and easier“, says Tim Wendschoff, Managing Director of NUMBERO.

out Power BI and enlisted the services of novaCapta, a partner with the expertise to develop the solution. Together they developed the Cockpit, which now makes customers‘ hearts beat faster. It extracts the customers‘ existing data from their system, which has no API interface, into the Azure database. Power BI is then used to pull and automatically process the data sets, thanks to state-of-the-art data modeling. This way, the final data is easily available and customers get a quick insight into their goals and optimization potential.

novaCapta also added a client authorization (Row Level Security) and governance to the solution. In this way, all customer data can run through the database and unauthorized access is prevented by the login procedure. To simplify the analysis of the data, a canvas app was integrated with Power Apps. This allows users to comment on and store notes in the data record. This strengthens the processing of the data by allowing important findings and information to be directly recorded. By adding additional Power Apps or other Power Platform components the solution can be extended with new functions as required. 

NUMBERO‘s customers are impressed. The appealing design not only looks good, but also enables intuitive usage. The mobile version also ensures that employees 
can access their cockpit not only from their desks, but also directly from the garage. Moreover, the data view can be reduced to different views depending on the access (login) of the customer – from the manager who has an overview of all the information to the employee who wants to track his or her individual goals. The integration into the daily work routine is extremely easy. Just five to ten minutes in the morning are enough to get an overview of one‘s own potential and thus optimize revenues in the long term. The product is having an impact: since going live, the first customers have reported an immediate increase in revenue of over 25 percentage points. A promising start for the cockpit.

Download Case Study NUMBERO PDF (DE)

Download Case Study NUMBERO PDF (EN)