Diamond /Jwellery Stock Analysis Power BI Dashboards
Budget: ₹37,500 – ₹75,000 INR
I need a skilled Power BI developer to turn raw exports from our diamond/Jewelry inventory database and our in-house ERP into a set of detailed, comprehensive dashboards. All data will be supplied; your task is to model it cleanly in Power Query/DAX and design visuals that make day-to-day stock decisions effortless.
The finished report should let us drill from a high-level overview down to individual stones while updating automatically when new data is dropped into the source folders.
Key insights the dashboards must surface:
• Inventory levels broken down by shape, clarity, carat, location and ageing buckets
• Stock performance trends such as sell-through rates, turnover days and margin movement over configurable periods
• Supplier analytics covering fill rates, lead times, purchase price variance and contribution to total stock value
Please follow Power BI best practices (star schema, measures over calculated columns, reusable date table) and apply a clean, logically grouped layout so even non-technical users can find what they need in seconds. On completion I expect the .pbix file, a short video or walkthrough explaining key calculations and filters, and guidance on how to refresh the data on our end.
If you have experience with inventory-heavy businesses—or better yet, the gem trade—let me know; otherwise solid proof of complex ERP integrations will do. I’m ready to start as soon as you can confirm timeline and any clarifications you need.
The finished report should let us drill from a high-level overview down to individual stones while updating automatically when new data is dropped into the source folders.
Key insights the dashboards must surface:
• Inventory levels broken down by shape, clarity, carat, location and ageing buckets
• Stock performance trends such as sell-through rates, turnover days and margin movement over configurable periods
• Supplier analytics covering fill rates, lead times, purchase price variance and contribution to total stock value
Please follow Power BI best practices (star schema, measures over calculated columns, reusable date table) and apply a clean, logically grouped layout so even non-technical users can find what they need in seconds. On completion I expect the .pbix file, a short video or walkthrough explaining key calculations and filters, and guidance on how to refresh the data on our end.
If you have experience with inventory-heavy businesses—or better yet, the gem trade—let me know; otherwise solid proof of complex ERP integrations will do. I’m ready to start as soon as you can confirm timeline and any clarifications you need.