Dashboard for the analysis and use of public content related to medical studies
Medical Trials Dashboards
Making publicly available and intelligible information about clinical studies collected by an international organization to the greatest possible number of users. For this reason, the desire to create an embedded dashboard on the client's site that could be freely accessible and as explanatory as possible of the content covered emerged.
Description of activities
Development of an ETL pipeline in Azure environment for data collection via REST API from the institution's website, processing and writing tables in a structured database. Creation of a dashboard in Power BI for the visualization and usability of information by end users. Use of serverless components for cost optimization. Weekly scheduling of the automatic data update job.
Tools and technologies used
Azure, Power BI, Bitbucket
