Assignment 5

##bi

rahul Shah May 01 2021 · 1 min read
Share this

Here is my initial observation on the given dataset LTD Sales

The data looked complete with column headers and with no null and duplicate values, no blank rows in between the columns

PREREQUISITES

  •  Showcase the Revenue as per the State
  • Create a new column as per following condition as per the sales: Sales Range - Less 100 - 1001 to 5000 - 6000 to 10000 - 11000 to 15000 - 16000 to 20000 - 21000 to 25000 - Above 25000
  • Create a new column as per following condition as per the Product Category where for : Furniture it should show "Office Infra" - Others it should show "Non-Office Infra"
  • Creating a custom column - To generate Revenue as per State create a custom column.To create a custom column Go to Add column, click on custom column. A pop up window an will appear. In the new column name type Revenue and In custom column formula type Quantity column multiply with Unit price column i.e. Creating a custom column Revenue using two columns "Quantity" and "Unit Price" and Click OK.

  •   Create a new column as per following condition as per the sales: Sales Range - Less 100 - 1001 to 5000 - 6000 to 10000 - 11000 to 15000 - 16000 to 20000 - 21000 to 25000 - Above 25000 
  • To create new column as per the above condition First Create custom column for Add column tab and type formula as below and click OK

  • Create a new column as per the Product Category where for Furniture it should show "Office Infra" - Others it should show "Non-Office Infra"  
  • To create new column "Product type" go to "Add column"  tab click on Conditional Column apply conditional formatting on "Product Category" as below and Click OK.

    Insights from the Dataset

  • "New York" is leading with revenue while the least revenue is generated for state 
  • The revenue for Non-Office supplies is higher compare to Office Supplies.
  • Comments
    Read next