A question about Power BI

27 views
Skip to first unread message

a.br...@pnghs.school.nz

unread,
Apr 7, 2021, 12:55:16 AM4/7/21
to NZ Data Champions
Kia ora
Thanks Jake for organising yesterday it was a great day!
Can Power BI set up a template to track student's progress towards UE during the year? 

Ngā mihi
Anna

s...@mcneill.co.nz

unread,
Apr 7, 2021, 1:57:54 AM4/7/21
to NZ Data Champions
Kia ora Anna,

Definitely can be - PowerBI is ultimately the visualisation of your underlying data.

You can use measures to do the calculation (similar to formula in Excel) and then use the visualisations to make it easier to understand progress towards UE.

HAve a look at some of these blogs to show what was happening at st Andrew's when I was there - they've progressed this a long way since then:


Cheers,

Sam

Jake Wills

unread,
Apr 7, 2021, 2:03:50 AM4/7/21
to a.br...@pnghs.school.nz, NZ Data Champions
Hi Anna,

Glad you found the conference helpful. 
Definitely can be done, will require a few formulas to get there though, as UE is a “reasonably” complicated qualification.

If you want a hand or pointers to get going in the right direction do let me know. 

Jake. 

--
You received this message because you are subscribed to the Google Groups "NZ Data Champions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nz-data-champi...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/nz-data-champions/929f72e7-3f63-4a07-be99-c846194424acn%40googlegroups.com.
--
Sent from my phone, so please forgive any typos.

Mark Baldwin

unread,
Apr 7, 2021, 5:25:50 PM4/7/21
to Jake Wills, a.br...@pnghs.school.nz, NZ Data Champions
Hi Anna
I have done this for the last couple of years.  I hope to develop a more streamlined method this year when I have some time.  I built it in a very patchwork fashion.
I've attached a diagram showing the interrelationships between my tables and measures that I drew up last year when I started unpicking my process after I had built my model.
It's a bit messy but it might give you some idea of what is or can be involved.

Cheers
Mark

20210408_082205.jpg

a.br...@pnghs.school.nz

unread,
Apr 7, 2021, 6:20:10 PM4/7/21
to NZ Data Champions
Kia ora
Thank you all for taking the time to respond to my question! It is much appreciated, especially your diagram Mark!!!
We will be looking into Power BI for our school.
Ngā mihi
Anna

Reply all
Reply to author
Forward
0 new messages