How do I know when I should incorporate PowerBI into my Excel projects? What can PowerBI accomplish?

I run inventory control mostly through excel, and I'm looking to start tracking a lot more long term data. Lead times, item quantities, time from warehouse to the customer, etc.

I'm looking to push my skills to be able to provide more value to the company, and data analytics of our inventory seems like a natural place for me to explore in my free time at work. For those more versed in PowerBI what would you imagine is useful for this? How should I go about setting this up or pitching this to my boss?