PowerBI Management Analytics - COVID Report
The scope of services includes:
Based on the Power BI and Microsoft SharePoint Online services, we have compiled statistics on Covid-19, coronavirus disease. Thanks to custom automation flows, Azure SQL Database feeds the PowerBI reporting tool with the data gathered from several sources. In this case, the Azure based solution merges the data from https://www.worldometers.info/coronavirus/, https://systems.jhu.edu/, Polish Ministry of Health (semi-automatically) and presented graphically in the service. Notification of new data published is sent by Microsoft Automation to the operator's phone. Data is saved in an Excel file located on Microsoft SharePoint Online. Process is improved by application built with Microsoft PowerApps running on smartphone. Updated data is available from anywhere – no laptop is required. The data could be also published on cloud-based Azure-environment.
As part of the customer service, we present Azure environment to store datacapabilities and its use in projects created for individual orders
What we delivered
Integrity Partners in association with partner are able to prepare and implement dedicated reports using Power BI and SharePoint with the possibility of data synchronization. Service can run in the cloud (e.g. Azure).
Results for customer
- We present any company statistics graphically
- Quick access to the report placed in the cloud
- Especially recommended to support the manager's work
- The ability to obtain data from several sources at once
- Option to reduce or increase the frequency of data updates (download and processing)
- Ability to constantly track data from any device
Application implemented in cooperation with Jan Gachowski (W3Projekt)