Telework dashboard related files
-
Prepare Employees Telework Details.xlsx for the week. Report date should be Monday of the week.
-
Open the Telework Dashboard Template with Power BI Desktop. Under "Transform Data" and "Edit paramenters".
- (Optional) Average one-way commute miles (default: 15.4 miles)
- (Optional) Average one-way driving time in minutes (default: 27.4 minutes)
- (Optional) Commute Outlier Limit (default: 100 miles)
- Telework Data File (where your Excel file is stored)
-
Refresh the report dataset(s).