by David Pott | Sep 4, 2020 | Analysis, Bromcom, Power BI
Over the COVID lockdown Bromcom released a new service that will be of interest to local support units (LSUs) and MATs everywhere. Vision-X is a service that unifies the data held in pupil databases across your MAT. As such, it’s not the first product that claims to...
by David Pott | Aug 18, 2020 | Analysis, Power BI
I’m often asked where school staff should start when learning about Power BI, so here’s a post that lists all the online resources that have helped me to learn Power BI over the last couple of years. First, here’s all the online websites that...
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 | 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...
Comments