Project Initiation

1. Project Initiation

Stakeholders
1. BGH Out-Patient Department Doctors and Staff
2. BGH Board of Directors and Officers
3. Public
Objectives of the dashboard.
1. Be able to create a dynamic report that once refresh, will show the total number of unique patients count and total number of consultations per day, week, month, quarter and year.
2. Be able to identify the growth rate of total number of patients vs previous Month, quarter or date per date slicer.
3. Be able to produce the average waiting time of patients.
4. Any other useful measures that will be discovered during the creation of the dashboard.
Data Source
1. Single MS Excel File
  1. "OPD Logs from 2020 to 2025.xslx" - Updates possible to extract in a single file or monthly updates for aggregation.
Key performance indicators (KPIs) to be tracked.
1. Growth Rate
  1. Growth % Monthly = MTD/PM (Current or Currently selected month / Previous month)*100
  2. Growth % Quarterly
  3. Growth % Yearly
  4. Growth % Weekly
  5. Growth % All month yearly sum / All PM yearly sum
  6. Growth % All Quarter yearly sum / All PQ yearly sum
  7. Growth % PP
2. Average Waiting Time (in days or minutes)
  1. AWT = Date and Time of Disposition - Date and Time of Consultation / Total Number of Consultations
Setup Data Kick-off call with SME (Done)
Establish weekly recurring sync-up meetings
1. Added calendar placeholders as well as both can direct message each other for questions or updates
Create project group chat, and other helpful applications (Done)

Conduct interviews with stakeholders. (Done)
Initiate call with Data SMEs (Done)
1. Read access to database not possible. DOH owns the server. They can only extract reports for dashboard.
2. Would need to refresh dashboard daily/weekly/monthly depending on need.
3. May add additional dashboard features/reports tab, new data source (separate contract / project phase)
Distribute surveys to gather additional insights if needed
1. Not needed.
Document functional and non-functional requirements.

Develop a timeline with milestones (Estimated Duration: 3 days).
1. See Project Checklist and Timeline
Create Kanban board or similar project management board
1. See Project Checklist and Timeline
Assign roles and responsibilities.
1. See Project Checklist and Timeline
Identify resources required for the project.
1. Not Required. Single contributor

Page updated

Report abuse