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

Welcome to our comprehensive guide on conducting an ABC analysis using Power Query and Excel! In this tutorial, we'll walk you through the entire process, from data preparation to generating an insightful results table.
Download link for exercise data set: www.beer-manag...
This is a free supplementary video to our seminar Data Analysis for Warehouse Planning. Check out our seminar and workshop offers on www.beer-manag...
Follow us on LinkedIn: / dr-beer-management-log...

[@qasimali-gu3oz]

You can use List.Rang function in PQ to do Running sum. I will share a short video on this for you. Will share link here.

[@JakobBeer]

Thank you for feedback!
Yes, there are a number of different ways to do running totals in PQ. However, they are either extremely slow -- or surprisingly tedious. No question this is possible, but I recommend fitting the tool to the purpose: in this case, switching over to stock Excel (which we have to do anyway for the results table and more detailed analyses) will do the job.

[@qasimali-gu3oz]

Please do more videos like this.

[@AnilKumar-vi8oe]

Thank you for sharing, Keep bringing more videos

[@JakobBeer]

Thank you!

[@alexagafonov2748]

Thank you for such a detailed tutorial. Now I finally know how to do that (: Would be nice to have the similar tutorial of other analysis covered during the lectures.

[@JakobBeer]

Thank you very much! I'm glad to hear you find it useful.

[@neptoonpalace4027]

Why does your screen colors look like that?

[@JakobBeer]

I believe it was a performance issue. Used an old laptop computer for the video. Had no issues on my high performance workstation in other screencasts.

[@qasimali-gu3oz]

30:03 hahaha