David Pott @DavidPott

SIMS and Power BI consultant for schools. I deliver training and develop analysis systems for schools. https://t.co/Jjj2xk7HbZ schoolanalytics.co.uk North West, England Joined January 2009

Tweets

3K
Followers

2K
Following

1K
Likes

2K

David Pott @DavidPott

3 years ago

As someone who was brought up with the old BBC Micro computers in the 1980s, these micro:bits look very exciting! #PrimarySchools, you have until 18 December 2023 to register for your free pack of micro:bits. Visit bbc.co.uk/teach/microbit

0 0 1 269 0

View Details

David Pott @DavidPott

3 years ago

Get a comprehensive summary of the behaviour in your school. By using School Analytics to analyze data, schools can gain valuable insights that can be used to improve pupil performance and make data-driven decisions. More at buff.ly/3zEtc69

1 0 1 381 0

View Details

David Pott @DavidPott

3 years ago

@StThomas_CE I had a great time and saw lot s of wonderful paintings being created!

0 0 1 24 0

View Details

David Pott @DavidPott

3 years ago

Know exactly which pupils are off school today, see where they live and why they are off school. School Analytics uses Power BI to provide deeper understanding of the drivers behind school attendance. More info at buff.ly/3zEtc69

1 0 2 427 0

View Details

David Pott @DavidPott

3 years ago

Understand exactly why your pupils are absent from school. This is a heatmap marks analysis using School Analytics. More details here buff.ly/3zEtc69

0 0 2 342 0

View Details

David Pott @DavidPott

3 years ago

EAL and PP and SEN? Understand which pupils have multiple vulnerabilities with School Analytics. More info: buff.ly/3zEtc69 #powerbi #schooldata #data #analysis #school

0 0 3 348 2

View Details

David Pott @DavidPott

3 years ago

We often calculate the percentage of our pupils who are EAL, PP or SEN - but we seldom understand which pupils perhaps have multiple vulnerabilities. With a Venn diagram it is easy to discover which pupils have multiple issues. More at buff.ly/3N2V88W #schooldata

0 0 1 242 0

View Details

David Pott @DavidPott

3 years ago

When we look at PP, EAL and SEN groups in schools, for attendance or for attainment, it is often useful to compare them with the 'Non' group - non EAL, non PP and non SEN. I've just added these groups to the 'Attendance by Groups' page in School Analytics. #dataviz #schooldata

0 0 1 419 0

View Details

David Pott @DavidPott

3 years ago

Which pupils have more than 10 unauthorised absences or lates this year? School Analytics uses Power BI to list the names of pupils and show you the long term trend. More details at buff.ly/3zLpHNt

0 0 1 235 0

View Details

David Pott @DavidPott

4 years ago

Using Power BI to create analyses for MATs is tricky - summarising data across several schools, some of them using different MIS systems takes a lot of different skills. But the end result can be worth it. See buff.ly/3zEtc69 for more.#PowerBI

0 1 4 0 0

View Details

David Pott @DavidPott

4 years ago

Here's another attendance analysis that uses Power BI - this one identifies persistent absentees over a flexible period of time. Created to help a school who wanted to identify the pupils whose attendance over the last month had dropped below 90%. More at buff.ly/3zLpHNt

0 0 0 0 0

View Details

David Pott @DavidPott

4 years ago

Here's an example of an absence marks timeline that I created for school that wanted to understand why their pupils were absent. The timeline shows how many absence marks were recorded any type of absence. More details at buff.ly/3zLpHNt

0 0 3 0 0

View Details

David Pott @DavidPott

4 years ago

Wow, thank you so much everyone, I just hit 500 subscribers on YouTube! #500subs

0 0 1 0 0

View Details

David Pott @DavidPott

4 years ago

Power BI groups allow you to group together categorical data (eg pupil behaviours) into category groups (eg severe, moderate, trivial). But the feature is well hidden and the user interface isn't the simplest to understand. #PowerBI youtu.be/LBp48cwyCBg

1 1 4 0 2

View Details

David Pott @DavidPott

4 years ago

Great post from @Bi4Schools that just shows how useful real world school examples are for explaining Power BI techniques.

PowerBI4Schools @Bi4Schools

4 years ago

🗼POST Filtering with multiple fact tables - a couple of techniques for getting eg the attainment of persitent absentees or attendance of students getting 4 in maths

1 0 4 0 0

0 0 1 0 0

View Details

David Pott @DavidPott

4 years ago

@LukeSdm I think the wide range of formulas is something schools sometimes miss when the leave SIMS

1 0 1 0 0

View Details

David Pott @DavidPott

4 years ago

Here's an example of a heatmap in Power BI. School absence codes from the registers are are along the top, weeks and months down the side. It looks like a lot of people were on holiday (H) just before Christmas. More at schoolanalytics.co.uk #school #data #powerbi

0 2 7 0 0

View Details

David Pott @DavidPott

4 years ago

'Our school doesn't use SIMS, can we use Power BI?' Yes! Power BI can be connected to Arbor, Bromcom and more. School Analytics is a Power BI template for your school. It works with SIMS and can also work with Arbor and Bromcom. buff.ly/3zEtc69 for more details.