/PowerBI_projects

shows a Hex Map of State migration in 2019

1. State-Migration-2019

shows a Hex Map of State migration in 2019

Tool Used :

Power BI

Methodology :

Get Data from raw data in Github website. Generate a Hex map of UK

Result link :

https://sysphcd.github.io/statemigration2019.html

2. UK Areas population on benefit 2017

shows a Hex Map of UK areas population on benefit in 2017.

Tool Used :

Power BI

Methodology :

Get Data from raw data in Github website. Generate a Hex map of UK

Result link :

https://sysphcd.github.io/ukpopulationOnBenefit2017.html

3. Work with Python Script in PowerBI - Swarmplot

generate a Swarmplot with Seaborn dataset tips by using Python script in Power BI

Methodology :

User Python Script to get data in Power BI, then choose Python tool in visualisations. Write Python Script within the Python tool to create the Swarmplot

Tool Used :

Power BI , Python Script

Result link :

https://sysphcd.github.io/PythonScript_tips_swarmplot.html

4. Shape MAP - UK Election 2019

Method

activate shapeMap in Power BI https://mapshaper.org/ - update the shape projection to wgs84 https://colorbrewer2.org/#type=sequential&scheme=BuGn&n=3 - choose a color pattern

Dataset

HoC2019GE_results_by_constituency.xlsx Source: https://commonslibrary.parliament.uk/research-briefings/cbp-8749/ https://geoportal.statistics.gov.uk/datasets/ons::westminster-parliamentary-constituencies-december-2020-uk-buc/explore?location=55.215744%2C-3.315966%2C6.47

Result link :

https://sysphcd.github.io/ukelection2019.html

5. COVID19 cases

Method

created in Power BI

Dataset source

https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series

Result link :

https://sysphcd.github.io/covid19cases.html

6. Glasgow Income Deprived and Median Energy Consumption 2020

Dataset source

SIMD 2020 EPC

Method

process data in Python and created the report in Power BI

result link :

incomedeprived_medianenergy.html

7. Donut Chart Exercise

Dataset source

Method

created the report in Power BI

result link :

DonutChart Exercise