Abdul Data Analyst

From 3 Hours to 20 Minutes with Smart Data Solutions
Excel • SQL • Python • Power BI • AWS • Microsoft Fabric • Linux • Google Sheets

Coffee Sales Analytics EXCEL

Transformed NYC coffee sales data into interactive dashboards. Optimized reporting from hours to minutes and highlighted peak sales hours & top products.
Excel Power Query Pivot Tables Charts

🍕 Pizza Sales Analytics Excel

Analyzed one year of pizza sales data to uncover customer behavior, peak hours, and revenue trends. Transformed raw data using Power Query and built dashboards to highlight top-selling products and seasonal performance.

Excel Power Query Pivot Tables Charts

🏥 Hospital Data Analysis (SQL)

Analyzed hospital patient data (2011–2022) to uncover trends in admissions, readmissions, length of stay, and costs. Queried and aggregated data using SQL to generate insights for healthcare operations and decision-making.

sql Joins Aggregation Data Exploration

🚆 Rail Ticket Data Analysis (Power BI)

This project analyzes mock National Rail train ticket data in the UK from Jan–Apr 2024. The dataset includes ticket types, travel dates & times, departure & arrival stations, prices, and journey status.

Power Bi Power Query Dax Visuals

Train-Ticket-Python Data Cleaning

Cleaned and prepared the NYC 2020 Accident dataset for analysis. The dataset contains information about vehicle types, contributing factors, locations, and casualties. Used Python, Pandas, and Numpy for data cleaning.

Python Jupyter Notebook Pandas Numpy

🏗️ Medallion Architecture (Microsoft Fabric)

Built an end-to-end data pipeline using Microsoft Fabric, transforming raw data into structured insights through Lakehouse, Data Warehouse, and Semantic Model layers for reporting and analytics.

Microsoft Fabric Medallion Architecture Lake House Sementic Model

NYC Accident Analysis – Microsoft Fabric

End-to-end analysis of NYC motor vehicle accidents using Microsoft Fabric and Power BI. This project demonstrates data ingestion, transformation, semantic modeling, and interactive dashboards to uncover accident trends and insights..

Microsoft Fabric Medallion Architecture Lake House Sementic Model