Maged Kamal

Maged Kamal

Quality Assurance Analyst en Huawei Consumer Business Group

Derecho en Ain Shams University

Egipto

Acerca deEventosCanalesComunidades

¡Hola, soy Maged Kamal!

Quality Assurance Analyst en Huawei Consumer Business Group

I am a professional data analyst who have concluded many projects using SQL, Excel, Python and visualized data using Tableau and Power BI. I managed within the data that I got to extract insights from qualitative / quantitative data and visualize impactful dashboard for business requirements which created impact in decision making. Also, I have sharpened my data analytics skills during my learning journey at Udacity platform sponsored by the Ministry of Communications 'FWD' initiative, where I solved real world problems through data analysis.

Redes sociales

Experiencia

Educación

Certificaciones y Distintivos

No se agregó certificaciones o distintivos

Proyectos

Excel - Ecommerce Business Interactive Dashboard

https://github.com/Maged27/Interactive-Excel-Dashboard/blob/main/Interactive%20Excel%20Dashboard.xlsx

Part-Time

I have create an impressive and interactive Excel Dashboard from scratch by combining Pivot Tables, Pivot Charts, Slicers, and a beautiful design concept for an E-Commence Business.

Project overview:
To complete my Data Analysis professional project I have used TMDb movies dataset that Udacity provided us with. This data set contains information about 10 thousand movies collected from The Movie Database (TMDb).

In this project I did the following:
Cleaned, removed duplicates and renamed columns in the DataFrame.
Concluded some insights from the data, like the highest budget and the lowest movie income in the past 150 years.
Used matplotlib to visualize data in charts.

I have created this dashboard in which I gathered real data about Data Professionals!

Topics:

  • Cleaning & transforming data in Power Query
  • Data visualization using Power BI

    This dashboard answers the following questions:

  • When was this survey taken
  • How many respondents
  • Average yearly salary by job title
  • Average yearly salary by industry
  • Favorite programming language
  • Salary happiness rating
  • Work-life balance happiness rating
  • Countries of survey takers
  • Difficulty levels of breaking into data

DTI is an important part of your overall financial health. I have created an interactive Excel sheet to help you calculate DTI ratio (debt-to-income).

In this project I have used MySQL to find insights related to salaries based on gender and I used tableau for the viz.
SQL clause used:
ORDER BY
GROUP BY
HAVING
JOIN
Aliases

Tableau skills used:
Dashboard building
Connecting SQL with Tableau
Data filtering

Idiomas

Árabe

Nativo

Inglés

Profesional

Francés

Principiante

Habilidades

Data Analysis

Data Analytics

SQL

Excel

Python

Analysis and Reporting

Tableau

Trello

Power BI

JIRA

Analyst

Localized conecta a estudiantes universitarios y recién graduados con expertos de la industria y empleadores.

footer.learners.labelfooter.learners.learnfooter.learners.eventsfooter.learners.jobsfooter.learners.experts
footer.partners.labelfooter.partners.partnerWithUs

PrivacidadTérminosMapa del sitio

©2025 Localized, Inc. Todos los derechos reservados.

¿Listo para una experiencia personalizada? Utilizamos cookies y tecnologías similares para adaptar nuestro sitio especialmente para ti. Al hacer clic en 'Aceptar', nos das luz verde para utilizar cookies y tecnologías similares. 🍪