Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

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

Microsoft Excel Pivot Tables, Get and Transform (Power Query) and Power Pivot (DAX) for advanced data analysis. 70-779.

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - The Udemy Interface

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum

6 - 70-779Data.xlsx

6 - CustomFormatting.pdf

6 - MFunctions191009.pdf

6 - MlanguageManual190828.docx

6 - MlanguageManual190828reduced.docx

6 - MonthlyCSVFiles.zip

6 - PivotTableFormatting170416.pdf

6 - Resources.html

6 - daxfunctions200320.zip

2 - Creating our first PivotTable and PivotChart

7 - Our first PivotTable

8 - PivotTable Menus

9 - Our first PivotChart

10 - PivotChart Menus and An Introduction to Practice Activity 1

11 - Practice Activity Number 1.html

12 - Answer to Practice Activity 1

3 - Expanding our PivotTable

13 - Source data requirements

14 - Adding additional values

15 - Recommended PivotTables

16 - Moving PivotTable

17 - Refresh PivotTable why it doesnt autoupdate

18 - Extracting data

19 - Sorting

20 - Practice Activity Number 2.html

21 - Answer to Practice Activity 2

4 - Going deeper in our PivotTable

22 - Adding additional row fields

23 - Different layouts Compact Outline and Tabular

24 - Blank Rows

25 - Group Records

26 - Showing or hiding additional detail the buttons

27 - Adding columns

28 - Adding page fields

29 - Adding filters

30 - Changing source

31 - Using a table source

32 - Other PivotTable Analyze options

33 - Introduction to Practice Activity 3

34 - Practice Activity Number 3.html

35 - Answers to Practice Activity 3

5 - Modify field selections

36 - Change aggregate COUNT MIN MAX

37 - Repeat All

38 - Using Conditional Formatting to hide Repeat All

39 - Grand Totals

40 - Adding subtotals

41 - Show items with no data

42 - Other field settings

43 - Practice Activity Number 4.html

44 - Answers to Practice Activity 4

6 - PivotTable Options

45 - Layout

46 - Totals Filters and Alt Text

47 - Display

48 - Print

49 - Data

50 - Practice Activity Number 5.html

51 - Answers to Practice Activity 5

7 - Slicers

52 - Create slicers

53 - Identifying impossible options and selecting more than one option at once

54 - Join to multiple PivotTables

55 - Options

56 - Practice Activity Number 6.html

57 - Answer to Practice Activity 6

8 - Dates and Timeline

58 - Aggregates

59 - Group by time period

60 - Timelines

61 - Practice Activity Number 7.html

62 - Answer to Practice Activity 7

9 - Formatting

63 - Formatting number values

64 - Custom Formatting number formatting

65 - Custom Formatting dates and text

66 - CustomFormatting.pdf

66 - Custom Formatting sections and colors

67 - Conditional Formatting Highlighting cells

68 - Conditional Formatting Data Bars and Color Sets

69 - Formatting printing

70 - Styles

71 - PivotTableFormatting170416.pdf

71 - Practice Activity Number 8.html

72 - Answer to Practice Activity 8

10 - Advanced calculations

73 - Percentage of total

74 - Percentage of total Advanced

75 - Cumulative totals

76 - Rank and Index

77 - Difference from

78 - Calculated fields

79 - Calculated Items

11 - PivotCharts

80 - Relationship of Pivot Chart with Pivot Table

81 - Options and Styles

82 - Bubble charts

83 - Formatting charts.html

84 - Adding legends

84 - Level-5-Session-2.xlsx

85 - Positioning and Resizing charts and graphs inc moving charts into chart sheets

86 - Modifying chart and graph parameters

87 - Applying chart layouts and styles

88 - Conclusion to Part 1

12 - Part 2 Get and Transform Data Home Part 1

89 - Introduction lets Get some more Data

90 - Exploring the Power Query Editor interface

91 - Introducing the M language

92 - Lets start look at the Home tab

93 - Home menu Manage Columns

94 - Home menu Reduce Rows and Use First Row as Headers

95 - Practice Activity Number 9.html

96 - Practice Activity Number 9 The Solution

13 - Get Data Home Part 2

97 - Sort and Filter

98 - Split Column

99 - Other Transform activities

100 - Practice Activity Number 10.html

101 - Practice Activity Number 10 The Solution

14 - Getting Multiple files Dont forget to create Visualizations

102 - Merge Queries and Expand Table

103 - Different types of Joins

104 - Merge Queries with Group By

105 - Appending two queries together

106 - appending three or more queries together resolving a problem with data types_ea.mp4.zip

106 - appending three or more queries together resolving a problem with data types_ev.mp4.zip

107 - Combine Files getting information from a folder

108 - Load To

109 - Drive-Safely.zip

109 - Practice Activity Number 11.html

110 - Practice Activity Number 11 The Solution

15 - Transform Menu

111 - Transform Table and Any Column

112 - Pivot Column

113 - Unpivot

