Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# Vendor Analysis In Inventory Management Dashboards

by | 7:00 pm EST | December 09, 2020 | Power BI

In this tutorial, you’ll learn how to add elements for vendor analysis in your inventory management dashboards using DAX formulas.

Previous blogs have discussed how to set up the data model and the code used to get stock reorder analysis. The next details you need to focus on are the vendor tables.

You have a number of different vendors and you should know how much inventory you have for each of them. Thus, you have narrow down your vendors to the top 5.

This part brings in another concept or pattern that you can utilize in your formulas with DAX. You just need to understand how to utilize it in your models to get valuable insights quickly and effectively.

## Vendors By Stock Units

Create a new measure and name it Top 5 Vendors by Stock Units. Then, use the CALCULATE function and put the Inventory Stock Quantity.

In another line, add in the TOPN function and input 5 to return the top five. Use the ALL function and then order it again using the inventory stock quantity. This ALL statement releases the context on the vendors. So, you need to bring back the content by using the VALUES function.

If you bring it into the chart, it will only show you 5 values. It blanks out everyone that is not in the top five.

## Vendors By Stock Value

Next, copy the previous measure and alter it to get the Top 5 Vendors by Stock Value.

Bring it in the chart and you’ll have another insightful visualization.

## Conclusion

The vendor analysis technique discussed in this tutorial is simple but it can give you insights that add immense value to your inventory management reports.

With the steps you’ve implemented following previous tutorials, your dashboard has now all the insights and logic that you need. The next thing to do is to correctly fix and format all the elements in your report. The next tutorials will cover this lesson.

All the best,

Sam

## How to Calculate Age in Excel: 5 Best Methods Explained

Looking to calculate age in Excel? Well, you're in the right place. Whether you need to find the age of...

## Funny ChatGPT Prompts: 20 Hilarious ChatGPT Ideas

In a world where technology continues to amaze us, we have now arrived at the point where we can have a...

## Power BI Slicer Search: User Guide With Examples

Ready to get started with the Power BI slicer? This feature will allow you to filter and slice your...

## How to Move Files in SharePoint: Top 4 Methods Explained

Struggling to move Files in SharePoint? Don't worry, we've all been there. Knowing how to move files...

## How to Return List in Python: 3 Top Methods Explained

The return statement plays a pivotal role in Python. It’s what lets your functions communicate with the...

## How to Create P Value in Excel? A Step-by-Step Guide

Ready to create a P value in Excel? Want to learn how to quickly and efficiently do it? Read on. To...

## How to Strikethrough Text in Excel? Easy Guide + Examples

Want to strikethrough some text in your Excel document but don’t know how? Don’t worry, it's easy, read...

## How To Calculate Z-Scores in Excel? User Guide with Examples

Ready to calculate a z-score in Excel? Awesome. Because we are going to show how to do it quickly and...

## Top 20+ Data Visualization Interview Questions Explained

So, you’re applying for a data visualization or data analytics job? We get it, job interviews can be...

## Top 10 Free Datasets for Statistics Projects

Are you looking for a way to explore and analyze real-world data to enhance your understanding of...

## How to Calculate Standard Error in Excel? Top 3 Methods

The standard error is a key statistical tool that allows you to assess the accuracy and reliability of...

## How to Delete a SharePoint Site: 4 Best Methods Explained

Ready to delete your SharePoint site? It really is as easy as 1,2,3 and 4! To delete a SharePoint site:...