Marketing Insight Report
I am a data science enthusiast eager to learn and improve, with experience in data analysis, community leadership, and hands-on technical projects. My passion lies in uncovering actionable insights through data and leveraging technology to solve real-world problems. As a first-class computer science student and active participant in various competitions and challenges, I constantly seek opportunities to grow and contribute meaningfully
In the current era, efficiency is critical in decision-making to remain competitive within the business space. This is a report on the analysis of a dataset from 9,994 transactions conducted, which allows us to investigate the tendencies of sales, discounting, and product profitability.
Key Findings
1. Top-Selling Products
Binders and Papers generated the highest total revenue, making them key contributors to overall sales.
Appliances, on the other hand, did not do well in terms of revenue and have struggled in being a part of this product mix.
2. Profitability Insights
The company made an approximate total of $286,241 from its sales activities in the US.
Tables were the most productive product, with $-17,725 making the lowest and Copiers the highest with $55,618 in profit.
3. The Role Discounts Play on Sales & Profitability
Aggressive selling often did not translate to consistently higher sales.
The Sales vs. Discount graph shows no correlation, which means that spending higher discounts does not translate to sales.
The Profit vs. Discount analysis showed a strong negative analysis—spending higher discounts resulted in losses or the worst profit margins.
4. Regional Sale Performance
The West region had great sales, profit, and total revenue, this being the most competitive market.
The central region had the least sales and revenue, hence being the worst performer
Actionable Recommendations
Set convenient rates for products such as tables and bookcases, which have high sales volumes but low profit.
Do away with discounts for products that are currently underperforming.
Encourage the purchase of bundle items such as papers and binders without the use of abnormal discounts.
Ensure that sales volumes are accompanied by profits for all items sold, thus improving the business's overall performance.
Final Thoughts
Achieving a balance between price setting, price setting at a certain percentage level, and even using analytical tools should get an organization more business profit. Organizations should focus on overusing the discount selling approach, losing potential sales on the most sold-out product line.
Check out my full analysis on GitHub via: https://github.com/i-am-christy/HNG_task_0
Are you looking to hire professional data analysts for your business? Visit https://hng.tech/hire/data-analysts
