Analyzing the Impact of Car Features on Price and Profitability

• Tech Stack:EXCEL LOOKUP FUNCTIONS PIVOT TABLE DASHBOARD
• Google drive: Project Link

The automotive industry has been rapidly evolving over the past few decades, with a growing focus on fuel efficiency, environmental sustainability, and technological innovation. With increasing competition among manufacturers and a changing consumer landscape, it has become more important than ever to understand the factors that drive consumer demand for cars.

For the given dataset, as a Data Analyst, the client has asked How can a car manufacturer optimize pricing and product development decisions to maximize profitability while meeting consumer demand?