Global Vehicle sales

Facing challenges in efficiently managing its data, a multinational vehicle manufacturing company, currently operating across 19 countries requires assistance with effective data unification and reporting.

Challenge Statement

Facing challenges in efficiently managing its data, a multinational vehicle manufacturing company, currently operating across 19 countries requires assistance with effective data unification and reporting. Due to inefficient practices, data from various offices are stored in diverse file formats and storage locations.

To address this issue, the company is pursuing a solution that involves the integration of all sales data into a unified system. The key objective is to establish a dynamic dashboard, which will serve as a centralized platform for monitoring and analyzing the consolidated data. This approach will empower the company to make well-informed data-driven decisions and foster proactive business growth.

Process

Initially, the integration of all sales files were completed, consolidating the data into a single location.

Now using the power of Alteryx, performing a series of data transformations and leaning procedures, columns such as postal code and product code were incorporated into the dataset to ensure data accuracy and consistency.

Dashboard

Shopping Basket