Retail Data Analysis

This is an document related to the analysis of a retail store transactions between 1/2011-12/2014.

1

Import data using the following url:

#Import the data from a web-hosted source
retail <- read.csv("https://myxavier-my.sharepoint.com/:x:/g/personal/gruent_xavier_edu/Ef6VnP3dwFBMk06u4Z437pABs8uRVGmJRbO0ZOQjZPBJjg?download=1")

Question 1

Create a customer dataset related to sales.

#Arrange data by total sales to determine best customer
Customers <- retail %>%
  select(Customer.ID,Customer.Name,City,State,Country,Postal.Code,Market,Sales) %>% 
  group_by(Customer.Name)%>%
  summarise(Sales = sum(Sales, na.rm = TRUE))%>%
  arrange(desc(Sales))

Question 1a

Create a graph based off customer sales.

Question 2

Determine the highest sales by market.

Question 3

Determine the highest sales by region

Question 4

Determine which category has the highest sales.

### Question 5

Determine the sub category volume related to market.

Sub-category by Region