I'm a Data-driven Analyst with a background in Communication Engineering and a strong passion for turning raw data into actionable insights. Through hands-on projects and real-world applications, I've developed expertise in Excel , Google Loooker studio , Tableau and seamless data transformations via Power Query and Python. Through dynamic dashboards, interactive visuals, and advanced charting, I help businesses visualize trends, customer behavior, and performance metrics with clarity and impact.
- Excel – Advanced functions, dashboards, pivot tables
- Power Query – clean, transform, and integrate data from multiple sources.
- Python – Pandas, NumPy, Matplotlib, Seaborn
- SQL – Data extraction, joins, filtering, data cleaning
- Tableau / Power BI /Google Looker Studio – Dashboard creation & insight communication
- Data Profiling & Cleaning – Handling missing values, outliers, duplicates
- Documentation & Reporting – Clear business-focused insights
• Collaborated with Leading companies and governmental organizations like :Aramco, GOSI (Saudi Arabia), the Ministry of Defense,Al Nahdi Pharmacies and Bashaer Dawah Assosiation..
• Delivered integrated analytical systems that help organizations track performance, automate reporting, and make data-driven decisions.
• Conducted data analysis and visualization projects for clients, optimizing decision-making and business strategies.
• Developed automated reports using Excel , Google sheets and Looker Studio , reducing manual reporting time by 30%.
• Performed data cleaning, transformation, and modeling, improving data accuracy and insights extraction.
• Created interactive dashboards to stakeholders for strategic decision making.
- Conducted in-depth data analysis using Excel, SQL, Python and Tableau.
- Delivered business-ready dashboards and actionable insights.
- Collaborated in a team environment with continuous feedback and iteration.
Tools Used: SQL , Python and Tableau Analyzed sales data from a US-based superstore to identify trends across regions, categories, and customer segments. Built an interactive Tableau dashboard that revealed underperforming areas and top-selling products. The insights supported strategic decisions in inventory and marketing efforts.
project Link https://github.com/fatma-elshall/DEPI_gradution_project
link of Tableau dashboard: https://public.tableau.com/views/salesproject_17457012015180/salesoverview2?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
Tools Used: Excel
Designed a comprehensive Excel dashboard to analyze call center performance metrics, such as average handling time, resolution rate, and peak hours. Helped improve customer response efficiency by identifying bottlenecks, leading to a 20% reduction in average wait time.
project Link https://github.com/fatma-elshall/Call-center-data-analysis
Tools Used: Excel Cleaned and transformed over 128,000 rows of Amazon sales data to analyze performance by category, SKU, fulfillment type, and region. Identified patterns in order volume, B2B vs B2C behavior, and delivery issues. Produced Excel reports that aided in operational improvement strategies.
project Link https://github.com/fatma-elshall/Amazon-sales-dashboard
Tools Used: Google sheets, Google Looker Studio Explored purchasing patterns in an e-commerce dataset to understand customer behavior by product type, seasonality, and repeat purchases. Performed interactive dashboard using Looker Studio to help improve targeting and retention strategies.
project Link https://github.com/fatma-elshall/Ecommerce-Consumer-Behavior-Analysis
Dashboard link in Google Looker Studio: https://lookerstudio.google.com/reporting/aae6147f-c6c3-4e0f-a3cb-6fb3ccef1bc4
Tools Used: Python, Tableau
Conducted a churn analysis for a telecom company to identify the key factors behind customer attrition. Built predictive visualizations in Tableau and created Python scripts for feature analysis. The project helped define retention strategies for at-risk customer segments.
project Link https://github.com/fatma-elshall/Telecom-Customer-Churn-Analysis
Bachelor’s Degree in Communications Engineering
Al-Azhar University, Egypt
- Email: fatmaelshal24@gmail.com
- LinkedIn: [linkedin.com/in/fatma-elshall ](https://www.linkedin.com/in/fatma-elshall/)
🚀 Always open to collaborating on meaningful data projects or freelance opportunities!