Analytics FY2020 Q1 Goals (Jul-Sept)

General

Create a troubleshooting guide for PDMs/PMs/Analytics to use to determine what is broken (pipeline, ETL, DM refresh, etc)/ Missing data tool ("Where's my data?") (AM/MM/RAS)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-4927

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5574

Mariela and Rafael are working on this, Nasko is helping.

ETL Resiliency (AM)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5522

Expand dependency visualizer to be useful (e.g. for use in troubleshooting guide) (RAS)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5310

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5317

Need to meet with AM and KC to review usefulness 

Samples

Sample Initiation in Mercury: Datamarts and Tableau (KC, RAS)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-4980

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5390

Ticket TBD for other Pico work once pico is moved to Mercury. KC still a part of those conversations.

Extractions in Mercury: Datamarts and Tableau (KC, MM, RAS) (LIMS dependencies are mitigated with fix in QA 6/19)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5165

 https://gpinfojira.broadinstitute.org/jira/browse/RPT-5449

CRSP kits sent/received, data into Tableau

https://gpinfojira.broadinstitute.org/jira/browse/RPT-4290

Workflow has been defined for CRSP. Now we need to determine whether/where the data are in the MercuryDW. PRIORITY TBD

Non-CRSP Mercury receipt in Tableau

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5389

This should be doable using event_fact? received vs imported?

New Product Development

Quality

Lab Instrument QC (AB)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-4961

3/4 QCs are in Tableau. One waiting for Mercury

Tracking Bravo QC (AB) NOTE: THIS WON'T BE THIS Q

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5355

Sequencing Technology

 Broad West: Show new parsed SAV data in Tableau (KC, RAS)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5257

Data are ready for visualization. It can't be the same report as BroadEast bc data structure is different (e.g. no organic run) but a simple monitoring report should be easy. Early Q1.

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5391 (MM)

 Autopush to Cloud

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5358 (Nasko, Chris)

 Peltier logs

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5361 (RAS)

Seq plating report in Tableau (KC)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5485

Somatic Exome (AB)

 RPT-5218 - New LCSET type for Twist aka "Somatic Exome" (AB)

RPT-5629 - Reporting for Twist Somatic Exome (MM)

 Germline Exome improvements (AB, RAS)

https://gpinfojira.broadinstitute.org/jira/browse/RPT-5431

Financial Reporting

 https://gpinfojira.broadinstitute.org/jira/browse/RPT-5311 (ZL) (complete until we go live)

Other

ULP & Duplex Consensus calling report (CG)

https://gpinfojira.broadinstitute.org/jira/browse/SUPPORT-4829

DEPENDENCIES

GPLIM-6127

GPLIM-6126

GPLIM-6069

DDP (ticket unknown)