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

Focused View

Start-Tech Academy

25:50:18

98 View

1 - Introduction

1 - Introduction.mp4

04:26

2 - Excel Basics

2 - Getting started with Excel.mp4

08:18

3 - Course Resources.html

4 - This is a milestone.mp4

03:31

5 - Worksheet basics.mp4

16:41

6 - Entering values and Formulas.mp4

07:04

7 - Data Formats.mp4

08:36

8 - Data Handling Basics Cut Copy Paste.mp4

13:56

9 - Saving and Printing in Excel.mp4

08:56

3 - Essential Excel functions

10 - Basic Formula Operations.mp4

13:10

11 - Mathematical Functions Part 1.mp4

11:35

12 - Mathematical Functions Part 2.mp4

07:31

13 - Difference between RANK RANKAVG and RANKEQ.html

14 - Textual Functions Part 1.mp4

08:45

15 - Textual Functions Part 2.mp4

08:37

16 - Logical Functions.mp4

11:13

17 - DateTime Functions.mp4

06:59

18 - Lookup Functions V Lookup Hlookup IndexMatch.mp4

08:34

4 - Data Tools

19 - Data Tools Part 1.mp4

13:15

20 - Data Tools Part 2.mp4

05:40

5 - Formatting data and tables

21 - Formatting data and tables.mp4

18:00

6 - Pivot Tables

22 - Pivot Tables.mp4

08:25

7 - Excel Charts

23 - Excel Charts Categories of messages that can be conveyed.mp4

04:34

24 - Elements of charts.mp4

05:23

25 - The Easy way of creating charts.mp4

03:17

26 - Bar and column charts.mp4

12:38

27 - Formatting charts Part 1.mp4

10:14

28 - Formatting charts Part 2.mp4

04:58

29 - Line Charts.mp4

09:04

30 - Area Charts.mp4

05:51

31 - Pie and Doughnut Charts.mp4

12:58

32 - Why we should avoid Pie charts.mp4

04:05

33 - Scatter plot or XY chart.mp4

16:17

34 - Frequency Distribution and Histograms.mp4

13:03

35 - Waterfall Charts.mp4

11:54

36 - Hierarchy Charts Sunburst and Treemap.mp4

07:57

37 - Combination charts.mp4

07:32

38 - Sparklines.mp4

05:43

8 - Pivot Charts

39 - Pivot Charts.mp4

05:05

9 - Special purpose charts

40 - Stock charts.mp4

11:28

41 - Radar charts.mp4

04:51

42 - Surface charts.mp4

05:14

43 - Heatmaps.mp4

04:55

10 - Named Ranges

44 - Named Ranges.mp4

09:20

45 - Indirect Functions.mp4

05:04

11 - Excel Shortcuts

46 - Shortcuts.mp4

12:26

12 - Macros

47 - Macros.mp4

09:57

13 - Advanced Excel

48 - Advanced Excel Analytics in Excel.mp4

15:28

14 - Creative Infographics

49 - Infographic Example 1.mp4

14:06

50 - Infographic Example 2.mp4

06:45

15 - SQL

51 - Introduction.mp4

04:45

16 - Installation and getting started

52 - Installing PostgreSQL and pgAdmin in your PC.mp4

09:30

53 - If pgAdmin is not opening.html

17 - Case Study Demo

54 - Case Study Part 1 Business problems.mp4

04:21

55 - Case Study Part 2 How SQL is Used.mp4

06:17

18 - Fundamental SQL statements

56 - CREATE.mp4

11:40

57 - INSERT.mp4

09:07

58 - Import data from File.mp4

04:59

59 - SELECT statement.mp4

03:40

60 - SELECT DISTINCT.mp4

06:05

61 - WHERE.mp4

04:02

62 - Logical Operators.mp4

06:03

63 - UPDATE.mp4

05:24

64 - DELETE.mp4

04:11

65 - ALTER part 1.mp4

06:49

66 - ALTER part 2.mp4

10:31

19 - Restore and Backup

67 - Restore and Backup.mp4

07:37

68 - Debugging restoration issues.mp4

08:26

69 - Creating DB using CSV files.mp4

05:40

