Asmaa Zaher

Data Analyst

Data-driven professional with hands-on experience in managing, cleaning, and analyzing structured datasets to drive informed decision-making. Skilled in Excel, performance tracking, and data control processes, with a strong ability to transform raw data into actionable business insights. Currently mastering advanced data visualization, dashboard creation, and data modeling using Power Pivot and Pivot Tables. Passionate about identifying operational patterns, improving efficiency, and supporting business outcomes through clear, impact-driven reporting

Giza,Egpt

Projects

Marketing Analytics Project

An interactive dashboard built with Power BI that leverages Data Cleaning, Normalization, Star Schema modeling, and advanced DAX measures to optimize marketing spend and analyze campaign performance.

Built a comprehensive analytics solution to optimize marketing spend and regional performance. Managed the full data lifecycle, including Data Cleaning and Normalization via Power Query. Architected data using Star Schema modeling and developed dynamic DAX measures to visualize key insights and improve decision-making.

Power BIPower QueryStar SchemaDAXNormalizationData Cleaning

Project link

IMDb Movie Analytics Project

An interactive dashboard built with Power BI that leverages Data Cleaning, Normalization, and Star Schema modeling with advanced DAX measures to analyze and visualize global movie ratings, trends, and viewership performance.

Developed a comprehensive dashboard to visualize movie trends, ratings, and viewership distribution. Managed the full data lifecycle, including Data Cleaning and Normalization via Power Query to ensure data integrity. Architected data using Star Schema modeling and implemented complex DAX measures to analyze performance metrics across different decades and movie classifications.

Power BIPower QueryStar SchemaDAXNormaliztionData Cleaning

Project link

Bank Customer Churn Analysis Project

An interactive dashboard built with Excel that leverages Data Cleaning and Normalization to streamline data preparation, enabling in-depth visualization of customer churn behavior, spending patterns, and retention drivers.

Developed a comprehensive dashboard to analyze customer churn behavior and identify key retention drivers. Managed the full data lifecycle, including Data Cleaning and Normalization to ensure data accuracy and integrity. Built a structured data model and utilized advanced Excel functions and interactive tools to visualize key performance metrics such as churn rates, spending patterns, and customer activity levels.

ExcelPower QueryDaxPower PivotStar SchemaData CleaningNormalization

Project link

Sales & Shipping Analytics Project

An interactive dashboard built with Excel that leverages Data Cleaning and Normalization to streamline data preparation, enabling comprehensive visualization of sales trends, order quantities, and shipping cost performance.

Developed an interactive dashboard to monitor total sales, order quantities, and shipping costs. Streamlined data preparation by performing comprehensive Data Cleaning and Normalization to optimize the dataset for accurate analysis. Built a structured data model and utilized advanced Excel tools to visualize key performance metrics such as profit margins and regional sales distribution.

ExcelPower QueryData CleaningDaxStar SchemaPower PivotNormaliztion

Project link

Skills

Data AnalysisBusiness IntelligenceData VisualizationReporting & InsightsExcelPower BIStatisticsProblem SolvingAnalytical ThinkingAttention to DetailCommunication SkillsTeamworkTime Management

Education

Excel, Power Bi Data Analysis Diploma

Growth level Academy

Certification

Bachelor of Specific Education, Department of Music

Cairo University

Sep 2009 - Jun 2013

Other

Links

LinkedIn CV

Contact

Open to wok

Let’s connect. Choose the fastest way to reach me.

semamd63@gmail.com

Fastest response via email.

Email me

Phone

+201129745423

Call WhatsApp