Dublin Business School Highest Financial Development Index and Financial Market Analysis PPT The information to the assignment can be found in the “Data An

Dublin Business School Highest Financial Development Index and Financial Market Analysis PPT The information to the assignment can be found in the “Data Analytics File” doc. This doc will explain in depth what you need to do for the assessment.

The countries that you will be assessing can be found in the “student country portfolios” doc. Ive marked the countries in RED, under my student number 10540605, which is student 10.

Your task is to analyse the datasets and tell a story with your dataset using Tableau and PowerPoint slides. What does your analysis for IMF? Overview of Assessment:
CA1:
Unit Title
Unit code
Level
Assessment title
Assessment Number
Assessment type
MIMLOs being assessed:
Task
Data Analytics & Machine learning
B9FT105
9
Telling story with data – using SQL server and Tableau
1
Individual
1
Upload data to SQL server and tell a story with your data using
Tableau
Feb 29, 2020
30%
March 31, 2020
Issue date
Assessment Weighting:
Submission Date:
(All assignments must
submitted through Moodle)
be
Feedback Date:
Assessment Task (30%)
Notes: You are a consultant at the international monetary fund (IMF). On your first day at
work, you were given two datasets representing the financial development index and
another dataset showing international financial statistics on various countries. The
Organisation is looking to gain an understanding of what’s happening in these countries.
IMF works to foster global financial stability, facilitate international trade, promote high
employment and sustainable economic growth around the world.
Your task is analyse the datasets and tell a story with your dataset using Tableau and
PowerPoint slides. What does your analysis for IMF?
Questions.
Prepare a presentation using any tool of your choice that we have studied in class including
(Tableau, SQL, PPT, etc.) to tell a story of the data in your portfolio.
1. Use the ‘Financial development index dataset’ to answer the following questions:
a. Import the data into SQL server and create a table called
‘Financial_Development_Index’
b.
c.
d.
e.
i. Count the unique number of countries in the entire dataset
ii. Write a SQL query to extract the ‘Financial development index’ and
‘Financial market index’ for the countries in your portfolio.
Globally, what are top 5 countries with the highest financial development and
financial markets indices?
Which country in your portfolio has the highest financial development index?
Which of the countries in your portfolio has experienced the highest growth in their
financial development index in the last 10 years?
Show on a map with colour gradient the financial indices of countries in your
portfolio in final year.
Tips:
–
Rename the column names with the header in the flat file.
Ensure that the file is closed before you attempt to import into the SQL server database.
Change the data type for ‘Value’ column as float.
If you mistakenly imported all your columns as characters, use the following query to
convert the ‘value’ as data type float
• ALTER TABLE [DAML].[dbo].[Financial_Development_Index] ALTER COLUMN
[Value] FLOAT
2. Use the ‘International Financial Statistics dataset’ to analyse the countries in your portfolio
in Tableau based on the following indicators:
i.
Assets, Direct Investment, US Dollars (This is the international investment positions
of the respective countries)
ii.
External Trade, Goods, Value of Exports, Free on Board (FOB), US Dollars (This is the
value of goods and services exported by the country
iii.
International Liquidity, Total Reserves excluding Gold, US Dollars (this is the amount
of international reserves, excluding gold)
iv.
Total Reserves, US Dollars (Gold at Market Price)
v.
Employment, Persons, Number of (the number of people employed)
vi.
Unemployment, Persons, Number of
vii.
Tourism, Number of Visitors, Persons, Number of (tourists)
viii.
Prices, Consumer Price Index, All items, Index (the consumer price index)
ix.
Disposable Income, Net, Nominal, Domestic Currency
Use these questions as a guide in answering the questions but they are NOT exhaustive:
1. How are the countries performing along these indicators in the last 10 years –
upward or downward trend?
2. Who are the best and worst performers relative to others in the portfolio?
3. By how much has the indicators increased or decreased relative to first?
4. How do the best/worst performers in your portfolio compare with the overall
dataset?
5. So what? As a consultant – what do these mean to the IMF and what are you
proposing?
Student 1 Student 2 Student 3 Student 4 Student 5 Student 6 Student 7 Student 8 Student 9 Student 10
10383202 10525843 10536834 10531876 10520583 10540446 10522443 10517490 10376046 10540605
Denmark Israel
Portugal Moldova Cameroon Senegal Sudan
Ethiopia South AfricaTunisia
France
Jordan
Pakistan Russian Federation
Benin
Georgia South Sudan
Gabon
Argentina Eritrea
Germany Kuwait
Yemen, Republic
Tajikistan
of Equatorial Guinea
Italy
Swaziland Tanzania Bolivia
Gambia, The
India
Lebanon Austria
China, P.R.:Lithuania
Mainland Luxembourg
North Macedonia,
Spain Republic
Brazil of Ghana
Indonesia Oman
Belgium Turkmenistan
Mongolia NetherlandsBosnia and Turkey
Herzegovina
Chile
Guinea-Bissau
BangladeshQatar
Botswana Ukraine Croatia
Norway Poland
Canada
Colombia Latvia
Bhutan
Saudi Arabia
French Territories:
Slovak Republic
French
Slovenia
Polynesia
Sweden Romania Japan
Costa Rica Malaysia
Brunei Darussalam
Syrian ArabArmenia,
Republic Republic
Cabo Verde
of Sierra Leone
SwitzerlandCzech Republic
Australia Dominican Maldives
Republic
Myanmar United ArabAzerbaijan,
Emirates Central
Republic
African
ofMorocco
Republic
United States
Malawi
New Zealand
Ecuador Nepal
China, P.R.:Egypt
Hong KongBelarus
Chad
Mozambique
United Kingdom
Mali
Finland
El SalvadorDominica
Timor-Leste,
Ireland
Dem. Rep.
Albania
of
Comoros Niger
UzbekistanMauritaniaGreece
Estonia
Grenada
Korea, Republic
Maltaof
Bulgaria Congo, Republic
Nigeria
of Namibia Mauritius Iceland
Rwanda Guyana
Student 11Student 12Student 13
10509579 10525351 10536779
Hungary Haiti
Vietnam
Mexico
Bahrain, Kingdom
Djiboutiof
Nicaragua Cyprus
Lesotho
Panama Togo
Liberia
Paraguay Uganda Libya
Peru
Burkina Faso
Madagascar
Uruguay Cote d’Ivoire
Guinea
Venezuela, Kenya
Republica Bolivariana
Samoa
de
Antigua andZambia
Barbuda Tonga
Bahamas, The
Papua NewPhilippines
Guinea
Iran, IslamicAlgeria
Republic of
Singapore
Jamaica Angola
Thailand
Overview of Assessment:
CA1:
Unit Title
Unit code
Level
Assessment title
Assessment Number
Assessment type
MIMLOs being assessed:
Task
Data Analytics & Machine learning
B9FT105
9
Telling story with data – using SQL server and Tableau
1
Individual
1
Upload data to SQL server and tell a story with your data using
Tableau
Feb 29, 2020
30%
March 31, 2020
Issue date
Assessment Weighting:
Submission Date:
(All assignments must
submitted through Moodle)
be
Feedback Date:
Assessment Task (30%)
Notes: You are a consultant at the international monetary fund (IMF). On your first day at
work, you were given two datasets representing the financial development index and
another dataset showing international financial statistics on various countries. The
Organisation is looking to gain an understanding of what’s happening in these countries.
IMF works to foster global financial stability, facilitate international trade, promote high
employment and sustainable economic growth around the world.
Your task is analyse the datasets and tell a story with your dataset using Tableau and
PowerPoint slides. What does your analysis for IMF?
Questions.
Prepare a presentation using any tool of your choice that we have studied in class including
(Tableau, SQL, PPT, etc.) to tell a story of the data in your portfolio.
1. Use the ‘Financial development index dataset’ to answer the following questions:
a. Import the data into SQL server and create a table called
‘Financial_Development_Index’
b.
c.
d.
e.
i. Count the unique number of countries in the entire dataset
ii. Write a SQL query to extract the ‘Financial development index’ and
‘Financial market index’ for the countries in your portfolio.
Globally, what are top 5 countries with the highest financial development and
financial markets indices?
Which country in your portfolio has the highest financial development index?
Which of the countries in your portfolio has experienced the highest growth in their
financial development index in the last 10 years?
Show on a map with colour gradient the financial indices of countries in your
portfolio in final year.
Tips:
–
Rename the column names with the header in the flat file.
Ensure that the file is closed before you attempt to import into the SQL server database.
Change the data type for ‘Value’ column as float.
If you mistakenly imported all your columns as characters, use the following query to
convert the ‘value’ as data type float
• ALTER TABLE [DAML].[dbo].[Financial_Development_Index] ALTER COLUMN
[Value] FLOAT
2. Use the ‘International Financial Statistics dataset’ to analyse the countries in your portfolio
in Tableau based on the following indicators:
i.
Assets, Direct Investment, US Dollars (This is the international investment positions
of the respective countries)
ii.
External Trade, Goods, Value of Exports, Free on Board (FOB), US Dollars (This is the
value of goods and services exported by the country
iii.
International Liquidity, Total Reserves excluding Gold, US Dollars (this is the amount
of international reserves, excluding gold)
iv.
Total Reserves, US Dollars (Gold at Market Price)
v.
Employment, Persons, Number of (the number of people employed)
vi.
Unemployment, Persons, Number of
vii.
Tourism, Number of Visitors, Persons, Number of (tourists)
viii.
Prices, Consumer Price Index, All items, Index (the consumer price index)
ix.
Disposable Income, Net, Nominal, Domestic Currency
Use these questions as a guide in answering the questions but they are NOT exhaustive:
1. How are the countries performing along these indicators in the last 10 years –
upward or downward trend?
2. Who are the best and worst performers relative to others in the portfolio?
3. By how much has the indicators increased or decreased relative to first?
4. How do the best/worst performers in your portfolio compare with the overall
dataset?
5. So what? As a consultant – what do these mean to the IMF and what are you
proposing?
Student 1 Student 2 Student 3 Student 4 Student 5 Student 6 Student 7 Student 8 Student 9 Student 10
10383202 10525843 10536834 10531876 10520583 10540446 10522443 10517490 10376046 10540605
Denmark Israel
Portugal Moldova Cameroon Senegal Sudan
Ethiopia South AfricaTunisia
France
Jordan
Pakistan Russian Federation
Benin
Georgia South Sudan
Gabon
Argentina Eritrea
Germany Kuwait
Yemen, Republic
Tajikistan
of Equatorial Guinea
Italy
Swaziland Tanzania Bolivia
Gambia, The
India
Lebanon Austria
China, P.R.:Lithuania
Mainland Luxembourg
North Macedonia,
Spain Republic
Brazil of Ghana
Indonesia Oman
Belgium Turkmenistan
Mongolia NetherlandsBosnia and Turkey
Herzegovina
Chile
Guinea-Bissau
BangladeshQatar
Botswana Ukraine Croatia
Norway Poland
Canada
Colombia Latvia
Bhutan
Saudi Arabia
French Territories:
Slovak Republic
French
Slovenia
Polynesia
Sweden Romania Japan
Costa Rica Malaysia
Brunei Darussalam
Syrian ArabArmenia,
Republic Republic
Cabo Verde
of Sierra Leone
SwitzerlandCzech Republic
Australia Dominican Maldives
Republic
Myanmar United ArabAzerbaijan,
Emirates Central
Republic
African
ofMorocco
Republic
United States
Malawi
New Zealand
Ecuador Nepal
China, P.R.:Egypt
Hong KongBelarus
Chad
Mozambique
United Kingdom
Mali
Finland
El SalvadorDominica
Timor-Leste,
Ireland
Dem. Rep.
Albania
of
Comoros Niger
UzbekistanMauritaniaGreece
Estonia
Grenada
Korea, Republic
Maltaof
Bulgaria Congo, Republic
Nigeria
of Namibia Mauritius Iceland
Rwanda Guyana
Student 11Student 12Student 13
10509579 10525351 10536779
Hungary Haiti
Vietnam
Mexico
Bahrain, Kingdom
Djiboutiof
Nicaragua Cyprus
Lesotho
Panama Togo
Liberia
Paraguay Uganda Libya
Peru
Burkina Faso
Madagascar
Uruguay Cote d’Ivoire
Guinea
Venezuela, Kenya
Republica Bolivariana
Samoa
de
Antigua andZambia
Barbuda Tonga
Bahamas, The
Papua NewPhilippines
Guinea
Iran, IslamicAlgeria
Republic of
Singapore
Jamaica Angola
Thailand

Purchase answer to see full
attachment