Project 1: Business profitability models

This project was about developing a set of criteria for evaluating businesses that are suitable for low-income youth in rural areas to start-up and run. Through the model I was able to come with an evaluation criteria for evaluating most viable business and through the help of Profitability Model I was able to know when the business should break-even (# of days / weeks from start and How much profit the business will make on a monthly basis after breaking even against the amount of start-up capital, fixed costs, and variable costs needed to run the business and laid down business assumption. Further providing additional questions for testing the business if it is viable and use the information gathered to refine the profitability model.

Project 2: Project performance dashboard

The dashboard gives details on the project delivery milestones and performance over 4 years period from 2019 to 2021. Where a total of 124 projects were delivered over the years. The projects were delivered in West Africa, Asia, East and Central Africa, Latin America and Caribbean, Eurasia and North Africa, Southern Eastern Africa. The Beneficiary reach rate was 37.17% and total number of project approaches used was 21. Therefore through the dashboard the stakeholders were able to make data driven decisions based on the insights, patterns and trends exhibited.

Project 3: Google Ads Campaign 

Client:Energie Energy Access
Objective: Launch a Google Ads campaign to generate 500+ qualified leads for Energie Energy Access company within 3 months.

Strategy:

• Researched and selected high-intent keywords around sustainable energy and solar panels.

• Structured campaigns by user intent (Cost Savings | Environmentally Friendly | Local Installation)

• Implemented smart bidding strategies and conversion tracking via Google Analytics.

Results:

• Delivered 520 qualified leads at an average CPA (Cost Per Acquisition) of $12.

• Increased website traffic by 70% over baseline.

• Built Google Looker Studio reports to track campaign ROI and optimize performance weekly.

Tools Used: Google Ads, Google Analytics, Google Looker Studio, Canva

Project 4: Sales Trends Dashboard 

Client:  BrandME Kenya
Objective: Analyze sales data to identify seasonal trends and opportunities for revenue growth across different regions.

Strategy:

• Cleaned and prepared sales data from different regions using Excel and SQL.

• Built a Power BI dashboard showing key metrics: total sales, product categories, market segment performance, and month-over-month trends.

• Applied predictive modeling to forecast sales for the next two quarters.

Insights Uncovered:

• Found that holiday promotions in Q4 drove a 45% revenue spike.

• Identified underperforming regions during Q2, recommending targeted marketing efforts.

Tools Used: Power BI, Excel, SQL

Project 5: Donor Engagement Analysis

Client: Water.org
Objective: Increase donor retention and understand giving patterns to improve fundraising effectiveness.

Strategy:

• Analyzed historical donation data in Google Sheets and categorized donors into engagement segments.

• Built a Google Looker Studio dashboard showing average donation size, frequency, retention rates, and lapsed donors.

• Developed targeted re-engagement strategies based on donation history insights.

Results:

• Personalized outreach emails improved second-time donation rates by 15%.

• Executive team received easy-to-read monthly donor trend reports to support strategic planning.

Tools Used: Google Sheets, Google Looker Studio, Mailchimp