Supply Chain Analysis

- Problem: Supply chain losses amounting to 9% of monthly procurement. - Solution: Tracking dashboard + alerts to identify areas of loss across the chain eg delays, damages, returns, etc. - Impact: losses reduced to 3% in 1 month after solution implementation.

Supermarket Sales Analysis

I cleaned and analyzed Supermarket Sales data from January 2019 to March 2019. with Excel to show the distribution of total sales and the relationship between product type and customer type among other KPIs. I created a dashboard to visualize all KPIs.

Molvin Hotel Group Bookings

An Analysis of Hotel bookings, cancellations, and Revenue generated.

Bitcoin/US Dollar Historical Data Analysis

Task: Retrieval and analysis of historical trading data for the Bitcoin/US Dollar over the past five years. Solution: Developed a real-time dashboard using Streamlit which provides a simple interface for analysis and visualization. Impact: Users can obtain critical insights into Bitcoin price trends

Flowers Website

Designed and developed the official corporate website for Edge Flowers, a Kenyan flower export company connecting local flower growers with international buyers. The website serves as the company's digital presence, showcasing its products, services, export capabilities, and company profile.

Tracking of Advertising Costs and E-commerce Order Analysis

Developed and implemented an automated solution to track and analyze the combined advertising costs of Facebook and Google, along with the cost per e-commerce order. The primary goal is to enhance our understanding of advertising effectiveness and overall return on investment (ROI).

Streaming clicks and purchase data

This project enables organizations to generate data through clicks from their pages. The clicks from different page URLs enable organizations to record users' data. This data will help the organization understand if the clicks made led to users making a purchase.

Blockchain Transactions Analysis

This analysis contains blockchain financial transactions within the open metaverse aiming to provide a rich, diverse, and realistic set of data for developing anomaly, fraud analysis, and prescribe analytics in virtual environment.