Become An Expert In Microsoft Power BI Desktop

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

2024's cutting-edge Power BI course tailored for Business Intelligence Analysts, Data Analysts and Data Professionals

1 - Introduction and Course Structure

1 - Read Me.html

2 - Introduction to Course

3 - Course Design

4 - Adventure-Works-Image-Resources.rar

4 - Adventure-Works-Raw-Data.rar

4 - Adventure-Work-Dashboard.rar

4 - Become-an-Expert-in-Power-BI.rar

4 - Download Resources.html

5 - Course Project

6 - Setting Expectations

2 - Power BI Introduction

1 - Quiz Introduction to Power BI Desktop.html

7 - Introduction

8 - What is Power BI

9 - Power BI Download and Installation

10 - Power BI Settings

11 - Work Flow Interface

12 - Resources and Monthly Updates

3 - Connecting Preparing Data

13 - Introduction Connecting Preparing Data

14 - Power BI Data Sources Connectors

15 - New Power Query Editor Tools

16 - Table transformation

17 - Assignment Table Transformation

18 - Solution Table Transformation

19 - Expert Tip Data Storage Connection Modes

20 - Connecting to SQL Server Datasource

21 - Connecting to a Web Page

22 - QA Column Profiling Tools

23 - Numeric Tools

24 - Assignment Numeric Tools

25 - Solution Assignment Numeric Tool

26 - Text Tools

27 - Assignment Text Tools

28 - Solution Assignment Text Tools

29 - Date Time Calendar Table

30 - Changing Locale to Format Date

31 - Expert Tip Rolling Calendar

32 - Assignment Date Table

33 - Solution Date Table

34 - Index Conditional Columns

35 - Guidelines to Work With Calculated Columns

36 - Grouping Aggregation

37 - Pivot UnPivot Columns

38 - Merging Queries

39 - Appending Queries

40 - Expert Tip Adding Files From Folder

41 - Data Source Setting

42 - Expert Tip Parameterised Data Source

43 - Refreshing Queries Organizing

44 - Expert Tip Import Excel Model in Power BI

45 - Best Practices Data Connection Preparation

4 - Data Model

46 - Data Modeling Introduction

47 - Data Modeling 101

48 - Normalization

49 - Fact Dimension Tables

50 - Primary Foreign Keys

51 - Understanding Table Relationships

52 - Creating Table Relationships

53 - Managing Table Relationships

54 - Star Snowflake Schemas

55 - Assignment Table Relationships

56 - Solution Assignment Table Relationships

57 - Expert Tip Active InActive Relationship

58 - Cardinality

59 - Connecting to Multiple Data Tables

60 - Filter Context Flow Waterfall Model

61 - Bidirectional Filters Risks

62 - Hiding Fields From Report View

63 - Expert Tip Custom Model Layout

64 - Assignment Hiding Fields

65 - Solution Assignment Hiding Fields Filter Flow

66 - Categorizing Formatting Data

67 - The Data Hierarchies

68 - Assignment Date Hierarchy

69 - Solution Assignment Date Hierarchy

70 - Best Practices Desiging a Data Model

5 - Using DAX in Power BI

71 - Introduction to Using DAX in Power BI

72 - DAX

73 - Mcode vs DAX Code

74 - Calculated Columns

75 - DAX Measures

76 - Implicit Explicit Measures

77 - Quick Measures

78 - Comparing Calculated Columns Measures

79 - Expert Tip Measures Tables

80 - The Filter Context

81 - Calculation Steps for a Measure

82 - DAX Syntax and Operators

83 - Frequently Used Functions

84 - Maths Statistics Functions

85 - Maths Counting Functions

86 - Assignment New Measures

87 - Solution Assignment New Measures

88 - Expert Tip Organising Measures

89 - Logical Functions in DAX

90 - Switch Logical Function

91 - Assignment Logical Functions

92 - Solution Assignment Logical Functions

93 - Text Functions in DAX

94 - Assignment Text Functions

95 - Solution Assignment Text Functions

96 - DAX Functions for Date Time

97 - Assignment Date Functions

98 - Solution Assignment Date functions

99 - The DAX Function RELATED

100 - The DAX Function CALCULATE

101 - The Peculiar Case of Unmtached Totals

102 - Assignment CALCULATE Function

103 - Solution Assignment CALCULATE Function

104 - The ALL Function of DAX

105 - Assignment CALCULATE ALL

106 - Solution Assignment Calculate All

107 - The FILTER Function of DAX

108 - The Iterator Functions of DAX

109 - Assignment Iterator Functions

