Hybrid

Full-Stack Data Analytics

A practical, hands-on diploma that takes you from zero to advanced across Excel, Power BI, SQL, and Python, with AI tools (ChatGPT/Claude) built into the workflow. You’ll turn raw data into interactive dashboards and actionable business insights.

Hybrid

eyouth Learning Platform | Full-Stack Data Analytics

Overview

The Full-Stack Data Analytics Diploma covers the entire analytics lifecycle: extracting, cleaning, transforming, modeling, analyzing, and visualizing data. The program has five parts: Excel: formulas, XLOOKUP, dynamic arrays, PivotTables, Power Query, Power Pivot, and dashboards. Power BI: data modeling, DAX, interactive reports, and publishing on Power BI Service. SQL: queries, joins, subqueries, CTEs, and window functions. Python: Pandas, NumPy, Matplotlib, Seaborn, SQLAlchemy, and AI-assisted coding. Capstone project: an end-to-end solution that combines all the tools.

Learning Outcomes

AI integration use ChatGPT/Claude and prompt engineering to write scripts, optimize queries, and automate workflows.
Storytelling & capstone combine all tools into an end-to-end data pipeline and deliver professional presentations.
Excel & Power Query perform advanced data cleaning, modeling, dynamic array calculations, and Power Pivot data modeling.
Power BI & DAX build interactive dashboards, write complex DAX measures, and publish reports on Power BI Service.
SQL write complex queries with joins, aggregations, CTEs, and window functions to extract data from relational databases.
Python clean, manipulate, transform, and visualize large datasets with Pandas, NumPy, Matplotlib, and Seaborn.

Instructor

Mahmoud Eidarous

Data Professional & Instructor | 7+ Years Experience Domain & Industry Experience: ● Telecommunications (Current): Data Analyst Lead at VOIS (Vodafone Intelligent Solutions), in the Data & Business Insights team. I lead the migration of reporting from legacy systems to Google Cloud Platform (BigQuery & Looker Studio) and build dashboards for project managers and leadership. ● Diverse Sector Background: Previous experience across E-commerce & Logistics (Noon), FMCG & Sales (Froneri – Nestlé Ice Cream), and Print-on-Demand (iPrint), focused on business analytics and operational optimization. --------------------------------------------------------------- Tools & Technologies: ● Cloud & Database: Google Cloud Platform (GCP), BigQuery, SQL Server, SQL (Advanced). ● Data Visualization & BI: Power BI (DAX, Data Modeling), Looker Studio, Tableau. ● Data Engineering & ETL: SSIS, SSAS, Power Query. ● Programming & Analysis: Python (Pandas, NumPy), Excel (Advanced). --------------------------------------------------------------- Instruction & Leadership: ● Freelance Instructor: Partner with NTI, EYouth and YAT to deliver data analysis training under DEPI (Digital Egypt Pioneers Initiative), Egypt's national program to upskill the digital workforce. I've taught and mentored 200+ learners, many now working as data analysts in leading organizations. ● Curriculum Development: Design course materials, labs and capstone projects that other instructors use in their own delivery. ● Internal Training at VOIS: Upskill cross-functional teams on GCP tools and modern data workflows so migration projects get adopted smoothly. --------------------------------------------------------------- Academic Background: ● Postgraduate Diploma: Artificial Intelligence, Information Technology Institute (ITI). ● Bachelor's Degree: Computers and Systems Engineering, Ain Shams University.

1 Training Courses0 Learners

Profile Page

190 $

This course contains the following:

Duration

Accredited Certificate of Completion :

Lifetime Access

Language: Arabic

190 $

Full-Stack Data Analytics

Fahym

Fahym

Full-Stack Data Analytics

Made by Mahmoud Eidarous

This course contains the following:

Overview

Live Broadcast Times

Lecture Schedule:

Learning Outcomes

Who should Enroll

Instructor

Mahmoud Eidarous

Centers

This course contains the following: