Python, Mysql, Chatgpt & Tableau With Data Analysis Projects

No Prior Experience Required - Learn MySQL, Python, ChatGPT and all topics for the Tableau Data Analyst Certification

What you'll learn

Understand MySQL and it's role in data storage and analysis

Gain hands-on experience in using Python libraries such as Pandas and Matplotlib for data manipulation, cleaning, visualization, and analysis

Learn how to effectively use ChatGPT as an assistant in writing code and analyzing data

Study the Tableau topics required for the Tableau Certified Data Analyst exam and prepare with hands on tutorials

Build your own interactive dashboard in Tableau

Engage in practical projects involving SQL, Python, ChatGPT, and Tableau, gaining hands-on experience in each technology.

Requirements

No programming experience required. We will start from scratch.

A PC or laptop with internet connection capable of installing MySQL Workbench

Description

Welcome to this comprehensive course designed to equip you with the skills needed for effective data analysis and visualization. This course is perfect for beginners, as no prior experience is required. Whether you're looking to change careers, enhance your current job, or simply learn a new skill, this course is tailored for you.What You Will Learn:• Python for Data Analysis: Learn 2 popular python libraries - Pandas and Matplotlib, starting from the basics and progressing to advanced data manipulation techniques. You'll learn how to handle datasets, perform computations, and create dynamic columns, among other skills.• SQL: Understand the need for SQL in managing and querying databases. You'll start with the fundamentals and advance to complex operations like joins, subqueries, and aggregate functions. Real-world projects will solidify your knowledge and prepare you for industry tasks.• ChatGPT for Enhanced Productivity: Discover how to write better prompts with ChatGPT, transforming it into a powerful assistant for your coding and analysis needs. Learn to assign roles, add instructions, and provide context to maximize ChatGPT's capabilities.• Tableau for Data Visualization: Study the use of Tableau in creating stunning visualizations. From basic charts to complex dashboards, you'll explore how to present data in a meaningful and impactful way. The course covers certification topics, ensuring you're well-prepared for the Tableau Data Analyst Certification.• Real-World Projects: Apply your skills in projects like analyzing LA crime data and exploring sales trends. These hands-on experiences will reinforce your learning and give you a portfolio to showcase your abilities.Why Take This Course?• Comprehensive Curriculum: Covering four major tools (Python, SQL, ChatGPT, and Tableau), this course provides a holistic approach to data analysis and visualization.• No Experience Required: Start from scratch and gradually build your expertise. Our step-by-step guidance ensures that anyone can follow along.• Practical Projects: Real-world projects enhance your understanding and prepare you for real-life challenges.• Future-Proof Skills: Data analysis and visualization are in high demand across industries. This course equips you with skills that are valuable in today's job market.• Flexibility: Learn at your own pace with lifetime access to the course materials.Who Is This Course For?• Beginners interested in data analysis and visualization.• Professionals seeking to enhance their skills in Python, SQL, ChatGPT, and Tableau.• Anyone looking to switch careers to data-related fields.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Download Course Files Here

Section 2: Python - Pandas Part 1

Lecture 3 Download Anaconda

Lecture 4 Introduction to Jupyter Notebook

Lecture 5 Import Pandas and Matplotlib

Lecture 6 Read csv files into Jupyter Notebook

Lecture 7 Markdown and Commenting Out Code

Lecture 8 Overview of Datasets we will use

Lecture 9 Python Methods to Understand Datasets

Lecture 10 Replace Column Names

Lecture 11 Select Columns

Lecture 12 Basic Computations

Lecture 13 Standard Deviation and Count

Lecture 14 Describe

Lecture 15 Value Counts

Section 3: Python - Pandas Part 2

Lecture 16 Indexes

Lecture 17 Sort Values

Lecture 18 Loc and iloc

Lecture 19 Multi Indexes and Slices

Lecture 20 To Dataframe and Plot

Section 4: Python - Pandas Part 3

Lecture 21 Dealing with NULLs

Lecture 22 Unique and Nunique

Lecture 23 Filtering with Between

Lecture 24 Multiple Filter Conditions

Lecture 25 Filtering with Isin and Or

Lecture 26 Tilde - Bitwise Negation

Lecture 27 Create and Drop Columns

Lecture 28 Create Dynamic Columns

Section 5: Python - Pandas Part 4

Lecture 29 Converting to Datetime

Lecture 30 Replacing Values in a DataFrame

Lecture 31 Type Conversion using astype

Lecture 32 .dt Method

Lecture 33 Grouping Data using Groupby

Lecture 34 Aggregation with .agg Method

Lecture 35 Stack and Unstack

Section 6: Python - Matplotlib

Lecture 36 Introduction to Matplotlib

Lecture 37 Create Bar Plot, Add Titles and Labels

Lecture 38 Visualize Data Distribution with Histograms

