p roject management (d ashboard and m etrics ) with q lik v iew s tÉphane p irault k eyrus - b...
Post on 26-Mar-2015
213 Views
Preview:
TRANSCRIPT
PROJECT MANAGEMENT (DASHBOARD AND METRICS) WITH QLIKVIEW
STÉPHANE PIRAULTKEYRUS - BIOPHARMA
PHUSE 2010 – BERLIN PHUSE 2010 – BERLIN
OUTLINE OUTLINE
OBJECTIVE OF THE SOLUTIONOBJECTIVE OF THE SOLUTION
THE SOURCE DATATHE SOURCE DATA
THE IMPORT OF SOURCE DATATHE IMPORT OF SOURCE DATA
CONCEPTION OF THE INFORMATION MONITORING TAB CONCEPTION OF THE INFORMATION MONITORING TAB
CONCLUSIONCONCLUSION
LINICAL A KEYRUS BIOPHARMA SOLUTIONLINICAL A KEYRUS BIOPHARMA SOLUTION
OBJECTIVE OBJECTIVE
CENTRALISED APPLICATIONCENTRALISED APPLICATION
PROVIDES MONITORING INDICATORSPROVIDES MONITORING INDICATORS
MUST ALSO MEET THE SAFETY REQUIREMENTS OF CLINICAL TRIAL DATAMUST ALSO MEET THE SAFETY REQUIREMENTS OF CLINICAL TRIAL DATA
ASSISTS IN THE PLANNING AND PERFORMANCE OF MONITORING VISITSASSISTS IN THE PLANNING AND PERFORMANCE OF MONITORING VISITS
EASY TO USEEASY TO USE
THE SOURCE DATATHE SOURCE DATA
IMPORT OF SOURCE DATA : ODBC (1)IMPORT OF SOURCE DATA : ODBC (1)
IMPORT OF SOURCE DATA : IMPORT OF SOURCE DATA : THE SCRIPTTHE 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_alerteFROM `C:\Qlikview\Projets QV Paris\DATA\Outils recherche clinique English QV.xls`.`Patient$` where date_monitoring is not null and date_envoi is null;;//************************************************
CONCEPTION OF THE CONCEPTION OF THE INFORMATION MONITORING TABINFORMATION MONITORING TAB
CREATION OF NEW TABCREATION OF NEW TAB
INSTANT INSTANT INFORMATIINFORMATI
ONON
NOT NOT EXPANDABLE EXPANDABLE
SCREEN SCREEN
DESIDESIGN GN
Current Selection
Visit Status
OBJECT CREATION (1)OBJECT CREATION (1)
OBJECT CREATION (2)OBJECT CREATION (2)
OBJECT CREATION (3)OBJECT CREATION (3)
OBJECT CREATION (4)OBJECT CREATION (4)
OBJECT CREATION (5)OBJECT CREATION (5)
TAB DESIGN (1)TAB DESIGN (1)
TAB DESIGN (2)TAB DESIGN (2)
TAB DESIGN (3)TAB DESIGN (3)
TAB DESIGN (4)TAB DESIGN (4)
HOW TO USE THE TAB (1) ?HOW TO USE THE TAB (1) ?
HOW TO USE THE TAB (2) ?HOW TO USE THE TAB (2) ?
LINICALLINICAL
KEYRUS BIOPHARMA KEYRUS BIOPHARMA SOLUTIONSOLUTION
CONTENTS OF THE SOLUTIONCONTENTS OF THE SOLUTION
HOME PAGEHOME PAGE
DASHBOARDDASHBOARD
CENTER STATISTICSCENTER STATISTICS
CENTER INFORMATIONCENTER INFORMATION
COUNTRY STATISTICSCOUNTRY STATISTICS
INFORMATION MONITORINGINFORMATION MONITORING
SAESAE
FINANCIAL INFORMATIONFINANCIAL INFORMATION
HELPHELP
HOME PAGE TABHOME PAGE TAB
DASHBOARD TABDASHBOARD TAB
CENTER INFORMATION TABCENTER INFORMATION TAB
CENTER INFORMATION TABCENTER INFORMATION TAB
CENTER STATISITICS TABCENTER STATISITICS TAB
HELP TABHELP TAB
CONCLUSIONCONCLUSION
INTUITIVE AND EASY TO USE APPLICATION INTUITIVE AND EASY TO USE APPLICATION
AVAILABLE FOR EVERYONEAVAILABLE FOR EVERYONE
EVOLUTIVE SOLUTIONEVOLUTIVE SOLUTION
ALLOWS AN OVERVIEW AT EACH STEP OF THE PROJECT ALLOWS AN OVERVIEW AT EACH STEP OF THE PROJECT
CONSISTENT WITH SECURITIES PRE-REQUISITESCONSISTENT WITH SECURITIES PRE-REQUISITES
ALLOWS SPONSOR ACCESSALLOWS SPONSOR ACCESS
top related