Excel & Power BI Warehouse Tracker

Offer description

Our warehouse needs a clean, reliable system that shows—at a glance—where every item has come from, how it has moved, and when it was used. I want complete traceability and a sense of orderliness, without having to sift through paperwork or scattered spreadsheets. Here’s the workflow I have in mind: • Excel will serve as the master data entry point. Each product entry or exit must be logged with item code, description, batch/lot, quantity, operator name, and time stamp. • Power Query or VBA (whichever you find more efficient) should handle the heavy lifting: append new transactions, prevent duplicate IDs, and instantly update current stock levels. • Power BI will pull directly from that Excel file—no manual exports—to produce interactive...

Skills and categories

Similar offers