Ecommerc 1

Ecommerce – Summer Dresses Dataset
Tables
Review Table
 Product ID
 Title
 Ratings
 Rating Five count
 Rating Four Count
 Rating Three count
 Rating two count
 Rating one count
Product Table
Merchant Table
Order Table
 Title
 Merchant title
 Title Origin  Title (1574 records)  Merchant Name
 Product Id  Product ID  Merchant info Subtitle
 Product Colour  Price  Merchant Rating Count
 Product Size  Retail Price  Merchant Rating
 Product Inventory  Units Sold  Merchant Id (1574 records)
 Product URL  Merchant id  Merchant Profile Picture
 Product Picture  Shipping option Name (Yes/No)
 Theme  Merchant Profile picture
 Tags
 Uses ad boosts
Shipping Table Merchant Selling Table
 Shipping option Name  Merchant Id (958 records)

 Product Id  Listed Products
 Shipping option price  Total Units sold
 Shipping Type  Mean units sold per
 countries Shipped to product
 Inventory Total  Rating
 Has Urgency Banner  Merchant Ratings Count
 Urgency text  Mean Product Prices
 Original Country  Mean Retail prices
 Crawl month  Average discount
 Mean Product Ratings
count
Order Table
 Title: Product Name (1574)

 Product Id: A unique number is provided for product
 Price: Actual Price per unit
 Retail Price: Selling Price per unit
 Units Sold: NO of units sold
Product Table:
 Title: Product Name

 Title Origin:
 Product Colour: Indicates Colour of the product
 Product Size: Indicates the size of the product
 Product Inventory: No of Pieces.
 Product URL: Link to search for product
 Product Picture: Link for product picture
 Theme:
 Tags: Type of Dress
 Uses ad boosts: using ads to promote? (Yes =1/No = 0)
Merchant Table:
 Merchant Title: Merchant Name (Seller Name) (Total 958 sellers)

 Merchant Name:
 Merchant Info: Information about Merchant
 Merchant ID: Unique number provide for Seller
 Merchant Rating Count: Total No. of Ratings seller received
 Merchant Rating: Rating of the Merchant
 Merchant Profile Picture: Indicates merchant profile picture presents in website
 Merchant Profile Picture: Link for Merchant Profile Picture
Review Table:

 Title: Product Name
 Rating Count: Total Ratings received
 Rating Five Count: Total five-star ratings received
 Rating Four Count: Total four-star ratings received
 Rating three Count: Total three-star ratings received
 Rating two Count: Total two-star ratings received
 Rating One Count: Total One-star ratings received
Shipping Table:
 Shipping option Name: Name of the shipping

 Shipping Option Price:
 Shipping is Express: Indicates whether express shipping (Yes = 1/NO = 0)
 Countries shipped to: Indicates to how many No of countries product shipped
 Inventory Total: What is the quantity
 Urgency Banner: Indicates is there any urgency. (yes =1/No= 0)
 Urgency Text: What is the urgency
 Original Country: From which country product being shipped
 Crawl Month: which month
Merchant Selling Table:
 Merchant Id: Unique number provide for Seller

 Listed Products: No. of product types sold by seller
 Total Units sold: Total number of units sold by seller
 Mean units sold per product: Average of units sold per product
 Rating: Rating provided to Merchant
 Merchant Ratings Count: Ratings count of Merchant received
 Mean Product Prices: Average product Price
 Mean Retail prices: Average retail price
 Average discount: Average Discount given
 Mean Product Ratings count: Average of Product Ratings count
Alteryx Work – Cleansing
o Product Variation size – For some records there is prefix as “Size”, need to remove
o Uses ad boosts: For Some records (No = 0) is having something else. Need to change it as “0”
o Has Urgency Banner – only Yes = 1 is mentioned rest all records left as blank, Blank should be
replaced with “0”
o Country code is given, Change to full name.
o Merchant Name – In some records merchant name is like alpha numeric and special characters need
to cleanse.
o Create a Rating field in the Review Table based on Star (5, 4, 3, 2,1) Ratings in Review Table. (Either in
Alteryx or Tableau)
Tableau – Dashboard Insights
 Build the individual Dashboards for Products, Ratings, Merchants & Shipping on your understanding.
 Demographics Dashboard
 KPIS
o Total Products
o Total Units Sold
o Total Revenue Generated
o Total Profit Gained
o Total Merchants
o Total Ratings count of Merchants
 Insights
o Share of each country of units sold
o Share of each country for products
o Top 5 rated products from each country
o Top N Merchants based on Rating count (Show rating of the merchant as tool tip)
o Top N merchants based on units sold
o Top N merchants based on Profits received
o Top N products based on revenue generated
o Top N products based on rating count (Show Rating of the product as tool tip)
o Create the above TOP N questions in single sheet with the dynamic Dimensions & dynamic Measures
o Products based on units sold(bar) and Revenue/Amount (Line)
o There is urgency banner in data, how many products are achieved that urgency?
o Show the Comparison between the Product urgency and Express Shipping
o How many products received Star rating (5, 4, 3, 2 & 1)
o Show the performance (Sales, Profits etc) of products that used Ad boost.
o How the Sales & Profits are behaving in terms of Discounts on products and Merchants.
 Create a Story board based on product and merchant Analysis.

Ecommerc 1

Uploaded by

Copyright:

Available Formats

Ecommerc 1

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Ecommerc 1

Uploaded by

Copyright:

Available Formats

Ecommerce – Summer Dresses Dataset

Shipping Table Merchant Selling Table

 Shipping option Name  Merchant Id (958 records)

 Title: Product Name (1574)

 Title: Product Name

 Merchant Title: Merchant Name (Seller Name) (Total 958 sellers)

 Product Id: A unique number is provided for product

 Shipping option Name: Name of the shipping

Merchant Selling Table:

 Merchant Id: Unique number provide for Seller

Tableau – Dashboard Insights

 Create a Story board based on product and merchant Analysis.

You might also like