114 - Practice Activity Number 12.html

115 - Practice Activity 12 The Solution

116 - Unpivot in conjunction with other Transform features

117 - Practice Activity Number 13.html

118 - Practice Activity 13 The Solution

16 - Transform Text and Numbers

119 - TransformAdd Column Text Format

120 - TransformAdd Column Text Merge Columns

121 - TransformAdd Column Text Extract

122 - TransformAdd Column Text Parse

123 - TransformAdd Column Number Column Statistics and Standard

124 - TransformAdd Column Other Number Column functions

125 - Practice Activity Number 14.html

126 - Practice Activity 14 The Solution

17 - Transform Dates and Time

127 - Creating a list of dates

128 - TransformAdd Column Date

129 - TransformAdd Column Dates in other cultureslanguages

130 - TransformAdd Column Time

131 - TransformAdd column Duration

132 - Practice Activity Number 15.html

133 - Practice Activity Number 15 The Solution

18 - Add Columns View and Help Menus

134 - Column from examples

135 - Conditional Column

136 - Resolving Errors from Conditional Columns

137 - Index Column and Duplicate Column

138 - Custom Column If Then Else

139 - Practice Activity Number 16.html

140 - Practice Activity Number 16 The Solution

19 - View and Help menus and advanced functionality

141 - Other M Functions

142 - View and Help menus

143 - Advanced Editor

144 - Custom Functions

145 - DateTimeZone date type and Functions

146 - Worked Practice Activity 17 Dividing Annual data into Months

20 - Get other types of data

147 - Introduction to SQL Server

148 - Importing database data into Get and Transform and Query Folding

149 - Expanding multiple tables in SQL Server

150 - Importing data from SQL Server Analysis Services SSAS

151 - Setting up Azure SQL Database

152 - Using Azure SQL Database in Get and Transform

153 - Using Big Data

21 - Part 3 Creating a Data Model

154 - Get multiple data sets

155 - Connecting multiple data sets together

156 - The problems with direction of relationships between data sets

157 - Practice Activity Number 18.html

157 - practiceactivitydata.zip

158 - Practice Activity Number 18 The Solution

22 - Developing the Data Model

159 - Filtering sorting and formatting fields

160 - Hiding columns from Client Tools and other column tools

161 - Refreshing or processing data

162 - Perspectives

163 - Creating quick measures

164 - Hierarchies

165 - Practice Activity Number 19.html

166 - Practice Activity Number 19 The Solution

23 - Using your Data Model in PivotTable

167 - NonVisual Totals

168 - Show no data in rows and columns

169 - Using formulas to query Data Model

24 - An introduction to DAX functions including Logical functions

170 - DAX functions A useful Resource

171 - Calculated columns an introduction

172 - Basic operators

173 - IF BLANK and ISBLANK

174 - AND OR and NOT

175 - SWITCH

176 - Other functions

177 - Practice Activity Number 20.html

178 - Practice Activity Number 20 The Solution

25 - Statistical functions

179 - Measures an introduction with standard aggregations including Countblank

180 - Aggregation of calculations

181 - Other statistical functions

182 - Practice Activity Number 21.html

183 - Practice Activity Number 21 The Solution

26 - Mathematical functions

184 - Introduction to mathematical functions.html

185 - Rounding functions

186 - Division functions MOD and QUOTIENT

187 - SIGN and use with SWITCH and ABS

188 - Exponential functions

189 - Other functions

190 - Practice Activity Number 22.html

191 - Practice Activity Number 22 The Solution

27 - Text functions

192 - Text searching

193 - Text extraction and substitution

194 - Text conversion

195 - Other functions

196 - Practice Activity Number 23.html

197 - Practice Activity Number 23 The Solution

28 - Information Functions

198 - ISERROR and LOOKUPVALUE

199 - Other functions

200 - Practice Activity Number 24.html

201 - Practice Activity Number 24 The Solution

29 - Filter and Value Functions

202 - RELATED

203 - RELATEDTABLE and COUNTROWS

204 - Context

205 - ALL

206 - FILTER

207 - CALCULATE

208 - ALLEXCEPT

209 - ALLSELECTED

210 - Other functions

211 - Practice Activity Number 25.html

212 - Practice Activity Number 25 The Solution

30 - Time Intelligence Functions

213 - Date and Time Functions

214 - Sort by Column

215 - FIRSTDATE LASTDATE

216 - Start of and End of

217 - Previous and Next

218 - DATESINPERIOD

219 - DATESMTD DATESQTD DATESYTD TOTALMTD TOTALQTD TOTALYTD

220 - Opening Balance and Closing Balance

221 - SAMEPERIODLASTYEAR and PARALLELPERIOD

222 - Other Time Intelligence Functions

223 - Practice Activity Number 26.html

224 - Practice Activity Number 26 The Solution

31 - Well done

225 - Congratulations for finishing the course

226 - Bonus Lecture

226 - idodatabonuslecture230113.zip

139,000 تومان

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

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

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

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