70 - Debugging summary and Code for CSV files.html

20 - Selection commands Filtering

71 - IN.mp4

04:18

72 - BETWEEN.mp4

05:40

73 - LIKE.mp4

08:52

21 - Selection commands Ordering

74 - Side Lecture Commenting in SQL.mp4

01:21

75 - ORDER BY.mp4

07:42

76 - LIMIT.mp4

03:38

22 - Alias

77 - AS.mp4

03:33

23 - Aggregate Commands

78 - COUNT.mp4

05:07

79 - SUM.mp4

03:24

80 - AVERAGE.mp4

02:53

81 - MIN MAX.mp4

04:18

24 - Group By Commands

82 - GROUP BY.mp4

11:42

83 - HAVING.mp4

05:04

25 - Conditional Statement

84 - CASE WHEN.mp4

05:17

26 - JOINS

85 - Introductions to Joins.mp4

02:54

86 - Concepts of Joining and Combining Data.mp4

11:58

87 - Preparing the data.mp4

02:00

88 - Inner Join.mp4

08:04

89 - Left Join.mp4

07:30

90 - Right Join.mp4

06:27

91 - Full Outer Join.mp4

04:59

92 - Cross Join.mp4

04:21

93 - Intersect and Intersect ALL.mp4

07:06

94 - Except.mp4

02:53

95 - Union.mp4

05:04

27 - Subqueries

96 - Part1 Subquery in WHERE clause.mp4

04:55

97 - Part2 Subquery in FROM clause.mp4

05:23

98 - Part3 Subquery in SELECT clause.mp4

04:02

28 - Views and Indexes

99 - VIEWS.mp4

07:14

100 - INDEX.mp4

06:25

29 - String Functions

101 - LENGTH.mp4

03:22

102 - UPPER LOWER.mp4

02:10

103 - REPLACE.mp4

04:13

104 - TRIM LTRIM RTRIM.mp4

06:56

105 - CONCATENATION.mp4

02:56

106 - SUBSTRING.mp4

06:01

107 - LIST AGGREGATION.mp4

04:54

30 - Mathematical Functions

108 - CEIL FLOOR.mp4

03:20

109 - RANDOM.mp4

05:04

110 - SETSEED.mp4

04:11

111 - ROUND.mp4

02:27

112 - POWER.mp4

02:18

31 - DateTime Functions

113 - CURRENT DATE TIME.mp4

04:25

114 - AGE.mp4

03:50

115 - EXTRACT.mp4

08:16

32 - PATTERN STRING MATCHING

116 - PATTERN MATCHING BASICS.mp4

07:33

117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1.mp4

08:29

118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2.mp4

06:49

33 - Windows Functions

119 - Introduction to Window functions.mp4

09:57

120 - Introduction to Row number.mp4

06:04

121 - Implementing Row number in SQL.mp4

19:19

122 - RANK and DENSERANK.mp4

07:19

123 - NTILE function.mp4

07:20

124 - AVERAGE function.mp4

08:22

125 - COUNT.mp4

03:55

126 - SUM TOTAL.mp4

11:14

127 - RUNNING TOTAL.mp4

06:58

128 - LAG and LEAD.mp4

08:17

34 - COALESCE function

129 - COALESCE function.mp4

05:57

35 - Data Type conversion functions

130 - Converting Numbers Date to String.mp4

10:46

131 - Converting String to Numbers Date.mp4

05:49

36 - User Access Control functions

132 - User Access Control 1 Grant and Revoke.mp4

07:50

133 - User Access Control 2 Drop Alter users.mp4

05:22

37 - Nail that Interview

134 - Tablespace.mp4

05:37

135 - PRIMARY KEY FOREIGN KEY.mp4

05:02

136 - ACID compliance.mp4

05:32

137 - Truncate.mp4

03:54

38 - Performance tuning tips

138 - TIP 1 EXPLAIN.mp4

04:03

139 - TIP 2.mp4

01:17

140 - TIP 3.mp4

02:32

141 - TIP 4 VACCUM.mp4

00:34

142 - TIP 5.mp4

01:59

143 - TIP 6 STRING FUNCTIONS.mp4

02:20

