Data Analysis using Excel & Power Bi course

Data Analysis using Excel & Power Bi course

EGP 4000


Course Objectives 
•    Build a solid understanding on the Basics of Microsoft Excel
•    Learn the most common Excel functions used in the Office
•    Harness the full power of Microsoft Excel by automating your day to day tasks 
•    Maintain large sets of Excel data in a list or table
•    Create dynamic reports by mastering one of the most popular tools, PivotTables
•    Wow your boss with powerful insights 
•    Connect & Load your data from different extension sources 
•    Transform data using power query
•    Modeling data  
•    Visualize your data using Power Bi  

Course Language
•    Arabic but most terminology is in English. 
•    Training can be presented in English only based on request.

Course Methodology
Training methods and techniques are almost infinite in their variety. They can be used on their own or in creative combination. However, they should be chosen carefully to fit the activity, the nature of participants, the cultural milieu and the facilities available for using them. We use different methodologies in training to ensure good communication of information to all trainees - but not limited to the following:

•    Lectures and PowerPoint Presentation 
•    Case Studies, Self-Questioner and Real-World Scenarios 
•    Visual Aid (Videos Simulation) 
•    Brainstorming (Perception Activity)
•    Gamification (Puzzles)

Course Prerequisites
•    Laptops should provide with each participants  

Course Assessment & Certification 
•    This course is assessed by Three main project (Power Query+ Power pivot+ power Bi) 
•    Trainees will receive A4 Certificate and course transcript from (R.N: 12909)

Courses Video



  • sections: 4
  • Feature: Yes
  • Duration: 40 Hours
  • Specialties: Management courses
  • Quizzes: Yes
  • Language: Arabic
  • Certificate: Yes

Course Syllabus

  •  Fast revision on the basic of excel    
  • Pivot table & Dashboard
  • Power Query    
  •  Data Modeling
  •  DAX 
  •  Visualization using Excel & power bi

Register now