When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Data Science
Udemy logo

Mastering Power BI: From Basics to Advanced Analytics

Data Analysis Using Power BI from Scratch to Professional Level

     
  • 4.8
    •  |
  • Reviews ( 3 )
₹799
Mastering Power BI: From Basics to Advanced Analytics

Related Courses

This Course Includes

  • iconudemy
  • icon4.8 (3 reviews )
  • icon4 total hours
  • iconarabic
  • iconOnline - Self Paced
  • iconcourse
  • iconUdemy

About Mastering Power BI: From Basics to Advanced Analytics

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

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