Walmart Sales Analysis
A brief analysis of the Walmart sales using R
A brief analysis of the Walmart sales using R
Customer ratings, revenue and profit analysis of Walmart for the last 10 years
Data Upload
Data Cleaning
Data Analysis
Data Presenting
I. Dependencies used in the project
Following libraries and packages have been used:
dplyr
tidyr
readr
lubridate
II. Data structure & summary of the dataset used for analysis purpose
You can see 10051 entries with 11 columns and data type of each columns
Observe the unit price column structure to understand the need of the cleaning
III. Data View
IV. Cleaning & Data Preparation : missing values and duplicates
V. Cleaned Data Upload
VI. Data Preparation for Time-bound Analysis
Time (Year Month Day) Breakdown
Shift Breakdown:
Morning
Afternoon
Evening
VII. Subsetting for preparing the last 10 years' data
VIII. Presentation
A. Branches General Scenario
Payment Method Per Branches
Top Rated Branches
B. Branches Earning Scenario : 10 Year Period
Top 10 Earners in Last 10 Years
Earning Per Shift
C. Branches Earning Scenario : 10 Year Period
i. Year Over Year:
Comparing Profit in relation to last year
ii. Month Over Month:
Comparing Revenue in relation to December last year