Home

All courses

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

Data Analysis

Business

Business Analytics & Intelligence

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

4.5

(2418)

23735 enrolled on this course

Last updated 11/2021

Start-Tech Academy

₹ 799.0

₹ 2299.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

[November 2024 update]
Added a video on the "Analyze Data" option in MS Excel
Added a new section on how to practice SQL using fun case studies.
Added a video on "How to integrate ChatGPT inside Excel using openAI API"
Added a video on "How Index works in SQL"
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

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.

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction

2-Excel Basics

2.1-Getting started with Excel

2.2-Course Resources

2.3-This is a milestone!

2.4-Worksheet basics

2.5-Entering values and Formulas

2.6-Data Formats

2.7-Data Handling Basics - Cut, Copy, Paste

2.8-Saving and Printing in Excel

2.9-Quiz

3-Essential Excel functions

3.1-Basic Formula Operations

3.2-Mathematical Functions - Part 1

3.3-Mathematical Functions - Part 2

3.4-Quiz

3.5-Difference between RANK, RANK.AVG and RANK.EQ

3.6-Exercise 1: Mathematical Functions

3.7-Textual Functions - Part 1

3.8-Textual Functions - Part 2

3.9-Exercise 2: Textual Functions

3.10-Quiz

3.11-Logical Functions

3.12-Exercise 3: Logical Functions

3.13-Date-Time Functions

3.14-Exercise 4: Date-Time Functions

3.15-Lookup Functions ( V Lookup, Hlookup, Index-Match )

3.16-Exercise 5: Lookup Functions

3.17-Quiz

4-Data Tools

4.1-Sorting, Filtering and Data Validation

4.2-Text-to-columns and remove duplicates

4.3-Advanced Filter option

4.4-Exercise 6: Data Tools

4.5-Quiz

5-Formatting data and tables

5.1-Formatting data and tables

5.2-Exercise 7: Formatting

6-Pivot Tables

6.1-Pivot Tables

6.2-Exercise 8: Pivot tables

7-Excel Charts

7.1-Excel Charts - Categories of messages that can be conveyed

7.2-Elements of charts

7.3-The Easy way of creating charts

7.4-Bar and column charts

7.5-Formatting charts Part -1

7.6-Formatting charts Part -2

7.7-Line Charts

7.8-Area Charts

7.9-Pie and Doughnut Charts

7.10-Why we should avoid Pie charts

7.11-Scatter plot or XY chart

7.12-Frequency Distribution and Histograms

7.13-Waterfall Charts

7.14-Hierarchy Charts: Sunburst and Treemap

7.15-Combination charts

7.16-Sparklines

7.17-Exercise 9: Charts

7.18-Quiz

8-Pivot Charts

8.1-Pivot Charts

9-NEW! Analyze Data option in Excel - only for Microsoft 365 users

9.1-Analyze Data option in Excel

10-Special purpose charts

10.1-Stock charts

10.2-Radar charts

10.3-Surface charts

10.4-Heatmaps

10.5-Quiz

11-Named Ranges

11.1-Named Ranges

11.2-Indirect Functions

11.3-Quiz

12-Excel Shortcuts

12.1-Shortcuts

12.2-Exercise 10: Shortcuts

13-Using ChatGPT with Excel

13.1-Use ChatGPT for Excel problems

13.2-Integrating ChatGPT with Excel using API key

14-Macros

14.1-Macros

14.2-Exercise 11: Macros

14.3-Quiz

15-Advanced Excel

15.1-Advanced Excel: Analytics in Excel

15.2-Quiz

16-Creative Infographics

16.1-Infographic Example 1

16.2-Infographic Example 2

16.3-Quiz

16.4-Practical Task 1

16.5-Quiz

16.6-Practical Task 2

17-SQL

17.1-Introduction

18-Installation and getting started

18.1-Installing PostgreSQL and pgAdmin in your System

18.2-If pgAdmin is not opening...

19-Case Study : Demo

19.1-Case Study Part 1 - Business problems

19.2-Case Study Part 2 - How SQL is Used

20-Fundamental SQL statements

20.1-CREATE

20.2-Exercise 1: Create DB and Table

20.3-Solutions to all Exercises

20.4-INSERT

20.5-Import data from File

20.6-Exercise 2 Inserting and Importing

20.7-SELECT statement

20.8-Quick coding exercise on Select Statement

20.9-SELECT DISTINCT

20.10-Quick coding exercise on Distinct Command

20.11-WHERE

20.12-Quick coding exercise on Where Statement

20.13-Logical Operators

20.14-Quick coding exercise on Logical Operators

20.15-Exercise 3 SELECT WHERE

20.16-UPDATE

20.17-Quick coding exercise on Update Command

20.18-DELETE

20.19-Quick coding exercise on Delete Command

20.20-ALTER part -1

20.21-ALTER part - 2

20.22-Quick coding exercise on Alter Command

