CekatanBiz is Software Tools Data Analyst,Business Analyst,and Business Intelligence. Developed using Python.

A real business case aiming for optimisation of stock management. Cleanse - Calculate - Visualize - Drive insights based on current dataset. Recommend new KPIs and metrics for operations.

You can find projects about Predictive Analytics for Business. There are 6 projects in this repo.

This repository is a collection of projects I have worked on, showcasing my skills in data analysis, data science, and machine learning.

Linear programming model to optimize product mix decisions in a retail setting, implemented in R with cost and capacity constraints.

The repository demonstrates my ability in SQL, including ranking, common table expressions (CTEs), datetime functions, text manipulation, aggregation, NULL handling, and more.

In this project, I analyzed a real-world ecommerce dataset from The Look public dataset in Google BigQuery to uncover financial insights and visualize revenue performance. I used advanced SQL, Power BI, DAX, Python, Excel/CSV

Developed a predictive model to identify potential customers who are likely to accept a personal loan offer.

Graduate Rotational Internship Program by The Sparks Foundation. During this Internship, I have worked on projects related to Prediction using Supervised and Unsupervised Machine Learning.

This repository contains the code for performing data analysis on US international air traffic data from Kaggle. The project involves creating a MySQL database and using Knime to answer various business-related questions about the data.

A clean, beginner-friendly SQL project that demonstrates real-world database design, data modeling, and analytical querying. This project simulates a small corporate employee database with hierarchical reporting, departmental structures, and key HR analytics such as salary insights, workforce distribution, and performance-based updates.

Analyze sales trends and customer behavior for Maven Roasters using Python, Matplotlib, and Streamlit. Key insights optimize operations, boost revenue, and enhance customer satisfaction.

Optimizing delivery routes for Rudi's Bakery using Python, Gurobi, and Google Maps API to minimize travel time, balance service constraints, and improve delivery efficiency across 53 store locations.

Analyzes 450K+ e-commerce sessions to quantify marketing channel ROI, connecting acquisition traffic to conversion, refunds, and profit using Python (pandas, matplotlib).

Data analysis of marketing spend, revenue, and ROMI using R

This is a comprehensive well visualized and analyzed data report or ekiti state, nigeria cutting across all thematic KPI areas in ECEWS SPEED project for FY24

The Project focused on analyzing and leveraging data from the television show "Shark Tank India" using SQL.Through data analysis, the project can provide valuable information such as the success rates of different types of pitches, the most successful investors, the industries that attract the most investment, and factors contribute to deal.

Pharmaceutical Sales Business Analysis Project done on Ms-Excel