Reference no: EM132137269
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