Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Excel for Data Analysis: Techniques and Application
Rating: 5.0 out of 5(2 ratings)
103 students

Advanced Excel for Data Analysis: Techniques and Application

Excel Data Analysis From Scratch To Professional Level
Created byNourhan Sarhan
Last updated 12/2023
Arabic
Arabic [Auto],

What you'll learn

  • 1-How To Mak Cleaning and Transformation to Data By Using Power Query Editor (Append ,Merge ,Group by ,Remove Columns, Split Columns ,Conditional Column etc)
  • 2-Make Relationships between tables by using Primary Kay and Foreign Key ,,Power Pivot ,, Create Measures and New Columns By Using DAX ,, Create Calendar Table
  • 3-Analyzing Data By Using Pivot Table (Row , Column , Value , Filter)
  • 4-Using Different Pivot Charts To Create Creative Dashboard and Professional Report
  • 5-Working on Real Data and Many Projects
  • EX: Sales Data Analysis Project

Course content

4 sections • 26 lectures • 3h 38m total length

  • Introduction1:50

    In this Course you will learn


    1-How To Mak Cleaning and Transformation to Data By Using Power Query Editor (Append ,Merge ,Group by ,Remove Columns, Split Columns ,Conditional Column  etc.) 


    2-Make Relationships between tables by using Primary Kay and Foreign Key in Power Pivot Create Measures and New Columns By Using DAX , Create Calendar Table


    3-Analyzing Data By Using Pivot Table (Row , Column , Value , Filter)


    4-Using Different Pivot Charts To Create Creative Dashboard and Professional Report


    5-Working on Real Data and Many Projects


Requirements

  • no programming experience needed. you will learn everything in this course from scratch.
  • You Don't Need Any Thing
  • no need to know any thing before this course

Description

This Course for any one want to learn data analysis field there is no need to any background for this course ,, in this course you will learn in details many things


1-Power Query Editor in Excel To Clean and Transform Data

(Remove Columns , Remove Rows , Merge Columns , Split Columns , Conditional Columns , Custom Columns ,Append Queries , Merge Queries, Select Data From Folder, Data Types ,Statistics , Standard, Rounding, Group by)


2-Pivot Table


3-Relationships between tables using Primary Key and Foreign Key ( Explain Primary Key and Foreign Key Concept )


4-Create Measures and Columns using DAX(Data Analysis Expression) to Know KPI'S in Data

(Using Calculate Function , SUM Function , SUMX Function , AVERAGEX Function , Divide Function)


5-Create Calendar Table to Analyze Data Based in Many Different Dates (Day , Month , Year , Quarter)

Analyzing Data by Using Day of Month or Day of Year or Day of Quarter ,, Analyzing Data by Using Month of Specific Year or Month of Specific Quarter ,, Analyzing Data By Specific Quarter or For All Quarters of all Year ,, Analyzing Data for Specific Year or all Years of Data

6-Analysisng Data Using Pivot Table

Using Rows , Columns Filter , Value on Pivot Table


7-Making Professional Dashboard By using Different Pivot Charts

Using Par Chart , Pie Chart , Column Chart , Line Chart , Area Chart

Who this course is for:

  • Beginner Data Analysis Developers Curios about Data Analysis Field
  • For Student ,Graduate , Employee ,, any one want to learn Data Analysis Field in Simplest and Easiest Way
  • For any one Want to Learn The Data Analysis Field
  • For any Beginners this Course Don't Require any Background

Report abuse