Mastering Power BI: From Data to Dashboards

سرفصل های دوره

Data Visualization Masterclass: Power BI Essentials for All Skill Levels

1 - 1. Business Intelligence concept

1 -Introduction

2 -Tools and Technologies in BI

2 - About Microsoft PBI

1 -Power BI introduction and Its components

2 -Power-bi-architecture

3 - Power BI Desktop - An Introduction

1 -PowerBI Flow

2 -Download PowerBI and Interface Tour

3 -Understanding Key backstage options

4 -Case study.zip

4 -Understanding Case Study 1 and Role play

4 - Connecting Power BI with Different Data sources

1 -Get Data from Flat Files

2 -Get-data-from-odata-feed

3 -Connect to local folder

5 - Data Transformation through Power Query

1 -Power Query Power Query Editor Introduction

2 -2.Difference-between-transform-and-load

3 -3.Merge, Add and remove columns

4 -4.Sorting in Power Query

5 -5.Merge and Append queries

6 -6.transform-table-tools-grouping-transpose-reverse-rows-count-rows-use-as-header

7 -7.Transform Column tools detecting changing data type Fill Unpivot

8 -8.Text Column tool, Splitting, Replace Value, Extracting, Merging & Parsing clum

9 -9.Building a complete Calendar Table

10 -10.Conditional Custom Invoke Custom Index and Duplicate Column

11 -11.Flashfill in Power Query (Columns from example)

12 -12.Understanding different view options

13 -13.Connect to multiple files in a folder

14 -14.Number Column tools Statistical standard rounding and information

6 - 6. Data Modelling in PowerBi

1 -12.Understanding different view options

2 -1.How to build relationship and relationship cardinality

7 - DAX

1 -Logical Function DAX (Data Analysis Expressions)

2 -Conditional Column

3 -Switch Function

4 -Understanding of Year and Today Function

5 -Left Search Function

8 - Related Table using Related Table

1 -Related Table using Related Table

9 - Contexts in PowerBI

1 -Filter Context and Row Context

10 - Understanding of Measures

1 -Understanding Measures Practically

2 -Creating Measure Table

11 - Most Common DAX Filter

1 -Understanding of Calculate Function

2 -Building Calculate Table Using Filter Function

3 -Understanding of Variables and Filter

12 - Filtering Data using DAX

1 -Cross filter

13 - Date & Time DAX

1 -Previous Day,month,Year Calculations

2 -YTD REVENUE

14 - Building a Report

1 -Adding Non Visual Object

2 -Basic Charts and formatting tab

3 -Bar chart for top customers

4 -Proportionate charts

5 -Values oN Real Time Map

6 -Matrix visual and conditional formatting

7 -Gauge Chart

8 -Understanding of Slicer

15 - Advance Visualization

1 -Monthly trend with Line chart

2 -Building KPIs

3 -Drill through function

4 -Bookmarks

5 -Natural Language Query (NLQ)

6 -Slicer

7 -Key Influencer

8 -D-Tree

9 -Tooltip Feature

16 - Advance Report Option

1 -Row Level Security (RLS)

2 -What If Parameter

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy