TEST Batch

Course Instructor: Sumit Kumar

To enroll in this course, please contact the Admin

Course Overview

Schedule of Classes

Course Curriculum

4 Subjects

Tableau

39 Learning Materials

Section 1 Tableau Introduction

Section 1- PPT

PPT

1. Getting Started

External Link

2. Navigating Tableau

External Link

3. Creating Your First Visualizations

External Link

4. Building Your First Dashboard

External Link

Coffee Datasets

Text

Section 2 Building Blocks of Data Visualization

Section 2- PPT

PPT

1. Dimensions & Measures

External Link

2. Green & Blue Pills

External Link

3. Measure Names & values

External Link

4. Working with Time Series Data

External Link

5. Aggregation and Granularity

External Link

6. Aggregation Options

External Link

7. Show Me Toolbar

External Link

8. Marks Card & Level of Detail

External Link

9. Custom Shapes

External Link

10. Filtering Data

External Link

Dataset Global_Superstore.csv

External Link

Section 3 Essential Visualisations

Chapter 1- Highlight Table

Video

00:13:19

Chapter 2 - Bar Charts & Sorting

Video

00:08:21

Chapter 3 - Bar in Bar

Video

00:08:16

Chapter 4- Histogram

Video

00:13:13

Chapter 5- Pie Charts

Video

00:09:59

Chapter 6- Tree Map

Video

00:10:59

Chapter 7- Bubble Chart

Video

00:09:00

Chapter 8 - Line Chart

Video

00:09:24

Chapter 10- Heat Map

Video

00:10:30

Chapter 11- Section Exercise

Video

00:24:16

Chapter 9 - Area Chart

Video

00:16:23

Chapter 12- Section Solution

Video

00:33:59

Everest_Fataliies.csv

Text

Vietnam War Civilian Deaths

Text

Vietnam War Timeline Stats

Text

Vietnam War US Casualties

Text

Titanic Dataset

Text

Section 4- Formatting in Tableau

1. Formating in Tableau

External Link

2. Formating and Editing lines

External Link

3. Parts of the View

External Link

S&P Returns Link

External Link

Assignment Testing

Test

Testing

SQL

Module 3 : Data Warehousing, ETL Pipelines using SQL and BigQuery

20 Learning Materials

Section 1

Installing MySQL on macOS

External Link

Section 2

1. Section Overview

External Link

2. Understanding Database Tables

External Link

3. Inserting records

External Link

4. Selecting Data

External Link

5. Filtering records

External Link

6. Updating Data

External Link

7. Deleting Data

External Link

Section 3

1. ORDER BY Clause

External Link

2. LIMIT, OFFSET & ISNULL

External Link

3. LIKE - WILDCARDS

External Link

Section 4

1. SQL Function

External Link

2. Math Function

External Link

3. Date And Time Function

External Link

4. Grouping and Aggregate Functions

External Link

Section 5

1. SQL Joins

External Link

2. SQL Subqueries

External Link

3. SQL Constraints

External Link

4. SQL Window Functions

External Link

5. SQL Case & CTE

External Link

Module 1: Data Analytics with Google Sheets: Analytics, Automation, and AI

1 Exercises • 21 Learning Materials

Getting Started with Google Sheets

PDF

Self Paced Learning Video

External Link

Mastering the Basics of Google Sheets

Mastering the Basics of Google Sheet

PDF

Self Paced Learning Video

External Link

Mastering Google Sheets Functions

Mastering Google Sheet Functions

PDF

Practice Workbook

DOC

Class Notes

PDF

Practice Workbook

Assignment

Pivot Table Foundations: Mastering KPIs and Data Analysis

PDF

Charts and Dashboarding : Advanced Techniques for Data Mastery

Pivot Tables Unleashed: Advanced Techniques for Data Mastery

PDF

Introduction to Google Apps Script

PDF

Self Paced Learning Video

External Link

Error Handling

External Link

Building Blocks of Google Apps Script

PDF

Self Paced Learning Video

External Link

Self Paced Learning Video

External Link

Custom Functions Deep Dive in Google Sheets

PDF

Self Paced Learning Video

External Link

Self Paced Learning Video

External Link

From Mockups to AI: Preparing for OpenAI GPT Integration

Challenge 9: From Mockups to AI: Preparing for OpenAI GPT Integration

PDF

Bringing GPT to Life: Implementing Real AI Functions in Google Sheets

Challenge 10: Bringing GPT to Life: Implementing Real AI Functions in Google Sheets

PDF

Implementing Advanced GPT Functions

Challenge 11: Implementing Advanced GPT Functions

PDF

Course Instructor