10xDataAnalyst DA210924_830
September 2024
To enroll in this course, please contact the Admin
/CourseBundles(47844)/3626398-8.png)
Course Overview
Schedule of Classes
Course Curriculum
19 Subjects
Self Paced Learning
5 Learning Materials
Module: Data Visualisation and Dashboarding with Tableau
1 Exercises • 40 Learning Materials
Data Warehousing, ETL Pipelines using SQL and BigQuery
1 Exercises • 16 Learning Materials
Understanding Data Warehouse Concepts and Use Cases
Deck Used
PDF
Hands-on SQL Basics Workshop
Deck Used
PDF
Mastering Complex SQL Queries
Optimizing SQL Queries for Performance
Deck Used in the class
External Link
Social Media Case Study
External Link
Social Media.SQL
External Link
SQL Clauses
External Link
Social Media- Case Study
PDF
Aggregation
External Link
Hands on SQL Project Live 1
SQL Assignment 1
Assignment
Answer Sheet
PDF
Hands on SQL Project Live 2
Products
DOC
Orders
DOC
Customers
DOC
Questions
PPT
Order Items
DOC
reviews
DOC
Solutions
application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess
AccessPlus Module- Google Sheets
1 Exercises • 21 Learning Materials
Getting Started with Google Sheets
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
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
Introduction to Google Apps Script
PDF
Self Paced Learning Video
External Link
Error Handling
External Link
Building Blocks of Google Apps Script
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
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
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
AccessPlus Course- 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
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
PPT
Excersice
Colab Link
Day 4 Deck used
PPT
PPT
Colab Link
Day 5 Deck Used
PPT
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
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
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
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
Time Series Theory and Time Series Code/Project
Text
Time Series Theory and Time Series Code/Project
Text
AccessPlus - Value-Added Course- Resume Building
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
Mastering HackerRank
2 Learning Materials
HackerRank (Basic Skill Module)
Introduction to Tech Portfolio
PDF
Step-by-Step Guide to Building Your Tech Portfolio
PDF
Resume Mastery for Aspiring Data Analysts
1 Learning Materials
Resume Mastery for Aspiring Data Analysts
Resume Mastery for Aspiring Data Analysts
PDF
AccessPlus Module - Python
6 Learning Materials
Introduction to Object-Oriented Programming in Python - OOP
Introduction to Object-Oriented Programming in Python - OOP
External Link
The Perfect Python AI Coding Setup
The Perfect Python AI Coding Setup
External Link
Classes & Objects
Classes & Objects
External Link
Everything is an Object
Everything is an Object
External Link
The Power of Constructors (__init__)
The Power of Constructors (__init__)
External Link
Encapsulation – Protecting Data
Encapsulation – Protecting Data
External Link
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
SQL Subquery
PDF
SQL Window Functions
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
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
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
Data Warehousing, ETL Pipelines using SQL and BigQuery .
1 Exercises • 17 Learning Materials
Understanding Data Warehouse Concepts and Use Cases
Deck Used
PDF
Hands-on SQL Basics Workshop
Deck Used
PDF
Optimizing SQL Queries for Performance
Deck Used
External Link
Deck Used
External Link
Assignment
PDF
Chicago Public School Data
External Link
Chicago Crime Data
External Link
Chicago Census Data
External Link
Problem Statements- Task to be performed
PDF
Hands on SQL Project Live 1
SQL assignment 1
Assignment
Answer Sheet
PDF
Hands on SQL Project Live 2
Reviews
DOC
Products
DOC
Customers
DOC
Order Items
DOC
Orders
DOC
Questions
PPT
Soultions
application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess
AccessPlus Module - 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 - Value Added Course- LinkedIn
2 Learning Materials
1. LinkedIn Basics
What is LinkedIn & How to Use LinkedIn
External Link
How to Create a Professional LinkedIn Account to Get a JOB
External Link
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
PROJECTS
67 Learning Materials
EV dashboard Using Tableau
EV Dashboard
External Link
Electric_Vehicle_Population_Data.csv
Text
PUBLIC CODE LINK
External Link
Netflix Data Analysis using Python
Netflix Data Analysis
External Link
Netflix Data Analysis
Text
PUBLIC CODE LINK
External Link
Instagram User Analytics using SQL
Instagram User Analytics
External Link
Instagram User Analytics
External Link
Public Code Link
External Link
Analyzing Spotify Track Popularity using Python & ML
Analyzing Spotify Track Popularity
External Link
spotify-dataset.csv
Text
Public Code Link
External Link
Coca Cola Sales Analysis using Python
Coca Cola Sales Analysis
External Link
coca_cola_sales_data.csv
Text
Public Code Link
External Link
K Means Brain Scan using Python + ML
K Means Brain Scan
External Link
Brain_Scan_Labelled
Image
Public Code Link
External Link
BBC_News_Prediction using NLP
BBC_News_Prediction
External Link
bbc-news-data.csv
Text
Public Code Link
External Link
LLM-Enhanced Web Scraping using Web Scraping + LLM
LLM-Enhanced Web Scraping
External Link
Student_Performace_Analysis using Python
Student_Performace_Analysis
External Link
Student_Performace_Analysis Dataset
Text
F1 Racing using SQL
F1 Racing
External Link
F1 Racing Dataset
Text
Uber Eats Analyis using Python+ ML
Uber Eats Analyis
External Link
Uber Eats Analyis Dataset
Text
Public Code Link
External Link
US Credit Analysis using Python + ML + Tableau
US Credit Analysis
External Link
US Credit Analysis Dataset
Text
Public Code Link
External Link
Fitbit_Data_Analysis using Python
Fitbit_Data_Analysis
External Link
Fitbit_Data_Analysis Dataset
Text
Public Code Link
External Link
Database main 2
Text
Real_Estate_Analysis using Python + ML
Real_Estate_Analysis
External Link
KC House Dataset
Text
Public Code Link
External Link
Airlines_Analysis using Python + ML
Airlines_Analysis
External Link
Train Dataset
Text
US Airline Dataset
Text
Public Code Link
External Link
Real Time Vision Counter using Python + Computer Vision
Real Time Vision Counter
External Link
Car
Image
Mask
Image
Car MP4
Audio
00:36:30
Requirements and sort
ZIP
The Unbeatable AI Project using Python + Reinforcement Learning
The Unbeatable AI Project
External Link
The Unbeatable AI Project datasets
ZIP
Price Prediction and Model Comparision
Price Prediction and Model Comparision
Text
Price Prediction and Model Comparision
External Link
Adidas Sales Analysis
Dataset- Adidas Sales Analysis
DOC
Adidas - LOGO
Image
Adidas Sales Analysis
External Link
AirBnB Dashboard
AirBnB Dashboard
External Link
AirBnB dataset
DOC
Public Code Link
External Link
Amazon_Reviews_Analysis - NLP Visualisations
Amazon_Reviews_Analysis
External Link
Amazon_Reviews_Analysis
Text
Public Code Link
External Link
Cursor AI Course + Project
Cursor AI Course + Project- Data Analaysis + CursorAI
External Link
Cursor AI Course + Project
Text
AI Fraud Detection- Python + ML
AI Fraud Detection
External Link
Real Estate analysis- Python + ML
Real Estate analysis- dataset
Text
Real Estate analysis
External Link
Public Code Link
External Link
Course Instructor
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy