Link to interact with the Tableau Dashboard https://public.tableau.com/views/WalmartRetail_16777682220620/WalmartRevenueAnalysis?:language=en-GB&:display_count=n&:origin=viz_share_link
Aim: A revenue analysis allows businesses to keep track of where they're at, and make accurate assessments on where to spend their resources in order to maximize profits. Hence, the purpose of this project is to perform a revenue analysis of Walmart's sales data from 2013-2015. Application Used: Tableau About the datasets: The dataset used for this project is a Kaggle and has a total of 25 columns and 8,399 rows. The variables used in this project are;
- Profit
- Sales
- Customer Segments
- Order Date
- Product Category
- Sales Region
- States
- Shipping Mode
- Order Priority
- Customer Age
Methodology: The analysis and dashboard was completed in in Tableau.
Business Questions:
- What is the averahge sales and profit profit generared from 2013-2015?
- What is the total number of products sold?
- Is there a profit variation between the different product category, shipping mode and customer segment?
- What does th distribution of revenue look like with respect to customers' age?
- What can you say about the year-over year growth form 2013-2015.
- What region and states generate the most revenue?
Please click the link below to interact with dashboard. https://public.tableau.com/views/WalmartRetail_16777682220620/WalmartRevenueAnalysis?:language=en-GB&:display_count=n&:origin=viz_share_link