Real-Time Metric Tracking and Visualization Dashboard
Client Overview
The Program for Multicultural Health (PMCH) at Michigan Medicine implements culturally responsive initiatives in partnership with communities to enhance overall health & well-being by increasing knowledge, skills, and health equity.
The Challenge
PMCH faced significant challenges with their data collection and reporting system:
- Manual Process: Non-automated, time-consuming data collection
- Inefficient Reporting: Time-consuming reporting procedures
- Poor Organization: Inefficient data organization
- Limited Access: No real-time access to metrics
Initial Analysis
Data Assessment
Conducted thorough analysis of existing data collection methods and requirements
Platform Evaluation
Explored various automation platforms and selected Microsoft ecosystem for optimal integration
Team Organization
Established specialized roles for each team member to handle different aspects of the automation flow
Technical Documentation
Microsoft Form
Event information and metrics collection form
SharePoint List
Centralized data management structure
Power Automate Flow
Automated workflow diagram
Excel Dashboard
Data analysis and reporting template
Results & Impact
Successfully automated data collection and reporting processes
Enabled real-time access to program metrics
Reduced manual data entry time significantly
Provided scalable solution for future growth