Matt Callus (@MatthewCallus) header
Matt Callus (@MatthewCallus) profile picture

Matt Callus

@MatthewCallus

Analyst at #MakingDataCount @NHSEngland, creating SPC chart tools in SQL, Power BI, and Excel #PlotTheDots

future.nhs.uk/MDC/grouphome
Joined July 2021
  • Tweets168
  • Following645
  • Followers283
41Media
Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)Photo by Matt Callus (@MatthewCallus)
STOP PRESS : Very pleased to announce the launch of a new tool : @MatthewCallus has developed this amazing benchmarking tool. A brilliant addition to the Making Data Count toolkit 👏👏👏 #plotthedots Download the tool here 👇👇👇future.nhs.uk/MDC/view?objec…
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
4
8
4
45
6,840
Really pleased to see the incredible progress made by Norfolk & Suffolk NHS Trust @NSFTtweets @dgkl1 @MatthewCallus on their IPR redevelopment. Very impressive work #plotthedots 👏👏👏 nsft.nhs.uk/download.cfm?doc…
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
3
4
991
NEWS FLASH : Are you interested in finding out about some of the most impressive Making Data Count work we have ever seen? If so, register for this session when @HywelDdaHB @huwcwmdyllest will share their inspiring journey & impressive work eventbrite.co.uk/e/mastering… #plotthedots
Mastering the art of Making Data Count : learning from Wales

Mastering the art of Making Data Count : learning from Wales

Hear about the inspiring work by Hywel Dda University Health Board to establish Making Data Count as a guiding principle for decision making

eventbrite.co.uk
15
4
31
7,411
🚨 SPC TOOLS RELEASE 🚨 New versions of the SQL query (v2.5) and Power BI template (v2.1) for creating SPC charts: future.nhs.uk/MDC/view?objec… Multiple fixes made, including missing marker issue below. Check how-to guide for full details and how to make fixes yourself. #PlotTheDots
Matt Callus (@MatthewCallus) profile pictureMatt Callus@MatthewCallus21 Nov 2022
🚨 SPC tool issue 🚨 There is an issue with the published version of the Power BI template where most of the markers are not shown (i.e. no coloured dots). Not an issue in Power BI Desktop, though. We are investigating and will update when we know more. #PlotTheDots #AddTheDots
1
4
TODAY #INSIGHT2022!!! What do analysts need to advance and what do they need like a hole in the head? With @CharlesTTHF @SarahScobie2 & Steven Wyatt Programme: bit.ly/3SCdgZX This one: bit.ly/3fWL1rD @Strategy_Unit @apha_analysts @AnalystX_ @NuffieldTrust
2
4
What a brilliant analyst network meeting today? 150 participants 😁 we heard about brilliant work @UHMBT @aaroncumminsNHS to develop a metric library, processes and procedures to support ward to board reporting - data driven decisions which lead to insight led care 👏🏻👏🏻👏🏻
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
1
7
2
24
🚨 SPC tool issue 🚨 There is an issue with the published version of the Power BI template where most of the markers are not shown (i.e. no coloured dots). Not an issue in Power BI Desktop, though. We are investigating and will update when we know more. #PlotTheDots #AddTheDots
2
1
3
When @MicrosoftTeams Speaker Coach report tells me to slow down a bit and speed up a bit. 😰
Matt Callus retweeted
Samantha Riley (@samriley) profile picture
Samantha Riley@samriley3 Nov 2022
BIG NEWS FLASH : Very exciting news - we are now ready to launce step 8 : Data driven conversations which lead to insight led care. Join us on 7th December 13.00-14.00 for the first ever session. Link to register is here eventbrite.co.uk/e/making-da… #plotthedots
13
5
40
NEW! Stats-based metric alerting is available on Model Health System. This new alert highlights metrics that statistical process control (SPC) charts show as a drop in performance so you can take action. Take a look here: model.nhs.uk/ #SPC #PlotTheDots @samriley
Image from Model Health System (@ModelNHS)
6
4
14
STOP PRESS : Look at this fantastic 63 page guide for the SQL query and Power BI template. Yet more amazing work from @MatthewCallus 👏👏👏 #plotthedots future.nhs.uk/connect.ti/MDC…
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
7
2
27
The updated and most comprehensive guide yet for the SQL and Power BI SPC chart tools is out: future.nhs.uk/MDC/view?objec… Further updates to the tools and guide are also imminent. #PlotTheDots
1
5
A brilliant analyst network meeting yesterday. Nearly 150 attendees. An inspiring presentation from the BI team @EastEnglandAmb describing their journey to a best practice IPR. If you’d like to join the network you can sign up here forms.office.com/r/c60DtsmpT… #plotthedots
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
Image from Samantha Riley (@samriley)
1
3
2
12
STOP PRESS : An important #plotthedots public service announcement is contained within this short animated film 😀 Please share with interested colleagues!!
36
18
65
Cohort 3 #NHSfinance innovations are now live! Read 'Using SQL and Power BI to analyse data at scale to create SPC charts to aid decision making' by Matthew Callus, Analyst in the Making Data Count team at @NHSEnglandLDN here - bit.ly/3AdVKoX
Image from One NHS Finance (@OneNHSFinance)
Matt Callus (@MatthewCallus) profile pictureMatt Callus@MatthewCallus8 Aug 2022
Really proud to see the work done in SQL and Power BI to make SPC charts more accessible be recognised as a @OneNHSFinance innovation. #PlotTheDots onenhsfinance.nhs.uk/the-fin…
2
2
3
🚨 SPC TOOLS RELEASE 🚨 The latest versions of the Power BI template (v2.0) and SQL query (v2.4) for creating SPC charts is now on our Futures workspace: future.nhs.uk/MDC/view?objec… New how-to guide coming shortly. #PlotTheDots
7
14
3
54
What's included: • Improved Power BI layout, including 89 page layouts • Pareto chart • Filter columns for further breakdowns • Axis min/max control • Custom date formats • Summary info precision control • Further group order control • Updated moving range outlier logic
2
4
Really proud to see the work done in SQL and Power BI to make SPC charts more accessible be recognised as a @OneNHSFinance innovation. #PlotTheDots onenhsfinance.nhs.uk/the-fin…
1
1
10
SPC TOOLS PREVIEW The SQL query v2.4 and Power BI template v2.0 will be released next week, along with new video guides. Here are just a few more layouts to whet your appetite. 😋 #PlotTheDots
Matt Callus (@MatthewCallus) profile pictureMatt Callus@MatthewCallus2 Aug 2022
SPC TOOLS PREVIEW The Power BI template v2.0 is just around the corner. A large number of page templates will help you create a report quickly. A few examples below, combining SPC charts, summary info, summary tables/matrices, narrative sections, and Pareto charts. #PlotTheDots
The title at the top reads 'Page Template (3 summary tables + narrative). Below that are three summary tables on the left with text for narrative on the right for each of them.

