Fuenfgeld/ATeamDatenmanagementUndArchivierung

Issues

• SQL Sum coloums skip NULL

  #60 opened 4 years ago by fphans
  3

• Wiki Seite für eure Ergebnisse

  #47 opened 4 years ago by Fuenfgeld
  14

• fehlende bildlegende

  #69 opened 4 years ago by fphans
  1

• master file compilieren

  #57 opened 4 years ago by fphans
  5

• GitHub Übersicht im Wiki aktualisieren

  #68 opened 4 years ago by lknegendorf
  2

• Datenmanagement Feedback

  #62 opened 4 years ago by Fuenfgeld
  5

• Prüfungsskript

  #51 opened 4 years ago by fphans
  9

• felix_branch defekt nach master update

  #59 opened 4 years ago by fphans
  9

• Archivierungsseite im Wiki

  #66 opened 4 years ago by lknegendorf
  1

• Datenmanagement Plan enthält noch Satzbausteine aus dem Template

  #46 opened 4 years ago by Fuenfgeld
  7

• hypothese 1

  #67 opened 4 years ago by fphans
  3

• cape_privacy

  #65 opened 4 years ago by fphans
  4

• Linkfunktionalität

  #63 opened 4 years ago by Carmen-Haubold
  2

• Datenflussdiagramm

  #58 opened 4 years ago by fphans
  2

• Dokumentation der Systemumgebung

  #44 opened 4 years ago by Fuenfgeld
  14

• Geimpfet vs ungeimpfte

  #43 opened 4 years ago by fphans
  12

• Verlinkung

  #53 opened 4 years ago by Carmen-Haubold
  1

• Alternativer Code zum start post ETL

  #50 opened 4 years ago by fphans
  7

• Datenmanagement Plan soll eure Dokumentation referenzieren

  #33 opened 4 years ago by Fuenfgeld
  9

• Noch ein paar links für eure Auswertung

  #37 opened 4 years ago by Fuenfgeld
  4

• Datenschutz Folgeabschätzung

  #45 opened 4 years ago by Fuenfgeld
  3

• kontrolle kontaktdaten

  #40 opened 4 years ago by fphans
  5

• ETL Doku

  #35 opened 4 years ago by Fuenfgeld
  10

• tb_table specs

  #41 opened 4 years ago by fphans
  3

• Mir ist unklar wie Quelldatenmodell I-III zusammenhängt

  #34 opened 4 years ago by Fuenfgeld
  1

• schlüsselattribute

  #42 opened 4 years ago by fphans
  2

• Shortcut to Pocket

  #29 opened 4 years ago by fphans
  1

• Gute Modularisierung des Codes

  #36 opened 4 years ago by Fuenfgeld
  6

• Write SQL Create view Statements to build the star scheme

  #23 opened 4 years ago by lknegendorf
  1

• Write resulting data into a new database

  #25 opened 4 years ago by lknegendorf
  0

• Are transformations needed for the data we use?

  #24 opened 4 years ago by lknegendorf
  7

• Identify data needed to answer our research questions

  #21 opened 4 years ago by lknegendorf
  3

• Identify dependencies in the data needed for our research

  #22 opened 4 years ago by lknegendorf
  1

• Could tb_payers.UNCOVERED_IMMUNIZATIONS be calculated from data stored elsewhere in the database?

  #20 opened 4 years ago by lknegendorf
  1

• Could tb_payers.COVERED_IMMUNIZATIONS be calculated from data stored elsewhere in the database?

  #19 opened 4 years ago by lknegendorf
  1

• Do partly-covered immunizations exist?

  #18 opened 4 years ago by lknegendorf
  1

• Could tb_payers.AMOUNT_UNCOVERED be calculated from data stored elsewhere in the database?

  #17 opened 4 years ago by lknegendorf
  1

• Could tb_payers.AMOUNT_COVERED be calculated from data stored elsewhere in the database?

  #16 opened 4 years ago by lknegendorf
  1

• Is Id UNIQUE in tb_payers over different datasets?

  #30 opened 4 years ago by lknegendorf
  1

• How is tb_encounters.TOTAL_CLAIM calculated?

  #15 opened 4 years ago by lknegendorf
  1

• Is sum of tb_encounters.TOTAL_CLAIM grouped by patient equal to tb_patients.HEALTHCARE_EXPENSES?

  #13 opened 4 years ago by lknegendorf
  1

• Is sum of tb_encounters.PAYER_COVERAGE grouped by patient equal to tb_patients.HEALTHCARE_COVERAGE?

  #14 opened 4 years ago by lknegendorf
  0

• Set up the project wiki

  #5 opened 4 years ago by lknegendorf
  4

• Vereinheitlichung der Sprache im Wiki - Einigung auf Sprache DEUTSCH

  #27 opened 4 years ago by lknegendorf
  7

• Is PATIENT_ID unique in tb_patients?

  #12 opened 4 years ago by lknegendorf
  6

• Import patient data from .csv files into database

  #4 opened 4 years ago by lknegendorf
  0

• ändern der db source zurück auf memory

  #11 opened 4 years ago by fphans
  0

• Verständnis crosslink zwischen Dataframe Pandas und Tabelle/SQL

  #9 opened 4 years ago by fphans
  3

• Importing CSV differenet options

  #7 opened 4 years ago by fphans
  3

• Improve presentation of the repository

  #6 opened 4 years ago by lknegendorf
  1