× Limited Time Offer ! FLAT 20-40% off - Grab Deal Before It’s Gone. Order Now
Connect With Us
Order Now

DATA4100 Data Visualisation Software Report 4 Sample

Your Task

This written report with a dashboard is to be created individually.

- Given a business problem and data, finalise visualisations and prepare a report for the Australian Department of Foreign Affairs and Trade.

- On Tuesday of week 13 at or before 23:55 AEST submit your written report as a Microsoft Word file with a snapshot of your dashboard via Turnitin.

This assessment covers Learning outcomes: LO2, LO3

Business Background:

Germany, Japan, South Korea, United States, France and China are amongst the main exporters of cars. Suppose that the Australian government is particularly interested in the products exported from Germany, as well as Australian products exported to Germany, in considering the possibility of a free trade agreement.

Suppose that you have been asked, as an analyst for the Australian Department of Foreign Affairs and Trade, to report on exports from Germany, and in particular, the types of products Germany exports to Australia. Likewise, analyse the products that Australia exports to Germany currently, based on your own research into available data sets.

Your written report (to be prepared in this assessment - in Assessment 4) will ultimately end up in the hands of the minister for trade and investment, so any final decisions made should be supported by data

In Assessment 4, you are to finish designing your visualisations, then prepare a report by interpreting the visualisations and integrating with theory from this subject.

Data set

- Use the data given to you in week 11

Assessment Instructions

- As an individual, finish the visualisations for your report.

- Write a structured report with appropriate sections, as follows:

- Introduce the business problem and content of your report.

- Interpret your charts, summaries, clustering and any other analyses you have done in the process of creating your visualisations, and link it back to the business problem of whether Australia should enter a free trade agreement with Germany?

- Justify the design of your visualisations in terms of what you have learnt about cognitive load and pre-attentive attributes and Tufte’s principles.

Solution

Introduction of Business Problem

The business problem is to gather information and analyse the trade between Germany and Australia in order to consider the possibility of (FTA) free trade agreement. Specifically, the Australian government taking interest in the products exported from Germany to Australia and the products exported from Australia to Germany. The analyst is tasked with collecting data and reporting on the current trade relationship between the two countries. So that decision can be made by the government based on visualization and analysis.

The analyst is working for Australian Department of Foreign Affairs and Trade and is expected to provide a comprehensive report on the trade relationship between Germany and Australia. The report should include information on the types of products that Germany exports to Australia and the types of products that Australia exports to Germany. The report will help the government in making informed decisions regarding a potential free trade agreement between the two countries.

Visualizations and Summary

This is an important issue for the Australian government because a free trade agreement with Germany could potentially bring economic benefits to both countries. By eliminating tariffs and other trade barriers, both Germany and Australia could increase their exports and grow their economies. However, the government must first understand the current trade relationship and the types of products being exchanged in order to determine if a free trade agreement is feasible and would be in the best interest of both countries.


This is the line and clustered column chart that represents the trade value of the sections and products. The highest product is available in section 6 and the highest trade value is in section 16.

Based on the line and clustered column chart showing the sum of trade value between Australia and Germany along with the count of products, several key insights and interpretations can be drawn:

Trade Value: The line chart shows the sum of trade value between Australia and Germany over time. This allows us to see the overall trend in the trade relationship between the two countries. If the line is trending upwards, it indicates an increase in the total trade value between the two countries. If the line is trending downwards, it indicates a decrease in the total trade value.

Product Count: The clustered column chart shows the count of products being traded between Australia and Germany. This allows us to see the variety of products being traded between the two countries and understand the composition of the trade relationship. If the count of products is increasing over time, it indicates a diversifying trade relationship. If the count of products is decreasing, it may indicate a more focused or specialized trade relationship.

This is the scatter chart that is divided into three clusters by using the auto clustering of power BI. the trade value per HS2 ID is represented in this chart.

This is the waterfall chart that represents the trade value per product and section. The products are divided into sections and that is shown in this chart. The car's trade value is highest that is up to 70bn.

This is the bar chart that represents the sum of a trade by using the section cluster that is done in the scatter chart. This will make the data and chart easier to understand.

Draft Dashboard

This dashboard includes four different types of charts that are created in Power BI. The cognitive load and pre-attentive attributes are also used to create effective and understandable charts to understand the data easily. The auto-clustering method is also used in power BI, to sort and represent the data and insights (Korpela, 2016).

A visualization dashboard for the assignment help is an important tool for solving the business problem because it allows for a clear and concise representation of the trade data. Visualization dashboards provide a visual representation of the data, which can help the government quickly understand the key trends and patterns in the trade relationship between Germany and Australia. This can include visualizations such as bar charts, pie charts, and line graphs that clearly show the types and amounts of products being exported between the two countries.

