Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering Power BI: From Basics to Advanced Analytics
Rating: 4.8 out of 5(3 ratings)
98 students

Mastering Power BI: From Basics to Advanced Analytics

Data Analysis Using Power BI from Scratch to Professional Level
Created byNourhan Sarhan
Last updated 12/2023
Arabic

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 Columns)
  • 2-Make Relationships between tables by using Primary Kay and Foreign Key , Create Measures and New Columns By Using DAX ,, Create Calendar Table
  • 3-Analyzing Data By Using DAX Functions
  • 4-Using Different Charts To Create Creative Dashboard and Professional Report , 5-Working on Real Data and Many Projects

Course content

4 sections • 21 lectures • 4h 10m total length

  • Introduction2:20

    In this Course you will learn :

    1-Power Query Editor in Power BI  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-Relationships between tables using Primary Key and Foreign Key ( Explain Primary Key and Foreign Key Concept )


    3-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)


    4-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


    5-Analysisng Data Using DAX Functions


    6-Making Professional Dashboard By using Different Visuals


    Using Par Chart , Pie Chart , Column Chart , Line Chart , Area Chart, Ribbon Chart , Waterfall Chart , Map Chart , Slicers , Card Chart , Gauge Chart and more

Requirements

  • No need to know anything before taking this course
  • No need any thing before this course

Description

In this Course You Will Learn Everything Related to Power BI to Make Data Analysis and Professional Report :

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 Many Functions by DAX


7-Making Professional Dashboard By using Different  Charts


Using Par Chart , Pie Chart , Column Chart , Line Chart , Area Chart , Waterfall Chart , Ribbon Chart , Map Chart , Guage Chart , Slicers , Card Chart , and more

Who this course is for:

  • 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
  • for any one want to learn data analysis course

Report abuse