144 - TIP 7 JOINS.mp4

01:57

145 - TIP 8 SCHEMAS.mp4

04:51

39 - Database Basics

146 - What is SQL.mp4

01:49

147 - Tables and DBMS.mp4

03:10

148 - Types of SQL commands.mp4

04:30

149 - PostgreSQL.mp4

02:29

40 - TABLEAU

150 - Introduction.mp4

04:41

151 - Why Tableau.mp4

04:28

152 - Tableau Products.mp4

09:21

41 - Installation and getting started

153 - Installing Tableau desktop and Public.mp4

05:02

154 - About the data.mp4

09:59

155 - Connecting to data.mp4

12:26

156 - Live vs Extract.mp4

04:24

42 - Combining data to create Data model

157 - Combining data from multiple tables.mp4

04:27

158 - Relationships in Tableau.mp4

13:56

159 - Joins in Tableau.mp4

06:43

160 - Types of Joins in Tableau.mp4

06:12

161 - Union in Tableau.mp4

07:55

162 - Physical Logical layer and Data models.mp4

06:30

163 - The visualization screen Sheet.mp4

09:13

43 - Data categorization in Tableau

164 - Types of Data Dimensions and Measures.mp4

06:49

165 - Types of Data Discreet and Continuous.mp4

06:09

166 - Changing Data type in Tableau.mp4

09:25

44 - Most used charts

167 - Bar charts.mp4

14:09

168 - Line charts.mp4

08:53

169 - Scatterplots.mp4

06:11

45 - Customizing charts using Marks shelf

170 - Marks cards.mp4

13:38

171 - Dropping Dimensions and Measures on marks card.mp4

09:49

172 - Dropping Dimensions on Line chart.mp4

04:10

173 - Adding marks in scatterplot.mp4

04:44

46 - Other important charts

174 - Text tables heat map and highlight tables.mp4

08:33

175 - Pie charts.mp4

07:34

176 - Area charts.mp4

09:06

177 - Creating custom hierarchy.mp4

04:04

178 - Tree map.mp4

05:00

179 - Dual combination charts.mp4

08:16

180 - Creating Bins.mp4

06:11

181 - Histogram.mp4

04:36

47 - Grouping and Filtering data

182 - Grouping Data.mp4

09:18

183 - Filtering data.mp4

09:31

184 - Dimension filters.mp4

10:55

185 - Measure filters.mp4

04:04

186 - DateTime filters.mp4

08:02

187 - Filter options.mp4

08:51

188 - Types of filters and order of operation.mp4

11:00

189 - Customizing visual filters.mp4

09:09

190 - Sorting options.mp4

14:35

48 - Map chart in Tableau

191 - How to make a map chart.mp4

07:04

192 - Considerations before making a Map chart.mp4

04:46

193 - Marks card for customizing maps.mp4

07:26

194 - Customizing maps using map menu.mp4

09:33

195 - Layers in a Map.mp4

07:56

196 - Visual toolbar on a map.mp4

04:35

197 - Custom background images.mp4

11:04

198 - Territories in maps.mp4

06:12

199 - Data blending for missing geocoding.mp4

11:09

49 - Calculations and Analytics

200 - Calculated fields in Tableau.mp4

15:07

201 - Functions in Tableau.mp4

02:53

202 - Table calculations theory.mp4

07:06

203 - Table calculations in Tableau.mp4

09:38

204 - Understanding LOD expressions.mp4

27:11

205 - LOD expressions examples.mp4

15:49

206 - Analytics pane.mp4

20:01

50 - Sets and Parameters

207 - Understanding sets in Tableau.mp4

05:34

208 - Creating Sets in Tableau.mp4

10:51

209 - Parameters.mp4

14:45

51 - Dashboard and Story

210 - Dashboard part 1.mp4

17:04

211 - Dashboard part 2.mp4

10:45

212 - Story.mp4

05:09

52 - Appendix

213 - Connecting to SQL data source.mp4

05:26

214 - Connecting to cloud storage services.mp4

03:53

53 - Congratulations and about your certificate

215 - The final milestone.mp4

01:33

216 - Bonus lecture.html

Description

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

What You'll Learn?

