Maji Ndogo: Visualizing the Currents of Change

🎯 Project Goals:

• Empowering decision-making with cutting-edge visual analytics.
• Building a comprehensive Power BI data model to integrate diverse data streams for in-depth insights into Maji Ndogo's water utilization, societal impacts, and infrastructure.
• Crafting dynamic, interactive visualizations using Power BI, with Figma enhancing the visual appeal, for fresh perspectives and informed strategies.

🔑 Key Achievements:

• Developed a robust relational data model in Power BI for complex storytelling and data-driven decision-making.
• Achieved exceptional clarity and enhanced user experience by using Figma to carefully design visual elements.
• Enhanced visual quality, making intricate data more comprehensible and engaging, thanks to Figma's design capabilities.
• Demonstrated high-level expertise in data cleaning, ensuring the reliability and accuracy of insights.

🛠️ Skills and Techniques:

• Showcased end-to-end expertise in Power BI, covering everything from data importation to visualization and dashboard sharing.
• Utilized DAX for creating complex measures and columns, enriching the data narrative.
• Designed intuitive and impactful visuals, applying knowledge of themes, fonts, and layouts in Figma.
• Implemented dynamic conditional formatting in Power BI, guided by Figma's design principles.
• Managed and troubleshooted data relationships within Power BI, understanding their nuances and impacts.

🚧 Solutions to Challenges:

• Established a structured data cleaning process to ensure the highest quality of data for analysis.
• Tackled data model complexities by implementing best practices in data modeling and relationship management.
• Created user-friendly visual designs with Figma to ensure intuitive communication of complex data insights.

📊 Visual Narratives Revealed in the Dashboards:

1. Summary
2. National Water Overview
3. Queue Dynamics & Access
4. Crime Statistics & Social Impact

👁️ Feast your eyes on the dashboards created using Power BI and Figma - they visualize the currents of change in Maji Ndogo!