DEV Community

Cover image for FIRST GLANCE ANALYSIS
Ben-Aj
Ben-Aj

Posted on

2

FIRST GLANCE ANALYSIS

Hi guys,

I have always wanted to write technical reports and share my knowledge in data analytics, this is my first time and if I can, you can too!

Today, I am going to be uncovering initial insights from a dataset at first glance. The data we are using contains 3 years of vehicle sales from 2003 - 2005.

WOOAHHH! Long time ago, right? πŸ˜‚

Well, that's the fun thing about data analytics, you get to go back in time. I LOVE IT and I am sure you can feel the thrill too.

LET'S GOOOO!πŸ€Έβ€β™€οΈπŸš€

Data link below
πŸ‘‡
Sale data link

Here comes the big questionπŸ’‘, without doing any deep analysis, what are the obvious patterns, trends, or anomalies in the data?

I know , I know, data can seem overwhelming πŸ˜‘, but don't worry, you've got this. Let's go!πŸ˜‹

Firstly, the headers are very important because they give us a description of the data we are looking at, with each variable having unique values that are relevant to understanding the full scope of the data. In this case, we can observe that some of the data headers are ambiguous which causes confusion on what the values are really describing. Example of such headers is MSRP.

Secondly, Eagle-eyed observers would have seen the inconsistency of date, postal code and PHONE format, this can be troublesome when trying to perform deep analysis. Also, there are missing values for columns like postal code, state.

Thirdly, we can perform simple calculations to find the year with the highest sales, trendy products or highest selling products, we can also find the most frequent/regular customer to award loyalty bonuses and the Country with the highest market potential or where most sales occur in order to streamline the company's target market. All these can be done using simple formulas.

Finally, the following trends were uncovered by performing light analysis on the dataset, we can see a sudden upward surge in sales in 2004 followed by decrease in 2005 (all-time low). Also, we can observe that Classic cars are bought more often than other cars.

If we perform deeper analysis, start questioning our findings and finding out the WHYs, finding cause and trends that can help business decisions. It's so much like being a detective, a business Sherlock Holmes unlocking mysteries, and growing the revenue of this company, haha!

😁

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

πŸ‘‹ Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay