May04 B26 DA240525_830

Batch Start Date: 24th May 2025

Course Instructor: 1to10x

To enroll in this course, please contact the Admin

Contact Admin

Course Overview

Schedule of Classes

Start Date & End Date

May 24 2025 - May 24 2027

Course Curriculum

9 Subjects

May04 B26 DA240525_830

3 Learning Materials

LMS Guide

Using the Learning Management System Effectively

Video

00:03:50

Walkthrough - PDF

PDF

Assessment Submissions

Submitting an Online assessment- Walkthrough Guide

Video

00:02:27

Preparatory Session

1 Learning Materials

Preparatory Session

Preparatory Session Tableau Public and MySQL Workbench

PDF

Module : Data Analytics with Google Sheets(6)

12 Learning Materials

Mastering the Basics of Google Sheets

Google Sheet - 1

PDF

Dataset Ski Resort

DOC

Mastering Google Sheets Functions

Google Sheet - 2

PDF

Olympics Dataset

DOC

Case Study - Retail Giant Walmart Analytics

Retail Giant - Walmart

DOC

Case Study - HR Analytics Using Google Sheets

HR Analytics Using Google Sheets

DOC

Appscript -1

AI Integration in Google Sheets

PDF

Data set used - Product Review

DOC

Appscript - 2

Creating your Own AI Functions

PDF

Dataset - UI

DOC

Dataset - Fitness Planner Generator

DOC

Dataset - Social Media Scheduler

DOC

Prompt Engineering Session

4 Learning Materials

1. Prompt Engineering

Module 1- ChatGPT Essentials

PDF

Prompt Engineering

Module 2 - Understanding Prompt Basics

PDF

Deck Used- Prompt Engg

PPT

PDF

Prompt Engineering New

PDF

Module: Data Visualisation and Dashboarding with Tableau

1 Exercises • 40 Learning Materials

Getting Started with Tableau - Hands-on Workshop

Mastering Tableau: The Cornerstone of Modern Business Intelligence

PDF

Start Up data

DOC

Building Your First Tableau Dashboard

Supply Chain Optimization Project PPT

PDF

Inventory Data

Text

Sales data

Text

Shipping Data

Text

Supplier Data

Text

Mastering Tableau Calculations and LOD Expressions

Deck Used- Google Finance

External Link

Deck

PDF

Enhancing Dashboard Interactivity and User Experience

Kaggle World-education- Dataset

External Link

Deck

PDF

Other Important references

Quick Table Calculations

External Link

Format Text

External Link

Stories

External Link

Quick Table Calculations

External Link

Create a Story

External Link

Best Practices for Telling Great Stories

External Link

Visiting Trends

External Link

Filter Data from Your Views

External Link

color wheel - Google Search

External Link

GOOGLEFINANCE - Google Docs Editors Help

External Link

Kaggle

External Link

Tableau Public

External Link

Connecting Tableau with Special Format Files.

Deck Used- New York Park Data Set

External Link

Deck Used - Crime Data Set

External Link

Deck Used - World Health Data Set

External Link

PPT Deck used- Tableau

Mastering Tableau: The Cornerstone of Modern Business Intelligence- Day 1

PDF

Supply Chain Optimization Project: GlobalTech Solutions-Leveraging BI in Industry - Day 2

PDF

Mastering Tableau Dashboards: From Basics to Advanced Techniques- Day 3

PDF

Mastering Tableau Calculations and LOD Expressions- Day 5

PDF

Tableau_Assignment_1

The Tableau Workspace

Data Source Page

External Link

The Tableau Workspace

External Link

GOOGLE FINANCE

External Link

How to use the GOOGLEFINANCE function in Google Sheets

External Link

Tableau_Assignment_1

Exercise

NBA vs NFL MultiTime dataset

Multitimeline Dataset Worldwide

Text

MultiTimeline Dataset

Text

Dataset- Electric_Vehicle_Population

Electric_Vehicle_Population_Data.csv

Text

Dataset- Tips

Text

Dataset- Startup

Startup Dataset

DOC

Module: Data Warehousing, ETL Pipelines using SQL and BigQuery

1 Exercises • 42 Learning Materials

Database, RDBMS, SQL and MySql Installation

Day 1 Getting Started with SQL

PDF

Mysql Installation

External Link

Reading material- Chapter 1: Introduction to Database & DBMS & MySQL Workbench Setup

PDF

Data Types, Intro to Constraints

Exploring MYSQL interface

PDF

Required Link - Mysql Installation

External Link

Script File - day 2

External Link

Reading material - Chapter 2: SQL Theory

PDF

SQL Clauses 1: Querying, Filtering, Conditional Filtering

SQL CLAUSES- PART 1

PDF

Used Cars Dataset

Text

Script file - day 3

External Link

Reading Material - Chapter 3: Querying Data

PDF

SQL Clauses 2: Sorting, Organizing, Summarizing, Aggregation

SQL CLAUSES - PART2

PDF

Reading material Chapter 4: Subquery & Aggregating Data

PDF

Case Study Social Media Analysis Using MySQL

PDF

Social Media Database

External Link

SQL Joins, Type of Joins, Union and Union all

SQL – Master the Joins

PDF

Chicago Public School Data

External Link

Chicago Crime Data

External Link

Chicago Census Data

External Link

Chicago Solution

External Link

Problem Statements- Task to be performed

PDF

Reading material Chapter 5: Joins

PDF

SQL Subquery

PDF

SQL Window Functions

PDF

Reading material - MySQL Window Functions

PDF

MySQL Advanced Concepts and Optimization

Reading Material Chapter 7 - MySQL Advanced Concepts and Optimization

PDF

Bigquery Project

Google BigQuery

PDF

Set Up Guide - Google BigQuery

PDF

From data warehouse to a unified, AI-ready data platform

External Link

Social Media dataset

Case Study Social Media Analysis Using MySQL

PDF

Social Media Solution

External Link

Spotify Dataset

Spotify dataset 1

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

Spotify dataset 2

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

Chinook Database

Chinook

Text

Billing

Text

Assessment

Assessment 1

Exercise

Assignment- Adidas

Adidas

PDF

Script File

External Link

Assignment- F1 Racing

Dataset Formula1 Racing

DOC

F1 Racing with Solution

PDF

Assignment- Ecommerce

SQL Assignment 2 SQL - JOINS

PDF

Hospital_patient_dataset

hospital_patient_dataset

Text

Bigquery_Assignment

BigQuery - restaurant_dataset.tips.

PDF

AI Driven Data Analytics with Python

26 Learning Materials

Day 1 Setting Up Your Python Environment for Data Analytics

Deck Used PPT

PPT

Colab link

External Link

Day 2 Hands-on Python Basics Workshop

PPT

PDF

colab notebook link of James - Sorting Hat example

External Link

colab notebook of python live - 2

External Link

Day 3 Deck Used

PPT

Excersice

Colab Link

Day 4 Deck used

PPT

Colab Link

Day 5 Deck Used

PPT

Colab Link

Dataset

Sales data

Text

Day 6 Deck Used

Deck used PPT

PPT

Colab Link USed

External Link

Data Set

DOC

Day 7 Deck Used

Deck Used

PDF

Plot types

External Link

Colab Link used

External Link

Plot Type

External Link

Data Set Used

DOC

Day 8 Deck used

Deck Used

PDF

Colab link used

External Link

Reading material

Python Fundamentals: Unlocking Data's Potential with Python

PDF

Python Workbook

Python DSA Workbook

PDF

Statistical Modeling and Machine Learning for Data Analytics

20 Learning Materials

STATISTICAL_MODELING_1

PPT

PDF

Election Data Analysis Case Study

application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess

Election 2024 Dataset for Case study

External Link

Election 2024 Dataset for Case study

ZIP

STATISTICAL_MODELING_2

Optimizing Logistics with Data Analytics

PDF

Introduction To Machine Learning

PDF

BHP- Dataset

Text

Plant - Dataset

Text

HomePrices - Dataset

Text

Canada Per Capita Income

Text

New York Airbnb Open Data

Text

Code - Colab Link

External Link

Code - Colab Link 2

External Link

Linear Regression

ZIP

Dataset for Homeprices_Multi

Homeprices_multi

Text

Dataset for Gym Attendance

Gym Attendance

Text

Dataset for Student's Exam

Student's Exam

Text

Dataset for Cricket Player

Cricket Players

Text

Time Series Theory and Time Series Code/Project

Text

Time Series Theory and Time Series Code/Project

Text

Python Capstone Project

2 Learning Materials

Day 1 - Python capstone Project

Live Class Recording

External Link

Day 2- Python capstone Project

Live Class Recording

External Link

Course Instructor

1to10x

103 Courses • 994 Students

May04 B26 DA240525_830

Course Overview

Schedule of Classes

May 24 2025 - May 24 2027

Course Curriculum

May04 B26 DA240525_830

LMS Guide

Using the Learning Management System Effectively

Walkthrough - PDF

Assessment Submissions

Submitting an Online assessment- Walkthrough Guide

Preparatory Session

Preparatory Session

Preparatory Session Tableau Public and MySQL Workbench

Module : Data Analytics with Google Sheets(6)

Mastering the Basics of Google Sheets

Google Sheet - 1

Dataset Ski Resort

Mastering Google Sheets Functions

Google Sheet - 2

Olympics Dataset

Case Study - Retail Giant Walmart Analytics

Retail Giant - Walmart

Case Study - HR Analytics Using Google Sheets

HR Analytics Using Google Sheets

Appscript -1

AI Integration in Google Sheets

Data set used - Product Review

Appscript - 2

Creating your Own AI Functions

Dataset - UI

Dataset - Fitness Planner Generator

Dataset - Social Media Scheduler

Prompt Engineering Session

1. Prompt Engineering

Module 1- ChatGPT Essentials

Prompt Engineering

Module 2 - Understanding Prompt Basics

Deck Used- Prompt Engg

PPT

Prompt Engineering New

Prompt Engineering New

Module: Data Visualisation and Dashboarding with Tableau

Getting Started with Tableau - Hands-on Workshop

Mastering Tableau: The Cornerstone of Modern Business Intelligence

Other Link: Tableau Public

Start Up data

Building Your First Tableau Dashboard

Supply Chain Optimization Project PPT

Inventory Data

Sales data

Shipping Data

Supplier Data

Mastering Tableau Calculations and LOD Expressions

Deck Used- Google Finance

Deck

Enhancing Dashboard Interactivity and User Experience

Kaggle World-education- Dataset

Deck

Other Important references

Quick Table Calculations

Format Text

Stories

Quick Table Calculations

Create a Story

Best Practices for Telling Great Stories

Visiting Trends

Filter Data from Your Views

color wheel - Google Search

GOOGLEFINANCE - Google Docs Editors Help

Kaggle

Tableau Public

Connecting Tableau with Special Format Files.

Deck Used- New York Park Data Set

Deck Used - Crime Data Set

Deck Used - World Health Data Set

PPT Deck used- Tableau

Mastering Tableau: The Cornerstone of Modern Business Intelligence- Day 1

Supply Chain Optimization Project: GlobalTech Solutions-Leveraging BI in Industry - Day 2

Mastering Tableau Dashboards: From Basics to Advanced Techniques- Day 3