Become a Data Analyst: Excel, SQL & Tableau – 3-in-1 Bundle

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

Boost Your Career with Data Analytics: Learn Excel, SQL & Tableau for Advanced Business Insights & Competitive Advantage

1 - Introduction

1 - Introduction

2 - Excel Basics

2 - Getting started with Excel

3 - Course Resources.html

4 - This is a milestone

5 - Worksheet basics

6 - Entering values and Formulas

7 - Data Formats

8 - Data Handling Basics Cut Copy Paste

9 - Saving and Printing in Excel

3 - Essential Excel functions

10 - Basic Formula Operations

11 - Mathematical Functions Part 1

12 - Mathematical Functions Part 2

13 - Difference between RANK RANKAVG and RANKEQ.html

14 - Textual Functions Part 1

15 - Textual Functions Part 2

16 - Logical Functions

17 - DateTime Functions

18 - Lookup Functions V Lookup Hlookup IndexMatch

4 - Data Tools

19 - Data Tools Part 1

20 - Data Tools Part 2

5 - Formatting data and tables

21 - Formatting data and tables

6 - Pivot Tables

22 - Pivot Tables

7 - Excel Charts

23 - Excel Charts Categories of messages that can be conveyed

24 - Elements of charts

25 - The Easy way of creating charts

26 - Bar and column charts

27 - Formatting charts Part 1

28 - Formatting charts Part 2

29 - Line Charts

30 - Area Charts

31 - Pie and Doughnut Charts

32 - Why we should avoid Pie charts

33 - Scatter plot or XY chart

34 - Frequency Distribution and Histograms

35 - Waterfall Charts

36 - Hierarchy Charts Sunburst and Treemap

37 - Combination charts

38 - Sparklines

8 - Pivot Charts

39 - Pivot Charts

9 - Special purpose charts

40 - Stock charts

41 - Radar charts

42 - Surface charts

43 - Heatmaps

10 - Named Ranges

44 - Named Ranges

45 - Indirect Functions

11 - Excel Shortcuts

46 - Shortcuts

12 - Macros

47 - Macros

13 - Advanced Excel

48 - Advanced Excel Analytics in Excel

14 - Creative Infographics

49 - Infographic Example 1

50 - Infographic Example 2

15 - SQL

51 - Introduction

16 - Installation and getting started

52 - Installing PostgreSQL and pgAdmin in your PC

53 - If pgAdmin is not opening.html

17 - Case Study Demo

54 - Case Study Part 1 Business problems

55 - Case Study Part 2 How SQL is Used

18 - Fundamental SQL statements

56 - CREATE

57 - INSERT

58 - Import data from File

59 - SELECT statement

60 - SELECT DISTINCT

61 - WHERE

62 - Logical Operators

63 - UPDATE

64 - DELETE

65 - ALTER part 1

66 - ALTER part 2

19 - Restore and Backup

67 - Restore and Backup

68 - Debugging restoration issues

69 - Creating DB using CSV files

70 - Debugging summary and Code for CSV files.html

20 - Selection commands Filtering

71 - IN

72 - BETWEEN

73 - LIKE

21 - Selection commands Ordering

74 - Side Lecture Commenting in SQL

75 - ORDER BY

76 - LIMIT

22 - Alias

77 - AS

23 - Aggregate Commands

78 - COUNT

79 - SUM

80 - AVERAGE

81 - MIN MAX

24 - Group By Commands

82 - GROUP BY

83 - HAVING

25 - Conditional Statement

84 - CASE WHEN

26 - JOINS

85 - Introductions to Joins

86 - Concepts of Joining and Combining Data

87 - Preparing the data

88 - Inner Join

89 - Left Join

90 - Right Join

91 - Full Outer Join

92 - Cross Join

93 - Intersect and Intersect ALL

94 - Except

95 - Union

27 - Subqueries

96 - Part1 Subquery in WHERE clause

97 - Part2 Subquery in FROM clause

98 - Part3 Subquery in SELECT clause

28 - Views and Indexes

99 - VIEWS

100 - INDEX

29 - String Functions

101 - LENGTH

102 - UPPER LOWER

103 - REPLACE

104 - TRIM LTRIM RTRIM

