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.

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.

Intro to Data Analysis

5 minutes 40 seconds
Why Pivot Table

4 minutes 47 seconds
Pivot Table

7 minutes 25 seconds
Power Pivot

8 minutes 51 seconds
Data Model

9 minutes 22 seconds
Connecting with Different Data Types

12 minutes 6 seconds
Power Query

3 minutes 50 seconds
Data Cleaning & Transformation

15 minutes 45 seconds
Intro to DAX Functions

3 minutes
DAX Functions

9 minutes 27 seconds
Calculated Measures

11 minutes 55 seconds
Calendars

6 minutes 38 seconds
Dynamic Time Intelligence

14 minutes 39 seconds
Chart Types

11 minutes 5 seconds
Dynamic Dashboard

11 minutes 22 seconds

Meet your instructor

Mohamed Essam

I'm a highly experienced Data Analyst with an Engineering background. I'm an IT Business Analyst at Reckitt Benckiser. I became certified by Microsoft in Data Analyzing & Visualization after being certified in Project Management from the University of California and Advanced Excel for Business by Macquarie University. I earned a scholarship in the Next Technology Leaders (NTL) and African App Launchpad (AAL) in Programming for Data Science with Python Nanodegree and Data Analyst Nanodegree, after which I earned another full scholarship in the Advanced Data track sponsored by the Information Technology Industry Development Agency (ITIDA), FWD and managed by Udacity and its global leading technology partners!

Furthermore, I'm a certified trainer in which I trained 15+ Entity for 1400+ Trainee across 5 different countries making 500+ Training Hours. I believe the future relies on taking smart business decisions and coming up with accurate insights about your business based on smart data analysis in order to improve operational processes and seize better business opportunities which will lead to higher efficiency and value.

Visit Linkedin

Intermediate