Home / courses / Data analysis using Excel

Data analysis using Excel

It is a comprehensive program designed to equip you with the skills and knowledge necessary to analyze and interpret data using Excel . Through this course, you will learn how to extract insights from complex datasets, create interactive visualizations, and build meaningful reports and dashboards. This course provides a hands-on and practical learning experience, enabling you to harness the power of data analysis and become a valuable asset in today’s data-driven landscape

admin
(1)
115 enrolled students

Description

Benefits of the course

Connect with multiple data sources and then transform that data into a usable format.
Create robust accounts for comparisons across multiple datasets from various sources.
Visualize that data in a meaningful way to uncover new insights for your business.
Create interactive reports and dashboards tailored to your specific needs.

Topics for this course

33 Lessons

Module 1 Tables and Pivot Table

Module 1 Part 1 Creating Tables15:04

Module 1 Part 2 Pivot Table Part 144:48

Module 1 Part 2 Pivot Table Part 250:47

Module 2 Interactive Dashboard

Module 3 Data Modeling and DAX

Module 3 Part 1 Creating Relationship Part 134:14

Module 3 Part 2 Creating Relationship Part 221:53

Module 3 Part 3 Calculated Columns VS Explicit measures28:47

Module 3 Part 4 Implicit VS Explicit Measure ( filter context)15:08

Module 3 Part 5 DAX % of item10:04

Module 3 Part 6 % of GT20:00

Module 3 Part 7 Iterative Functions14:48

Module 3 Part 8 Time Intelligence Functions27:10

Module 3 Part 9 Some Advanced Modification12:10

Module 4 Data Transformation using Power Query

PQ Task 1 – Splitting Column19:11

PQ Task 2 – TEXT, Number and Date Transformation43:16

PQ Task 3 – Filling Down, Replace , Filter11:47

PQ Task 4 – Unpivot Columns12:40

PQ Task 5 – Pivot Column and Transpose12:14

PQ Task 15 – Unpivot nested headers13:45

PQ Task 6 – Merging Queries25:13

PQ Task 7 – Group by17:56

PQ Task 8 – Conditional columns16:45

PQ Task 9 – Appending Queries12:39

PQ Task 10 – From Folder 107:08

PQ Task 11 – From Folder 221:39

PQ Task 12 – From multi sheets00:00

PQ Task 13 – From Folder 320:02

PQ Task 14 – From Folder 407:23

PQ Task 16 – Invoke custom function15:02

Module 5 Final Projects

Target Audience

Informed Decision Making: Data analysis empowers you to make informed decisions based on evidence and insights.
Work Efficiency and Business Performance Improvement: Data analysis plays a crucial role in improving business operations and increasing efficiency. Through studying data analysis, you will learn how to identify obstacles, gaps, and areas that can be enhanced within organizations.
Career Growth and Advancement: Studying data analysis opens up numerous career opportunities and paves the way for professional growth and advancement.

Student Feedback

5.0

Total 1 Ratings

1 rating

0 rating

Hassan Hamed

1 week ago

احترافية واداء راقي في الشرح وايصال المعلومة

Duration
Lessons33
Skill levelIntermediate
CategoryData Analysist

Secure Payment:

Unit (230), 2 May Buildings, Nasr Road – Nasr City – Cairo – Egypt

PSA (Planet of Skills Academy) is a specialized center that offers training courses in Excel, Advanced Excel, and Power BI programs.

We take pride in providing high-quality and exceptional education in these fields, aiming to empower individuals to acquire the skills and knowledge necessary for success in the field of data and its analysis.

Get in touch!

info@planet-acdm.com

Data analysis using Excel

Description

Benefits of the course

Topics for this course

Module 1 Tables and Pivot Table

Module 1 Part 1 Creating Tables15:04

Module 1 Part 2 Pivot Table Part 144:48

Module 1 Part 2 Pivot Table Part 250:47

Module 2 Interactive Dashboard

Module 2 Part 1 Dashboard 138:35

Module 2 Part 1 Dashboard 235:58

Module 3 Data Modeling and DAX

Module 3 Part 1 Creating Relationship Part 134:14

Module 3 Part 2 Creating Relationship Part 221:53

Module 3 Part 3 Calculated Columns VS Explicit measures28:47

Module 3 Part 4 Implicit VS Explicit Measure ( filter context)15:08

Module 3 Part 5 DAX % of item10:04

Module 3 Part 6 % of GT20:00

Module 3 Part 7 Iterative Functions14:48

Module 3 Part 8 Time Intelligence Functions27:10

Module 3 Part 9 Some Advanced Modification12:10

Module 4 Data Transformation using Power Query

PQ Task 1 – Splitting Column19:11

PQ Task 2 – TEXT, Number and Date Transformation43:16

PQ Task 3 – Filling Down, Replace , Filter11:47

PQ Task 4 – Unpivot Columns12:40

PQ Task 5 – Pivot Column and Transpose12:14

PQ Task 15 – Unpivot nested headers13:45

PQ Task 6 – Merging Queries25:13

PQ Task 7 – Group by17:56

PQ Task 8 – Conditional columns16:45

PQ Task 9 – Appending Queries12:39

PQ Task 10 – From Folder 107:08

PQ Task 11 – From Folder 221:39

PQ Task 12 – From multi sheets00:00

PQ Task 13 – From Folder 320:02

PQ Task 14 – From Folder 407:23

PQ Task 16 – Invoke custom function15:02

Module 5 Final Projects

Project Preparation27:28

Project DAX19:00

Project Visualization20:31

Target Audience

Student Feedback

Secure Payment:

Course category

Related Courses

Data analysis using Excel

Get in touch!

© 2024 – Developed by Go Ninety Agency.