A C T A I A
Data Analysis
  • Excel and Power BI
  • Course Description:

  • This Course provides a practical journey into data analysis using Excel and Power BI

  • It starts with foundational statistical concepts and Excel skills, then progresses to advanced data transformation, modeling, and dashboard design in Power BI

  • Through real-world projects and a final capstone, you will develop strong analytical thinking and the ability to deliver insights that support business decision-making

  •  
  • Course Main Points:

  • > Excel for Data Analysis
  • – Introduction to Data Analysis
  • – Excel Introduction (Interface, Shortcuts, Basic Functions)
  • – Statistics in Excel, Advanced Functions
  • – Data Visualization
  • – Data Exploration
  • – Power Query,Power Pivot, Data Modeling and Relationships
  • > Power BI for Data Analysis
  • – Introduction to Power BI
  • – Data Modeling Basics
  • – Data Visualization in Power BI
  • – Introduction to DAX (Data Analysis Expressions)
  • – Advanced DAX Functions (Time Intelligence, Aggregations)
  •  
  • Course Duration:

  • 66 Hrs

  •  
  • Instructor Bio:

  • Eng Aya Farg

  • A Data Analyst specialist and technical Coach who transitioned from engineering in satellite systems to business-focused data analytics
  • She has trained over +500 learners through platforms such as Depi iSchool, Almentor, and Hi Deep AI, utilizing tools including Python, SQL, Excel, Power BI, Tableau, and AI tools
  • She helps aspiring analysts and professionals build the skills they need to analyze data confidently, create dynamic dashboards, and extract KPIs that support smart business decisions
  •  
Get Quick Support

Request a Call Back

Ready to explore how artificial intelligence can revolutionise your business operations and unlock new efficiencies? ACTAIA is here to guide you through every step of the transformation journey.

Call Us Now

Office Address

Cairo, Egypt | Global Reach