Power BI Master Class-Data Models and DAX Formulas 2022

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

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI

1 - Introduction to the Course

1 - Introduction to the Course

2 - About the Course

3 - Data.xlsx

3 - Date-Master.xlsx

3 - Employee-Master.xlsx

3 - HR-Date-Master.xlsx

3 - Please download the Training Data Files.html

2 - Overview of the Power BI Data Model

4 - Introduction to Overview of the Data Model

5 - Overview of the Data Model

3 - Creating Calculated Columns

6 - Introduction Calculated Columns

7 - Creating Calculated Columns

8 - Practical Activity Calculated Columns.html

9 - Creating Calculated Columns of Date Fields

10 - Practical Activity Calculated Columns with Date Fields.html

11 - Weekday and Weeknum Formulas

12 - Formatting Date Names

13 - Practical Activity Formatted Date Names.html

14 - Using a Date Master Table in the Data Model

15 - Practical Activity Adding a Date Table to the Data Model.html

16 - IF Function

17 - Switch Function

4 - Creating Power BI Measures

18 - Introduction to the Measures Section

19 - What is a Measure

20 - Creating Measures

21 - Practical Activity Creating Measures.html

22 - Practical Activity Measures

23 - Using the Calculate Formula

24 - Practical Activity Calculate Formula.html

25 - The All and AllExcept Function

5 - Time Intelligence Functions

26 - Time Intelligence Part 1

27 - Time Intelligence Part 2

28 - Time Intelligence Part 3

6 - Additional Measure Calculations

29 - Using the SUMX function

30 - Example of MAXX Find the Highest Sales Day.html

31 - Example MAXX Functions using Values function

32 - RANKX Function

33 - Customer Segmentation SWITCH Function

34 - What If Parameters

7 - Virtual Tables

35 - Introduction to Virtual Tables

36 - Creating Virtual Tables

37 - Customer Segmentation

38 - Performance Analyzer

39 - Practical Activity Virtual Tables.html

40 - Completed Practical Activity Part 1

41 - Completed Practical Activity Part 2

8 - Creating Relationships in Power BI

42 - Introduction to the Relationships Section

43 - Download the Training Data Files.html

43 - Employee-Master.xlsx

43 - HR-Date-Master.xlsx

44 - Relationships between Tables

45 - Relationship Calculations

46 - USERELATIONSHIP Function

47 - Practical Activity Create Relationships and Calculations.html

9 - Hierarchies and Data Groups

48 - Introduction to Hierarchies

49 - Creating Hierarchies

50 - Creating Data Groups

10 - Case Studies

51 - Introduction to Case Studies

52 - Introduction to Star Schemas

53 - Creating Star Schemas

54 - Using DirectQuery Mode

55 - Creating Quick Measures

11 - Conclusion to the Course

56 - Course Conclusion

45,900 تومان

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

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

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

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