Data Analysis using Excel & Power Bi course

Home
Courses

Data Analysis using Excel & Power Bi course

Data Analysis using Excel & Power Bi course

Specialties Management courses

4

EGP 4000

Description

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 ita.co (R.N: 12909)

Courses Video

section 1: Fast revision on the basic of excel
- lesson 1 Preview
  
  minute

section 2: Pivot table & Dashboard
- lesson 2 Locked
  
  minute

section 3: Power Query
- lesson 3 Preview
  
  minute

section 4: Data Modeling
- lesson 4 Preview
  
  minute

FAQ's

Are there discounts?

Yes, in the case of friends, relatives and sisters
Do you have online and offline courses?

Yes, we have online and offline courses
Is there hall rental?

Yes, we have multiple systems for renting halls
Are there installment systems?

Yes, we have it
What are installment systems?

If the course amount is more than one thousand Egyptian pounds
-    30% of the course/course/workshop price is paid as an advance payment for the reservation.
-    Then 30% after the third lecture
-    Then 30% in the fifth lecture
If the course is less than a thousand pounds
-    50% is paid for the reservation
-    50% maximum for the second lecture

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

Register now