by David Pott | Feb 12, 2020 | Analysis, Power BI
Sometimes we have columns in different tables that hold the same type of data. For example: A class (eg 11B/Ma1) might appear in a behaviour table (to indicate the class where a behaviour incident took place) and also in an assessment table (to indicate the class 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 | Dec 4, 2019 | Analysis, Assessment, Power BI
After a first page that should consist of the most important ‘headline’ measures for a school, the next page in any SIMS + Power BI report is probably attendance. Partly, this is because of it’s importance to schools and partly because it is one of... 
by David Pott | Jun 16, 2019 | Analysis, Assessment, Beginner, Intermediate
Why many schools have ‘official’ and ‘unofficial’ results… I find that schools often have two sets of statistics: the official set of statistics that includes the results of all the pupils who will be included in the year’s key... 
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... 
Comments