In Progress

Excel to PowerBI Dashboard -- 2


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

Skills: Excel, Power BI

See more: advanced level english transcribed text, excel 2007 dashboard tamplate, vba macros advanced level, istqb certified tester advanced level training, excel finance dashboard, excel financial dashboard, excel milestone dashboard, excel 2007 dashboard, excel templates dashboard, excel milestones dashboard, advanced level, excel sheetwith macros automatically adjusts security level excel, advanced level excel, ashrae level 2 energy audit scope of work, powerbi dashboard excel

About the Employer:
( 1 review ) Edmonton, Canada

Project ID: #31605109

Awarded to:


"Sir, I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. About me I am Lead Generation Specialist with more than 4 years of exper More

$15 CAD in 7 days
(1 Review)