Improve car wholesale inventory and sales forecasting

United Motors is a wholesale company operating in the car industry in North California. It serves Ford branches by filling their inventory needs and wholesaling to Ford branches across California. However, United Motors faced challenges in managing its inventory and forecasting sales due to the distribution of data across different systems, including finance and sales systems, and Excel sheets.

To address these issues, our team implemented data visualization for inventory data, sales, and procurement data for the wholesale industry. We used SQL to extract data and created a data warehouse from various sources and systems. We utilized API, ETL, and SQL to gather data together and integrate it into Power BI to create data visualization.

The data visualization allowed United Motors to gain a better understanding of their inventory in different branches around California and forecast which branch of Ford needs what vehicle. The forecasting feature allowed the company to plan better and sell more efficiently, providing a competitive edge in the market.

The implementation of the data visualization system enabled United Motors to overcome its inventory management and sales forecasting challenges. It provided real-time insights and comprehensive reporting, improving decision-making processes and giving the company a competitive edge in the market.