@DavidPott Profile picture

David Pott

@DavidPott

SIMS and Power BI consultant for schools. I deliver training and develop analysis systems for schools. https://t.co/Jjj2xk7HbZ

Joined January 2009
Similar User
Peter Atherton photo

@DataEducator

SIMS photo

@SIMS_ESS

Duncan Baldwin photo

@Duncan_Baldwin

Helen Conley photo

@HelenSisra

Claire Ashton photo

@ClaireAshton

Becky St. John photo

@Becky_StJohn

School Data Managed photo

@ChrisBeeden

Deerwood photo

@deerwood

Mark Data Dumbledore photo

@mark_johnson71

DataCurriculumExams photo

@DataCurricExams

Sam Jukes photo

@elJukes

DD 🕺FCCT🕺 photo

@HeadTeachDunn

Tony Parkin photo

@tonyparkin

Mike Bostock photo

@Mike_Bostock

Ed Cadwallader photo

@Cadwalladered

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


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

DavidPott's tweet image. 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

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

DavidPott's tweet image. 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

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

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

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

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

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

DavidPott's tweet image. 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

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

DavidPott's tweet image. 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

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


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

DavidPott's tweet image. 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

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


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

DavidPott's tweet image. 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

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


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


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

🗼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



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

DavidPott's tweet image. 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

'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.

DavidPott's tweet image. '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.

David Pott Reposted

📈Want to learn Power BI?📊 I'm running a course for complete beginners soon: -3 hours online training + course templates -Covers how to get data, build a model and create visualisations -only £99 Reply or DM me if you're interested

Bi4Schools's tweet image. 📈Want to learn Power BI?📊

I'm running a course for complete beginners soon:
-3 hours online training + course templates
-Covers how to get data, build a model and create visualisations
-only £99

Reply or DM me if you're interested

Listening to today's #Bromcom event. Lots of really good examples of Power BI being used with Bromcom's MAT vision product. I can confirm that MAT Vision is a great way to connect multiple schools using different MIS and develop incredible Power BI analyses.


Loading...

Something went wrong.


Something went wrong.