Business Challenges
- Disparate Data – R&D managed their own lists of entities in disparate files and thus employees were unable to quickly and easily search for data related to clinical trials in a comprehensive system
- Lack Data Access – No easy way to connect to source systems, display the data in an easy-to-view and navigate format, and export data to Excel or text files
Solution
- Structured Data into One Materialized View – Used data maintained in Informatica MDM and existing relationships to build the appropriate hierarchy for reporting; Informatica PowerCenter ETL was developed and modeled into mastered entity detail to enable capability and access to pre-existing reports
- Developed 12 Interactive Dashboards – Using Tableau, dashboards were created and connected with the mastered data; all search queries and selected filters dynamically reflect across all dashboards, narrowing the search
- Secure Storage – Workbooks are published and maintained on Tableau Server 10.1 where security is handled using AD groups and Tableau site roles; these groups distinguish between users who should and should not see personally identifiable information pertaining to investigators
Impact
- One-Stop Shop – Delivered a one-stop-shop for exploring MDM data and the relationships between the mastered entities; this includes a comprehensive search and filter functionality, navigation between entity dashboards and relationships, and reports that easily export for additional reporting needs
- Interactive Visuals Allow to Create Insights – Users can explore data in various visuals including maps and charts and make use of summary level information; additionally, users can now access pre-existing reports for specific programs and clinical trials that are stored on SharePoint
