(Power BI, SQL, Python) Dynamic Inventory Dashboard

I had a fulfilling time working as a Demand Planner at a company specializing in Power Technology and Services. Per the standard process, the data was hybrid recorded and maintained using Excel workbooks (clouded on SharePoint) and SAP S4/HANA.

The problem was the lack of information centralization. Checking and tracking the performance was required to access multiple different data points. Also, this provides zero help in transparency between the Supply Chain team and other stakeholders.

Per the traditional way, I used a lot of INDEX MATCH in Excel, trying to gather all the relevant information across multiple data points. It did not go well. At one point, my workbook took 15 minutes just to open.

Interact with the dashboard and read the full blog: