Nouran Tarek
Data Analyst Specialist
Data Analyst Specialist
I help turn raw data into clear, visual insights that support better decisions.
With strong skills in SQL, Excel, Power BI, and data analysis, I focus on making numbers simple, accurate, and meaningful.
I care about details, communication, and delivering results that clients can actually use.
Always learning and improving — because good data tells great stories.
With strong skills in SQL, Excel, Power BI, and data analysis, I focus on making numbers simple, accurate, and meaningful.
I care about details, communication, and delivering results that clients can actually use.
Always learning and improving — because good data tells great stories.
Education
2024 – 2028 | Alexandria, Egypt
Faculty of Business Alexandria University
Faculty of Business Alexandria University
I am pursuing my degree in Business with a focus on Data Analytics, where I develop strong foundations in management and strategy alongside advanced skills in data analysis, visualization, and data-driven decision-making.
Business Performance Analysis
(Collaborative Project)
(Collaborative Project)
Developed an Excel-based dashboard that provides a 360° view of business performance, enabling data-driven decisions across different functions.
Main Highlights:
- Leadership Overview: Snapshot of essential KPIs (revenue, volume, profit, and return rates) designed for executive use.
- Regional & Store Breakdown: Comparative analysis of performance by geography and store categories.
- Customer Analysis: Explored purchase patterns, membership tiers, and payment methods to identify key customer groups.
- Product Evaluation: Assessed brand- and category-level profitability to detect top and low performers.
- Operational Monitoring: Tracked efficiency metrics and measured the business impact of product returns.
E-Commerce Sales & Performance Analysis
(Collaborative Project)
(Collaborative Project)
This project focuses on analyzing multi-year e-commerce sales data to understand product performance, revenue trends, and the relationship between website transactions and product launches.
Using SQL for data extraction and cleaning, I calculated key metrics such as net revenue per product, taking into account refunds and product launch dates. The cleaned and aggregated data was then visualized to show how each product performed over time and how new product releases affected overall sales performance.
The project provides valuable insights for strategic decision-making, such as identifying top-performing products, understanding seasonality, and evaluating the financial impact of new launches.
Tools Used: SQL, Power BI
Retail Sales Performance
This project involved analyzing a retail sales dataset to generate actionable insights that inform decision-making at various business levels.
In this project, I worked on a comprehensive analysis of retail sales data to generate insights that guide decision-making at different organizational levels.
- Data Preparation: Transformed raw data into a clean, reliable dataset by fixing errors and ensuring consistency.
- Analytical Scope: Developed key business questions around product trends, regional performance, salesforce productivity, and strategic KPIs.
- Visualization & Insights: Built interactive dashboards tailored to various stakeholders:
- Management View: Summarized revenue, closed deals, and performance by region/sector.
- Salesforce Dashboard: Tracked results and contributions of individual agents and managers.
- Product Analysis: Highlighted bestsellers as well as products needing attention.
- Regional Overview: Showed distribution of sales and growth dynamics across markets.
