Featured Projects

A collection of my Real-world projects.

TIJARAH

TIJARAH – AI-Powered Smart Inventory & Business Intelligence Platform (ITI Graduation Project)

Developed an end-to-end Business Intelligence platform as an ITI Graduation Project, integrating a SQL Server Data Warehouse, SSIS ETL pipelines, interactive Power BI dashboards, an AI-powered business copilot for natural language analytics, sales forecasting using Prophet, and automated executive reporting through a Flask web application.

SQL Server DWH ETL SSIS Power BI Tableau Data Analysis Python Flask AI Natural Language Processing Business Intelligence
Fantasy Premier League Data Analysis

Fantasy Premier League (FPL) 2025–2026 Data Analysis

Fantasy Premier League (FPL) 2025–2026 player data analysis using Python. This project explores player performance through data cleaning, feature engineering, exploratory data analysis (EDA), statistical visualizations, and actionable insights to identify top performers, hidden gems, and cost-efficient players.

Python Pandas NumPy Matplotlib Seaborn Jupyter Notebook
Airline Performance Dashboard

✈️ Airline Performance & Delay Analysis Dashboard (Power BI)

Developed an interactive Power BI dashboard analyzing over 1.9M flights, including 177K early and 35K on-time flights. Performed data cleaning using Power Query, designed a star schema model, and implemented DAX measures to track delay rates, cancellations, and time-based trends.

Power Bi Data Analysis Dashboard ETL Business Intelligence Star Schema DAX
Sales Analysis Dashboard

Sales Dashboard - Power BI (AdventureWorks)

Interactive Sales Dashboard built with Power BI using the AdventureWorks dataset. The project features a Star Schema model, advanced DAX calculations, and interactive visuals including drill-down, drill-through, and bookmarks to provide clear insights into sales performance across markets and time.

Power Bi Data Analysis Dashboard ETL Business Intelligence Star Schema DAX
Sales Analysis Dashboard

AdventureWorks Sales Analysis Dashboard (Power BI)

An interactive Power BI dashboard analyzing AdventureWorks sales data using a star schema model and DAX measures. The project includes KPI tracking, drill-down product hierarchy, and tooltip insights to explore sales trends, product performance, and regional distribution.

Power Bi Data Analysis Dashboard ETL Business Intelligence Star Schema DAX
Sales Analysis Dashboard (Excel)

Sales Analysis Dashboard (Excel)

Interactive Sales Analysis Dashboard built using Excel, Power Query, and Power Pivot to transform AdventureWorks data into actionable business insights through KPIs, slicers, and visual analytics, highlighting sales trends, product performance, and regional distribution.

Excel Data Analysis Dashboard ETL Power Query Star Schema Power Pivot Business Insights
Clinic Management System

Smart Clinic Management System

A MongoDB-based Clinic Management System that manages doctors, patients, appointments, and scheduling. It uses a scalable NoSQL data model with referenced relationships and applies aggregation queries to generate insights like doctor workload and peak booking times.

MongoDB MongoDB Atlas NoSQL Database Design Data Modeling Aggregation Framework Business Logic Healthcare System
Movie Analysis

Movie Data Analysis

Performed Exploratory Data Analysis (EDA) on movie datasets using Python, Pandas, and Matplotlib to uncover trends, rating distributions, and genre insights.

Data Analysis Python Pandas Matplotlib Data Visualization EDA Data Cleaning Data Preprocessing Data Transformation Data Exploration
Books Analysis

Books Sales & Ratings Analysis

This project analyzes a Books Dataset using Python and data visualization. It includes sales, ratings, authors, genres, and publication details to explore trends in book popularity and revenue.

Data Analysis Python Pandas matplotlib data-visualization sales-analysis
SQL Project

Telecom SQL System

Telecom Management System built with SQL Server featuring ERD design, advanced SQL (Views, Functions, Stored Procedures, Triggers, Cursors), and business analytics for usage monitoring and revenue insights.

Database Design SQL ERD Views Functions Triggers Cursors Stored Procedures
E-Commerce

E-Commerce-Analytics

An interactive E-Commerce Analytics Dashboard built with Python, Plotly, and Dash. It provides insights into sales trends, customer behavior, product performance, and geographical distribution.

Data Analysis Python Pandas data-visualization matplotlib Plotly Dash sales-analysis
ML Project

Car Price Prediction

Developed a machine learning regression model to predict car prices using Python and scikit-learn. Applied data analysis, preprocessing, feature engineering, and model evaluation techniques to identify the most accurate model.

Python Pandas Machine Learning Scikit-learn Regression Data Analysis Preprocessing Feature Engineering Model Evaluation
Health Analysis

Diabetes Prediction

This project applies several machine learning models to the Diabetes Dataset to predict whether a person is likely to have diabetes. The code includes data loading, model training, evaluation, and visual comparison using metrics such as accuracy, recall, precision, and F1-score.

Python Pandas Machine Learning Scikit-learn Regression Data Analysis Preprocessing Feature Engineering Model Training Model Evaluation

Get In Touch

Mostaql Khamsat
Always Open to collaborations, freelance projects, and exciting data opportunities.