Data Analysis Project

Wehrschmatt-Lance Automotives Co. Ltd., a multinational automobile distributor headquartered in Detroit, Michigan, commissioned a comprehensive analysis of their annual sales data to identify top profit-generating products and pinpoint areas for improvement. The project also involved developing an interactive dashboard to improve accessibility to sales insights, allowing the company to assess its market position and strengthen data-driven decision-making. SQL was used for data cleaning and exploratory data analysis, Python was applied for correlation analysis via heatmaps, and Power BI was utilized to design and deploy the dashboard.