Building a unified data foundation to enable near real-time insights, scalable reporting, and dealer-level data security.

About the customer

The customer is a multinational automotive manufacturer headquartered in Japan.

The project was done for one of their country operations with 70 dealers nationwide for its sales distribution and service centers.

The country operations also operate a manufacturing plant performing strategic roles in the manufacture and export of automotive products to ASEAN, Japan and other parts of the world.

Pain Points

Key challenges/observations across Businesses:

• Have a real-time data replication tool for replicating data across its ECC and C4C solutions to the SQL based data warehouse
• Avoid performance impact on the transactional systems during replication
• Minimize the current 12-hour window for data replication to real-time or near real-time
• Generate Real time reports using Power Bl
• Provide Self Service Reporting access to more than 70 Dealers and its users with more than 500 users who are envisaged to use the solution

Customer Benefits

Emisha worked with the customer to deliver the following:

• A single data integration and data quality platform to integrate multiple source systems and provide scalability to add additional sources in future.
• A single data consolidation and reporting platform based on MS SQL and Power BI
• Understanding data structures, quality and end reports requirements
• Getting data from more than 200 source tables with real time or near real time replication
• Creating a robust security framework for reporting to enable Dealers to have access only to their data sets and do self service BI
• Creation of relevant Dashboards and reports in Power Bl