Amrazzam10
I'm Amr Azzam, a passionate computer science graduate with a knack for data and analytics.
Pinned Repositories
sales-data-mart-
Utilizing the AdventureWorks2014 dataset, I have successfully constructed a Sales Data Mart through the powerful features of SQL Server Integration Services (SSIS) and SQL Server Modeling. This Data Mart proves to be a pivotal asset in the overarching goal of effective data management and analytics within organizational frameworks.
FIFA-WORLD-CUP-1930-2018
combining SQL for data preparation and Power BI for visualization and analysis. Adjustments can be made based on specific dataset structures and analytical goals.
Pizza-Report-Project
The Pizza Report Project provides a framework for analyzing pizza business data, offering insights into sales, customer preferences, and ingredient usage through the combined use of SQL and Power BI. Adjustments can be made based on specific business requirements and dataset structures.
Supermarket-Dashboard
The Supermarket Dashboard project is a comprehensive data analysis solution designed to provide insights into the sales performance
AdventureWorksSalesReport
The AdventureWorks Sales Report project aims to provide comprehensive insights into sales data using Power BI. It involves the creation of a data model comprising a fact table and dimension tables, the utilization of DAX measures and KPIs, and the development of visualizations to answer specific questions about the data.
Clothes-Store-Analysis
The Clothes Store Analysis project aims to provide a comprehensive understanding of our store's performance through data-driven insights. By leveraging ETL processes, SQL, and Power BI, we analyze key metrics and trends to enhance decision-making and drive business growth.
-Maven-Coffee-Shop-Sales
Maven Coffee Shop Sales Analysis repository! This project focuses on analyzing sales data from Maven Coffee Shop using Power BI, a powerful business intelligence tool. The goal of this analysis is to extract actionable insights from the data to optimize business operations, enhance customer experience, and drive revenue growth.
Accidents-United-Kingdom-dashboard
The "Accidents United Kingdom Dashboard" in Power BI is a data visualization project that leverages real-world accident data to provide comprehensive insights into road accidents in the United Kingdom. This interactive dashboard is built using Power BI to facilitate data exploration and analysis.
Football-Player-Transfers-Analysis-2000-2019-
This project aims to analyze football player transfers from 2000 to 2019 using Power BI.
Friends-Dashboard
The Friends TV Show Dashboard in Power BI offers a comprehensive visualization of insights derived from the iconic sitcom's seasons and episodes
Amrazzam10's Repositories
Amrazzam10/Clothes-Store-Analysis
The Clothes Store Analysis project aims to provide a comprehensive understanding of our store's performance through data-driven insights. By leveraging ETL processes, SQL, and Power BI, we analyze key metrics and trends to enhance decision-making and drive business growth.
Amrazzam10/Football-Player-Transfers-Analysis-2000-2019-
This project aims to analyze football player transfers from 2000 to 2019 using Power BI.
Amrazzam10/AdventureWorksSalesReport
The AdventureWorks Sales Report project aims to provide comprehensive insights into sales data using Power BI. It involves the creation of a data model comprising a fact table and dimension tables, the utilization of DAX measures and KPIs, and the development of visualizations to answer specific questions about the data.
Amrazzam10/sql-music-store-analysis
This project aimed to create a robust relational database structure focusing on establishing comprehensive relationships between tables to significantly enhance data organization and accessibility. Additionally, advanced SQL skills were applied to craft queries that effectively address specific questions.
Amrazzam10/Supermarket-Dashboard
The Supermarket Dashboard project is a comprehensive data analysis solution designed to provide insights into the sales performance
Amrazzam10/Friends-Dashboard
The Friends TV Show Dashboard in Power BI offers a comprehensive visualization of insights derived from the iconic sitcom's seasons and episodes
Amrazzam10/Pizza-Report-Project
The Pizza Report Project provides a framework for analyzing pizza business data, offering insights into sales, customer preferences, and ingredient usage through the combined use of SQL and Power BI. Adjustments can be made based on specific business requirements and dataset structures.
Amrazzam10/-Maven-Coffee-Shop-Sales
Maven Coffee Shop Sales Analysis repository! This project focuses on analyzing sales data from Maven Coffee Shop using Power BI, a powerful business intelligence tool. The goal of this analysis is to extract actionable insights from the data to optimize business operations, enhance customer experience, and drive revenue growth.
Amrazzam10/FIFA-WORLD-CUP-1930-2018
combining SQL for data preparation and Power BI for visualization and analysis. Adjustments can be made based on specific dataset structures and analytical goals.
Amrazzam10/Tableau-Financial-customer-Complaints
This project provides an interactive Tableau dashboard for visualizing financial customer complaints data. The dashboard is designed to offer insights into complaint trends, key metrics, and patterns
Amrazzam10/Accidents-United-Kingdom-dashboard
The "Accidents United Kingdom Dashboard" in Power BI is a data visualization project that leverages real-world accident data to provide comprehensive insights into road accidents in the United Kingdom. This interactive dashboard is built using Power BI to facilitate data exploration and analysis.
Amrazzam10/Sales-starschema
This repository contains the source code and documentation for my AdventureWorks Sales Analysis project implemented using Power BI. The project follows a star schema data model for effective data analysis and visualization.
Amrazzam10/ks-salesproject
Data cleaning and visualization
Amrazzam10/tableau-dashboard
HR tableau dashboard
Amrazzam10/sales-power-bi-project
A results-driven sales professional with a strong foundation in data modeling, DAX, and visualization techniques
Amrazzam10/power_bi_projects
Amrazzam10/sales-data-mart-
Utilizing the AdventureWorks2014 dataset, I have successfully constructed a Sales Data Mart through the powerful features of SQL Server Integration Services (SSIS) and SQL Server Modeling. This Data Mart proves to be a pivotal asset in the overarching goal of effective data management and analytics within organizational frameworks.
Amrazzam10/SQL
sql projects