The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Developed an Excel-based Monitoring & Evaluation dashboard for a simulated NGO youth economic empowerment programme. The project covered data quality assessment, M&E indicator and KPI tracking, target-versus-actual performance analysis, beneficiary outcomes, employment and income analysis, and executive reporting.
I also implemented VBA automation to streamline dashboard refreshes, validate KPIs, check duplicate IDs and missing data, refresh charts, update timestamps, and maintain an automation log. The project demonstrates how programme data can be transformed into practical insights for monitoring performance and supporting evidence-based decision-making.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
I created an interactive Excel dashboard to help businesses understand their sales and profitability. The project involved cleaning and organizing sales data, analyzing monthly sales and profit, comparing regional performance, and creating interactive charts and filters for product categories.
The dashboard turns raw sales data into clear visual insights that can help business owners monitor performance and make data-driven decisions.
Tools: Microsoft Excel, Pivot Tables, Charts, Data Cleaning, Dashboard & Data Analysis
Built an AI-powered Social Media Post Analyzer that analyzes social media content and generates structured insights using LLMs.
The application uses LangChain and Pydantic to process the input and return structured results through an interactive Streamlit interface.
Built with: Python, LangChain, Pydantic, Hugging Face, Streamlit, and LangSmith.
Pydantic catches shape errors, but a plausible wrong insight can still pass. I'd keep a small set of posts with expected labels in LangSmith and rerun it after prompt changes. Are you tracking that kind of drift?
Built a comprehensive Excel-based US Payroll Management System designed to organize employee payroll data, automate payroll calculations, and provide clear management insights through an interactive dashboard.
The system includes payroll summaries, employee records, payment tracking, automated calculations, KPI reporting, and visual analysis to make payroll data easier to manage and monitor.
Built with advanced Excel formulas, PivotTables, data validation, charts, dashboards, and automation-focused workflows.