Lecture 39 Display Data with Pie Charts

Lecture 40 Explore Relationships with Scatter Plots

Lecture 41 Visualize Trends with Line Plots

Lecture 42 Create Figures

Lecture 43 Organize Plots using Subplot

Lecture 44 Visualizing Sales Data - Part One

Lecture 45 Visualizing Sales Data - Part Two

Lecture 46 Formatting Sales Plots - Part One

Lecture 47 Formatting Sales Plots - Part Two

Section 7: Python Project - LA Crime

Lecture 48 Getting Dataset and Importing to Jupyter Notebook

Lecture 49 Understand and Prepare Data - Part One

Lecture 50 Understand and Prepare Data - Part Two

Lecture 51 Feature Understanding & Analysis - Part One

Lecture 52 Feature Understanding & Analysis - Part Two

Lecture 53 Feature Understanding & Analysis - Part Three

Lecture 54 Time Taken to Report Crime

Lecture 55 Average Victim Age per Crime

Lecture 56 Areas with Most Crime

Lecture 57 Crime Count by Time of Day

Section 8: SQL

Lecture 58 Downloading MySQL Workbench for Windows

Lecture 59 Downloading MySQL Workbench for Mac

Lecture 60 Introduction to MySQL Workbench

Lecture 61 What is SQL and Data Definition Language (DDL)

Lecture 62 Introduction to SQL: Insert Into Statements

Lecture 63 Importing our Databases

Lecture 64 Understanding the Data in the Database

Lecture 65 Select Data from the Database

Lecture 66 Filtering the Output with Where

Lecture 67 Applying Multiple Filters with In and Not In

Lecture 68 Finding Unique Values using Distinct

Lecture 69 Searching for Text Patterns in Strings using the Like Operator

Lecture 70 An Introduction to Joins

Lecture 71 Combining Tables using Inner Join

Lecture 72 Combining Tables using Left Join

Lecture 73 Combining Tables using Right Join

Lecture 74 Joining a Table to Itself

Lecture 75 Examples and Use Cases of Joins

Lecture 76 Combining Data with Union and Union All

Lecture 77 Introduction to Aggregate Functions

Lecture 78 Grouping Aggregated Data using Group By

Lecture 79 Using Subqueries in SQL

Lecture 80 Practice and Use Cases of Sub Queries

Lecture 81 Grouping Data using a Case Statement

Lecture 82 Transform Data using a Case Statement

Section 9: SQL Project

Lecture 83 Average Order Amount for Each Country

Lecture 84 Sales Value per Product Line

Lecture 85 Top 10 Products by Sales

Lecture 86 Sales Rep Performance

Lecture 87 Average Number of Orders per Customer

Lecture 88 Percent of Orders Shipped on Time

Lecture 89 Net Profit per Product

Lecture 90 Segment Customers by Value

Lecture 91 Identify Cross Selling Opportunities

Section 10: ChatGPT - Introduction to Writing Better Prompts

Lecture 92 Signing up to Open AI and ChatGPT

Lecture 93 Assigning a Role in ChatGPT

Lecture 94 Adding Instructions for Clarity and Impact

Lecture 95 Context is Key: Enhancing Prompt Clarity

Lecture 96 The Importance of Adding Examples: Few Shot Prompting

Lecture 97 Limitations and Considerations when Using ChatGPT

Section 11: Python Project using ChatGPT - Crime in Los Angeles

Lecture 98 Overview of the Dataset

Lecture 99 Importing Data and Beginning Preprocessing

Lecture 100 Begin Analyzing Dataset

Lecture 101 Continued Analysis and Plotting

Lecture 102 Putting Plots Together and Summarizing the Output using ChatGPT

Lecture 103 Ask our Own Questions of Data using ChatGPT

Section 12: SQL Project using ChatGPT - Netflix

Lecture 104 Provide ChatGPT with Tables and Columns - First Prompt

Lecture 105 Continue Analysis using SQL and ChatGPT

Lecture 106 Summarize SQL Output using ChatGPT

Section 13: GPT-4 Analysis

Lecture 107 Adding Review Sentiment Column using GPT-4

Lecture 108 Airline Review Sentiment Analysis

Lecture 109 Sales Analysis using GPT-4

Section 14: Tableau Data Analyst Certification Topics - Part 1

Lecture 110 Download and Install Tableau

Lecture 111 Establishing Data Connections by Connecting to Data Source

Lecture 112 Exploring Attributes and Measures

Lecture 113 Understanding Data Granularity

Lecture 114 Utilizing Aggregate Functions in Tableau

Lecture 115 Organizing Fields in Tableau

Lecture 116 Create Line Chart

Lecture 117 Create Bar Chart

Lecture 118 Create Highlight Table

Lecture 119 Adding Filters to Sheets

