Analyzed the E-workflow process to track on-hand, completed, and urgent jobs from the company’s website database.
The 'E-workflow' project was one of my most complex projects during my internship. Its main objective was to analyze the E-workflow process to track on-hand, completed, and urgent jobs from the company’s database using SQL and DAX, and then visualize the data in Power BI.
This dashboard monitored the progress of the PDE project, including its value and responsible parties. The project consisted of various jobs and tasks, requiring me to assess the completeness of all tasks to determine whether the project was finished. Additionally, I had to evaluate the urgency of tasks based on emails sent and identify projects with repeated cost estimates.
This project was challenging due to the numerous conditions needed to query the database and calculate the on-hand, completed, and urgent jobs. The data source was directly from the company's website, which necessitated multiple join conditions and made it difficult to consolidate all the information.