Forum Discussion
Is Power BI right for our needs?
Several ways to attack this but try adding this custom visual to easily search for a specific datapoint..
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309
Can also be added straight from the marketplace within PBI.
Hi Anonymous
Based on your description I would definitely say that Power BI can suit your needs.
Whether you want to visualize information on a per item basis or per category, you can easily do this with slicers (filters). The slicers can also be adjusted to handle thousands of SKU's, as you can enable search in the slicers themselves, so that the employees can search for the values.
What I would look into however is how easily you can connect to your data in PowerBI. Are you using Microsoft ERP's or do you have the data in a database, excel sheets etc. If the data connection part is not a hassle, I would definitely say that Power BI can solve your problem.
Let me know if this helps!
Thanks AWA! This helps a lot in terms of trying to understand if Power BI is suitable for us. We have decently Excel savvy people within the company, but I find the sheer number of parts and tables that need to be referenced within Excel makes it slow and not particular user firendly for employees who are not the best with Excel.
Is there a tutorial link you could point me to in regards to setting up slicers within a dashboard/report?
Hi Anonymous
Glad you found the explanation helpful!
There are plenty of online videos and tutorials explaining how slicers works. In reality, It's just a filter. So for instance, you can create a slicer with the SKU, where the user would need to enter a SKU, which would filter the entire dashboard to only show information about that particular SKU.
In terms of references between different datasets, you would love PowerBI over Excel! Once you've uploaded the different sheets to PowerBI, you can define relationships between the tables. When you work with these tables, PowerBI will automatically make sure to join data depending on the relationsships you've set up.