• Andrew Owondo
• Data Analyst

• Data Analysis & Visualization
• Business Intelligence & Reporting
• Project Management

• Uncovering insights using:
• Power BI, Python, SQL, Excel

As a data analyst, I specialize in uncovering actionable insights that drive strategy and performance. From developing dynamic Power BI dashboards to automating analytics workflows in Python, I help organizations in hospitality, healthcare, education, retail, and finance leverage their data for real-world impact.

Skills & Expertise

Featured Projects

Hospitality Revenue Dashboard

Analyzing hotel booking & revenue data.

Building Water Consumption BI

Tracking meter readings, consumption trends, and billing across residential units.

Kenyan Migration & Tourism Analysis

• Project: Created a Power BI dashboard to monitor occupancy and revenue trends, helping management identify off-peak seasons.
• Key Takeaway: Revealed seasonality dips, prompting targeted marketing efforts that increased bookings by 20% in off-seasons.
• Tools: Power BI, Excel
• 

View on GitHub

Building Water Consumption BI

• Project: Developed a utility billing and consumption tracking system for multi-unit residential properties using Excel and VBA.
• Key Takeaway: Enabled accurate meter reading, automated billing, and early detection of abnormal water usage, improving operational efficiency and reducing water wastage by over 20%.
• Tools: Excel, VBA, Form Controls, Dynamic Named Ranges

View on GitHub

Retail Sales Performance

• Project: Developed an interactive report to analyze product performance and branch profitability across a retail chain.
• Tools: Power BI, Power Query
• Key Takeaway: Identified underperforming SKUs and optimized inventory allocation, reducing dead stock by 35%.
• 

View on GitHub

Retail Sales Performance

• Project: Developed an interactive report to analyze product performance and branch profitability across a retail chain.
• Tools: Power BI, Power Query
• Key Takeaway: Identified underperforming SKUs and optimized inventory allocation, reducing dead stock by 35%.
• 

View on GitHub

• View Resume

Get In Touch

If you're looking for a data analyst who can translate complex data into clear strategies and impactful dashboards, let's connect. I'm open to freelance projects, collaborations, and full-time roles globally.