Data Visualization Project: Sales, Profit, and Shipping Analysis

This project presents a comprehensive data visualization analysis of sales, profit, and shipping data using various charts and dashboards. The analysis includes a profit map color-coded by average profit across countries, filtered by region. Sales by subcategory are displayed using treemaps, with profit added in the tooltip, and further filtered by region and order date. A map of regions illustrates sales distribution, and a treemap visualizes product profit and sales by segment. A sales by product category heatmap is also included. The project features a customer ranking dashboard based on profit ratio and an area chart indicating overall shipping performance. Shipping trends are analyzed by region, with color-coded charts showing shipped early, late, and on-time orders. Year-over-year sales comparisons are conducted for different regions, highlighting product performance changes. The project references several sources on data visualization and business intelligence.

USIP3
Name of Student:
Name of University:

The Profit map for the
company’s business
across several countries
is presented and is
colour coded with deep
blue representing the
highest Average profit
and dark red the lowest
average profit. Filters
are added for the north,
south and central
regions of individual
countries.

Sum of sales by
subcategory is
displayed with filters
for region and year
of order. The region
filter is colour coded
for the different
regions. It is seen
that Bookcases,
Copiers, Phones and
Storages lead the
sales chart.

Dashboard representing the sales by product subcategory and the profit
map. The filter in the map works by indicating for both the sheets the
required parameter of interest.

The Sale by Subcategory
is represented by a
treemap. The profit is
added in the tooltip.
Bookcases have the
highest sales and Labels
have the lowest sales.
The treemap is filtered by
region and Oder Date in
years.

A map of the regions
and the corresponding
sales. Deeper blue
indicates higher sales.
Central and a few
southern regions have
higher sales while
region show relatively
low sales.

A treemap for Product
Profit And Sales b
Segment indicating that
the distribution of Sales
across the different
segment of products i.e
Consumer, Corporate,
and Corporate. The
treemap is color coded to
visually identify the
performance in different
segments.

A sale by Product category heat map is color
coded with dark to lighter spectrum of grey.
Products under technology have the highest
sales and products under Furniture have the
lowest sales.

An overview
dashboard consisting
of the Profit map, the
Map of Sales by
region, and the sales
by region. The Profit
and Sales maps are
color coded and
deeper color
differentiates the
regional parameters
that we are interested
in.

Customer Dashboard
showing Customer Ranking
based on Profit Ratio. A
treemap of product profit
and sales and segment,
and a scatterplot of sales
and profits by name.

An area chart indicating
the overall shipping
performance. The figure
gives us an idea about
the proportion of
shipping done before,
on or after the
scheduled time. It can
be seen that overall the
proportion of products
shipped early has been
the highest.