Excel to PowerBI Dashboard -- 2
Budget: $10 – $20 CAD
Dashboard Requirements: ADVANCED LEVEL OF POWERBI DASHBOARDING
1. Would like to have Anticipated Labour Cost per MDF column to calculate a formula. (Formula will be provided upon project award)
2. Would like PowerBI to have a dropodown list just like column AI has and when it is selected the calculations will be the same as if it was done in Excel.
3. Would like PowerBI to have a dropdown list to be able to select a Lodge name for the day and see all the Blue column data from the excel file in a list or graph of some sort
4. Data will be pulled by Web (so excel online)
5. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost, Target, Anticipated Labour Cost per MDF, Target for a selected Month and year upon the selection of the Lodge Name
a. The KPI will show red or green if the variance is off between Anticipated Food Cost vs Target
6. Be able to print a report
1. Would like to have Anticipated Labour Cost per MDF column to calculate a formula. (Formula will be provided upon project award)
2. Would like PowerBI to have a dropodown list just like column AI has and when it is selected the calculations will be the same as if it was done in Excel.
3. Would like PowerBI to have a dropdown list to be able to select a Lodge name for the day and see all the Blue column data from the excel file in a list or graph of some sort
4. Data will be pulled by Web (so excel online)
5. Would like a KPI on to show LodgeName, Selected Day, Anticipated Food Cost, Target, Anticipated Labour Cost per MDF, Target for a selected Month and year upon the selection of the Lodge Name
a. The KPI will show red or green if the variance is off between Anticipated Food Cost vs Target
6. Be able to print a report