CASE STUDY
A global pharmaceutical company was facing issues with project governance, also their leadership team wanted updated and real-time reports regarding the performance of individual projects. They already had a data visualization system in place where all the project information was collected into a dataset connected to Power BI for report generation. However, the information was not real-time, and the project leaders were not able to get a complete picture of the project progress.
So, they required a subscription-based notification system utilizing Power BI dataset insights. This will help the line manager to receive alerts on any escalations in the tolerance values or open items before the report reaches the leadership team. The client also required flexibility in selecting notification channels, such as Outlook email/calendar invites or Teams. Additionally, they sought the capability to customize the frequency of notifications according to their preferences.
Our team at i2e addressed this problem by implementing a comprehensive solution using Power Apps, Power Automate, SharePoint, Power BI, Outlook and Teams.
The team designed a user-friendly subscription screen using Power Apps, enabling seamless customization of notification preferences. The integration of the Power BI dataset ensured real-time interaction with pertinent data, enhancing the overall user experience and data-driven decision-making.
Power Automate played a pivotal role in managing workflows and notifications. A dynamic approach was followed to design an automated workflows to respond to changes in the Power BI dataset or frequencies set by users. Furthermore, the system was configured to send notifications through selected channels, such as Outlook or Teams, aligning with individual user preferences.
Our experts leveraged SharePoint for secure storage of user details, preferences, and metadata, while seamlessly incorporating Power BI to extract relevant insights essential for generating notifications. In addition to this, we integrated outlook for emails and calendar information while teams in-platform notification and content for comprehensive communication solution.
We also integrated preferences into Power Automate for personalized and flexible management of notifications channels and enabled users to choose channels for notification.
Our team ensured a robust solution by optimizing Power Automate workflows and Power Apps for scalability, while consistently monitoring and fine-tuning for optimal performance. Implemented comprehensive security measures within SharePoint to safeguard sensitive user information, strictly adhering to data privacy and compliance standards.