In an initial workshop, key requirements and initial objectives were defined. In the case of bekumoo, taod also provided business development consulting. The aim was to develop a product based on application questions and available data sources and databases. What data is available or still needed? How can it be used within the SaaS to answer questions or for business management?

Data in very heterogeneous formats is to be incorporated into the SaaS and standardized so that it can be visualized in reports at a later stage. The basis for standardized reporting is the respective merchandise management system of the car dealerships. The employees document their activities on an order-related basis, independently and transmit the data on a daily basis. This raw data is then cleansed and transformed using taod's ELT integration. 

Another challenge in this context is authorization management. To ensure the highest security standards with regard to highly sensitive personal data, taod uses row level security (RLS) with Power BI and the underlying database. Row level security can be used to restrict data access for selected users. Data access at row level is restricted by filters and the filters can be defined in roles. These filters are influenced by a well thought-out role concept. For example, managers of a team can see the entire team and members of a team can only see their own performance data.

Once a uniform database is in place, the data is finally visualized and evaluated in Power BI. For bekumoo, the BI tool from Microsoft is a logical choice, as the data is hosted via Microsoft Azure due to the specific individual requirements.

As a result, the bekumoo software has been in use since January 2021 on the basis of standardized data models, modern cloud hosting and automated Power BI connection for modern controlling of the car trade.