Mastering XYZ Analysis with Power Query and Excel: A Step-by-Step Tutorial

Ғылым және технология

Welcome to our detailed step-by-step tutorial on conducting an XYZ analysis using Power Query and Excel! In this tutorial, we'll walk you through the entire process, from importing a (large) data set to assigning XYZ categories.
Download link for exercise data set: drive.google.com/file/d/1uvXx...
This is a free supplementary video to our seminar Data Analysis for Warehouse Planning. Check out our seminar and workshop offers on www.beer-management.de/en/sem...
Follow us on LinkedIn: / dr-beer-management-log...

Пікірлер: 6

  • @shylomathew
    @shylomathew12 күн бұрын

    Great video. Thanks a lot. There are not many such videos on KZread for inventory management professionals. ❤

  • @JakobBeer

    @JakobBeer

    12 күн бұрын

    Thank you very much!

  • @martyc5674
    @martyc5674Күн бұрын

    Great video. A question- is XYZ normally categorized on CoV? - where I work they classify it purely on order volume. (Which I’m now questioning 😅)

  • @JakobBeer

    @JakobBeer

    Күн бұрын

    Thank you! Coefficient of Variation (CoV or CV) is independent of the unit of analysis you use. It is a measure of variability and dimensionless. In the video, I used orderlines, but you can use volume or quantities just as well.

  • @martyc5674

    @martyc5674

    Күн бұрын

    @@JakobBeer thanks Jacob. We actually use orderlines also- but literally the volume of them not the variability(eg the SKUS that contribute to 80% of all our orderlines are X, the next 15% are Y, and the last 5% are Z) - variability is not considered at all. I think we are doing it wrong- variability should of course be considered.

  • @JakobBeer

    @JakobBeer

    23 сағат бұрын

    Alright, I see. What you are describing is typically called ABC Analysis. ABC Analysis is a way of operationalizing the Pareto Principle whereas XYZ Analysis aims at understanding variability (and thus implicitly predictability) of demand. You can also combine the two (making it an ABC-XYZ Analysis) in order to get a better understanding of the combination of importance and variability.

Келесі