Skip to main content

    Power BI

    Needs Votes

    Ability to generate Statistical Process control charts (SPC) in Power BI

    Vote (154) Share
    's profile image

    on 31 Oct 2015 01:41:08

    A great deal of my work with clients is SPC, statistical process control. In Excel with or without Powerpivot (depending on the data size) I create a column with the process data which is usually data over fixed time period (Patients per week, Appointments per day etc) then overlay control limits (upper and lower UCL+LCL, based on 3*stdevP) along with Average and Erlang's (0.8*(UCL-LCL)+LCL with all 5 lines displayed on the graph and the extracted numbers in a box at the side. (LCL,UCL+Average+Erlangs). It would be awesome to have it as a type of chart instead of calculating it all out manually each time (even with Macros it's a pain)

    Comments (9)
    's profile image Profile Picture

    0c5160a4 f9f4-4870-80b6-8d901ac68bb8 on 05 Jul 2020 23:32:21

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    100% agree as I'm trying to generate the same view for my consumers of the data.

    's profile image Profile Picture

    eee6649d 7f27-41c8-969d-30c9d8dee026 on 05 Jul 2020 23:22:47

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    I have a number of customers asking for this. It would be hugely valuable

    's profile image Profile Picture

    08fc0117 944f-4ffb-9098-18d929dc8fce on 05 Jul 2020 23:22:36

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    Totally Agree

    's profile image Profile Picture

    6be73004 00bd-44ae-bb0c-ea2c33e1b057 on 05 Jul 2020 23:10:01

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    I would agree completely. Currently we use a separate product for SPC charts and analysis, but would like to be able to utilize proper SPC charts from PowerBI and SSRS's RDLs.

    's profile image Profile Picture

    932b0f30 e935-4106-bb46-8041de2731b7 on 05 Jul 2020 22:36:55

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    QlikSense have a community contributed visualisation add-in that does this. For PowerBI to compete it needs more sophisticated visualisation types, so an MSDN article on this and survival Kaplan-Meir plots would be fantastic.

    's profile image Profile Picture

    1edab20f 1f8b-4a8c-80f9-3cda11eb04ce on 05 Jul 2020 22:34:39

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    great idea.

    's profile image Profile Picture

    298e9307 f1d5-447a-a736-3c5b68a5b629 on 05 Jul 2020 22:29:59

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    I have been trying to figure out a way to do this within PowerBI. I think it would be a great piece of automation if it were natively incorporated. Especially if it provided the ability to choose between different methods (average, median, stdev) as part of the tool.

    's profile image Profile Picture

    400cce9b 2138-47a3-ab7e-f2d67004f797 on 05 Jul 2020 22:18:13

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    Fantastic proposal ... You have my support

    's profile image Profile Picture

    51e68b30 5b5b-42e9-9746-deb8f73eb3b4 on 05 Jul 2020 22:11:08

    RE: Ability to generate Statistical Process control charts (SPC) in Power BI

    I agree. The ability to track critical X´es in Power BI would a very useful addition