ADS Capstone Chronicles Revised

‭22‬

‭Figure‬ ‭13‬ ‭Random‬ ‭Forest‬ ‭Classification‬ ‭Matrix‬

‭5.2 Dashboard in PowerBI‬ ‭A‬‭Power‬‭BI‬‭dashboard‬‭was‬‭created‬‭to‬‭enable‬ ‭users‬ ‭and‬ ‭healthcare‬ ‭providers‬ ‭to‬ ‭interact‬ ‭with‬ ‭data‬ ‭related‬ ‭to‬ ‭adverse‬ ‭drug‬ ‭effects.‬ ‭The‬‭dashboard‬‭dynamically‬‭displays‬‭various‬ ‭metrics,‬ ‭including‬ ‭the‬ ‭number‬ ‭of‬ ‭adverse‬ ‭event‬ ‭reports,‬ ‭patient‬ ‭sex‬ ‭distribution,‬ ‭patient‬ ‭age‬ ‭distribution,‬ ‭outcome‬ ‭severity‬ ‭levels,‬ ‭observed‬ ‭reactions,‬ ‭reaction‬ ‭counts,‬ ‭and‬ ‭reaction‬ ‭proportions‬ ‭reported‬ ‭(Figure‬ ‭15).‬ ‭5.2.1 Microsoft PowerQuery‬ ‭Data‬‭was‬‭loaded‬‭into‬‭Power‬‭BI‬‭using‬‭Power‬ ‭Query‬ ‭Editor.‬‭Data‬‭from‬‭the‬ ‭adverse_events‬ ‭table‬ ‭and‬ ‭patient_drugs‬ ‭table‬‭in‬ ‭pharma_db‬ ‭were‬ ‭uploaded‬ ‭as‬ ‭CSV‬ ‭files,‬ ‭comprising‬ ‭a‬ ‭total‬ ‭of‬ ‭20,885‬ ‭unique‬ ‭adverse‬ ‭reaction‬ ‭event‬ ‭reports.‬ ‭Additionally,‬ ‭the‬ ‭reactions_raw‬ ‭CSV‬ ‭file‬ ‭generated‬ ‭in‬ ‭the‬ ‭code was uploaded.‬

‭Figure‬ ‭14‬ ‭Random‬ ‭Forest‬ ‭Feature‬ ‭Importance Scores‬

‭Figure 15‬ ‭Drug Adverse Events Dashboard‬

172

Made with FlippingBook - Online Brochure Maker