Access Plus 1to10x

Course Instructor: 1to10x

To enroll in this course, please contact the Admin

Contact Admin

Course Overview

Schedule of Classes

Start Date & End Date

Aug 17 2024 - Apr 30 2030

Course Curriculum

9 Subjects

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

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

LinkedIn and Resume Building

15 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

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 template

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

AccessPlus Module - Python

6 Learning Materials

Introduction to Object-Oriented Programming in Python - OOP

External Link

The Perfect Python AI Coding Setup

External Link

Classes & Objects

External Link

Everything is an Object

External Link

The Power of Constructors (init)

External Link

Encapsulation – Protecting Data

External Link

PROJECTS

69 Learning Materials

EV dashboard Using Tableau

EV Dashboard

External Link

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 Dataset

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 Dataset

Text

Public Code Link

External Link

Coca Cola Sales Analysis using Python

Coca Cola Sales Analysis

External Link

coca_cola_sales_data.csv Dataset

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 Dataset

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

F1 Racing - Dataset

Text

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

Requirements and sort

ZIP

Car MP4

Video

00:00:12

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 Dataset

Text

Price Prediction and Model Comparision

External Link

Adidas Sales Analysis

Dataset- Adidas Sales Analysis Dataset

DOC

Adidas - LOGO

Image

Adidas Sales Analysis

External Link

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 Dataset

Text

Public Code Link

External Link

Cursor AI Course + Project

Cursor AI Course + Project- Data Analaysis + CursorAI

External Link

Cursor AI Course + Project Dataset

Text

Required files

ZIP

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

Certification Microsoft Certified: Azure AI Fundamentals

39 Learning Materials

AI - 900 Azure AI Fundamentals

Fundamentals

External Link

"Intro to AI, Supervised and Unsupervised machine learning"

External Link

Intro to ML , Types of ML algorithms

External Link

Study Guide

External Link

Artificial Intelligence Workloads and Considerations

Common AI Workloads

External Link

Guiding Principles for Responsible AI

External Link

Fairness, Reliability, Safety, Privacy and Security

External Link

Inclusiveness, Transparency, Accountability

External Link

Identify Common Machine Learning Types and Core Machine Learning Concepts

Common Machine Learning Types

External Link

Deep Learning

External Link

Transformer Architecture

External Link

Dataset Features and Labels

External Link

Training and Validation Datasets

External Link

Confusion Matrix, TPR, FPR and AUC

External Link

No Code Machine Learning

Auto ML

External Link

DEMO: Create Azure Machine Learning Workspace

External Link

Resource

External Link

DEMO: Use Auto ML to Build a No Code Model

External Link

Machine Learning Designer

External Link

DEMO: Machine Learning Designer to Build a No Code Model

External Link

Computer Vision Workloads on Azure

Common Types of Computer Vision Workloads

External Link

Computer Vision Services in Microsoft Azure

External Link

DEMO: Using the Computer Vision Service

External Link

DEMO: Using the Custom Vision Service

External Link

Resource

External Link

Azure AI Video Indexer

External Link

Azure AI Video Indexer overview

External Link

Natural Language Workloads on Azure

Common Types of NLP Workloads

External Link

NLP Services in Microsoft Azure

External Link

Describe Features of Generative AI workloads on Azure

Overview of Generative AI

External Link

Generative AI Common Scenarios

External Link

Responsible Generative AI

External Link

Identify capabilities of Azure OpenAI service

Natural Language Generation(NLG) capabilities of Azure OpenAI Service

External Link

DEMO: Chat in Azure OpenAI Service

External Link

Azure AI Foundry

External Link

Code generation capabilities of Azure OpenAI Service

External Link

DEMO: Code Generation in Azure OpenAI Service

External Link

Image generation capabilites of Azure OpenAI Service

External Link

DEMO: Image Generation in Azure OpenAI Service

External Link

GitHub

8 Learning Materials

GIT INSTALLATION

PDF

GITHUB SETUP

PDF

VS CODE INSTALLATION

PDF

On-Demand Videos

Github Part 1

Video

01:47:07

GitHub - Part 2

Video

02:19:48

Git & GitHub Assignment

PDF

Git & GitHub Assignment- Answer Key

PDF

Git and GitHub- Notes

PDF

Course Instructor

1to10x

103 Courses • 994 Students