Reference no: EM133001194
DATA4100 Data Visualisation Software - Kaplan University
Creating a draft dashboard for a Business Problem
Your Task
This DRAFT Dashboard is to be created individually.
- Given a business problem and data, start to create visualisations and a dashboard in preparation for your final assessment.
Assessment Description
What do Germany export other than cars? Can we have a trade deal with them?
Business Background: Germany, Japan, the United States, Mexico, South Korea and Canada are the main exporters of cars, however they export many other products. Suppose that the Australian government are particularly interested in the products exported from Germany, as they are discussing trade deals. Imagine that you have been asked, as an analyst for the Australian Department of Foreign Affairs and Trade, to report on exports from Germany in particular. Furthermore, your written report will ultimately end up in the hands of the minister for trade and investment, so that the final decisions made are supported by data.
You will be given data listing other products exported from Germany and are to start designing a data dashboard for the report. Interpretation and integration of the theory will be left until assessment 4.
Data set
- Your teacher will send you the data file before class.
Assessment Instructions
- As an individual, open the data sets in the software of your choice. Most students will choose Power Bi, Tableau or Excel.
- Begin to explore visualisations which will enable you to report on the categories and particular of exports from Germany across the globe.
Create at least four visualisations.
- Start to apply clustering to the data set and any other analyses you think may be useful for your final report.
- As you create your charts, begin to consider what you have learnt about cognitive load and pre-attentive attributes. Write down at least four dot points.
- At the end of class, submit your draft via MyKBS, in the form of a software file.
Attachment:- Data Visualisation Software.rar
|
Prepare the necessary adjusting entry for interest expense
: Prepare the necessary adjusting entry for interest expense on December 31, year 1. Also, record the repayment of the loan plus interest on February 1
|
|
What is the 95 percent probability range of returns
: A stock has produced annual returns of 12 percent, 10 percent, -5 percent, and 4 percent over the past four years, respectively. What is the 95 percent probabil
|
|
Yen-share on the tokyo exchange
: Walter purchased 100 shares of ABC stock, a Japanese company, last year. At the time of his purchase, ABCs stock was on the Tokyo exchange at 4,600 yen/share, a
|
|
What are the objectives of a well-designed internal control
: What are the objectives of a well-designed internal control structure in an organization? What is internal control and it's importance in business organization.
|
|
Create visualisations and a dashboard in preparation
: Create visualisations and a dashboard in preparation - What do Germany export other than cars - categories and particular of exports from Germany across
|
|
Compute the beta of goldday
: Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall market portfolio under two economic states nature as follows.
|
|
What is the equivalent annual annuity
: It is assumed that it will require servicing costing $500 each year. What is the equivalent annual annuity of this deal, given a cost of capital of 12%?
|
|
How many units must be sold to achieve after-tax net? income
: Assume the information for Richard? Company, Selling price per unit? $100. How many units must be sold to achieve the after-tax net? income?
|
|
What yield will li ping achieve on her investment
: Li Ping Sledges has today invested in a 180-day bank bill with a face value of $10 million, priced to yield 3.25 per cent per annum. Simultaneously she has sold
|