Our client has evolved into a leading non-governmental organization, extending its reach to remote rural villages of Nairobi. With a devoted team of over 1700+ Kenyan staff members, a global network of partners and leaders, and the unwavering support of missionaries, the organization has become a beacon of hope for countless children and families.The Client
Our client has evolved into a leading non-governmental organization, extending its reach to remote rural villages of Nairobi. With a devoted team of over 1700+ Kenyan staff members, a global network of partners and leaders, and the unwavering support of missionaries, the organization has become a beacon of hope for countless children and families.
Challenges Faced by the Client
The organization encountered several significant struggles that hindered its operations,
- Message Security: The organization faced persistent challenges in ensuring that sensitive or inappropriate content was filtered from messages exchanged between sponsors and children. The lack of clear visualizations for flagged messages made monitoring and managing content effectively difficult, leading to delays and inefficiencies in ensuring secure communication.
- Message Tracking: Monitoring the status of message exchanges was difficult, particularly identifying successfully delivered messages versus those held back due to content issues.
- Data-Driven Insights: Analyzing communication metrics, such as response times and message flow segmented by gender and region, lacked efficiency. The absence of advanced analytical tools made it harder to understand engagement patterns and make informed decisions to improve sponsor-child interactions.
- User-Friendly Interface: The platform for managing and monitoring message flows lacked clarity and intuitiveness, hindering the efficiency of CS teams and delaying their ability to address issues promptly.
- Workflow Visibility and Bottleneck Identification: There was no system in place to provide insights into the time taken at each stage of message handling. This led to delays caused by bottlenecks in various steps of the process, such as approvals by Customer Support (CS).
Solutions
To address these challenges, the organization implemented a comprehensive messaging system integrated with Power BI for data analysis.
The solution involved:
- Message Flow Management: A structured message flow was designed using Power BI for the CS team, resolving the issue of inappropriate or irrelevant communication. Power BI’s analytical capabilities allowed for seamless tracking and verification of messages, ensuring content compliance while enhancing stakeholder trust and maintaining communication standards.
- Message Tracker Dashboard: A user interface designed to visually represent the status of messages. It uses color coding—green for successfully delivered messages and red for those held—allowing quick assessments of communication flow.
- Advanced Data Analytics System: Leveraged Power BI to develop a robust data analytics platform, encompassing the following key features
-
- Power BI provided actionable insights into communication trends, enabling the CS team to identify regional and gender-specific challenges in message delivery. This empowered the team to adjust their approach, ensuring more effective and timely communication.
- Evaluating the time taken for message delivery to ensure timely communication between sponsors and children.
- Differentiation between High School (HS) and Primary messages to address specific processing needs and timelines.
- Prioritization Alerts: Prioritization alerts played a pivotal role in ensuring urgent messages were addressed promptly, significantly improving response times and fostering better engagement between stakeholders.
- Workflow Insights and Bottleneck Analysis: Integration of KPIs to measure:
- Average days from the time a message is received until it is approved and sent to the sponsor.
- Average time messages spend at each step, including CS and SW processing.
- Specific delays at stages such as CS initial approval, SW task completion, and final CS approval before sending to sponsors.
Solutions Benefits
The implementation of this solution provided several significant benefits:
- Enhanced Communication Security: By filtering messages for inappropriate content, the organization ensured a safe communication environment for both sponsors and children.
- Data-Driven Insights: The integration with Power BI allowed the organization to make informed decisions based on real-time data analytics, helping them identify trends in communication and areas needing improvement.
- Operational Efficiency: The message tracking dashboard streamlined the CS team’s workflow, allowing them to focus on high-priority communications while effectively managing their workload.
- End-to-End Visibility: The KPIs provided a clear picture of the entire workflow, highlighting bottlenecks and allowing for targeted improvements.
- Timely Approvals: By analyzing delays at each step, the organization was able to train teams, allocate resources, and improve response times.
