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...

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,
Co
un
t o
f y
e…
2015 2016 2017 2018 2019 2020 2021
57K 61K
104K
88K
76K
97K
67K
53K 52K
95K
79K
70K
88K
61K57K...