Power Query and M Language the easy way

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

Most complete and comprehensive course in Power Query and M Language with hands on exercises and demos step-by-step.

1 - Introduction

1 - Mastering-Power-Query-and-M-Language.zip

1 - What are you going to learn in this course

2 - Thank you and how to get support

2 - Power Query Introduction

3 - Mastering-Power-Query-and-M-Language.zip

3 - What is Power Query

4 - Why M created Power Query and Why use it

5 - Power Query Interface Components

3 - Introduction to M Language

6 - Course-Material.zip

6 - First things first

7 - What is M Language

8 - M Language Syntax

9 - M Language Type Structures Values

10 - M Language Type Primitive Values

11 - M Language Operators

12 - What are Lists and how to create them using M Language

13 - What are Tables and Records

4 - Home Tab in Power Query

14 - Course-Material.zip

14 - Create initial pbix file

15 - Close and Apply

16 - New and Recent Sources0

17 - New and Recent Sources1

18 - Data Source and Privacy Settings

19 - Using Parameters in Report0

20 - Using Parameters in Report1

21 - Using Parameters as File Path or Data Source

22 - Query Options

23 - Manage Column using M Language

24 - Reduce Rows using Power Query

25 - Reduce Rows using M Language

26 - Sort Order for Data and Filters using Power Query

27 - Sort Order for Data using M Language

28 - Split Column using Power Query

29 - Split Column using M Language

30 - Group by or Grouping Data using Power Query0

31 - Group by or Grouping Data using Power Query1

32 - Group by using M Language

33 - Data Type using Power Query and M

34 - Headers as first row and First row as Headers using Power Query and M

35 - Replace Values using Power Query and M

36 - Merge Tables using Power Query0

37 - Merge Tables using Power Query1

38 - Append Tables using Power Query0

39 - Append Tables using Power Query1

5 - Transform Tab in Power Query

40 - Course-Material.zip

40 - Group by or Grouping Data using Power Query0

41 - Group by or Grouping Data using Power Query1

42 - Headers as first row and First row as Headers using Power Query and M

43 - TransposeReverseCount Rows using Power Query and M

44 - Data Type and Rename using Power Query and M

45 - Replace Fill using Power Query and M

46 - Pivot Unpivoting using Power Query

47 - Move Convert to List using Power Query

48 - Split Column using Power Query 0

49 - Split Column using Power Query 1

50 - Split Column using M Language

51 - Format Trim clean Lower Upper Case using Power Query

52 - Format Trim clean Lower Upper Case using M Language

53 - Merge Columns using Power Query and M Language

54 - Extract using Power Query and M Language

55 - Parse XML Data using Power Query and M Language

56 - Parse JSON Data using Power Query and M Language

57 - Statistics using Power Query and M Language

58 - Standard and Scientific using Power Query and M Language

59 - Trigonometry Rounding Information using Power Query and M Language0

60 - Trigonometry Rounding Information using Power Query and M Language1

61 - Date Transformation using Power Query and M Language0

62 - Date Transformation using Power Query and M Language1

63 - TimeDuration Transformation using Power Query and M Language

6 - AddColumn Tab in Power Query

64 - Column From Example using Power Query and M Language

65 - Custom Column using Power Query and M Language0

66 - Custom Column using Power Query and M Language1

67 - Invoke Custom Column using Power Query and M Language0

68 - Invoke Custom Column using Power Query and M Language1

69 - Conditional Column using Power Query and M Language

70 - Index Column using Power Query and M Language0

71 - Index Column using Power Query and M Language1

72 - Duplicate and Merge Column using Power Query and M Language

73 - Format Trim clean Lower Upper Case using Power Query

74 - Format Trim clean Lower Upper Case using M Language

75 - Extract using Power Query and M Language

76 - Parse XML Data using Power Query and M Language

77 - Parse JSON Data using Power Query and M Language

78 - Statistics using Power Query and M Language

79 - Standard and Scientific using Power Query and M Language

80 - Trigonometry Rounding Information using Power Query and M Language

81 - Date Transformation using Power Query and M Language0

82 - Date Transformation using Power Query and M Language1

83 - Time Duration Transformation using Power Query and M Language

7 - View Tab in Power Query

84 - Query Setting in View Tab0

85 - Query Setting in View Tab1

86 - Data Preview 1 in View Tab

87 - Data Preview 2 in View Tab

8 - Create Date Table using M language and Dax

88 - Create Calendar using M Language and DAX

9 - Power Query Best Practices

89 - Power Query Best Practices0

90 - Power Query Best Practices1

91 - Power Query Best Practices2

10 - Mega searchable tutorials o Power BI DAX SQL and Power Query

92 - Mega searchable tutorials o Power BI DAX SQL and Power Query.html

11 - Additional contents Best Practices Power BI

93 - Best Practices Power BI0

93 - Bonus-Best-Practices-Power-BI.zip

94 - Best Practices Power BI1

95 - Best Practices Power BI2

96 - Best Practices Power BI3

97 - Best Practices Power BI4

98 - Best Practices Power BI5

12 - Additional content Dashboard in a day

99 - DIAD Introduction

100 - DIAD Accessing Data

101 - DIAD Data Prepration0

102 - DIAD Data Prepration1

103 - DIAD Data Modeling and Exploration0

104 - DIAD Data Modeling and Exploration1

105 - DIAD Data Modeling and Exploration2

106 - DIAD Data Modeling and Exploration3

107 - DIAD Data Modeling and Exploration4

108 - DIAD Data Visualization0

109 - DIAD Data Visualization1

110 - DIAD Publishing Report

111 - DIAD Creating Dashboards

112 - DIAD Creating Dashboards0

113 - DIAD Creating Dashboards1

139,000 تومان

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

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

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

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