topic Re: Australian school terms and public holidays by state in Data Stories Gallery

Australian school terms and public holidays by state

rbbi — Thu, 03 Nov 2016 18:28:41 GMT

Australia has eight states and each one has its own schedule of school terms/holidays that roughly coincide in four terms. There's also variation in public holidays, some of which are observed nationaly, others occuring in one or more states. When you work with schools around the whole country, or even if you're going on vacation in (or even near!) another state and want to avoid the holiday crowds, it's nice to be able to see this information in a graphic rather than the text-based lists available from government web sites.

In this report I've used data generated in SQL Server from term and holiday dates. It's formatted specifically for the report, allowing a horizontal view by state. The colour scheme is from web sites advising on colours that are helpful for people living with colour-blindness issues. I've also added tooltips that describe each type of day and the names of public holidays, plus a half-day indicator for "pupil-free days" (i.e. staff-only days for development activities) that occur in some states at various times.

I'm happy with the result as something that's publicly accessible. It replaces a paper grid report that my company used to distribute internally that was tedious to produce and usually inaccurate.

eyJrIjoiM2YyYjllNGEtNDE5Ni00YjM0LWFjOWQtMTZlZjFkNTU3NGJhIiwidCI6IjA1ZjI2ZDdiLWJjYWYtNDc3My05NDM2LTJlOTI1YWVmMzhkNyJ9

Re: Australian school terms and public holidays by state

osoosh — Thu, 03 Nov 2016 02:10:42 GMT

rbbi Hi there, you might want to edit your post and save it again since it says content not available. I had previous issues before as per this post content not available !

Re: Australian school terms and public holidays by state

rbbi — Thu, 03 Nov 2016 03:10:08 GMT

thanks for checking this out osoosh but I can't see any edit functionality on the post. Jessica can you possibly help me with this one? thanks

Re: Australian school terms and public holidays by state

osoosh — Thu, 03 Nov 2016 03:15:42 GMT

hi rbbi go to the options menu and edit your message (see below the 3 dots on right hand side)

copy the power bi link and paste it back then save your message.

Re: Australian school terms and public holidays by state

Jessica — Thu, 03 Nov 2016 18:29:44 GMT

Thanks for pinging me, rbbi! Your report should be visible to everyone again. :)