Data Analysis Masterclass (4 courses in 1) 

How is excel important to businesses

Basic Formatting in Excel

Insertion and Deletion in Excel

Data Types in Excel

Q and A

Thanks for your Support

Quiz on Excel Basics

Quiz Solution

Applying the sort function

Applying the advanced filter function

Quiz on Sort and Filter

Quiz Solution

Exercise on Filters

Solution on Filters

Using the UPPER, LOWER and PROPER functions

Using the LEFT, RIGHT and SEARCH functions

Using the TRIM, CONCAT and LEN functions

Quiz on Text functions

Quiz Solution

Exercise on Text Functions

Solution on Text Functions

Using the MIN, MAX AVERAGE functions

Finding the Standard deviations

Finding the Outliers present in data

Finding the Missing values in data

Quiz on Statistical functions

Quiz Solution

Applying VLOOKUP function

Quiz on Lookup Functions

Quiz Solution

Exercise on Lookup Functions

Solution on Lookup Functions

Why to use Index and Match?

Applying Index and Match

Quiz on Index and Match

Quiz Solution

Exercise on Index and Match Functions

Solution on Index and Match Functions

Build your first SQL query

Basic SQL queries Part - 1

Basic SQL queries Part - 2

Brain Buster Exercise

Brain Buster Solution

Quiz on Introduction to SQL

Quiz Solution

Installation

Numerical Datatypes

String Datatypes

Constraints

Quiz on DDL

Quiz Solution

Creating Databases and Tables

Alter, Drop, and Truncate

Insert, Update, and Delete

Quiz on DML

Quiz Solution

Foreign Key

Joins

Left, Right, and Outer Join

Compound Joins, and Multiple Joins

Star Schema

Sub Queries Part 1

Sub Queries Part 2

Quiz on Joins, Sub Queries & Set Operations

Quiz Solution

Connecting MySQL through Python

Loading Tables into a Pandas DataFrame

Quiz Solution

Why should you learn Python?

Installing Python and Jupyter Notebook

Understanding the Interface of Jupyter Notebook

Naming Convention for variables

Built in Data Types and Type Casting

Quiz on Variables and Data Types

Quiz Solution

Exercise on Variables and Data Types

Exercise on Scope of Variables

Introduction to datetime

The date and time class

The datetime class

Quiz on Dates and Times

Quiz Solution

Exercise on Date and Time

Solution on Date and Time

Meta Characters for Regular Expressions

Built-in Functions for Regular Expressions

Special Characters for Regular Expressions

Sets for Regular Expressions

Getting Started with Tableau

Navigating Tableau

Creating Your First Visualization

Building Your First Dashboard

Quiz on Creating your First Tableau Dashboard

Introduction

Dimensions and Measures

Green & Blue Pills

Measures Names & Values

Working with Time Series Data

Aggregation and Granularity

Aggregation Options

Show Me Toolbar

Marks cards & Level of Detail

Custom Shapes

Filtering Data

Pages Shelf

Exercise on Building Blocks of Data Visualization

Solution on Building Blocks of Data Visualization

Quiz on Building Blocks of Data Visualization

Highlight Table

Highlight Table Bar Charts & Sorting

Bar-in-Bar

Histogram

Pie Charts

Pie Chart Exercise Solution

Tree Map

Bubble Chart

Line Charts

Area Chart

Heat Map

Exercise on Tableau Basic Visualization (Vietnam War Dataset)

Solution on Tableau Basic Visualization

Quiz on Tableau Basic Visualization

Overview

Theme & Workbook Level Formatting

Axis Lines and Formatting

Parts of the View

Formatting Pane - Part 1

Formatting Pane - Part 2 (Fonts, Alignment & Shading)

Formatting Pane - Part 3 (Borders & Lines)

Number Format

Titles & Captions

Mark Labels

Styling and Customizing a Tooltip

Visualization in Tooltip

Editing Axis

Annotating the Viz

Section Exercise - Data Ink Ratio

Section Exercise Solution - Data Ink Ratio