Automating the synchronization of data from the Lab Management System (LMS) API, processing the data, and visualizing it on Power BI can indeed save time and ensure the reliability of the data.
The project saved around 180 minutes per week for 3 members with various stages, including creating an Excel item test, gathering and extracting data from the LMS, cleaning and transforming data into an Excel file, modeling data and defining relationships for testing, creating visualizations in email and Excel, designing the report layout with interactivity, and reviewing and finalizing the report via email.