# 04 Lab [en] - Data visalization
###### tags: `Data Visualization` `Sales and profit anaylsis` `Ad hoc analyis`.

[TOC]

# Introduction - objective of the exercise
During the exercise we will prepare a dashboard consisting of 4 visualisations:
* a composite map,
* scatter plot: analysis of sales and discounts vs profit,
* bar plot: sales and profit history.
* line plot: sales and profit trend analysis.

[](https://public.tableau.com/views/GlobalSuperstore_16481236677490/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link)
<center><small>Rys.0 Dashboard.</small></center></div>.

# 1. Basic information

## 1.1 Data source
The data source is the *"GlobalSuperstore "* file provided with the exercise. After connecting to the data source, check the simple join option for the two tables: orders and returns (returns - orders that have been returned to the seller).


## 1.2 Data hierarchies
Please organise data into appropriate hierarchies:

# 2 Preparation of visualisation
## 2.1 Customer map
* two layers on map: market, country
* market geographical role is created from **country**

* define parameter and calculated field, which can change the meauser which will be used for colors on visusalisations


## 2.2 Sales and Discount vs %Profit
* define the calculated field **Profit%**
* change default properties of Profit%: dafault color for red-black diverging and number format to suffix %.


## 2.3 Sales and Profit history
* use annotations for annotate marks on the visualisation
*

## 2.4 Sales and profit - trend analysis

# 3. Analytical issues

1. In which African countries were sales in Q3 2012 higher than the average for that region?
2. In which EU country were sales in Q4 2011 closest to the median for the region?
3. In which month of 2012-2014 total sales were highest in each market?
4. On which day of the week was the average profit highest in 2012 for EU, US and EMEA (respectively)?
5. Which week number was the worst in terms of sales value in 2011 for Poland, Germany and France?
6. What is the average annual sales value in Poland for 2012-2014?