• Post category:StudyBullet-13
  • Reading time:22 mins read


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

What you will 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.

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?


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

Content

Introduction

Introduction

Excel Basics

Getting started with Excel
Course Resources
This is a milestone!
Worksheet basics
Entering values and Formulas
Data Formats
Data Handling Basics – Cut, Copy, Paste
Saving and Printing in Excel

Essential Excel functions

Basic Formula Operations
Mathematical Functions – Part 1
Mathematical Functions – Part 2
Difference between RANK, RANK.AVG and RANK.EQ
Textual Functions – Part 1
Textual Functions – Part 2
Logical Functions
Date-Time Functions
Lookup Functions ( V Lookup, Hlookup, Index-Match )

Data Tools

Data Tools Part 1
Data Tools Part 2

Formatting data and tables

Formatting data and tables

Pivot Tables

Pivot Tables

Excel Charts

Excel Charts – Categories of messages that can be conveyed
Elements of charts
The Easy way of creating charts
Bar and column charts
Formatting charts Part -1
Formatting charts Part -2
Line Charts
Area Charts
Pie and Doughnut Charts
Why we should avoid Pie charts
Scatter plot or XY chart
Frequency Distribution and Histograms
Waterfall Charts
Hierarchy Charts: Sunburst and Treemap
Combination charts
Sparklines

Pivot Charts

Pivot Charts

Special purpose charts

Stock charts
Radar charts
Surface charts
Heatmaps

Named Ranges

Named Ranges
Indirect Functions

Excel Shortcuts

Shortcuts

Macros

Macros

Advanced Excel

Advanced Excel: Analytics in Excel

Creative Infographics

Infographic Example 1
Infographic Example 2

SQL

Introduction

Installation and getting started

Installing PostgreSQL and pgAdmin in your PC
If pgAdmin is not opening…

Case Study : Demo

Case Study Part 1 – Business problems
Case Study Part 2 – How SQL is Used

Fundamental SQL statements

CREATE
INSERT
Import data from File
SELECT statement
SELECT DISTINCT
WHERE
Logical Operators
UPDATE
DELETE
ALTER part -1
ALTER part – 2

Restore and Back-up

Restore and Back-up
Debugging restoration issues
Creating DB using CSV files
Debugging summary and Code for CSV files

Selection commands: Filtering

IN
BETWEEN
LIKE

Selection commands: Ordering

Side Lecture: Commenting in SQL
ORDER BY
LIMIT

Alias

AS

Aggregate Commands

COUNT
SUM
AVERAGE
MIN & MAX

Group By Commands

GROUP BY
HAVING

Conditional Statement

CASE WHEN

JOINS

Introductions to Joins
Concepts of Joining and Combining Data
Preparing the data
Inner Join
Left Join
Right Join
Full Outer Join
Cross Join
Intersect and Intersect ALL
Except
Union

Subqueries

Part-1 Subquery in WHERE clause
Part-2 Subquery in FROM clause
Part-3 Subquery in SELECT clause

Views and Indexes

VIEWS
INDEX

String Functions

LENGTH
UPPER LOWER
REPLACE
TRIM, LTRIM, RTRIM
CONCATENATION
SUBSTRING
LIST AGGREGATION

Mathematical Functions

CEIL & FLOOR
RANDOM
SETSEED
ROUND
POWER

Date-Time Functions

CURRENT DATE & TIME
AGE
EXTRACT

PATTERN (STRING) MATCHING

PATTERN MATCHING BASICS
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part -1
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Part 2

Windows Functions

Introduction to Window functions
Introduction to Row number
Implementing Row number in SQL
RANK and DENSERANK
NTILE function
AVERAGE function
COUNT
SUM TOTAL
RUNNING TOTAL
LAG and LEAD

COALESCE function

COALESCE function

Data Type conversion functions

Converting Numbers/ Date to String
Converting String to Numbers/ Date

User Access Control functions

User Access Control -1 Grant and Revoke
User Access Control -2 Drop, Alter users

Nail that Interview!

Tablespace
PRIMARY KEY & FOREIGN KEY
ACID compliance
Truncate

Performance tuning tips

TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 ( STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)

Database Basics

What is SQL?
Tables and DBMS
Types of SQL commands
PostgreSQL

TABLEAU

Introduction
Why Tableau
Tableau Products

Installation and getting started

Installing Tableau desktop and Public
About the data
Connecting to data
Live vs Extract

Combining data to create Data model

Combining data from multiple tables
Relationships in Tableau
Joins in Tableau
Types of Joins in Tableau
Union in Tableau
Physical Logical layer and Data models
The visualization screen – Sheet

Data categorization in Tableau

Types of Data – Dimensions and Measures
Types of Data – Discreet and Continuous
Changing Data type in Tableau

Most used charts

Bar charts
Line charts
Scatterplots

Customizing charts using Marks shelf

Marks cards
Dropping Dimensions and Measures on marks card
Dropping Dimensions on Line chart
Adding marks in scatterplot

Other important charts

Text tables, heat map and highlight tables
Pie charts
Area charts
Creating custom hierarchy
Tree map
Dual combination charts
Creating Bins
Histogram

Grouping and Filtering data

Grouping Data
Filtering data
Dimension filters
Measure filters
Date-Time filters
Filter options
Types of filters and order of operation
Customizing visual filters
Sorting options

Map chart in Tableau

How to make a map chart
Considerations before making a Map chart
Marks card for customizing maps
Customizing maps using map menu
Layers in a Map
Visual toolbar on a map
Custom background images
Territories in maps
Data blending for missing geocoding

Calculations and Analytics

Calculated fields in Tableau
Functions in Tableau
Table calculations theory
Table calculations in Tableau
Understanding LOD expressions
LOD expressions examples
Analytics pane

Sets and Parameters

Understanding sets in Tableau
Creating Sets in Tableau
Parameters

Dashboard and Story

Dashboard part -1
Dashboard part – 2
Story

Appendix

Connecting to SQL data source
Connecting to cloud storage services

Congratulations and about your certificate

The final milestone!
Bonus lecture