Moreover, visualization dashboards can provide real-time updates to the data, allowing the government to track changes in the trade relationship over time. This can help the government identify any potential trade imbalances or changes in the trade relationship that may impact the feasibility of a free trade agreement.
Additionally, visualization dashboards can provide an interactive experience for the user, allowing them to explore the data in greater detail and uncover insights that may not be immediately apparent from a static report. This can help the government make more informed decisions based on a deeper understanding of the data.

Overall, a visualization dashboard is an important tool for solving the business problem of understanding the trade relationship between Germany and Australia because it provides a clear, concise, and interactive representation of the data that can help the government make informed decisions.

List of Dot Points

The visual information is provided in small chunks in the bar and scatter chart which is done by using the cognitive load. By putting much more information into each significant chunk of data and reducing the amount of them for a viewer to observe, one objective when developing visualization is to lessen the cognitive load.
The dot points for pre-attentive attributes

Color – Different colors are used in the charts to represent the different data which helps to understand the insights from the data.

Form – The type, shape, and size of the chart are selected to represent the meaningful information and the chart is clearly showing all the information (Nordlinder 2021).

An analysis and visualization report can help solve the business problem by providing a clear and concise representation of the trade relationship between Germany and Australia. The report can include visualizations such as bar charts, pie charts, and line graphs to clearly show the types and amounts of products being exported between the two countries. This information can help the government understand the current trade relationship and identify any potential trade imbalances.

Additionally, the report can use data analysis techniques such as trend analysis and regression analysis to identify any trends or patterns in the trade data over time. This information can help the government predict the potential impact of a free trade agreement and make informed decisions.

Finally, the report can highlight key insights and recommendations based on the data analysis. This information can be used by the government to make informed decisions regarding a potential free trade agreement with Germany. Overall, an analysis and visualization report can help the government make informed decisions by providing a comprehensive and clear understanding of the trade relationship between Germany and Australia.

Analysis of the trade relationship between Australia and Germany can provide valuable insights to inform decision making in several ways:

- Trade Opportunity: The analysis can reveal opportunities for expanding the trade relationship between Australia and Germany. For example, if there is a high demand for a particular type of product in Germany that is not being produced in Australia, this could provide an opportunity for Australian businesses to enter the German market.

- Market Trends: The analysis can also reveal trends in the trade relationship between Australia and Germany, such as changes in the demand for certain products or shifts in the composition of the trade relationship over time. This information can help businesses and government organizations make informed decisions about their trade strategies.

- Competitive Advantage: The analysis can reveal areas where Australia has a competitive advantage in the trade relationship with Germany. For example, if Australia is exporting a product that is in high demand in Germany, this could provide an opportunity for Australian businesses to increase their exports and gain a competitive advantage in the German market.

- Free Trade Agreement: The analysis can also provide valuable information to support the negotiation of a free trade agreement between Australia and Germany. For example, if the analysis reveals that there is significant potential for increased trade between the two countries, this could be used as a negotiating point to support the implementation of a free trade agreement.

Justification of Design

The visualizations is based on the principles of cognitive load and pre-attentive attributes and Tufte's principles of data visualization. These principles ensure that the visualizations are easily readable and provide the user with the most important information in an efficient manner.

In terms of cognitive load, the visualizations are designed to be simple and intuitive, with a minimal amount of clutter or distractions. This helps to reduce the cognitive load on the user, allowing them to quickly and easily understand the data. The use of colors and shapes that are easily distinguishable, as well as the use of clear and concise labels, help to make the data easily readable and reduce the cognitive load on the user.

In terms of pre-attentive attributes, the visualizations are designed to take advantage of the user's natural ability to quickly process visual information. This includes the use of colors to indicate different categories of data, as well as the use of shapes and patterns to quickly distinguish between different data points. These pre-attentive attributes help the user quickly understand the data, even before they have consciously processed it.

Finally, the visualizations are designed following Tufte's principles of data visualization, which emphasize the importance of maximizing the data-ink ratio. This means that the visualizations are designed to show only the most important information, without any unnecessary elements that may distract the user. This ensures that the visualizations are highly effective in conveying the data and providing insights into the trade relationship between Germany and Australia.

In addition, Tufte's principles also emphasize the importance of using clear and concise labelling, providing context to the data, and ensuring that the visualizations accurately represent the data. These principles help to ensure that the visualizations are not only aesthetically pleasing but also provide accurate and meaningful information to the user.

References

Fill the form to continue reading

Download Samples PDF

Assignment Services