by David Pott | Aug 17, 2020 | Advanced, Power BI
Academic terms (certainly for UK schools) are difficult to pin down in statistical terms. Typically Easter falls in a different week each year, altering the relative lenths of the spring and summer terms and making direct comparisons between years difficult. The... 
by David Pott | Jan 15, 2020 | Advanced, Analysis, Power BI
In education data, we often need to compare one percentage with another. For example the attendance of our whole school with the attendance of a particular class or year group. Or the P8 of one group of pupils, compared to the P8 of the whole school. It took me a few... by David Pott | Jan 7, 2020 | Advanced, Analysis, Assessment, Power BI
In this article, I’ll show you how Power BI can create drillable graphs based on terms, academic years and the days of the week. Edit: There’s lots of really useful comments at the bottom of this article and I do recommend you read them. Whenever we... 
by David Pott | Jun 9, 2019 | Advanced, Analysis, Assessment, Demonstration, Intermediate, Performance 8, Power BI, Primary, Progress 8, Secondary
You can’t just throw a few Power BI visuals into a report and expect users to be able to analyse their data more effectively. In this post I try to highlight what I think makes an effective Power BI report. Firstly, I recommend anyone starting to work with data... 
by David Pott | May 29, 2019 | Advanced, Analysis, Assessment, Power BI, Primary, Secondary
Keeping data ‘fresh’ I’ve been thinking about what makes a good Power BI report by trying to understand how best to present the information to the audience. When I’m looking at a dashboard that shows the latest pupil data, or attendance data,... by David Pott | May 14, 2019 | Advanced, Analysis, Power BI
Update: Check out the comments for some more tips on using DAX measures. DAX is the language behind Power BI. If you want to get the most out of Power BI sooner or later you’ll need to write some DAX code. The best DAX reference is Microsoft’s DAX... 
Comments