General
Create a troubleshooting guide for PDMs/PMs/Analytics to use to determine what is broken (pipeline, ETL, DM refresh, etc)/"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)
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)
DEPENDENCIES
GPLIM-6127
GPLIM-6126
GPLIM-6069
DDP (ticket unknown)