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

“Excel Formulas and Functions Masterclass for Data Analysis” به سبد خرید شما اضافه شد. مشاهده سبد خرید

189,000 تومان

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

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

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

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