Walmart Sales Analysis
Walmart Sales Analysis
A brief analysis of the Walmart sales using R
Embedded Files
Customer ratings, revenue and profit analysis of Walmart for the last 10 years
Milestone 1
Milestone 1
Data Upload
Milestone 2
Milestone 2
Data Cleaning
Milestone 3
Milestone 3
Data Analysis
Milestone 2
Milestone 2
Data Presenting
I. Dependencies used in the project
R Dependencies : Libraries & Packages
R Dependencies : Libraries & Packages
Following libraries and packages have been used:
dplyr
tidyr
readr
lubridate
II. Data structure & summary of the dataset used for analysis purpose
Dataset : Wallmart Sales
Dataset : Wallmart Sales
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
Page updated
Google Sites
Report abuse