Matt Callus

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…

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?d…

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-th… #plotthedots

🚨 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

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

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 👏🏻👏🏻👏🏻

🚨 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

@NHSrCommunity If the recordings from the 16th and 17th have been uploaded already, it appears that they are hidden, judging from the two unavailable in the playlist (youtube.com/watch?v=CEh-je…). Is it possible to have these unhidden or to get the links? Thanks

Yes! All recordings from workshops and talks from #NHSRConf2022 #NHSR2022Conf are on youtube.com/c/NHSRCommunity where previous recordings can also be found. #CatchUp #RStats

@LeslieHewitt09 Thanks! That sounds interesting. Would be great to hear how you get on. Maybe some learning to share?

@MatthewCallus This is spectacular work Matthew. I've started work on an automated SQL/SharePoint/Power BI solution using these templates.

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

When @MicrosoftTeams Speaker Coach report tells me to slow down a bit and speed up a bit. 😰

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-data-… #plotthedots

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

@ExcelHumor Fill every cell white to get rid of gridlines.

excel tips - wrong answers only

36 miles to go….. apparently this destination is frequented by NHS staff who report very good cake #plotthedots 🤔

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…

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/c60DtsmpTR #plotthedots

@Letxuga007 @ChrisBeeley Yeah, although technically I joined FROM a date table, to ensure all dates are included. Code in text file here: #issuecomment-1257642161" target="_blank" rel="nofollow noopener">github.com/nhs-r-communit…

Please contribute to this! How to calculate caseload size per day per team. github.com/nhs-r-communit… There is synthetic data in the repo, linked in the issue. Love to see lots of ideas on this please 🙏‍

@ChrisBeeley Sounds like an interesting exercise. If you can show some fake data of what you've got and what you want, I'd like to try.

I need to write a blog really, but has anybody else out there got stuck trying to work out the active patients for a specific team on a specific date? It seems like the simplest thing but it's ended up a three person job 🤔