Get 15% off on your first assignment order and best assignment writing service for HND AssignmentsOrder Now

Have Any Question?

UK +4474648-84564

Free Support


Get Help in BUS5VA Visual Analytics by HND Assignment Help


Are you worried about the submission of Assignment help in BUS5VA Visual Analytics? Now get this assignment done with plagiarism-free content, high-quality content and on-time delivery, So now you no need to worry about your assessment with HND Assignment Help. Our team of experts is well versed in the concepts and knowledge required for BUS5VA Visual Analytics assignment help and can deliver instant solutions.

Assignment 3: Data Visualisation using SAS Viya Due: 05th June 2022 Sunday @ 11:59 pm


All the tasks for this assignment are to be completed by using SAS Viya Visual Analytics. DATASET

The dataset used in this assessment is INSIGHT TOY COMPANY 2017, which can be found in the available datasets of SAS Viya.

Get Help in BUS5VA Visual Analytics by HND Assignment Help

Get Help in BUS5VA Visual Analytics by HND Assignment Help

TASK 1: Create data items. [4 marks]

  • Calculate the Gross Margin of products, which is (Product Sales Product Cost of Sales), and then create a new data item for the Average Gross Margin.
    • Create the Product Hierarchy including Brand, Line, Make, Style (in that sequence).
    • Create the Facility Geo-hierarchy including Continent, Country, Region, City (in that sequence).

For each hierarchical data item generated in the sub-tasks 1.2 and 1.3, create a drillable bar chart to show average gross margin at each level.

TASK 2: Create visualisations to summarise the gross margin in 2017. [6 marks]

  • Create a crosstab to summarise the Product Sales and Gross Margin based on Countries and


  • Create a visualisation to show which Country generates the highest and lowest Gross Margin.
    • Compare the Product Sales over time across all Continents in 2017.

TASK 3: Create ‘interactive’ visualisations to explore product sales and customer satisfaction. [10 marks]

  • Create a drillable geo-map to compare the Product Sales from facilities across Continents, Countries, Regions, and Cities.
    • Create and incorporate the Average Customer Satisfaction towards products from each facility into the above geo-map.
    • Create a visualisation (on the same page) for the Product Sales over time in 2017 which can be adapted / filtered as we drill down the above geo-map.

TASK 4: Build one report page to help the global production manager to identify the correlations between facility attributes and customer satisfaction. [10 marks]

  • Create a button bar to filter transactions by facilities from each Continent and create a bar chart

to compare the Average Customer Satisfaction towards products from each Country.

  • Create visualisations to show the correlations between Customer Satisfaction and Customer Distance; the distribution of Customer Distance; and the Average Customer Distance over time in 2017.
    • Interactively adapt / filter the three visualisations in the sub-task 4.2 by selecting each Country in the bar chart created in the sub-task 4.1.

TASK 5: [10 marks]

  • Design an ‘overview’ page for your SAS Report to provide a description for the visualisations presented for each of the tasks above (from Task 2 to Task 4). The description should include ‘what’ you are trying to show. (Assuming that this overview page is part of the visualisation report that you would be presenting to the stakeholders.)
    • Prepare a Word or PDF document containing the explanation of all your visualisations from Task 2 to Task 4 (300-400 words). The description should include ‘how’ and ‘why’ you have chosen to present the visualisation. You should support your justification based on various visualisation principles and guidelines for effective visualisation.


  • Each report page needs to be appropriately named based on the given tasks.
  • The first page of the report should be the overview with a brief description for each task.
  • Use the print option to generate the pdf file for the report (with all the pages included) and submit the pdf report via the submission link on LMS.
  • When printing the report, please make sure that the pdf report captures all the interactivities (and/or actions) created for the related pages, specifically for Task 3 and Task 4.
  • You should ensure that the appendix information is included in your pdf report.
  • Please follow the printing options as shown below:
Get Help in BUS5VA Visual Analytics by HND Assignment Help

Get Help in BUS5VA Visual Analytics by HND Assignment Help


  • Standard plagiarism and collusion policy, and extension and special consideration policy of this university apply to this assignment.
  • A cover sheet is NOT required. By submitting your work online, the declaration on the university’s assignment cover sheet is implied and agreed to by you.