Business Decision Analysis for Sales Data | Desklib

Running Head : DATA ANALYSIS, PROBLEM SOLVING, AND DIGITAL OPERATIONS
Business Decision Analysis
Name of the student
Name of the university
Author’s note

1DATA ANALYSIS, PROBLEM SOLVING, AND DIGITAL OPERATIONS
Table of Contents
Introduction......................................................................................................................................2
Analysis of Sales Data.....................................................................................................................2
Conclusion.......................................................................................................................................9

2DATA ANALYSIS, PROBLEM SOLVING, AND DIGITAL OPERATIONS
Introduction
Herein we present an analysis of sales of the retail organization. The organization deals in
office supplies, furniture and technology products. The key information that have been used for
the analysis pertain to the organization are the order date, shipping mode, order priority, sales
price, discount and profit on the products. Information regarding the activities of the organization
in different regions of Australia are also presented. The variables order priority, shipping mode,
product category and sub-category and customer segment are presented as categorical variables.
In order analyse the sales figures of the retail organization the numerical variables chosen are
order date, sales, profit and discount. Moreover, new variables are also created to help in the
analysis. Total discount is calculated as the product of sales and discount.
Total discount=sales∗discount
To gain insights into the functioning of the retail organization “Tableau” is used.
“Tableau” offers advantages over other BI tools such as we can clean and arrange the data. In
addition, new variables cam be created in Tableau. In the present analysis we have created Total
discount to analyse how it would affect the sales of the products.

3DATA ANALYSIS, PROBLEM SOLVING, AND DIGITAL OPERATIONS
Analysis of Sales Data
Relation of Sales and Profit
The above figure presents the relation between avg sales and profits of the products. The
image on the top presents the relation of sales and profits across product sub-categories. The
above graph effectively shows the average sales and profits on the basis of product category. In
addition to this, the graph also shows segregation on the basis of quarter. The image on the down
presents the relation of sales and profits across quarters for which trend lines are also shown.
From the above figure it can be inferred that for the entire period between 2013-16 “technology
products” had a higher average sale as well profits. Moreover, it is found that Tables and
bookcases, furniture products of the retail organization made losses. “Office Supplies” products
of the organization had the least average sales as well as average profits (Anderson et al. 2017).
The average profits is shown to be maximum for technological products such as copiers and fax,
office machines and telephones. The average profits and average sales on the basis of