20.23-Exercise 4 Updating Table

20.24-Quiz

21-Restore and Back-up

21.1-Restore and Back-up

21.2-Debugging restoration issues

21.3-Creating DB using CSV files

21.4-Debugging summary and Code for CSV files

21.5-Exercise 5 Restore and Back-up

22-Selection commands: Filtering

22.1-IN

22.2-Quick coding exercise on IN operator

22.3-BETWEEN

22.4-Quick coding exercise on Between Operator

22.5-LIKE

22.6-Quick coding exercise on Like operator

22.7-Exercise 6: In, Like & Between

23-Selection commands: Ordering

23.1-Side Lecture: Commenting in SQL

23.2-ORDER BY

23.3-Quick coding exercise on Order by Clause

23.4-LIMIT

23.5-Quick coding exercise on Limit Command

23.6-Exercise 7 Sorting

24-Alias

24.1-AS

24.2-Quick coding exercise on AS operator

25-Aggregate Commands

25.1-COUNT

25.2-Quick coding exercise on Count function

25.3-SUM

25.4-Quick coding exercise on Sum function

25.5-AVERAGE

25.6-Quick coding exercise on Average function

25.7-MIN & MAX

25.8-Quick coding exercise on MIN & MAX function

25.9-Exercise 8 Aggregate functions

25.10-Quiz

26-Group By Commands

26.1-GROUP BY

26.2-Quick coding exercise on Group By Clause

26.3-HAVING

26.4-Quick coding exercise on Having Clause

26.5-Exercise 9 Group By

26.6-Quiz

27-Conditional Statement

27.1-CASE WHEN

27.2-Quick coding exercise on CASE WHEN Statement

28-JOINS

28.1-Introductions to Joins

28.2-Concepts of Joining and Combining Data

28.3-Preparing the data

28.4-Inner Join

28.5-Quick coding exercise on Inner Join

28.6-Left Join

28.7-Quick coding exercise on Left Join

28.8-Right Join

28.9-Quick coding exercise on Right Join

28.10-Full Outer Join

28.11-Quick coding exercise on Full Outer Join

28.12-Cross Join

28.13-Quick coding exercise on Cross Join

28.14-Intersect and Intersect ALL

28.15-Quick coding exercise on Intersect and Intersect ALL

28.16-Except

28.17-Quick coding exercise on Except

28.18-Union

28.19-Quick coding exercise on Union Operator

28.20-Exercise 10 Joins

28.21-Quiz

29-Subqueries

29.1-Part-1 Subquery in WHERE clause

29.2-Quick coding exercise on Subquery in Where Clause

29.3-Part-2 Subquery in FROM clause

29.4-Quick coding exercise on Subquery in From Clause

29.5-Part-3 Subquery in SELECT clause

29.6-Quick coding exercise on Subquery in Select Clause

29.7-Exercise 11 Subqueries

30-Fun way to practice SQL

30.1-Solve Murder Mystery using SQL

31-Views and Indexes

31.1-VIEWS

31.2-Quick coding exercise on Views

31.3-INDEX

31.4-Quick coding exercise on Index

31.5-How Index works in SQL

31.6-Exercise 12 Views

31.7-Quiz

32-String Functions

32.1-LENGTH

32.2-Quick coding exercise on LENGTH function

32.3-UPPER LOWER

32.4-Quick coding exercise on UPPER LOWER function

32.5-REPLACE

32.6-Quick coding exercise on REPLACE function

32.7-TRIM, LTRIM, RTRIM

32.8-Quick coding exercise on TRIM, LTRIM, RTRIM functions

32.9-CONCATENATION

32.10-Quick coding exercise on CONCATENATION function

32.11-SUBSTRING

32.12-Quick coding exercise on SUBSTRING function

32.13-LIST AGGREGATION

32.14-Exercise 13 String Functions

33-Mathematical Functions

33.1-CEIL & FLOOR

33.2-Quick coding exercise on CEIL & FLOOR functions

33.3-RANDOM

33.4-SETSEED

33.5-ROUND

33.6-Quick coding exercise on ROUND function

33.7-POWER

33.8-Quick coding exercise on POWER function

33.9-Exercise 14 Mathematical Functions

33.10-Quiz

34-Date-Time Functions

34.1-CURRENT DATE & TIME

34.2-Quick coding exercise on CURRENT DATE & TIME function

34.3-AGE

34.4-EXTRACT

34.5-Exercise 15 Date-time functions

34.6-Quiz

35-PATTERN (STRING) MATCHING

35.1-PATTERN MATCHING BASICS

35.2-Quick coding exercise on Pattern Matching Basics

35.3-ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part -1

35.4-ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part 2

35.5-Exercise 16 Pattern Matching

36-Windows Functions

36.1-Introduction to Window functions

36.2-Introduction to Row number

36.3-Implementing Row number in SQL

36.4-Quick coding exercise on Row number

36.5-RANK and DENSERANK

