Unlocking DAX Secrets: Elevate Your Dashboard Design

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

Unlock the Potential of Data Analysis Expressions (DAX) in Power BI - Elevate Your Skills, Craft Engaging Dashboards.

1. Download Resources (All Files)

1.1 All Practice Files.zip

1.2 All Solved PBIX.zip

1. Download

2. Student Assessment

1. Test Your Power BI Skill Level (Assessment Test).html

3. Introducing You To DAX Language

1.1 01 Intro to Power BI DAX Dark Background.pdf

1.2 01 Intro to Power BI DAX Light Background.pdf

1.3 01 Prarctice Intro to DAX.zip

1.4 Solved PBIX-Intro to DAX.zip

1. Calculated Columns

2. Understanding Measures

3. 0.2 Power BI Conditional Functions

4. What Do You Know About Calculated Column.html

5. Measures vs Calculated Columns

6. Aggregation function vs Iterator functions

7. Where Calculated Columns wins over Measures

8. Your knowledge about Measure vs Calculated Column.html

9. Understanding the Power BI Counts Function

10. Your Knowledge About the Counts Functions.html

11. 0.1 Power BI Conditional Functions

12. Error Handling Functions

13. Intro to Power BI Variables

14. Understanding the Related Functions

15. What Do You Know About Related Functions.html

4. Understand The Table Functions

1.1 02 Practice -Understand the Table Functions.zip

1.2 02 Solved PBIX Understand the Table Functions.zip

1.3 02 Table Functions.pdf

1. Intro to Table Function

2. What Do You Understand By Table Functions.html

3. Intro to Filter Function (Filter and Filters Function in Calculated Table)

4. Intro to Filter Function (Filter Function in Measure)

5. What Do You Know About Filter Function.html

6. Understand the All

7. How to Mix Table Functions

8. What Do You Know About The All Function.html

9. Understand the Allselected Function

10. Understand the Related Functions

11. Edit Remove ending part Distinct Function

5. Inside Evaluation Contexts

1.1 03 Inside Evaluation Context Practice Files.zip

1.2 03 Inside Evaluation Context.pdf

1.3 03 Solved PBIX. Inside Evaluation Contexts.zip

1. Intro to Evaluation Context

2. Understand the Filter Context

3. Row Context

4. filtering a Table

5. How Filter and Relationship work

6. What Do You Know About The Evaluation Context.html

6. Understanding The Calculate Function In Power BI

1.1 03 Understand the Calculate function..pdf

1.2 04 Understanding the Calculate Function Practice file.zip

1.3 Solved PBIX. The CALCULATE function.zip

1. Intro to Calculate Function

2. Calculate Function (Gender Revenue)

3. Calculate Function (All function)

4. Calculate Function (filter Table)

5. Calculate Function (Allselected function)

6. Calculate Function (Keepfilter function)

7. How Do You Understand The Calculate function.html

8. Calculate Function (And Function)

7. All You Need To Know About Iterator Function

1.1 05 All You Need To Know About Iterator Functions Practice files.zip

1.2 Intro to the Iterator Functions.pdf

1.3 Solved Pbix. Iterator Functions.zip

1. Intro to Iterators and Context Transition

2. Understand the Iterator Function

3. Understand the MaxX, MinX and the AverageX

4. Understand the RankX Iterator Function

5. Intro to ISINSCOPE Function

6. What Do You Know About Iterators In Power BI.html

8. Build An Advance Power BI Date Table

1.1 06 Building an Advanced Power BI Data Table All Data Files.zip

1.2 Solved Pbix. Created Date Table.zip

1. Adding more columns to the Calendar

2. Importing Data for Date Table

3. The use of CalendarAuto

4. Filter CalendarAuto

5. Adding Start of Month

6. Advanced way to add Week of Month and End of Month

7. What Do You Know About Power BI Date Table.html

8. Full Date Table Built in Power Query

9. DAX Time Intelligence

1.1 07 DAX Time Intelligence Practice Files.zip

1.2 Solved Pbix- Time intelligence in Power BI DAX.zip

1.3 Time Intelligence.pdf

1. Intro to Time Intelligence Function in Power BI

2. DateAdd and SameperiodLastYear Time Intelligence Function

3. Use of Parallelperiod and DatesYTD

4. How to calculate Running Total without Time Intelligence Function

5. Seasonality Sales analysis using DatesBetween Function

6. How to calculate 7 days Rolling Total

7. What Do You Know About Time Intelligence.html

8. How to calculate 3 Month Average Sales

10. Understand Segmentation In Power BI

1.1 00 Solved Pbix- Segmentation.zip

1.2 08 Uderstand Segmentation in Power BI Practice File.zip

1.3 Segementation in Power BI.pdf

1. Intro to Segmentation

2. Product Segmentation 01

3. Product Segmentation 02

4. Product Segmentation 03

11. Hierarchies in DAX

1.1 Power BI Heirarchy.pdf

1.2 Practice File.zip

1.3 Solved Pbix- Hierarchies in DAX.zip

1. Intro to Hierarchy in Power BI

2. Default Hierarchies

3. Creating Hierarchies from One-Table

4. How to make changes or Delete your Hierarchy

5. Hierarchy over Multiple Tables

6. What Do You Know About Power BI Hierarchy.html

7. Advanced way to create Percentage Over Hierarchy

8. Do You Really Understand Percentage Over Hierarchy Using Isinscope.html

12. Dashboard Project (How to create dashboard using Power BI DAX)

1.1 Backgrounds.zip

1.2 Completed Dashboard.zip

1.3 Data Files.zip

1.4 How to Create Power BI Dashboard.pdf

1.5 Img.zip

1. Understanding the Dataset

2. What Is Power BI Dashboard.html

3. Data Cleaning and Transformation

4. What Do You Know About Data Cleaning and Transformation.html

5. Dashboard with HIT Map

6. Formatting HIT Map Dashboard

7. Creating the Compliance and None Compliance Dashboard

8. Adding Commentary to Compliance and None Compliace Dashboard

9. Formatting and creating Field Parameter.

10. Dashboard with Tooltips

11. Creating Background for Dashboard with Tooltips

12. Formatting Dashboard with ToolTips

13. Adding toolTips to Line Chart on Dashboard with Tooltips

14. Creating Other ToolTips on Dashboard with ToolTips

15. Adding Page Navigation

16. Congratulations we just finish the project

235,000 تومان

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

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

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

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