Earlier work · Data analysis · 2021

Gadgets Sales Analysis

Executive sales analysis for sales managers in Python and Pandas

  • Python
  • Pandas
  • Jupyter Notebook

This is an archived data analysis project from 2021. My current work is indata engineering.

Business Request & User Stories

The business request for this data analyst project was an executive sales report for sales managers. Based on the request that was made from the business we following user stories were defined to fulfill delivery and ensure that acceptance criteria’s were maintained throughout the project.

NoAs a (role) I want (request / demand)So that I (user value)Acceptance Criteria
1Sales ManagerWhat was the best month for sales? How much was earned that month?Can understand the key variables that influenced monthly salesA graph which shows the data overview of the Month Vs Sales
2Sales ManagerWhat city sold the most product?To focus on strong holds and make key invest decision on those areasA graph which shows the data overview of each city Sales
3Sales ManagerWhat time should we display advertisements to maximize likelihood of customer's buying product?Can cut the cost of advertisement and improve advertisement efficiencyA graph which shows the data overview of item count Vs hours of the day
4Sales ManagerWhat products are most often sold together?Can improve the arrangement of the store and promotion campaignA list showing multiple items with the highest purchase
5Sales ManagerWhat product sold the most? Why?Can know the sar product and the key indices that makes it a starA graph which shows the data overview of item count Vs Item Vs Commutative sales

Work with me

Need data you can actually trust?