PowerBI Data transform and model
Budget: £20 – £250 GBP
In Microsoft PowerBI:
Transform data from 3 date effective datasets (.xls). Datasets represent workflow tables from Dynamics Finance and Operations. Transform and data model should enable identification of workflows due to escalate in next 24hours (Identified by taking maximum of parts of the records to identify appropriate latest status) and comparing elapse to local escalation table formed by 1:1 relationship. Provide fully working PowerBI data model and transform that enables the requirements for completion.
Transform data from 3 date effective datasets (.xls). Datasets represent workflow tables from Dynamics Finance and Operations. Transform and data model should enable identification of workflows due to escalate in next 24hours (Identified by taking maximum of parts of the records to identify appropriate latest status) and comparing elapse to local escalation table formed by 1:1 relationship. Provide fully working PowerBI data model and transform that enables the requirements for completion.
Related categories:
Microsoft PowerBI