36.6-Quick coding exercise on RANK and DENSERANK

36.7-NTILE function

36.8-Quick coding exercise on NTILE function

36.9-AVERAGE function

36.10-Quick coding exercise on AVERAGE function

36.11-COUNT

36.12-Quick coding exercise on COUNT function

36.13-SUM TOTAL

36.14-Quick coding exercise on SUM TOTAL function

36.15-RUNNING TOTAL

36.16-LAG and LEAD

36.17-Quick coding exercise on LAG and LEAD function

37-COALESCE function

37.1-COALESCE function

37.2-Quick coding exercise on COALESCE function

38-Data Type conversion functions

38.1-Converting Numbers/ Date to String

38.2-Quick coding exercise on Converting Numbers/ Date to String function

38.3-Converting String to Numbers/ Date

38.4-Quick coding exercise on Converting String to Numbers/ Date function

39-User Access Control functions

39.1-User Access Control -1 Grant and Revoke

39.2-User Access Control -2 Drop, Alter users

39.3-Practical Task 1

40-Nail that Interview!

40.1-Showcasing SQL Skills with HackerRank Stars

40.2-Tablespace

40.3-PRIMARY KEY & FOREIGN KEY

40.4-ACID compliance

40.5-Truncate

41-Performance tuning tips

41.1-TIP 1 (EXPLAIN)

41.2-TIP 2

41.3-TIP 3

41.4-TIP 4 (VACCUM)

41.5-TIP 5

41.6-TIP 6 ( STRING FUNCTIONS)

41.7-TIP 7 (JOINS)

41.8-TIP 8 (SCHEMAS)

42-Database Basics

42.1-What is SQL?

42.2-Tables and DBMS

42.3-Types of SQL commands

42.4-PostgreSQL

43-TABLEAU

43.1-Introduction

43.2-Tableau Products

43.3-Quiz

44-Installation and getting started

44.1-Installing Tableau desktop and Public

44.2-About the data

44.3-Connecting to data

44.4-Live vs Extract

44.5-Quiz

45-Combining data to create Data model

45.1-Combining data from multiple tables

45.2-Relationships in Tableau

45.3-Joins in Tableau

45.4-Types of Joins in Tableau

45.5-Union in Tableau

45.6-Physical Logical layer and Data models

45.7-The visualization screen - Sheet

45.8-Quiz

46-Data categorization in Tableau

46.1-Types of Data - Dimensions and Measures

46.2-Types of Data - Discreet and Continuous

46.3-Changing Data type in Tableau

47-Most used charts

47.1-Bar charts

47.2-Line charts

47.3-Scatterplots

48-Customizing charts using Marks shelf

48.1-Marks cards

48.2-Dropping Dimensions and Measures on marks card

48.3-Dropping Dimensions on Line chart

48.4-Adding marks in scatterplot

49-Other important charts

49.1-Text tables, heat map and highlight tables

49.2-Pie charts

49.3-Area charts

49.4-Creating custom hierarchy

49.5-Tree map

49.6-Dual combination charts

49.7-Creating Bins

49.8-Histogram

49.9-Quiz

50-Grouping and Filtering data

50.1-Grouping Data

50.2-Filtering data

50.3-Dimension filters

50.4-Measure filters

50.5-Date-Time filters

50.6-Filter options

50.7-Types of filters and order of operation

50.8-Customizing visual filters

50.9-Sorting options

50.10-Quiz

51-Map chart in Tableau

51.1-How to make a map chart

51.2-Considerations before making a Map chart

51.3-Marks card for customizing maps

51.4-Customizing maps using map menu

51.5-Layers in a Map

51.6-Visual toolbar on a map

51.7-Custom background images

51.8-Territories in maps

51.9-Data blending for missing geocoding

51.10-Quiz

52-Calculations and Analytics

52.1-Calculated fields in Tableau

52.2-Functions in Tableau

52.3-Table calculations theory

52.4-Table calculations in Tableau

52.5-Understanding LOD expressions

52.6-LOD expressions examples

52.7-Analytics pane

53-Sets and Parameters

53.1-Understanding sets in Tableau

53.2-Creating Sets in Tableau

53.3-Parameters

53.4-Quiz

54-Dashboard and Story

54.1-Dashboard part -1

54.2-Dashboard part - 2

54.3-Story

54.4-Quiz

55-Saving and Sharing your work

55.1-Saving and sharing tableau workbook

55.2-Saving and sharing your data

55.3-Saving and sharing views and dashboards

56-Appendix

56.1-Connecting to SQL data source

56.2-Connecting to cloud storage services

56.3-Additional resources

56.4-Practical Task 1

56.5-Practical Task 2

56.6-Comprehensive Interview Preparation Questions

57-Congratulations and about your certificate

57.1-The final milestone!

57.2-Bonus lecture

Course Categories

Popular Courses

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

Description

What you'll learn

Requirements

Course Content

You May Like