Profile Picture

Parthiv Bhayani

Diamond Inventory Power BI Dashboard

Range Report Overview

+

This Report offers a detailed view of stock data with key metrics such as total value, carat weight, total pieces, and average discount percentage. It provides an interactive breakdown of stock by carat range, color, clarity, and fluorescence. The visualizations include pie charts to illustrate stock distribution across locations like Surat and South Africa and bar charts to represent stock by shape types such as RD and EM. This report enables users to analyze inventory trends and performance comprehensively.

Location Report Overview

+

This Report provides a detailed analysis of stock distribution across various manufacturing locations. The report highlights key metrics, such as total stock in Botswana (11.07M), Namibia (8.42M), South Africa (18.95M), and Surat (14.85M). It breaks down data by range categories, including 0.20–0.99, 1.00–3.99, and 4.00–99.99. Specific details include factory output, lab contributions, stock levels, upcoming items, and items without prices. Visual aids such as pie charts show the distribution of ranges, like 5.00–99.99 (33.27M) and 2.00–2.99 (19.32M), while bar charts illustrate shape-specific values, with RD at 37M and EM at 13M. This comprehensive dashboard enables location-specific inventory and trend analysis.

Download Resume

Skill Used

SQL

Data querying and Database management

Power BI

Data visualization and dashboards

Figma

Design Theme and elements