April 02 B20 DA190425_330

Start Date: 19th April

Course Instructor: 1to10x

To enroll in this course, please contact the Admin

Course Overview

Schedule of Classes

Course Curriculum

5 Subjects

April 02 B20 DA190425_330

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

AccessPlus Module- Google Sheets

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

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 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

25 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

Course Instructor

1to10x

74 Courses • 755 Students