110 - Solution Assignment Iterator Functions

111 - Time Intelligence Functions in DAX

112 - Assignment Time Intelligence

113 - Solution Assignment Time Intelligence

114 - Best Practices Using DAX

6 - Advanced DAX for Measures

115 - Introduction to Advanced DAX

116 - DAX Shortcuts

117 - Formatting DAX Code

118 - Comments in DAX Code

119 - Error Handling in DAX

120 - DAX Variables and Uses

121 - Evaluation Order for Variables

122 - Expert Tip Debug Test DAX

123 - Modifiers for CALCULATE Function

124 - Modifier REMOVEFILTERS

125 - Modifier KEEPFILTERS

126 - Assignment Modifiers

127 - Solution Assignment Modifiers

128 - Expert Tip Advanced CALCULATE Uses

129 - Table Filter Functions

130 - Calculated Virtual Tables

131 - The DISTINCT Function

132 - Versatile VALUES Function

133 - Table Relationships

134 - Iterator Cardinality

135 - CONCATENATEX Function

136 - Expert Tip Dynamic Labels

137 - Requirements of a Date Table

138 - Calendar Function

139 - Expert Tip Reusable Date Table

140 - Time Intelligence Functions

141 - PARALLELPERIOD Function

142 - PREVIOUSQUARTER Function

143 - SAMEPERIODLASTYEAR Function

144 - Additional Time Intelligence Calculations

145 - Best Practices Advanced DAX

7 - Visualizing Data

146 - Introduction Visualizing Data on Dashboards

147 - Key Questions Before You Design

148 - Analytics Dashboard

149 - The Dashboard Layout

150 - Adding Pages Objects to Report View

151 - Format Selection Panes

152 - Cards MultiRow Cards

153 - Assignment KPI Cards

154 - Solution Assignment KPI Cards

155 - OnObject Formatting

156 - Adding Line Charts

157 - Expert Tip Trend Lines Forecasts

158 - Assignment Line Chart

159 - Solution Assignment Line Chart

160 - KPI Cards

161 - Doughnut Bar Charts

162 - The Filter Options Pane

163 - Assignment Doughnut Chart Filters

164 - Solution Assignment Doughnut Chart Filters

165 - Tables Matrix Visuals

166 - Conditional Formatting

167 - Top N Filter

168 - Assignment Tables

169 - Solution Assignment Tables

170 - Expert Tip Top N Text Cards

171 - Assignment Top N Cards

172 - Solution Assignment Top N Cards

173 - New Card Visual

174 - Advanced Formatting New Card Visual

175 - More Advanced Formatting New Card Visual

176 - Assignment New Card Visual

177 - Solution Assignment New Card Visual

178 - Expert Tip Sparkline Chart in Card

179 - Map Visual

180 - Slicers

181 - Assignment Slicer

182 - Solution Assignment Slicer

183 - New Button Slicer

184 - The DAX Function HASONEVALUE

185 - Radial Gauge Charts

186 - Expert Tip Advanced Formatting Gauge Charts

187 - Area Charts

188 - Drill Up Down

189 - Assignment Drill Up Down

190 - Solution Assignment Drill Up Down

191 - CrossReport Drillthrough

192 - Editing Report Interactions

193 - Assignment Report Interactions

194 - Solution Assignment Report Interactions

195 - Power BI Bookmarks

196 - Assignment Bookmarks

197 - Solution Assignment Bookmarks

198 - Expert Tip Custom Navigation Buttons

199 - Expert Tip Slicer Panel

200 - Report Parameters

201 - Fields Parameters

202 - Assignment Field Parameters

203 - Solution Assignment Field Parameters

204 - Expert Tip Custom Tooltips

205 - Assignment Custom Tooltip

206 - Solution Assignment Custom Tooltip

207 - Using Custom Visuals

208 - Using Roles in Power BI

209 - Mobile Layouts

210 - Preview Publishing to Power BI Service

211 - Best Practices Data Visualizations

8 - Artificial Intelligence in Power BI

212 - Introduction to AI in Power BI

213 - Anomaly Detection

214 - Smart Narrative Summaries

215 - QA Visuals

216 - Decomposition Tree

217 - Key Influencers

9 - Optimization Tools in Power BI

218 - Introduction to Optimization in BI

219 - Optimize Menu Ribbon

220 - Pausing Visuals

221 - Optimization Presets

222 - Applying AIl slicer button

223 - Performance Analyzer

224 - External Tools

10 - Power BI Updates New Features

225 - About This Section.html

139,000 تومان

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

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

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

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