1 / 29

Phuse 2010 – Berlin

Phuse 2010 – Berlin. Project management (Dashboard and Metrics) with QlikView. Stéphane Pirault Keyrus - Biopharma. Outline. Objective of the solution. The source data. The import of source data. Conception of the information monitoring tab.

selene
Download Presentation

Phuse 2010 – Berlin

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Phuse 2010 – Berlin Project management (Dashboard and Metrics) with QlikView Stéphane Pirault Keyrus - Biopharma

  2. Outline Objective of the solution The source data The import of source data Conception of the information monitoring tab linical A KeyrusBioPharma Solution Conclusion

  3. Objective Centralised application Provides monitoring indicators Assists in the planning and performance of monitoring visits Easy to use Must also meet the safety requirements of clinical trial data

  4. The Source Data

  5. Import of source data : odbc (1)

  6. Import of source data : The Script SET ThousandSep=' '; SET DecimalSep='.'; SET MoneyThousandSep=' '; SET MoneyDecimalSep=','; SET MoneyFormat='# ##0,00 €;-# ##0,00 €'; SET TimeFormat='hh:mm:ss'; SET DateFormat='DD/MM/YYYY'; SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'; SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.'; SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.'; ODBC CONNECT TO [Excel Files;DBQ=C:\Qlikview\Projets QV Paris\DATA\Outils recherche clinique English QV.xls]; SQL SELECT * FROM `C:\Qlikview\Projets QV Paris\DATA\Outils recherche clinique English QV.xls`.`Centre$`;; //************************************************ SQL SELECT * FROM `C:\Qlikview\Projets QV Paris\DATA\Outils recherche clinique English QV.xls`.`Patient$`;; //************************************************ ……… //************************************************ Alertes: SQL SELECT patient_nb as patient_nb_alerte, date_monitoring as date_monito_alerte, centre_nb & ' (date monitoring : ' & date_monitoring & ')' as centre_monito_alerte FROM `C:\Qlikview\Projets QV Paris\DATA\Outils recherche clinique English QV.xls`.`Patient$` where date_monitoring is not null and date_envoi is null;; //************************************************

  7. Conception of the Information Monitoring TAB

  8. Creation of new tab Instant Information not expandable screen design

  9. Object creation (1) Current Selection Visit Status

  10. Object creation (2)

  11. Object creation (3)

  12. Object creation (4)

  13. Object creation (5)

  14. Tab Design (1)

  15. Tab Design (2)

  16. Tab Design (3)

  17. Tab Design (4)

  18. How to use the tab (1) ?

  19. How to use the tab (2) ?

  20. LINICALKEYRUS BIOPHARMA SOLUTION

  21. Contents OF The Solution Home Page Dashboard Center Information Country Statistics Center Statistics Information Monitoring Financial Information Help SAE

  22. Home Page Tab

  23. Dashboard Tab

  24. Center Information Tab

  25. Center Information Tab

  26. Center statisitics Tab

  27. Help Tab

  28. Conclusion Intuitive and easy to use application Available for everyone Evolutive solution Consistent with securities pre-requisites Allows sponsor access Allows an overviewateachstep of the project

More Related