ALT The title at the top reads 'Page Template (3 summary tables + narrative). Below that are three summary tables on the left with text for narrative on the right for each of them.

The title at the top reads 'Page Template (3 SPC charts with main chart and summary info + summary table + narrative). Below that is an SPC chart on the left with summary info relating to on its left. To the right of the SPC chart is a summary table with two smaller SPC charts underneath. At the bottom is a section for text and a table for additional narrative.

ALT The title at the top reads 'Page Template (3 SPC charts with main chart and summary info + summary table + narrative). Below that is an SPC chart on the left with summary info relating to on its left. To the right of the SPC chart is a summary table with two smaller SPC charts underneath. At the bottom is a section for text and a table for additional narrative.

The title at the top reads 'Page Template (20 SPC charts). Below that are 20 SPC charts in four rows and five columns.

ALT The title at the top reads 'Page Template (20 SPC charts). Below that are 20 SPC charts in four rows and five columns.

The title at the top reads 'Page Template (1 Pareto chart SPC charts). Below that is a Pareto chart, and below that are three SPC charts that relate to the first three columns in the Pareto chart.

ALT The title at the top reads 'Page Template (1 Pareto chart SPC charts). Below that is a Pareto chart, and below that are three SPC charts that relate to the first three columns in the Pareto chart.

1
1
SPC TOOLS PREVIEW The Power BI template v2.0 is just around the corner. A large number of page templates will help you create a report quickly. A few examples below, combining SPC charts, summary info, summary tables/matrices, narrative sections, and Pareto charts. #PlotTheDots
The title at the top reads 'Page Template (3 summary tables + narrative). Below that are three summary tables on the left with text for narrative on the right for each of them.

ALT The title at the top reads 'Page Template (3 summary tables + narrative). Below that are three summary tables on the left with text for narrative on the right for each of them.

The title at the top reads 'Page Template (3 SPC charts with main chart and summary info + summary table + narrative). Below that is an SPC chart on the left with summary info relating to on its left. To the right of the SPC chart is a summary table with two smaller SPC charts underneath. At the bottom is a section for text and a table for additional narrative.

ALT The title at the top reads 'Page Template (3 SPC charts with main chart and summary info + summary table + narrative). Below that is an SPC chart on the left with summary info relating to on its left. To the right of the SPC chart is a summary table with two smaller SPC charts underneath. At the bottom is a section for text and a table for additional narrative.

The title at the top reads 'Page Template (20 SPC charts). Below that are 20 SPC charts in four rows and five columns.

ALT The title at the top reads 'Page Template (20 SPC charts). Below that are 20 SPC charts in four rows and five columns.

The title at the top reads 'Page Template (1 Pareto chart SPC charts). Below that is a Pareto chart, and below that are three SPC charts that relate to the first three columns in the Pareto chart.

ALT The title at the top reads 'Page Template (1 Pareto chart SPC charts). Below that is a Pareto chart, and below that are three SPC charts that relate to the first three columns in the Pareto chart.

4
1
21
Load more