Posts

Showing posts from August, 2023

Analyzing the Impact of Car Features on Price and Profitability

Image
  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. In recent years, there has been a growing trend towards electric and hybrid vehicles and increased interest in alternative fuel sources such as hydrogen and natural gas. At the same time, traditional gasoline-powered cars remain dominant in the market, with varying fuel types and grades available to consumers. 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? This problem could be approached by analyzing the relationship between a car's features, market category, and pricing, an...

Bank Loan Case Study

Image
  Company that specializes in lending various types of loans to urban customers. Your company faces a challenge: some customers who don't have a sufficient credit history take advantage of this and default on their loans.  When a customer applies for a loan, your company faces two risks: If the applicant can repay the loan but is not approved, the company loses business. If the applicant cannot repay the loan and is approved, the company faces a financial loss. When a customer applies for a loan, there are four possible outcomes: Approved: The company has approved the loan application. Cancelled: The customer cancelled the application during the approval process. Refused: The company rejected the loan. Unused Offer: The loan was approved but the customer did not use it. Business objectives  The main aim of this project is to identify patterns that indicate if a customer will have difficulty paying their installments. This information can be used to make decisions such as ...