| Table of Contents | ||
|---|---|---|
|
Reports Logic
Based on current tables next data must be aggregated and analyzed:
...
Using replicated tables from fraud data mart and BI tool the reports with outliers must be shown.
Until there is no enough statistic to use statistical methods to find outliers, the top least(5%, 25 rows) can be shown instead.
For now there are 3 reports are required - for autorization, doctors and phone_numbers.
Predefine views with aggregation
1. Doctor aggregation
number of patients per doctor (total_patients_doctor)
...