# Dashboard's - energy source in UE
###### tags: `Data visualization` `Tableau`

[TOC]

# Purpose of the exercise
The purpose of the exercise is to effectively use a data source describing energy generation/recovery in the EU. A tool is available at Eurostat [**Energy and Industry Geography Lab**](https://energy-industry-geolab.jrc.ec.europa.eu/).

# 0. Data source
I suggest the following modifications to the data source:
* define calculated fields "**type of energy**"
* creating gropus in the dimension "type of energy" - eg. **type (group)**<br/>

* przygotowanie hierarchii w danych<br/>

*

# 1. Map
The map should show the location of each power plant, where color indicates the type of power plant and size indicates the amount of energy produced.

# 2. Bar charts

Create following charts:
1. amount of energy produced in the country (MW),
2. The relative amount of the selected energy type in the country's energy mix (\%)
* To do this, define the calculation field using the function [LOD::Fixed](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_fixed.htm)<br>
* Next, define a calculated field that will determine the share of a given type of energy in the total (%)<br>

The final graph is in the figure below.

# 3. Energy mix - Sunburst chart
A graph illustrating the energy mix of a selected country. Chart type - [sunburst](https://itsmerohanraj.medium.com/sunburst-chart-in-tableau-for-hierarchical-data-2f9bc8626303).


# 4. Enerdy mix - bar chart
Another form of Chart 3.

# 5. Dashboard
Dashboard as shown in the figure. You need to define the appropriate highliters, filters and actions.