Interesting features to get inspired from DQueen

OHDSI / DataQualityDashboard

A tool to help improve data quality standards in observational data science.

https://ohdsi.github.io/DataQualityDashboard

Apache License 2.0

143 stars 96 forks source link

Interesting features to get inspired from DQueen #197

Closed vojtechhuser closed 2 years ago

vojtechhuser commented 4 years ago

Expected behavior

num column and text column (in addition to count value)

https://github.com/ABMI/DQUEEN_OMOP_CDM_Version/blob/887f9418d02eae685aaaf2084162fc009426740e/inst/sql/sql_server/DQA_Level_2/cdm/117_261_262_check_the_missing_value_of_specimen.sql#L11

vojtechhuser commented 4 years ago

best list of rules is https://github.com/ABMI/DQUEEN_OMOP_CDM_Version/blob/master/inst/csv/rules/DQA_check_of_dqueen.csv

vojtechhuser commented 4 years ago

percentile calculation here https://github.com/ABMI/DQUEEN_OMOP_CDM_Version/blob/887f9418d02eae685aaaf2084162fc009426740e/inst/sql/sql_server/DQA_Level_3/CDM/136_291_daily_drutg_prescription_count.sql#L62

stephanieshong commented 2 years ago

https://github.com/ABMI/DQUEEN_OMOP_CDM_Version/blob/887f9418d02eae685aaaf2084162fc009426740e/inst/sql/sql_server/DQA_Level_2/cdm/117_261_262_check_the_missing_value_of_specimen.sql#L11 - this link is not found?

don-torok commented 2 years ago

This link works best list of rules is https://github.com/ABMI/DQUEEN_OMOP_CDM_Version/blob/master/inst/csv/rules/DQA_check_of_dqueen.csv

clairblacketer commented 2 years ago

closing this as it is a dup and looks like some was moved to achilles

stephanieshong commented 2 years ago

@clairblacketer -Is there a way for me to link the checks listed in the csv file to the actual sql statement in the data quality check dashboard without running the shiny app?

clairblacketer commented 2 years ago

Hi @stephanieshong you could run the DQD setting sqlOnly = TRUE which would output for you a file per sql statement rather than running the entire thing.