inline-defaultCreated with Sketch.
inline-defaultCreated with Sketch.
HomeUniversitiesProgramsStudents & Alumni
search
Students
Courses

Data Analysis with Excel and Power BI

German University in Cairo GUC
Cairo , Egypt
Visit Program Website
Students
Tuition Fee
Not Available
Start Date
Not Available
Medium of studying
Not Available
Duration
60 hours
Details
About Program
About University
Gallery
Contact School
Details
Program Details
Degree
Courses
Major
Data Analysis | Data Science
Area of study
Information and Communication Technologies | Mathematics and Statistics
Course Language
English
About Program

Program Overview

Program Overview

The Data Analysis with Excel and Power BI program is designed to equip trainees with the skills to apply fundamental Excel functions and formatting techniques for effective data analysis. By the end of the course, participants will be able to utilize Named Ranges, Lookup Functions, and Conditional Functions proficiently in data analysis tasks, demonstrate proficiency in creating Pivot Tables, Slicers, and Pivot Charts, and employ methods for data analysis.


Program Objective

The program objective is to enable trainees to:


  • Apply fundamental Excel functions and formatting techniques for effective data analysis
  • Utilize Named Ranges, Lookup Functions, and Conditional Functions proficiently in data analysis tasks
  • Demonstrate proficiency in creating Pivot Tables, Slicers, and Pivot Charts to analyze data effectively
  • Employ methods for data analysis, ensuring comprehensive understanding and application
  • Recognize the advantages of leveraging Power BI for data analysis purposes
  • Design interactive visualizations using Power BI to enrich and streamline data analysis processes
  • Develop sophisticated calculations and measures utilizing the DAX language within Power BI for enhanced analysis capabilities

Program Module

The program consists of the following modules:


  1. An Overview of Excel Fundamentals
  • Introduction to Excel interface
  • Data entry and manipulation
  • Basic Excel Formulas and functions
  • Advanced formulas (VLOOKUP, INDEX-MATCH, IF statements, etc.)
  • Data Validation vs. Data Cons
  1. Introduction to Statistical Data Analysis using Excel
  • Descriptive Statistics
  • Exploratory Data Analysis (tabular presentation and data visualization)
  • Inferential Data Analysis
  • Regression Analysis
  1. Introduction to Power BI
  • Overview of Power BI interface
  • Importing data into Power BI
  • Building visualizations and dashboards
  • Data modeling in Power BI
  1. Data Analysis with Power BI
  • Using DAX (Data Analysis Expressions) for calculations
  • Advanced visualization techniques in Power BI
  • Creating interactive reports and dashboards
  • Sharing and collaborating on Power BI reports

Program Details

  • Program Duration: 60 hours
  • Prerequisites:
    • Basic computer skills
    • An ability to install software from online websites

Upon completion of all the modules, participants will receive the Professional Certificate in Data Analysis with Excel and Power BI.


See More