January 02 B08 DA240125_930

Course Instructor: 1to10x

To enroll in this course, please contact the Admin

Course Overview

Schedule of Classes

Start Date & End Date

Jan 24 2025 - Sep 30 2025

Course Curriculum

16 Subjects

LMS Walkthrough Guide

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

10xDataAnalyst January 02 2025

1 Learning Materials

Induction

PPT

PDF

Module : Data Analytics with Google Sheets

7 Exercises • 32 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

Ch2 - Data Types

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

Banking Customer Churn Analysis

PDF

Customer_Churn_Reference

PDF

Customer Chrun Excercise

DOC

Customer_Churn_Solution

DOC

Exploring Space Mission Data in Google Sheets

Space Mission Assignment

PDF

Space Mission Reference

PDF

Space_Mission_Dataset

DOC

Space_Mission_Dataset Solutions

DOC

Assignments Google Sheets

Lesson 1: Laying the foundation of Spreadsheet Success

Exercise

Lesson 2: From Data Entry to Design: Building your Spreadsheet skills

Exercise

Lesson 3: Data Visualization Mastery: Pivot Tables and Charts in Google Sheets

Exercise

Lesson 4: From Data to Insights_ Crafting Effective Dashboards

Exercise

Lesson 5 - AI Integration in Google Sheets

Exercise

Lesson 6 - Building a Real -world Sales Anayltics System and Google Sheet and Apps Script

Exercise

Lesson 7 - Using AI functions inside your Spreadsheet

Exercise

Reading Hub

Lesson 1

PDF

Lesson 2

PDF

Lesson 3

PDF

Lesson 4

PDF

Lesson 5 - App Script - Part 1

PDF

Lesson 5 - App Script - Part 2

PDF

Lesson 5 - App Script - Part 3

PDF

Lesson 6 - GPT Integration - Part 1

PDF

Lesson 6 - GPT Integration - Part 2

PDF

Lesson 6 - GPT Integration - Part 3

PDF

Script files- Google Sheets

Script File

External Link

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

Value-Added Course

13 Learning Materials

Section 1 : The Foundation of Building Your Core Resume

Module 1: The Data Analyst’s Resume Revolution - Why Your Resume Matters

External Link

Module 2: Anatomy of a High-Performing Data Analyst Resume

External Link

Module 3: Optimizing Your Resume Sections for Data Analyst Impact

External Link

Section 2: Optimization & Powering Your Application

Module 4: Keywords, Skills, and ATS Optimization: Cracking the Data Analyst Code

External Link

Module 5: Data-Driven Bullet Writing: Showcasing Your Analytical Prowess

External Link

Module 6: Crafting Compelling Cover Letters: Your First Impression

External Link

Section 3: Connection for Expanding Your Professional Reach

Module 7 : Personalizing Your Resume: Tailoring for Success

External Link

Module 8: Approaching Recruiters: Building Connections

External Link

Module 9 : LinkedIn Strategies for Data Analysts: Expanding Your Reach

External Link

Section 4: The Execution: Landing Your Data Analyst Role

Module 10: Strategic Job Search: Targeting Your Ideal Role

External Link

Module 11 : Showcasing Expertise & Passion: Landing the Interview

External Link

Module 12: Putting it all together

External Link

Resume- Template

Resume

PDF

AccessPlus Course - Prompt Engineering

8 Learning Materials

Module 1 - ChatGPT Essentials

1.11 ChatGPT Essentials

External Link

1.12 Customization and Plus Features

External Link

ChatGPT Essentials Prompts

PDF

Module 2 - Understanding of LLM

1.21 Introduction to Generative AI

External Link

1.22 Introduction to LLM

External Link

1.23 How LLM Works ?

External Link

1.24 Learning process of LLM

External Link

Module 3 - Prompt Basics

1.3 Understanding Prompt Basics

External Link

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

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