Advanced Excel for Data Analysis: Techniques and Application

Excel Data Analysis From Scratch To Professional Level

Ratings: 5.00 / 5.00




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

What 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 ,,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

Who Should Attend!

  • 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