Build an SPC Chart in Power BI

An SPC (Statistical Process Control) chart is a popular chart, especially in healthcare and in manufacturing processes, but is not an out-of-the-box standard visualisation in Power BI. In this video we build a SPC chart. We start with a line chart, add a couple of slicers, write a few measures, and use these to add reference lines. If you want to follow along and build your own chart, the raw data for the chart is available at https://raw.githubusercontent.com/Mar... You can also download the Power BI file that I built from https://github.com/MarkWilcock/Course... Timestamps 00:00 Introduction to SPC Charts 00:42 The sample data used in the chart 01:10 Import, clean and reshape the raw data in the Query Editor 02:40 Build the basic visuals: line chart and slicers on date and region 04:55 Write the first measure, for the central value and add the central line 06:12 Add a Calculations table for the measures 07:05 Write the measures for the upper and lower control limits 08:10 Add the upper and lower reference lines 09:40 Add a vertical (constant x-axis) reference line to indicate the date of an important event 10:35 Conclusion. Next steps More information on SPC charts An SPC chart is based on a line chart. It records observations of a particular value at regular intervals - typically hourly, daily or monthly. The chart has three reference lines; a central line, a lower control line and an upper control line The value of the central line is often the average of the values. The lower and upper control lines are typically set to the average value plus or minus 2 or 3 standard deviations. The purpose of an SPC chart is to monitor a process to determine if it continues to operate normally – usually defined as observations staying within the upper and lower control lines. If points occur outside these line, this may suggest that the process is not operating normally and should be investigated. We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk