01 / EXPLORE
Analysis & discovery
Finding the signal in the noise and asking better questions.
SQLPythonPandasREDAStatistics
Data Analyst · BI Developer · Cairo, Egypt
Making data make
business sense.
I turn messy data into clear stories, useful dashboards, and decisions teams can move forward with.
A little about meCurious by nature.
Curious by nature.
Analytical by craft.
I’m a Data Analyst focused on turning raw and messy data into clear, actionable insights that support better business decisions. With a background in Business and hands-on experience across SQL, Excel, Power BI, Python, Power Query and Power Pivot, I work across the analytics process — from data cleaning and transformation to analysis, visualization and reporting.
I especially enjoy working with business, marketing and financial data, combining analytical thinking with business understanding to uncover trends and answer real-world questions. I’m also interested in automation and AI tools that make repetitive workflows more efficient.
12INTERACTIVE DASHBOARDS
20TRAINEES LED
My toolkit
Skills & tools
02 / PREPARE
Data cleaning & modelling
Building reliable, consistent data ready for analysis.
Power QueryData validationData modellingExcelSQL
03 / VISUALIZE
Visualization & BI
Turning measures and patterns into clear, interactive views.
Power BITableauLooker StudioPlotlyStreamlit
04 / REPORT
Dashboards & storytelling
Communicating performance and insights to decision-makers.
DAXKPI analysisExcel dashboardsData storytellingPowerPoint
05 / IMPROVE
Business & automation
Connecting analytical output to business needs and better workflows.
Business intelligenceFinancial analysisMarketing analyticsPower Automaten8n
06 / COLLABORATE
Ways of working
Bringing structure, clarity and communication to shared work.
LeadershipPresentationCritical thinkingMicrosoft 365SharePoint
Selected work
Projects in focus
PROJECT 01Car Store Sales Analysis
↗An exploration of car sales performance, surfacing product and revenue patterns through an interactive analytical report.
PROJECT 02Super Store Sales Analysis
↗A retail sales analysis focused on performance trends and practical insights across the Super Store dataset.
PROJECT 03Medical Appointment No-Show
↗SQL and Power BI analysis of appointment attendance, highlighting patient behavior and a no-show rate above 35%.
PROJECT 04Social Media & Mental Health
↗An analysis of population health data exploring how social media use relates to mental health outcomes.
Where I’ve been
Experience
Learning by doing, sharing what I know, and helping teams turn analysis into action.
CURRENT
Amend Business Solutions
Client Financial Advisor
Currently advising clients on financial solutions and supporting their needs through clear, client-focused communication.
AUG 2025 — JUL 2026
Digital Egyptians Pioneers Initiative (DEPI)
Data Analyst Specialist Trainee · Internship
- Led a team of 20 interns, coordinating work and supporting on-time project delivery.
- Applied data collection, cleaning and analysis techniques to datasets of 10,000+ records using Excel, SQL, Python and Power BI.
- Developed 12 interactive dashboards for data-driven decisions and performance monitoring.
MAY — JUN 2026
AperioHub
Business Analyst · Internship
- Conducted market research and business analysis for strategic initiatives.
- Worked with teams to identify business needs and recommend solutions.
JAN — MAR 2026
Empirici
Data Analyst Teaching Assistant · Training
- Taught practical Python, SQL, Excel, Power BI and Tableau concepts using real-world examples.
- Supported students with project feedback and one-to-one guidance; student engagement and exam scores increased by 30%.
Education
Mansoura University · Faculty of Commerce, English Section
Bachelor’s in Accounting · Expected graduation June 2027
The next stepLet’s make something
Let’s make something
clearer together.
Have a data challenge, a role in mind, or an interesting project? I’d be happy to hear from you.
ahmedkamalhikal@gmail.com