
Ultimate access to all questions.
You have been given a dataset from a healthcare provider containing patient records with fields such as 'PatientID', 'Age', 'Gender', 'Diagnosis', and 'TreatmentOutcome'. Your task is to perform exploratory analytics to uncover patterns and insights that could improve patient care. Describe the steps you would take, including the types of analyses you would perform and the visualizations you would use in Microsoft Fabric to represent your findings.
A
Use SQL to group data by Diagnosis and Gender, then use pie charts for visualizations.
B
Aggregate data by Age and TreatmentOutcome, then use bar charts and line charts for visualizations.
C
Filter data by PatientID and analyze correlations with other variables using heat maps.
D
Sort data by PatientID and use scatter plots for visualizations.