10xDataAnalyst February - 02 2025
DA080225-930
Course Instructor:
1to10x
To enroll in this course, please contact the Admin
/CourseBundles(54187)/3776074-ferb_25.png)
Course Overview
Schedule of Classes
Start Date & End Date
Feb 08 2025 - Aug 31 2025
Course Curriculum
13 Subjects
10xDataAnalyst February02 2025 DA080225-930
2 Learning Materials
LMS Guide
Using the Learning Management System Effectively
Video
00:03:50
Walkthrough - PDF
PDF
AccessPlus Course- 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
Module 1 : 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
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
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
Other Link: Tableau Public
External Link
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
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
Dataset- Tips
Text
Dataset- Startup
Startup Dataset
DOC
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
Resume Mastery for Aspiring Data Analysts
1 Learning Materials
Resume Mastery for Aspiring Data Analysts
Resume Mastery for Aspiring Data Analysts
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
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
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
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
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
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
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
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
Course Instructor
1to10x
103 Courses • 994 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy