Florish Store is an imaginary Store created for Analysis only.
There is need to import the file from it raw state using our preferred analytical tool
- Analysis of Sales by Order
- Analysed the sales by gender
- Display the top 5 location with the highest sales
- The Channel with more revenue
- Sales by age
| Name | Class |
|---|---|
| 1. Mayowa | Data Anlysis |
Since the Data is clean enough for visualization to dived directly to deriving useful dependants
Since the variable in age is much i decided to group them to Young, Senior and Adult
Agegroup=IF(E2>=50,"Senior",IF(E2>=30,"Adult","Young"))
extracting the first three letters from the month
Month=TEXT(G2,"mmm")
According to what was stated earlier as the tasks we decided to crerte a pivot table
Order vs Sales
Sales by Gender
Count by Order Status
After all has been done we need to have all present our findings in a better way
