This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment...

Question

This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment 3.pdf". It refers to a case study in "A1_Task_Description (See Case Study only).pdf", and the targeted user is the "Teacher" in "Assessment 1 Stakeholder Interview Data.pdf". The "Merged_Assessments.csv" file is the data you'll need for the PowerBI dashboard. So basically create a PowerBI dashboard with an appropriate number of pages that can be used by a teacher to evaluate a student.

Note that for the "connect back to the prototype you proposed" part, the referred prototype displays a student's academic history including all the A-E, NAPLAN and PAT assessments (the assessments' code, name, results, year/term when assessed).

a3-tasks-pi4gq03g.zip

Pratibha · Accepted Answer

Power BI DesktopSum of school_id by ASGS-RA_2016
0.0M 0.5M 1.0M
Sum of school_id
A
SG
S-
R
A
_2
01
6
major cities of A…
inner Regional A…
outer Regional A…
very remote part…
remote areas of …
1.08M
0.88M
0.34M
0.20M
0.15M
Count of gender by ASGS-RA_2016 and gender
0K
50K
100K
ASGS-RA_2016
Co
un
t o
f g
en
de
r
major cities
of Australia
inner
Regional
Australia
very remote
parts of
Australia
remote
areas of
Australia
outer
Regional
Australia
1K 1K 0K 0K 0K
132K
72K
25K 23K 20K
6K 3K 1K 1K 0K
gender Female Male Other
Sum of student_id by assessment_code
0.0bn
0.5bn
1.0bn
assessment_code
Su
m
 o
f s
tu
de
nt
_i
d
A-E PAT NAPLAN
1.17bn
0.14bn 0.13bn
Sum of school_id by assessment_code
0.0M
0.5M
1.0M
1.5M
2.0M
assessment_code
Su
m
 o
f s
ch
oo
l_
id
A-E PAT NAPLAN
2.15M
0.25M 0.25M
Sum of school_id by assessment_name
0.0M 0.5M
Sum of school_id
as
se
ss
m
en
t_
na
m
e
Mathematics
English
Health and Physi…
Science
Reading
Grammar
Numeracy
Spelling
Writing
0.66M
0.54M
0.54M
0.54M
0.18M
0.05M
0.05M
0.05M
0.05M
Sum of student_id by assessment_name
0.0bn 0.2bn 0.4bn
Sum of student_id
as
se
ss
m
en
t_
na
m
e
Mathematics
English
Health and Physi…
Science
Reading
Grammar
Numeracy
Spelling
Writing
0.36bn
0.29bn
0.29bn
0.29bn
0.10bn
0.03bn
0.03bn
0.03bn
0.03bn
0.00bn
Power BI DesktopCount of year, Count of year_level_id and Count of year_level_when_assessed by year
0K
50K
100K
year
Co
un
t o
f y
ea
r,

This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment 3.pdf". It refers to a case study in "A1_Task_Description (See Case Study only).pdf", and the targeted...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment