Gift Shop Data Analysis

Conducted a comprehensive data analysis for a retail business, focusing on sales trends, customer demographics, and inventory management. Insights led to optimized stock levels, targeted marketing strategies, and enhanced customer satisfaction, driving a significant increase in revenue and operation

Mobile_Manufacturers

This project contains SQL scripts designed to analyze various aspects of a mobile manufacturing company's operations. The SQL queries focus on different data points such as customer transactions, production metrics, manufacturer data, and sales performance. The repository contains the following SQL

Hypothesis Testing

This Jupyter Notebook project employs hypothesis testing to analyze data and draw statistical conclusions. Through rigorous statistical methods, including t-tests and chi-square tests. Utilizing Python libraries pandas, scipy.stats, seaborn, plotly.express, matplotlib.pyplot.

Retail Data Analysis

This project leverages data analytics to optimize business processes and enhance customer satisfaction in the retail industry. We merged these datasets into one data frame for comprehensive analysis.

Insurance Claim

Conducted an in-depth data analysis of insurance claims using Python. The aim was to uncover insights and patterns in the claims data to help improve the efficiency and accuracy of claim processing. Objectives were data cleaning and preprocessing, EDA, statistical analysis and give recommendations

Credit Card

Conducted a comprehensive data analysis of credit card transactions using Python. Cleaned and preprocessed data, performed exploratory data analysis, providing actionable insights to enhance transaction security and customer satisfaction.

Market Analytics

Analyzed an online marketplace to understand customer, seller, product, and channel behaviors. Conducted exploratory analysis, segmented users, identified cross-selling patterns, evaluated payment behaviors, and assessed customer satisfaction, providing data-driven insights to improve performance.

Retail Dashboard

Integrated retail data from four disparate sources, defined relationships, and enhanced datasets using DAX. Created new columns for analysis, ensuring comprehensive connections. Developed a dashboard with metrics like revenue, quantity, cancellations, and customer behavior by various dimensions.

E-commerce Company Dashboard

Created Power BI dashboards for an e-commerce client, analyzing KPIs, pricing, promotions, search, and recommendations. Cleaned data, derived variables, answered key business questions, and documented insights to enhance understanding of customer behavior and drive business performance.

Home Loan Data Analysis

Executed advanced SQL queries and stored procedures to perform comprehensive data analysis on a banking dataset. The dataset includes tables such as Customer_Data, Loan_Records_Data, Banker_Data, and Home_Loan_Data, containing details about customers, loans, bankers, and properties.