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.

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

AI-powered matchmaking assistant that helps human matchmakers analyze customer profiles, organize insights, generate CRM notes, and prepare personalized follow-ups.

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

# Excel_Sales_Analytics📊 This repository contains a comprehensive business intelligence report for AtliQ Hardware, focusing on sales performance and strategic insights. 🚀 Explore data-driven analytics to enhance product offerings and optimize sales strategies for improved profitability.

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.

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.

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.

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

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

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.

🚀 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.

exploring different analytics projects