Discover the power of Excel and use it to manipulate and analyze data like a pro.
Master SQL queries to extract, filter, and aggregate data from relational databases.
Explore Tableau's interface and create stunning visualizations that communicate insights.
Develop the skills to integrate data from multiple sources and create interactive dashboards in Tableau.
Apply best practices for data cleaning, wrangling, and transformation in Excel and SQL
Create dynamic and automated reports in Tableau that update with new data.
Use Excel and Tableau to identify trends, patterns, and outliers in data.
Develop a data-driven mindset and use data to make informed business decisions.
Apply critical thinking and problem-solving skills to data analysis challenges.

Who is this for?

Anyone curious to master Data Analysis in a short span of time

Individuals who want to pursue a career in data analysis, business intelligence, or data visualization

Professionals who want to upskill and add value to their existing roles by learning data analysis

Aspiring data analysts who want to develop the skills to turn raw data into actionable insights

Small business owners who want to use data to drive better decision-making in their companies

More details

Description
If you are interested in becoming a data analyst, but feel overwhelmed by the technical skills required, this "Become a Data Analyst: Excel, SQL & Tableau - 3-in-1 Bundle" course is designed for you. You'll learn Excel, SQL, and Tableau - the essential tools for data analysis - and develop the skills to turn raw data into insights that drive better business decisions.
In this course, you will:
Develop advanced Excel skills to manipulate and analyze data
Master SQL queries to extract data from databases
Create stunning data visualizations in Tableau to communicate insights
Learning these skills will allow you to excel as a data analyst, and open up new career opportunities. You'll practice real-world examples and complete hands-on exercises, so you can apply your new skills to real-world situations.
This course is different because it offers a comprehensive, 3-in-1 bundle approach that covers all of the key skills required to become a successful data analyst. The course is also taught in an engaging and easy-to-understand format, so you can learn at your own pace and confidently apply your skills in the workplace.
What makes us qualified to teach you?
The course is taught by Abhishek (MBA - FMS Delhi, B. Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B. Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problems using Analytics and we have used our experience to include the practical aspects of business analytics in this course. We have in-hand experience in Business Analysis.
We are also the creators of some of the most popular online courses - with over 1,200,000 enrollments and thousands of 5-star reviews like these ones:
This is very good, i love the fact the all explanation given can be understood by a layman - Joshua
Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy
What is covered in this course?
The analysis of data is not the main crux of analytics. It is the interpretation that helps provide insights after the application of analytical techniques that makes analytics such an important discipline. We have used the most popular analytics software tools which are MS Excel, SQL, and Tableau. This will aid the students who have no prior coding background to learn and implement Analytics and Machine Learning concepts to actually solve real-world problems of Data Analysis.
Let me give you a brief overview of the course
Part 1 - Excel for data analytics
In the first section, i.e. Excel for data analytics, we will learn how to use excel for data-related operations such as calculating, transforming, matching, filtering, sorting, and aggregating data.
We will also cover how to use different types of charts to visualize the data and discover hidden data patterns.
Part 2 - SQLÂ for data analytics
IN the second section, i.e. SQL for data analytics, we will be teaching you everything in SQL that you will need for Data analysis in businesses. We will start with basic data operations like creating a table, retrieving data from a table etc. Later on, we will learn advanced topics like subqueries, Joins, data aggregation, and pattern matching.
Part 3 - Data visualization using Tableau
In this section, you will learn how to develop stunning dashboards, visualizations and insights that will allow you to explore, analyze and communicate your data effectively. You will master key Tableau concepts such as data blending, calculations, and mapping. By the end of the course, you will be able to create engaging visualizations that will enable you to make data-driven decisions confidently.
Our Promise
Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.
Don't let technical skills hold you back from pursuing a career in data analysis. Enroll now and start your journey towards becoming a data analyst.
Who this course is for:
Anyone curious to master Data Analysis in a short span of time
Individuals who want to pursue a career in data analysis, business intelligence, or data visualization
Professionals who want to upskill and add value to their existing roles by learning data analysis
Aspiring data analysts who want to develop the skills to turn raw data into actionable insights
Small business owners who want to use data to drive better decision-making in their companies

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.