Itech1103- Big Data Analytics Project 2022

ITECH1103- BIG DATA AND ANALYTICS
[Student name]
[Student ID]
[University name]
[Professor Name]
[Date]

Table of Contents
1 Executive Summary.......................................................................................................2
2 Background...................................................................................................................3
3 Reporting / Dashboards..................................................................................................5
4 Additional Visualizations...............................................................................................6
5 Justification...................................................................................................................9
6 Discussion of findings..................................................................................................11
7 Conclusion..................................................................................................................14
8 References..................................................................................................................15
9 Appendices.................................................................................................................16

1 Executive Summary
This is a project about the data visualization for the business sales orders that are placed by
various customers in various continents moreover this visualization is done in order to offer good
business decision making for the organization. However in this report various aspects are put
into consideration which includes the background information, preparation of the dashboards and
reports, additional visualizations, justifications , finding and the conclusions which will be
presented to the organization management to be used for various decision making.

2 Background
This is a report of the business sales where there are various customers who are involved from
different countries. The project utilizes the “CUSTOMERS_CLEAN” data set which consists of
various attributes that records the sales details accordingly the data set consists of the order id,
customer id, customer name, customer type, title, city, country, continent, order quantity,
revenue, and day [1].
This project will involve the analysis of the various sales order that are being placed by various
customers from different countries where the data set is used to show the various customers and
the way they place the orders for various products and thus the analysis will enable the
organization involved in making of the good business decisions.
The project and the used data set will have much importance to the organization which includes
the following:
i. Identification of the number of the customers transacting with the organization.
ii. To identify the top customers who places the orders according to their respective
countries [2].
iii. Identification of the top most countries that give them highest revenues.
iv. Identification of the top most customers from Australia that generates highest
revenues.
v. To identify the top days in which the most of the orders are placed by the customers.
vi. To identify the top most customers according to order placement.
vii. To identify the bottom most customers according to order placement.
viii. To identify the type of customers that is highly popular depending on the highest
orders placed.
ix. To identify the type of customers that is least popular depending on the lowest orders.
x. To identify the top most countries according to each type of customer.
xi. To identify the quantity of order placed by customer types and the respective
continent names.
xii. To identify the number of customers having same tittles.
xiii. To identify the minimum days required to deliver placed order in each city.
xiv. To identify the maximum days required to deliver placed order in each city.
xv. To help in identification of the best predictors of the quantities of the orders placed.