Richard Ngene's Portfolio

Business Analyst & Data Scientist | Empowering data-driven decisions through expertise in SQL, Python, Power BI, and Azure. I bring a solid foundation in data analysis and machine learning (Scikit-Learn), complemented by advanced Excel skills and visualization capabilities in Tableau, to translate complex data into actionable insights.

Spotify_SQL_Project

This project involves analyzing a Spotify dataset with various attributes about tracks, albums, and artists using SQL. It covers an end-to-end process of normalizing a denormalized dataset, performing SQL queries of varying complexity (easy, medium, and advanced), and optimizing query performance.

Python_Data-App_Project

The Data Cleaning Master is a Python application designed to efficiently clean datasets by handling duplicates, missing values, and providing cleaned output within seconds. The application is user-friendly, highly performant, and has been tested on various datasets, ensuring smooth execution and accuracy.

EDA_Python_Project

This project performs Exploratory Data Analysis (EDA) on New York Airbnb data to uncover trends and patterns in rental listings. I used libraries like Pandas, Numpy, Matplotlib, Seaborn for cleaning, visualization, and analysis.

Excel_FNP
Sales_Analysis_Project

I was given a dataset from FNP (Ferns and Petals) that specializes in sending gifts for various occasions like Diwali, Raksha Bandhan, Holi, Valentine's Day, Birthdays, and Anniversaries. The dataset contains details about the products, orders, customers, and relevant dates. My task is to analyze this dataset to uncover key insights related to sales trends, customer behavior, and product performance.

Walmart_SQl_Python_Project

This project is an end-to-end data analysis solution designed to extract critical business insights from Walmart sales data. We utilize Python for data processing and analysis, SQL for advanced querying, and structured problem-solving techniques to solve key business questions. The project is ideal for data analysts looking to develop skills in data manipulation, SQL querying, and data pipeline creation.