collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
SQL based data profiling & data quality checks, which will help you to perform data profiling & data quality checks on SQL database at table & database level.
ERD Creation, SQL database implementation, Encryption, Computed columns, SQL functions, PowerBI reports
Exploratory Data Analysis using SQL in SQL Server Management Studio 19. Incorporated queries for KPIs Calculation (mathematical operations), sorting, data type conversions, joins and aggregations, Common Table Expressions (CTEs), Temporary Tables, Window Functions, Table Manipulation (Feature Engineering) etc.
Host Behaviour Analysis for Property Rental Company
🚀 Excited to share my latest project, a Bank Loan Analysis Dashboard developed in Power BI. This dashboard provides a consolidated view of key metrics, offering deep insights into loan applications, funding, and repayments.
An in-depth Exploratory Data Analysis (EDA) project that leverages Python libraries like Pandas, Matplotlib, and Seaborn to uncover trends, patterns, and insights from datasets, preparing the data for further analysis or modeling.
Welcome! This repository houses an analysis of international debt data supplied by The World Bank. The dataset includes details about the indebtedness (in USD) of developing countries, classified under various indicators. The aim of this analysis is to delve into and address fundamental inquiries concerning international debt.
A Full Data Analysis project where a sales data is ask,prepare,process,analyze,share and act through data analysis process
To contribute to business by utilizing data analysis techniques and creating an executive Dashboard using Tableau.
This project analyzes a coffee shop’s transaction dataset to uncover sales trends, customer behavior, and product performance. It combines SQL queries for data exploration with a Power BI dashboard for interactive visualization. The goal is to demonstrate beginner-to-intermediate level skills in SQL data analysis and Power BI reporting.
Ad-hock analysis of requests for HardWare company in MS SQL
This project cleans and prepares a layoffs dataset using SQL by removing duplicates, standardizing text, handling null/blank values, and dropping unnecessary columns. The result is a consistent, high-quality dataset ready for reporting, analysis, and visualization.
SQL: Cleaning,Wrangling and Exploring the Data; Excel: Created an Interactive Dynamic Dashboard using Pivot Tables and Pivot Diagrams
Processing covid data in SQL to show it in Dashboard.
This project presents a comprehensive data analysis for the Information Technology Institute (ITI) training system, which includes 9 branches (Smart Village , Alexandria, Assiut, Mansoura ,Ismailia , Luxor , Aswan , Beni Suef , Port Said) across different locations. The data involves students from various countries
🎯 Sales Dashboard Project using SQL + Power BI | Built on AdventureWorksDW2019 | Cleaned, transformed, and visualized internet sales data to practice real-world Data Analyst skills
A scalable and optimized data warehouse solution designed for efficient data integration, transformation, and analytics. This project demonstrates ETL workflows, dimensional modeling, and query performance tuning using modern data warehousing practices.
My final project for my Data Analytics trainings course
Add a description, image, and links to the dataanalysis topic page so that developers can more easily learn about it.
To associate your repository with the dataanalysis topic, visit your repo's landing page and select "manage topics."