Analyst at #MakingDataCount @NHSEngland, creating SPC chart tools in SQL, Power BI, and Excel #PlotTheDots
- Tweets168
- Following644
- Followers282
- Likes526
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.
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.
ALT 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 (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 (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 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 (20 SPC charts). Below that are 20 SPC charts in four rows and five columns.
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.
ALT The baby pigeon back in its small nest in a tree.
ALT The baby pigeon in a cardboard box, fully revealed, next to a small towel.
ALT A baby pigeon in a cardboard box, under a small towel.
ALT Screenshot of an SPC icon summary table from the Power BI template to show examples of the following key information: 1. The Latest Date column contains dates in two different formats (e.g. '28/06/21' and 'Jun 21') 2. The values in the Value, Target, -3σ, Mean, and 3σ columns contain up to three significant figures, except for numbers above 999 (e.g. 2807) and those in the time format (e.g. 15:03)
ALT Screenshot of nine SPC charts, all showing the chart title overlaid with an additional title of 'Line chart'.
ALT SPC T chart showing dates of runs over the last four years ending in an astronomical orange point for today's date, which is far above the upper process limit with an annotation of '446 days and counting'.
ALT Screenshot of website showing the construction of the together mode background. There is a white background image of three SPC charts with blue, orange, and grey dots. In front of the 48 dots are numbered placeholder avatars.
![A screenshot of the video guide on FutureNHS with links to 23 videos: Introduction [2:50] An overview of the SQL query [1:34] Customising SQL settings [5:49] Adding metric data [5:02] Adding each data point [5:36] Setting baselines [1:57] Adding targets [2:35] SPC Calculations [3:43] Warnings [1:23] SQL Output [1:42] Connecting the Power BI template to the SQL query [0:59] The pages of the Power BI template [6:15] Metric formats in the Power BI template [1:00] Summary icons in the Power BI template [1:20] Making small changes to the Power BI template [1:49] Changing the SPC Chart pages in the Power BI template [5:55] Creating dynamic multi-chart pages in the Power BI template [1:44] Adding more charts to the Power BI template [1:43] Adding additional columns to the Power BI template [1:36] The Excel tool [3:15] Connecting the Excel tool to the SQL query [4:12] Adding additional columns to the Excel tool [1:11] Worked example [24:33]](https://pbs.twimg.com/media/FTMD8OMXwAA_axo.png?name=orig)
ALT A screenshot of the video guide on FutureNHS with links to 23 videos: Introduction [2:50] An overview of the SQL query [1:34] Customising SQL settings [5:49] Adding metric data [5:02] Adding each data point [5:36] Setting baselines [1:57] Adding targets [2:35] SPC Calculations [3:43] Warnings [1:23] SQL Output [1:42] Connecting the Power BI template to the SQL query [0:59] The pages of the Power BI template [6:15] Metric formats in the Power BI template [1:00] Summary icons in the Power BI template [1:20] Making small changes to the Power BI template [1:49] Changing the SPC Chart pages in the Power BI template [5:55] Creating dynamic multi-chart pages in the Power BI template [1:44] Adding more charts to the Power BI template [1:43] Adding additional columns to the Power BI template [1:36] The Excel tool [3:15] Connecting the Excel tool to the SQL query [4:12] Adding additional columns to the Excel tool [1:11] Worked example [24:33]