Skip to content
0

Analyzing Sales Data in Alteryx

📷 Dashboard screenshot

Data Cleanup

Data cleaning

A) Customer Orders

  • We can join both east and west dataframes.
    • but, first we need to adjust coulmn name of Customer Name on west Dataframe to be matched with East Dataframe
  • To keep the info of which region customer belown we add new column main_region in both data frames
  • Change Order Date to datetime formate
  • Rich your data by extracting more features from Order Date such - Year - Month - Month Name - Day - Day Name - Is weekend - Quarter of Year

B) Oeders Details

  • Change the format of payment method [COD, Credit Card, Debit card, EFT] from wide to long
  • Create sub category column from category column

Data Tideness Notes

  • Items with a cost value less than or equal to $0 are inappropriate and should be removed from inventory.
  • There are 50 items with a sale price lower than their cost per item, which may indicate they are part of a promotional campaign.
  • Some items show profits exceeding 100%. Although we lack references to evaluate these items, they will be retained

Summary Analysis

🧾 Executive summary

1-The retail store is distributed across multiple U.S. states, with the West region generating higher profits than the East.

2-California stands out as the most profitable state.

3-Sales profits for the retail stores are primarily driven by the Electronics category.

4-Although 4 out of 7 subcategories in Clothing are top sellers, the overall profit from clothing is in the second place among categories.

5- Monthly purchasing analysis reveals that January yields the highest profit, third place for November—notably influenced by Black Friday. Conversely, July shows the least profit.

6- Weekend sales contribute 28.41% to total retail profits.

7- Fridays are identified as the most profitable day across the year for retail sales.

8- Customers predominantly prefer the Credit Card payment method.

2 hidden cells

Top 10 Poriftable Orders

Hidden code
1 hidden cell

West region is the most profitable region and northeast is the least

Hidden code

Retails stores existing in three states of West Region and achieving most profit for the region

Hidden code

Clalifornia state leading the profit

‌
‌
‌