ع
Search for courses, vacancies, internships
Search for anything: courses, vacancies, internships...
Data Analysis

Data Analysis from Business Perspective

In this course you will learn: 

- How to document your data and use pivot table.

- How to manage the data you're inserting and merge it all in one sheet.

- Understand the types of data and how to deal with multiple data.

- What is cleaning and transforming.

- How to adjust the data errors that might appear.

- the importance of the time factor and how to apply it on calculated measures.

- Usage of excel calendar and visualization.

Who takes this course

This course is for anyone who wants to fully understand how to analyze his business' data through excel sheets. Cause it helps build a strong background of using all the app's features, and in this course they'll learn all the tips and trick they need to make it easier to analyze and understand all their inserted data.

Course content
15 lectures • 02h 15m
  • Lecture 1: Intro to Data Analysis
    05:40 min
  • Lecture 2: Why Pivot Table
    04:47 min
  • Lecture 3: Pivot Table
    07:25 min
  • Lecture 4: Power Pivot
    08:51 min
  • Lecture 5: Data Model
    09:22 min
  • Lecture 6: Connecting with Different Data Types
    12:06 min
  • Lecture 7: Power Query
    03:50 min
  • Lecture 8: Data Cleaning & Transformation
    15:45 min
  • Lecture 9: Intro to DAX Functions
    03:00 min
  • Lecture 10: DAX Functions
    09:27 min
  • Lecture 11: Calculated Measures
    11:55 min
  • Lecture 12: Calendars
    06:38 min
  • Lecture 13: Dynamic Time Intelligence
    14:39 min
  • Lecture 14: Chart Types
    11:05 min
  • Lecture 15: Dynamic Dashboard
    11:22 min

Meet your instructor

Mohamed Essam

Visit Linkedin

Recorded Courses Subscription

Start watching our recorded courses in different fields with our great experts

1 Month
USD 15
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
3 Months
USD 40
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
1 Year
USD 70
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now

Have Question? Get in touch!

We are happy to answer your question regarding our services and programs that we provide.

Contact us