In this project, I analyze sales records of data from a retail chain stores, Groupe Darko Retails.
Code | Project Name | Deployed File link | Tool |
---|---|---|---|
001 | Retail Sore Analysis | PowerBI Page | Power BI |
The following are details of the data used for the project.
Retailer: The name of the sub-retailer.
Retail ID: The idenstification number of the sub-retailer.
Invoice date: Date on which invoice was issued
Region: The region where sub-retailer is located.
State: The state where sub-retailer is located.
City: The city where sub-retailer is located.
Beverage brand: The brand name of beverages sold by sub-retailers.
Price per unit: The cost of a single beverage.
Units sold: The quantity of beverages sold by a sub-retailer on a particular date.
Total Sales: The product of units sold and price per unit by a retailer on a specified date.
Operating profit: The net income generated by each sub-retailer.
Operating margin: The ratio of operating income to net sales. This is expressed in percentages.
- The top five (5) cities with the highest units of beverages sold were;
- New York City - 706600
- Charleston - 661950
- Miami- 597850
- Atlanta - 579350
- Houston - 566000
- The top three (3) retailers with the highest sales were;
- Sodapop - $4,400,000.00
- FizzySip - $2,600,000.00
- BevCo - $ 1,300,000.00
- The top three (3) beverage brands with the highest sales were;
- Coca-Cola - $2,015,890.00(23.21%)
- Dasani Water - $1,725,837.50(19.87%)
- Diet Coke - $1,481,425.00(17.06%)
- The top three (3) months with the highest sales were;
Elvis Darko