Filopater Maged
Data Analyst | Business & Sales Analytics
Transforming data into clear business decisions. Specialized in Excel • Power BI • SQL — building dashboards and reports that drive measurable results.
About Me
I help businesses turn messy, unorganized data into clear insights and powerful dashboards that support smarter decisions. My work focuses on cleaning and structuring raw datasets, building interactive Power BI and Tableau dashboards, and automating Excel reports that save time and remove manual tasks.
Data Cleaning & Structuring
I standardize formats, remove duplicates, and create analysis-ready tables that scale.
Dashboards & Visualization
I design interactive dashboards that answer business questions and highlight trends.
Automation & Reporting
Automated Excel reports and KPI trackers that reduce manual effort and improve accuracy.
Flexible budget approach: I deliver scoped solutions from one-off analyses to full reporting systems — each with clear deliverables and measurable value.
Education
I hold a Bachelor's degree relevant to business, accounting, or a data-focused field. My academic foundation combines financial principles with analytical techniques to interpret business performance and support decision-making.
Bachelor’s Degree
BIS TANTA University
Focused coursework in accounting, finance, and business analytics — building the foundation for data-driven financial analysis.
AI-Based Accounting Concept
Developed an idea integrating financial analysis and automation with AI concepts to streamline accounting workflows and deliver predictive insights.
Continued learning in Power BI, SQL, and advanced Excel keeps my skills current and practical for business applications.
Skills
Technical Skills
  • Microsoft Excel — Advanced formulas, Pivot Tables, Power Query
  • Power BI — Data modeling, DAX, interactive dashboards
  • SQL — Data extraction, joins, performance-aware queries
  • Data cleaning & transformation — ETL using Excel and Power Query
  • KPI development & tracking
  • HTML basics • C# Windows Forms (OOP)
Analytical Strengths
  • Business-oriented thinking — align analysis to commercial goals
  • Data storytelling — translate numbers into actions
  • Logical problem solving & attention to detail
  • Performance analysis focused on sales and customer metrics
I blend technical competence with business context to deliver insights that stakeholders can act on immediately.
Experience
Sales Data Analysis
Analyzed synthetic and structured sales datasets; built Pivot Tables for region-revenue, customer segments, and product performance; created dashboards to track KPIs and seasonality.
Power BI & Reporting
Designed interactive Power BI dashboards for revenue tracking and trend analysis, enabling quicker business decisions and clearer executive summaries.
Automated Excel Reporting
Developed automated Excel reports and KPI trackers that reduced manual processing and improved reporting cadence.
Software Development (C#)
Built a fast-food ordering system using Windows Forms and OOP concepts — focusing on structured business logic, classes, inheritance, and maintainable code.
Across projects, I emphasize clean data, reproducible processes, and visual storytelling that drive measurable improvements.
Services
Data Cleaning & Structuring
Prepare messy data for analysis — standardized fields, deduplication, and normalization for reliable reporting.
Power BI Dashboard Development
Custom, interactive dashboards that surface KPIs and business insights tailored to stakeholders.
Automated Excel Reports
Scheduled, reproducible reports and KPI trackers that eliminate repetitive manual work.
Sales & Revenue Analysis
Segmentation, trend detection, and performance breakdowns to identify growth opportunities.
SQL Data Extraction
Reliable data pulls and optimized queries to feed models and dashboards.
Business Insight Reporting
Actionable reports that connect analytics to strategy with clear recommendations.

Flexible budgets: from short analyses to full reporting systems — each engagement comes with clear deliverables and ROI-focused outcomes.
Projects
Sales Performance Analysis
Region vs revenue, customer segment vs quantity, product category performance, and payment method insights — designed to reveal where to invest and where to optimize.
KPI Dashboard (Power BI)
Revenue tracking, product monitoring, segment comparison, and visual trend analysis to support weekly and monthly decision cycles.
Business System Development (C#)
Fast-food ordering system built with OOP principles; focused on business logic, maintainability, and workflow efficiency.
Get in Touch
Ready to turn your data into decisions? I’m available for freelance, contract, and consulting projects. I work with teams of all sizes and adapt deliverables to budgets and timelines.
If you prefer, share a brief project summary and your budget — I’ll propose a clear plan with milestones and expected impact.
Thank You
Thank you for reviewing my portfolio. I appreciate your time and interest in my work.
I look forward to helping businesses make smarter, data-driven decisions — from cleaning and structuring raw data to delivering dashboards that guide strategy and growth. Reach out anytime to start a conversation.
Available for hire
Flexible schedule
Made with