Profile Picture

Parthiv Bhayani

Company Comparision Power BI Dashboard

Company Comparision Overview

+

This Power BI dashboard provides a comprehensive sales analysis for Company No. 1 and Company No. 2 over a dynamic time period. Key metrics include total value, total carats, packet count, and sales cycle time.

It features detailed insights into Round/Fancy Average Price (PPC) comparisons for two selected months, highlighting monthly price changes. Growth rates by value are segmented into monthly, quarterly, and selected time periods, providing clarity on performance trends.

The sold proportion section showcases the ratio of new arrivals to sales and stock to sales, offering valuable data to guide inventory and sales strategies. This dashboard is ideal for tracking performance and identifying opportunities for growth.

Month Wise Round & Fancy Report Overview

+

This Report provides a comprehensive month-wise report for Round and Fancy shapes in Company No. 1 and Company No. 2 for the year 2024. The stacked bar charts highlight the proportion of Round and Fancy shapes sold each month, offering a clear view of shape-wise performance trends. The comparison between the two companies allows stakeholders to assess market preferences and company-specific strategies. Interactive features enable users to filter and dive deeper into specific details, supporting data-driven decision-making to optimize shape-wise production and sales planning.

Monthly Trend for New Arrival & Sale Report Overview

+

    This Report presents a detailed analysis of monthly trends for New Arrivals and Sales across 2024 for Company No. 1 and Company No. 2. Key insights include the fluctuations in inventory arrivals and sales performance over the months, enabling users to understand seasonal patterns and demand-supply alignment. The dual charts allow for a comparative view between the two companies, while interactive elements provide flexibility to filter data by size, shape, and other parameters. This visualization aids in identifying trends and optimizing inventory management and sales strategies effectively.

Company Wise Monthly Sale Report Overview

+

This Report provides a Company-Wise Monthly Sales for the year 2024, comparing the sales performance of Company No. 1 and Company No. 2. The line chart visualizes monthly sales trends, highlighting fluctuations in revenue across the year. This comparative analysis helps stakeholders identify seasonal peaks and dips, evaluate performance disparities, and make data-driven decisions to enhance sales strategies. Users can further filter the data by specific dimensions, such as shape or size, to gain deeper insights into the sales dynamics of each company.

Download Resume

Skill Used

SQL

Data querying and Database management

Power BI

Data visualization and dashboards

Figma

Design Theme and elements