105 - CONCATENATION

106 - SUBSTRING

107 - LIST AGGREGATION

30 - Mathematical Functions

108 - CEIL FLOOR

109 - RANDOM

110 - SETSEED

111 - ROUND

112 - POWER

31 - DateTime Functions

113 - CURRENT DATE TIME

114 - AGE

115 - EXTRACT

32 - PATTERN STRING MATCHING

116 - PATTERN MATCHING BASICS

117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1

118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2

33 - Windows Functions

119 - Introduction to Window functions

120 - Introduction to Row number

121 - Implementing Row number in SQL

122 - RANK and DENSERANK

123 - NTILE function

124 - AVERAGE function

125 - COUNT

126 - SUM TOTAL

127 - RUNNING TOTAL

128 - LAG and LEAD

34 - COALESCE function

129 - COALESCE function

35 - Data Type conversion functions

130 - Converting Numbers Date to String

131 - Converting String to Numbers Date

36 - User Access Control functions

132 - User Access Control 1 Grant and Revoke

133 - User Access Control 2 Drop Alter users

37 - Nail that Interview

134 - Tablespace

135 - PRIMARY KEY FOREIGN KEY

136 - ACID compliance

137 - Truncate

38 - Performance tuning tips

138 - TIP 1 EXPLAIN

139 - TIP 2

140 - TIP 3

141 - TIP 4 VACCUM

142 - TIP 5

143 - TIP 6 STRING FUNCTIONS

144 - TIP 7 JOINS

145 - TIP 8 SCHEMAS

39 - Database Basics

146 - What is SQL

147 - Tables and DBMS

148 - Types of SQL commands

149 - PostgreSQL

40 - TABLEAU

150 - Introduction

151 - Why Tableau

152 - Tableau Products

41 - Installation and getting started

153 - Installing Tableau desktop and Public

154 - About the data

155 - Connecting to data

156 - Live vs Extract

42 - Combining data to create Data model

157 - Combining data from multiple tables

158 - Relationships in Tableau

159 - Joins in Tableau

160 - Types of Joins in Tableau

161 - Union in Tableau

162 - Physical Logical layer and Data models

163 - The visualization screen Sheet

43 - Data categorization in Tableau

164 - Types of Data Dimensions and Measures

165 - Types of Data Discreet and Continuous

166 - Changing Data type in Tableau

44 - Most used charts

167 - Bar charts

168 - Line charts

169 - Scatterplots

45 - Customizing charts using Marks shelf

170 - Marks cards

171 - Dropping Dimensions and Measures on marks card

172 - Dropping Dimensions on Line chart

173 - Adding marks in scatterplot

46 - Other important charts

174 - Text tables heat map and highlight tables

175 - Pie charts

176 - Area charts

177 - Creating custom hierarchy

178 - Tree map

179 - Dual combination charts

180 - Creating Bins

181 - Histogram

47 - Grouping and Filtering data

182 - Grouping Data

183 - Filtering data

184 - Dimension filters

185 - Measure filters

186 - DateTime filters

187 - Filter options

188 - Types of filters and order of operation

189 - Customizing visual filters

190 - Sorting options

48 - Map chart in Tableau

191 - How to make a map chart

192 - Considerations before making a Map chart

193 - Marks card for customizing maps

194 - Customizing maps using map menu

195 - Layers in a Map

196 - Visual toolbar on a map

197 - Custom background images

198 - Territories in maps

199 - Data blending for missing geocoding

49 - Calculations and Analytics

200 - Calculated fields in Tableau

201 - Functions in Tableau

202 - Table calculations theory

203 - Table calculations in Tableau

204 - Understanding LOD expressions

205 - LOD expressions examples

206 - Analytics pane

50 - Sets and Parameters

207 - Understanding sets in Tableau

208 - Creating Sets in Tableau

209 - Parameters

51 - Dashboard and Story

210 - Dashboard part 1

211 - Dashboard part 2

212 - Story

52 - Appendix

213 - Connecting to SQL data source

214 - Connecting to cloud storage services

53 - Congratulations and about your certificate

215 - The final milestone

216 - Bonus lecture.html

235,000 تومان

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

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

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

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