Asmaa Zaher

Marketing Analytics Project

Built a comprehensive analytics solution to optimize marketing spend and regional performance. Managed the full data lifecycle, including Data Cleaning and Norm

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.

IMDb Movie Analytics Project

Developed a comprehensive dashboard to visualize movie trends, ratings, and viewership distribution. Managed the full data lifecycle, including Data Cleaning an

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.

Bank Customer Churn Analysis Project

Developed a comprehensive dashboard to analyze customer churn behavior and identify key retention drivers. Managed the full data lifecycle, including Data Clean

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.

Sales & Shipping Analytics Project

Developed an interactive dashboard to monitor total sales, order quantities, and shipping costs. Streamlined data preparation by performing comprehensive Data C

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.

Adidas Sales & Customer Insights Dashboard

Developed an interactive, multi-page Power BI dashboard to analyze retail performance, tracking 7M EGP in Revenue and 4M EGP in Profit across 214K+ orders. Implemented an optimized Star Schema data model and utilized advanced DAX to calculate dynamic profit margins, monthly trends, and product performance metrics. Visualized critical customer demographics and distribution channel performance (Franchise vs. Retail) to enhance strategic decision-making. Designed a clean user interface with a custom navigation home page and global slicers for seamless interactivity.

Superstore Sales & Performance Dashboard

Developed an interactive dashboard tracking $2.30M in Sales and $286.40K in Profit across 9,994 orders. Performed Data Cleaning and transformation in Power Query to ensure data integrity and quality. Applied Data Normalization to build an optimized Star Schema model for efficient querying. Utilized advanced DAX to analyze operational KPIs across shipping modes, regions, and categories. Designed a clean UI with interactive slicers and a Decomposition Tree for deep-dive analysis.

HR & Salary Analytics Dashboard

Developed an Excel dashboard analyzing workforce metrics and a 1.31M Total Salary budget. Used Power Query for Data Cleaning and structured a normalized data model via Power Pivot. Created dynamic Pivot Tables to analyze performance, salaries, and experience by location. Designed a clean visual interface with interactive Slicers for quick human resources insights.