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 graphs based on terms, academic years and the days of the week. Whenever we analyse data, for schools or businesses, the best graphs often show a specific trend over a time period. For example, a graph of... 
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... 
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,... 
Comments