Daily Power BI Dashboard from Excel
Budget: ₹600 – ₹1,500 INR
Hi,
"I have attached the two data sets in the excel file. The first data set is the TaskMan data which is are the tasks that have been completed in 2022 by a user. This has the process name, who completed it, when it was completed, what the SLA is, was it completed on time, and how long it took for them to complete it. The second dataset is the process inventory which has additional details about each task such as its frequency, process group rollup, and how long it should take to complete. Please bring these datasets into PowerBI, join them together, and create a dashboard/visual based on the below.
Tab 1 – Timeliness SLA
Create a dashboard view based around timeliness SLA (if they completed a task on time). Some visualization options are:
Prior business Day’s SLA percentage.
Prior business Day’s items that missed SLA.
How SLAs compare month over month.
Anything else you think is important to know.
You can also add slicers such as date, process group, or whatever else you think is valuable.
Tab 2 – Task Duration
Create a dashboard view based around Task Duration. This can be the actual time it took to complete tasks (TaskMan), expected time to complete tasks (Process Inventory), or a combination of both. Some visualization options are:
Average actual processing time in hours.
Comparison between actual hours spent and estimated hours spend.
Comparison between number of tasks for a processor and hours. Maybe a number of tasks per hour metric.
Anything else you think is important to know.
You can also add slicers such as date, process group, processor, or whatever else you think is valuable
"I have attached the two data sets in the excel file. The first data set is the TaskMan data which is are the tasks that have been completed in 2022 by a user. This has the process name, who completed it, when it was completed, what the SLA is, was it completed on time, and how long it took for them to complete it. The second dataset is the process inventory which has additional details about each task such as its frequency, process group rollup, and how long it should take to complete. Please bring these datasets into PowerBI, join them together, and create a dashboard/visual based on the below.
Tab 1 – Timeliness SLA
Create a dashboard view based around timeliness SLA (if they completed a task on time). Some visualization options are:
Prior business Day’s SLA percentage.
Prior business Day’s items that missed SLA.
How SLAs compare month over month.
Anything else you think is important to know.
You can also add slicers such as date, process group, or whatever else you think is valuable.
Tab 2 – Task Duration
Create a dashboard view based around Task Duration. This can be the actual time it took to complete tasks (TaskMan), expected time to complete tasks (Process Inventory), or a combination of both. Some visualization options are:
Average actual processing time in hours.
Comparison between actual hours spent and estimated hours spend.
Comparison between number of tasks for a processor and hours. Maybe a number of tasks per hour metric.
Anything else you think is important to know.
You can also add slicers such as date, process group, processor, or whatever else you think is valuable