Data Insights & Analysis Dashboard(POWER BI) Diamond & gold jewellery
Budget: ₹1,500 – ₹12,500 INR
Your Excel file has multiple sheets with specific purposes. The Primary shhet is raw data , there's a Certified Diamond Details Sheet and Sales Analysis Report and process loss Sheet for specific information and sales insights.
I need to do a sales analysis report showing how much each salesman sold, create a global map based on customer countries (using mobile numbers), and calculate the net profit of customers (sales price - cost price).
Sales data will come from the sales analysis report, and cost prices can be found in the raw data.
Need a report where the physical location (Column H) is different from the brand name (Column AD) and also copare this with alias (Column C, as per the Alias sheet).lso see the alias true meaning and explanation in another sheet)
Differentiate between stock items and custom order items. Include filter buttons for each graph and data section, such as "STOCK DATA & CUSTOM ORDER" and "REPAIRING AND MANUFACTURING ACTIVITIES." also TIME ( time is calculate based on document date in raw data)
I need a report showing the number of data entries made by each data entry operator per day and the total amount of work they have done
I need a report that automatically searches for certified diamonds in the raw data ( check this certi or not based on certified diamond list ) If a certified diamond is found, it should create a separate sheet with its details. Additionally, when I click on a diamond, I should be able to see its corresponding jewelry tag number.
total profit ,sales analysis ,aging report
I need to do a sales analysis report showing how much each salesman sold, create a global map based on customer countries (using mobile numbers), and calculate the net profit of customers (sales price - cost price).
Sales data will come from the sales analysis report, and cost prices can be found in the raw data.
Need a report where the physical location (Column H) is different from the brand name (Column AD) and also copare this with alias (Column C, as per the Alias sheet).lso see the alias true meaning and explanation in another sheet)
Differentiate between stock items and custom order items. Include filter buttons for each graph and data section, such as "STOCK DATA & CUSTOM ORDER" and "REPAIRING AND MANUFACTURING ACTIVITIES." also TIME ( time is calculate based on document date in raw data)
I need a report showing the number of data entries made by each data entry operator per day and the total amount of work they have done
I need a report that automatically searches for certified diamonds in the raw data ( check this certi or not based on certified diamond list ) If a certified diamond is found, it should create a separate sheet with its details. Additionally, when I click on a diamond, I should be able to see its corresponding jewelry tag number.
total profit ,sales analysis ,aging report