Retail Analysis with Walmart Data using R


Walmart, would like to predict the sales and demand accurately. There are certain events and holidays which impact sales on each day. There are sales data available for 45 stores of Walmart. The business is facing a challenge due to unforeseen demands and runs out of stock some times, due to the inappropriate machine learning algorithm. An

ideal ML algorithm will predict demand accurately and ingest factors like economic conditions including CPI, Unemployment Index, etc.

Walmart runs several promotional markdown events throughout the year. These markdowns precede prominent holidays, the four largest of all, which are the Super Bowl, Labour Day, Thanksgiving, and Christmas. The weeks including these holidays are weighted five times higher in the evaluation than non-holiday weeks. Part of the challenge presented by this competition is modeling the effects of markdowns on these holiday weeks in the absence of complete/ideal historical data. Historical sales data for 45 Walmart stores located in different regions are available.

Dataset Description

This is the historical data which covers sales from 2010-02-05 to 2012-11-01, in the file Walmart_Store_sales. Within this file you will find the following fields:

Store - the store number

Date - the week of sales

Weekly_Sales - sales for the given store

Holiday_Flag - whether the week is a special holiday week 1 – Holiday week 0 – Non-holiday week

Temperature - Temperature on the day of sale

Fuel_Price - Cost of fuel in the region

CPI – Prevailing consumer price index

Unemployment - Prevailing unemployment rate

Holiday Events

Super Bowl: 12-Feb-10, 11-Feb-11, 10-Feb-12, 8-Feb-13

Labour Day: 10-Sep-10, 9-Sep-11, 7-Sep-12, 6-Sep-13

Thanksgiving: 26-Nov-10, 25-Nov-11, 23-Nov-12, 29-Nov-13

Christmas: 31-Dec-10, 30-Dec-11, 28-Dec-12, 27-Dec-13

Analysis Tasks

Basic Statistics tasks

Which store has maximum sales

Which store has maximum standard deviation i.e., the sales vary a lot. Also, find out the coefficient of mean to standard deviation

Which store/s has good quarterly growth rate in Q3’2012

Some holidays have a negative impact on sales. Find out holidays which have higher sales than the mean sales in non-holiday season for all stores together

Provide a monthly and semester view of sales in units and give insights

Statistical Model

For Store 1 – Build prediction models to forecast demand

Linear Regression – Utilize variables like date and restructure dates as 1 for 5 Feb 2010 (starting from the earliest date in order). Hypothesize if CPI, unemployment, and fuel price have any impact on sales.

Change dates into days by creating new variable.

Select the model which gives best accuracy.

Taidot: R-ohjelmointikieli, Data Analysis

Näytä lisää: analysis statistical data using spss, analysis questionnaire data using spss, data analysis commerce data using spss, analysis interpretation data using statistics, Analysis of Inventory Data using R, data analysis using R or python, data analysis using R, data analysis using r ppt, data analysis and graphics using r pdf, stock market data analysis using r, sales data analysis using r, finding patterns in data using r, data analysis using r pdf, statistical analysis and data reconfiguration job description, sentiment analysis of twitter data using r code, what is the correct way to clean data using r assume that the loaded data is in a table called test, sentiment analysis of twitter data using r, power bi retail analysis sample data, sentimental twitter analysis source code using r, scrap data using r

Tietoa työnantajasta:
( 3 arvostelua ) Duluth, United States

Projektin tunnus: #30545945

Myönnetty käyttäjälle:


Hello! I've carefully checked your requirements and really interested in this project Retail Analysis with Walmart Data using R. I'm a full-time data and statistical analyst. I have worked with many clients from the U. Lisää

$30 USD 1 päivässä
(50 Arvostelua)

5 freelanceria on tarjonnut keskimäärin $36 tähän työhön


Hello, I am a statistician with 2+ years of experience in statistical modeling, BI reporting, data mining and data visualization on structured and unstructured data to derive predictive business insight. Am a professi Lisää

$60 USD 2 päivässä
(9 arvostelua)

Hi there, I'm " Fatima W Computer science engineer, I am an expert in professionalization in essays and dissertations with skills including ✓ R program, ✓C program, ✓ Mathematics with report Writing. Feel free to conta Lisää

$20 USD 1 päivässä
(3 arvostelua)

Hi There, I’m a data analyst having six years of extensive experience with R language, Tableau, Power BI, Excel, Mysql and can deliver your task efficiently in minimal timeframe. Please drop me a text for further disc Lisää

$20 USD 1 päivässä
(3 arvostelua)

Hi, Dear Employer, I am an expert professionalization in essays and dissertations with✔R programming✔SPSS Statistics✔Finance✔Statistical Analysis✔Statistics✔Mathematics✔and Research Writing. Please send a message to co Lisää

$50 USD 2 päivässä
(1 arvostelu)