Power BI Report

1-Transformation

•Creating Implementation interval column instead of implementation_time column in data source to reduce data extraction.

•Adding new column ‘Implementation_Hours’ from Implementation interval to get total hours as decimal instead of dd.hh:mm:ss format.

•Adding new column ‘overall_hours’ from ‘overall_time’ to get total hours as decimal instead of dd.hh:mm:ss format.

2-Added tables

•Create implementation date dimension to avoid the duplication in date slicer

oHas one to many relationship with ‘destination_task’ table with ‘implementation_date_only’ column.

3-Measures

•No of tasks

oTo distinct count task id

•No of projects

oTo distinct count projects

•No of customers

oTo distinct count customers

Each of these measures was handled when its value is blank it appears as zero.