Lecture 120 Creating Context Filters

Lecture 121 Add Date Filters

Lecture 122 Area and Pie Charts

Lecture 123 Scatter Plots - Part One

Lecture 124 Scatter Plots - Part Two

Section 15: Tableau Data Analyst Certification Topics - Part 2

Lecture 125 Custom Shapes and Colors

Lecture 126 Create Bubble and Packed Bubble Charts

Lecture 127 Visualize Trends using the Pages Shelf

Lecture 128 Enhance Data Visualization using Animations

Lecture 129 Add Notes or Highlights to your Visualization using Annotations

Lecture 130 Add Titles and Captions

Lecture 131 Creating a Map in Tableau

Lecture 132 Choosing a Map Type and Grouping Map Data

Lecture 133 Dealing with Unknown Locations in Maps

Lecture 134 Heat Maps & Map Layers

Section 16: Tableau Data Analyst Certification Topics - Part 3

Lecture 135 Create a Dashboard

Lecture 136 Adding Dashboard Objects

Lecture 137 Dashboard Layout Options

Lecture 138 Adding Filters to Dashboards

Lecture 139 Make Dashboard Interactive using Actions

Lecture 140 Set Dashboard Design for Specific Devices

Lecture 141 Create a Story

Section 17: Tableau Data Analyst Certification Topics - Part 4

Lecture 142 Connect to a New Data Source

Lecture 143 Organize Data by Creating a Hierarchy

Lecture 144 Organize Data into Groups

Lecture 145 Segmenting Data into Bins

Lecture 146 Utilizing Sets for Analysis

Lecture 147 Sorting Data for Insights

Lecture 148 Visualizing Distributions with Histograms

Lecture 149 Exploring Data with Tree Maps

Lecture 150 Comparing Metrics with Dual Axes Charts

Lecture 151 Formatting Visuals for Impact

Lecture 152 Enhancing Tooltips with Visuals

Lecture 153 Creating Calculated Fields

Lecture 154 Making Decisions with IF and CASE Statements

Lecture 155 Manipulating Dates for Insights

Lecture 156 Converting Data Types

Lecture 157 Working with String Functions

Lecture 158 Applying Mathematical Operators

Section 18: Tableau Data Analyst Certification Topics - Part 5

Lecture 159 Summarizing Data with Totals and Subtotals

Lecture 160 Marking Key Points with Constant Lines

Lecture 161 Median and Average Confidence Intervals

Lecture 162 Adding Reference Lines for Context

Lecture 163 Visualizing Data with Reference and Distribution Bands

Lecture 164 Clustering Data for Patterns & Box Plots

Lecture 165 Showing Trends with Trend Lines

Lecture 166 Projecting Future Data with Forecasting

Lecture 167 Simplifying Analysis with Quick Table Calculations

Lecture 168 Customizing Calculations for Advanced Analysis

Lecture 169 Building Predictive Models in Tableau

Lecture 170 Utilizing Parameters for Dynamic Analysis

Lecture 171 Visualizing with Parameters and Reference Lines

Lecture 172 Swapping Sheets Dynamically with Parameters

Section 19: Tableau Data Analyst Certification Topics - Part 6

Lecture 173 Understanding Fixed Level of Detail Expressions

Lecture 174 Exploring Further with Fixed LODs

Lecture 175 Visualizing Project Timelines with Gantt Bar Charts

Lecture 176 Defining Relationships Between Data Sources

Lecture 177 Combining Data with Joins

Lecture 178 Managing Complex Data Sources and Blending Data

Lecture 179 Creating Calculations for Joins

Lecture 180 Combining Data with Union

Lecture 181 Preparing Data with the Data Interpreter and Pivot

Lecture 182 Splitting Data for Granular Analysis

Lecture 183 Getting Started with Tableau Desktop

Lecture 184 Creating and Filtering Data Extracts

Lecture 185 Publishing Workbooks to Tableau Server

Lecture 186 Managing Subscriptions, Alerts, and Data Sources

Lecture 187 Running and Managing Data Flows in Tableau

Section 20: Guided Project - Create your Own Tableau Dashboard

Lecture 188 Connecting to our Data Source

Lecture 189 Creating a Top 10 Products Visualization

Lecture 190 Designing a Stacked Bar Chart

Lecture 191 Adding a Bubble Chart

Lecture 192 Mapping Sales Data Geographically

Lecture 193 Analyzing Profit, Adding Year-over-Year Calculation and a Parameter

Lecture 194 Visualizing the Revenue Trend with a Line Chart

Lecture 195 Adding Product Costs

Lecture 196 Putting Dashboard Together - Part One

Lecture 197 Putting Dashboard Together - Part Two

Anyone with an interest in Data Analysis,Students looking to learn and practice the topics required for the Tableau Certified Data Analyst exam