Our client is a fortune 500 global biotechnology medicines company that discovers, develops, manufactures and markets pharmaceuticals for critical illnesses. They focus on human therapeutics and concentrate on innovating novel medicines based on advances in cellular and molecular biology
Our client wanted a solution to create visuals for PowerPoint in a BI Tool, however, in order to create a PowerPoint, an out of box solution was required. Prior to MResult’s intervention, the client used a Spotfire report and then manually generated slides every month from this report. They then applied filters in the report, selected specific details to get the desired visualizations, copy pasted visualizations to a PowerPoint slide deck and formatted them, renamed the slides, and adjusted headers. This deck is then manually circulated to team members via email and one of the team members places the deck on a SharePoint site. The process of manually creating and circulating the deck is cumbersome and time consuming. The time from data collection to when the data was being converted into dashboards for reporting was so long that by the time the data had been entered and shared with the decision team the information was no longer relevant. The BI tool in which the data was coming from did not have a robust export functionality. Most BI Tools do have export functionalities, but they do not allow customization for when it gets exported out to PowerPoint. The client could create the visuals in the BI Tool, however, in order to create a PowerPoint, an out-of-box solution was required.
It is our endeavor to reduce the steps that it takes from data to insights so that decisions can be made quicker. MResult used Python Scripting in combination with the BI Tool to achieve an out-of-box functionality for our client. MResult automated the process by building a solution inside the Spotfire dashboard using the Iron Python scripting capabilities. The Algorithm enables the user to manually toggle between the filters inside the dashboard to get control of the data the user desires to see. With the process now automated, the user simply opens the Spotfire report, selects the date for which they want to view data and clicks on the Export button. This triggers the script to start exporting images to a PowerPoint slide. The formatting, ordering, naming of slides, and header features are all automated. Moreover, MResult provided the additional operation automation for the content management by having the exported PPT directly placed to the department SharePoint site. The deck created is saved to a network drive and through that drive stored in the SharePoint document library where it can be retrieved for analysis without hassle.
This application improved the user experience by saving our client the time required in manually generating the deck. As soon as the data is entered the user can create a ppt by the click of a button and share. The earlier process required multiple steps including the time needed to create the PowerPoint. The new process does all this at the click of a button, thus a “Single Step” solution. Furthermore, the SharePoint linkage allows the team members to directly access the deck without any one person having to share the slide deck via emai
- Improved User Experience
- Automated Process
- Direct Access
- Time Saved