Scribd
Upload
3 views3 pages

Program 10

The document outlines a series of data visualization tasks using GDP datasets, including creating symbol maps, bar graphs, pie charts, waterfall charts, and scatter plots to compare GDP across various countries and years. It provides step-by-step instructions for each visualization type. Additionally, it mentions the creation of an interactive dashboard to present the findings.

Uploaded by

Sannidhi Rajesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views3 pages

Program 10

The document outlines a series of data visualization tasks using GDP datasets, including creating symbol maps, bar graphs, pie charts, waterfall charts, and scatter plots to compare GDP across various countries and years. It provides step-by-step instructions for each visualization type. Additionally, it mentions the creation of an interactive dashboard to present the findings.

Uploaded by

Sannidhi Rajesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

10.

Analysis of GDP dataset:


i) Visualize the countries data given in the dataset with respect to latitude and longitude along with
country name using symbol maps.
ii) Create a bar graph to compare GDP of Belgium between 2006 – 2026.
iii) Using pie chart, visualize the GDP of India, Nepal, Romania, South Asia, Singapore by the year
2010.
iv) Visualize the countries Bhutan & Costa Rica competing in terms of GDP.
v) Create a scatter plot or circle views of GDP of Mexico, Algeria, Fiji, Estonia from 2004 to 2006.
vi) Build an interactive dashboard.

i. Visualize the countries data given in the dataset with respect to latitude and longitutde
along with the country name using symbol maps.
Steps to be followed:
Select Filled map
[Link] the Country to the “Location”.
[Link] the sum of 2001 and sum of 2002 to the “Tooltip”.

ii. Create a bar graph to compare GDP of Belgium between 2006-2010.


Steps to be followed:
Select Clustered Bar Chart
[Link] the Country to the “Y-axis”.
[Link] the sum of 2006-2010 to “X-axis”.
iii. Using pie chart, visualize the GDP of India, Nepal, Romania, South Asia, Singapore by the
year 2010.
Steps to be followed:
Select Pie chart
[Link] the Country to the “Legend”.
[Link] the Sum of 2020 to the “Values”.
Select Filter>>Country>>Select>> India, Nepal, Romania, South Asia, Singapore.

iv. Visualize the countries Bhutan and Costa Rica competing in terms of GDP.
Steps to be followed:
Select Waterfall chart
[Link] the Country to the “Category”.
[Link] the Sum of 2009 to the “Y-axis”.
Select Filter>>Country>>Select Bhutan and Costa Rica

v. Create a scatter plot or circle views of GDP of Mexico, Algeria, Fiji, Estonia from 2004-2006.
Steps to be followed:
Select Scatter plot
1. Select Modelling>>New measure
New Measure=Sum(‘GDP Data’[2004])+Sum(‘GDP Data’[2005])+ Sum(‘GDP Data’[2006])
[Link] the Country to the “X-axis”.
[Link] the New Measure to the “Y-axis”.
[Link] the Sum of 2004,2005,2006 to the “Tooltip”.
Final Sales Dashboard

You might also like