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
Subscriptions
Start watching our recorded courses in different fields with our great experts
1 Month Subscription
Benefits
- Full access to all courses
- Full access to material of courses
- Engage with course instructors
- Get certificate of completion
1 Year
Benefits
- Full access to all courses
- Full access to material of courses
- Engage with course instructors
- Get certificate of completion
3-Months group subscription
Benefits
- All one month subscription perks
- Access for three months
- Access for 3 users