Analyzing the sales of a store called "My Galaxy Store"

A VBA application for geocoding and reverse geocoding in Microsoft Excel. Supports both Google's free and enterprise for business geocoder (Google Maps APIs for Business, Google Maps for Work or Google Maps).

Insightful Coffee Shop Sales Dashboard in Excel, highlighting peak hours, trends, and actionable insights.

📊 Power BI Dashboard: Shaqra University Student Statistics

This repository hosts the codebase for a comprehensive Road Dashboard designed for the years 2021 and 2022. The dashboard provides valuable insights into road safety metrics, aiding in understanding and analyzing various aspects of road accidents and casualties. Developed for our client, this dashboard aims to enhance awareness and decision-making

This repository contains the Cube Cycles Sales Report Dashboard project, which visualizes sales data using excel. It provides key insights into sales performance, monthly trends, and segment-wise analysis to support data-driven decision-making. The project leverages SQL for data management and retrieval, and Excel for interactive visualization.

Dynamic Paris 2024 Olympics medal count analysis using Microrosft Power BI, MS Excel and data analytical principles.

A Power BI analysis of credit card transactions and customer demographics, focusing on revenue, transaction volume, and customer segmentation by gender, age, and education. The interactive dashboards offer insights into financial performance and customer behavior. Included are the Power BI file, datasets, and key visualizations.

This project analyzes sales data from a Brazilian e-commerce store (2016-2018) to identify sales trends across states. Objectives include pinpointing states with increasing or declining sales, conducting root cause analysis, and providing recommendations for improvement.

Power BI dashboarding project using MS Excel, power query, indexing, Microsoft Power BI.

Problems solved

A Live Table Editor like Microsoft Excel and Google Sheets From Scratch Using HTML, CSS, Core PHP, Vanilla JavaScript, and MySQL Database, With my Live Table Editor You can edit your data in database directly from an HTML table in Real-Time without any page refresh.

Crime Case in Los Angeles 2020-2024

In our Zomato dataset journey 🍽️, we've refined data to its peak. Using Excel 📈 and Python 🐍, we meticulously cleaned restaurant names with regular expressions 🔍, ensuring authenticity. Our 'zomatocleaned.csv' now captures the true dining essence 🍴, showcasing our commitment to culinary precision 👨‍🍳.

Scripts for automating data extraction, transformation, and loading (ETL) tasks in Microsoft Excel and Power BI. These scripts simplify data manipulation and enhance productivity and collaboration.

"Excel-powered HR Dashboard for data-driven insights into employee metrics and trends. Visualize attrition rates, gender distribution, and more for strategic HR decision-making. #HRAnalytics #DataDriven #ExcelDashboard"

In this project, I developed a model to predict the winner of FIFA World cup 2022, and built an interactive dashboard using Power BI.

This data analysis project focused on examining Covid-19 vaccine data up to December 31, 2023, to extract valuable insights and trends using Microsoft Power BI.