Assignment - Data visualisation and report design using SAS Visual Analytics

TASK

Create a SAS VA report dashboard for the data set VA_SAMPLE_K12_STUDENT using the Report Designer.

a. Create the following new data items:

i. A 'School Hierarchy' containing: School, Grade, Ethnicity and Gender.

ii. A 'Discipline Hierarchy' containing: Sanction and Grade.

iii. Convert the numeric measure 'year' into a new category variable called 'Year'.

iv. A new calculated item that calculates the number of absent days

(HINT: the variable membership_days is the total number school days the student has been enrolled for).

b. Create a tab in the report called 'Enrolment' containing visualisations that show:

i. The percentage of students enrolled in each school.

ii. Enrolment numbers for each school category, each year.

iii. A breakdown of enrolment numbers by Grade, Ethnicity and Gender.

c. Create a tab in the report called 'Discipline' containing visualisations that show:

i. A bubble chart of discipline days by student count, grouped by school and sized by frequency.

ii. The average absent days and average discipline days by lunch status.

iii. A drillable chart of discipline days by discipline hierarchy.

iv. Include an interaction between the bubble chart and the other two visualisations so that if a user selects a bubble (representing a particular school) then the other visualisations are filtered to that school only.

(HINT: use the 'interactions' tab on the right panel).

d. Create a tab in the report called 'Assessment' containing:

i. A drop down menu filter for school.

ii. A visualisation of math, reading and writing levels by ethnicity. Include a display rule in this visualisation to show that levels above 3 are considered positive and levels below 3 are considered negative.

iii. A drillable crosstab visualisation showing the math, reading and writing scores by school hierarchy. Include a display rule to highlight excellent scores (>250) and poor scores (< 180).

Attachment:- Assignment Files.rar