Business Analytics

Analyse the market trends of the Used Car Market from multiple geographies using EDA and Data Visualization

Help a car reseller analyse the market trends of the used car market using exploratory data analysis and data visualization.

Certified by

Role

Business Analyst

Industry

Automotive Retail

Menterns at work

Level

Intermediate

Time Commitment

60 Hours

Duration

35 days

Tools you’ll learn

Here’s What You Work On

About the Company

Founded in 2015, CARS24 is a leading AutoTech company streamlining and revolutionizing the sale, purchase, and financing of pre-owned cars in India, Australia, Thailand, and UAE. Leveraging a Smart AI Pricing Engine, and 140 quality checks, selling and buying pre-owned vehicles is seamless and transparent with CARS24.

CARS24 has brought together cutting-edge technology and country-wide partners to solve all the problems associated with selling an existing car, or purchasing a pre-loved one. Their team of dedicated in-house researchers work tirelessly to understand what our customers desire and create a delightful buying or selling experience for them.

Explore

the following work techniques

Exploratory Data Analysis (EDA with SQL

Data Visualisation using Tableau

Learn more about our Menternship Principle

Bridging the gap

CARS24 aims to gain & maintain a competitive advantage by staying ahead of market trends and customer preferences in the car resale industry.

Leveraging SQL for data analysis and visualization tools like Tableau enables them to optimize their operations, inventory management, pricing strategy, and marketing efforts based on actionable data insights.

In this project, you will help analyze market data of the used car market in India and highlight trends that will help CARS24 make better strategy decisions such as target geographies and pricing.

Apply

the following skills

Data Analysis

Data Visualization

Data preparation

Learn more about our Menternship Principle

Expected output

In this Menternship, you will be required to submit the prepared dataset, documented SQL Queries and Results, Visual Dashboards showcasing your analysis & a Presentation outlining your findings and recommendations.

Create

the following deliverables

Data preparation of the given dataset

Visual Dashboards on Tableau

Presentation with Key Insights & Findings

Learn more about our Menternship Principle

What you’ll need before starting

Intermediate SQL
Tableau

Why Do Menternships?

Build Real Skills by doing work, by experience.

Each Menternship experience is powered by the MentorMind experiential learning model. We empower you as a Mentern to produce your own unique real work output through mentoring, deep-learning & applying your learnings to work.

Do Real Work that matches corporate expectations.

All our Menternships are co-created with companies. They are designed for real-time work in the corporate function which allows all levers of a work experience to flourish in your Menternship experience.

Get active guidance from Real Mentors.

You get access to a guild of industry mentors with remarkably diverse experience in their fields. Mentors help you with expert advice, domain guidance or to understand a specific task better. Moreover, you can always depend on our community of menterns, MentorMind Garage, to seek assistance from your co-menterns, guides & mentors!

Showcase your Official Certification.

Successfully completing a Menternship is no less that having practical, hands-on work experience. You earn a Certificate of Recognition from the Menternship partner company which can be showcased on your CV or your LinkedIn as a proof of your real skills!

Become a member of the Mentern Perks Club.

As a Certified Mentern you earn a spot in the exclusive Mentern Perks Club, a MentorMind community that opens up networking amongst menterns from across the globe. MentorMind empowers the community with our amazing Perks Club guides, Do-With-Us workshops & access to work opportunities with our Corporate Partners!

Meet Our Certified Menterns

It was amazing! I learnt so many things like creating engagement on social media platforms. The 1:1 with mentors were super helpful. I learnt how to create Instagram ads, identify goals & do competitor analysis- so many things.

There was a lot of interactive sessions with Mentors. The Menternship I completed gave me a new perspective to how work has to be done. I truly enjoyed working with real figures & actual industry case studies.

My experience was great as I got a chance to explore subjects like Analytics which are difficult to look for. The Menternship allowed to get subject knowledge and see what goes behind the making and delivering of a product.

My experience was very useful as I learnt so much about Fleet Management & Digital Marketing connected to the real-world scenario. I learnt how to actually work with social media channels like IG & Facebook.

Analyse the market trends of the Used Car Market from multiple geographies using EDA and Data Visualization

Help a car reseller analyse the market trends of the used car market using exploratory data analysis and data visualization.

Explore our curated Resource Hub

Get Guidance in One-on-One Mentor Hours

Ask Questions in our Biweekly AMA

Resolve all doubts on Mentor Support Chatbox

Get Actionable Mentor Feedback on your work

Learn & Network at the exclusive Mentern Perks Club