BIKES SALES DASHBOARD

This project aims to explore the correlations between various demographic and socioeconomic variables—such as age, occupation, gender, marital status, and income—and the propensity to purchase bikes.

Web Scraping

In this project, I try to extract the List_of_largest_companies_in_the_United_States_by_revenue from the website using Beautiful Soup

E-COMMERCE SALES DASHBOARD

E-COMMERCE SALES DASHBOARD Visualization Tool - #powerbi Database - Excel Process Include: 1. Importing and verifying data for transformations and cleaning in power query. 2. Data Modeling. 3. Identifying and creating measures using DAX 4. Validating all #data. 5. Creating a Dashboard.

House Price Prediction

This project aims to predict house prices using features like House Age, Transit Distance, Local Convenience Stores, Latitude, and Longitude. With preprocessing, missing values are handled, and features are normalized. The dataset is split into training and testing sets for accurate model evaluation

CUSTOMER SEGMENTATION

I use features like Age, Annual Income, and Spending Score to group customers into distinct segments based on similarities in these features. These segments are used to in targeted marketing strategies, personalized recommendations, an improving customer satisfaction and maximizing profits.

House Price Dashboard Analysis

In this project, I use tableau software to visualize and analysis to show how variable like Bedroom and Bathroom, Year Build, Square Lot and Location affect the Prizing of Houses.

British Airways Analysis Dashboard

This project entails the development and examination of the British Airways Dashboard, encompassing several key components: Data & Dashboard Overview, Map, Custom Parameter, Calculated Field, Advanced Filters. Line Chart Building & Formatting the Dashboard

Bank Loan Analysis

I leverage SQL queries extensively to develop key performance indicators (KPIs) for bank loan analysis. These KPIs encompass critical metrics such as Loan Amount, Loan Received Amount, Payable Amount, Average Interest, and Debt-to-Income Ratio.

Walmart Database

This project aims to explore the Walmart Sales data to understand top performing branches and products, sales trend of different products, customer behavior. The aims are to study how sales strategies can be improved and optimized

PIZZA DATABASE ANALYTICS

This project revolves around a Pizza Sales database, where we delve into key performance indicators such as total revenue, sales per order, and the overall number of pizzas sold. We accomplish this analysis using SQL. The project encompasses data modeling, wrangling, and analysis phases.

Super Store Analysis

In this project, we aim to extract valuable insights across various dimensions. Specifically, we'll delve into sales trends, shipping patterns, product categories, and customer segmentation for a comprehensive analysis.

A-B-Testing-Campaign ADS

GOAL/OBJECTIVE The primary goal is to determine which ad campaign, AKIN9326 or AKIN8012, resulted in more conversions for the Kindle product. Conversions serve as a key metric for evaluating the effectiveness of each ad campaign in driving user engagement and sales.

HOUSE PRICE PREDICTION USING NEAURAL NETWORK

AIM: Develop robust house price prediction models. These models, by considering a multitude of variables including property features, economic indicators, and market trends, aim to provide accurate predictions aligned closely with actual sales prices

CALL CENTER OPERATIONS OPTIMIZATION

To enhance customer satisfaction and reduce operational costs in the call center. Solution: Develop a comprehensive data-driven strategy utilizing Power BI dashboards to visualize key performance indicators, identify trends, and optimize resource allocation.

Furniture_Sales Analysis - SQL

I used SQL with query optimization techniques, including indexing and efficient joins, to analyze furniture sales data. This improved performance, enabling faster insights into key metrics such as revenue, customer behavior, and product performance for actionable sales strategies.

HR_ATTRITION_Analysis-EXCEL

Utilizing SQL alongside Excel Power Query for dataset transformation, manipulation, and cleaning, this project adds key columns like age group for deeper analysis. Through pivot tables and Excel formulas like XLOOKUP and IF, critical insights are uncovered, visualized, and presented.