PowerBI Report Generation from Excel
Budget: ₹600 – ₹1,500 INR
Your report/dashboard should answer the following questions posed by the sales director of the client:
1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard.
2. What is the revenue earned by the firm?
3. What is the total discounted value (base price - check out price) * number of orders?
4. What is the overall discount %?
5. What are the top 5 selling categories?
6. Does the operational area of the store influence number of orders?
7. Are emails & product features on the homepage an effective mode of promotion?
8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)?
You need to submit your PBIX file work as a zip.
1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard.
2. What is the revenue earned by the firm?
3. What is the total discounted value (base price - check out price) * number of orders?
4. What is the overall discount %?
5. What are the top 5 selling categories?
6. Does the operational area of the store influence number of orders?
7. Are emails & product features on the homepage an effective mode of promotion?
8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)?
You need to submit your PBIX file work as a zip.