Passionate data Engineer and Analyst skilled in designing scalable data solutions and transforming raw data into actionable insights. Expertise in SQL, Python, SSIS, ETL pipelines, data warehousing, Tableau, Power BI, data visualization, and problem-solving. Let's unlock the full potential of your data infrastructure together!
Github Profile
Linkedln Profile
PowerBi Profile
Tableau Profile.
This project develops a sophisticated product recommendation system specifically tailored for an e-commerce platform, leveraging the powerful data warehousing capabilities of Google Cloud Platform (GCP). By utilizing a suite of GCP services along with advanced SQL queries in BigQuery, the system efficiently processes large datasets to generate personalized product recommendations aimed at enhancing user experience and boosting sales.
This project involves designing and building a scalable data warehouse for financial and sales data, utilizing SQL Server and SSIS for ETL processes. The objective was to centralize and streamline data, optimize performance, and implement incremental loading and Slowly Changing Dimensions (SCD) for accurate historical tracking and efficient reporting.
This Python project aims to clean and analyze a dataset using pandas and seaborn libraries to perform correlation analysis. The dataset used for this project is "movies.csv".
In this project we scrape data from Jumia to analyze and compare price data for Samsung and iPhone products.
Data Visualization in Tableau on various projects
Data Visualization in PowerBI on various projects
Data Visualization using EXCEL on various projects
Data Visualization using EXCEL on various projects
The Top Counties Where Food Costs Bite Hardest in Kenya
In this project I was able to perform data cleaning using SQL to process and transform a dataset called NationalHousing. The dataset contains various columns related to property sales and ownership information. The objective of this project was to standardize the data, handle missing values, and improve data quality for further analysis.
This project focuses on analyzing COVID-19 data using SQL. The data used in the analysis was sourced from ourworldindata.org. The objective is to gain insights into the COVID-19 pandemic and its impact on different locations and populations.
NAIROBI, KENYA