businessanalytics

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.

Analysis of 3 million U.S. domestic flights (2019–2023) to identify what drives departure delays and whether delay likelihood can be predicted before a flight departs.

MS, Data Analytics Capstone (Nexford University) by Saheed Badru

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

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

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

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.

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.

Analyzed business sales data to uncover revenue trends, top-performing products, and actionable insights through an interactive Power BI dashboard.

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.

exploring different analytics projects

🚀 Power BI Case Study on AtliQ Hardware – Built interactive dashboards for Sales, Finance, Marketing & Supply Chain. Delivered key insights on revenue growth, cost optimization, market share, and forecasting accuracy using Power Query, DAX, and Data Modeling

A data-driven dissertation project demonstrating skills in data cleaning, analysis, and visualization using Excel. The study includes the use of Pivot Tables, VLOOKUP, and graphical insights to interpret trends and support meaningful conclusions.