Course Overview
Data Analysts aim to discover how data can be used to answer questions and solve problems through the use of technology. Many believe this will be the job of the future and be the single most important skill a job application can have in 2020.
In the last two decades, the pervasiveness of the internet and interconnected devices has exponentially increased the data we produce. The amount of data available to us is Overwhelming and Unprecedented. Obtaining, transforming and gaining valuable insights from this data is fast becoming the most valuable and in-demand skill in the 21st century.
In this course, you'll learn how to use Data, Analytics, Statistics, Probability, and basic Data Science to give an edge in your career and everyday life. Being able to see through the noise within data, and explain it to others will make you invaluable in any career.
We will examine over 2 dozen real-world data sets and show how to obtain meaningful insights. We will take you on one of the most up-to-date and comprehensive learning paths using modern-day tools like Python, Google Colab and Google Data Studio.
You'll learn how to create awesome Dashboards, tell stories with Data and Visualizations, make Predictions, Analyze experiments and more!
Our learning path to becoming a fully-fledged Data Analyst includes:
The Importance of Data Analytics
Python Crash Course
Data Manipulations and Wrangling with Pandas
Probability and Statistics
Hypothesis Testing
Data Visualization
Geospatial Data Visualization
Story Telling with Data
Google Data Studio Dashboard Design - Complete Course
Machine Learning - Supervised Learning
Machine Learning - Unsupervised Learning (Clustering)
Practical Analytical Case Studies
Google Data Studio Dashboard & Visualization Project:
Executive Sales Dashboard (Google Data Studio)
Python, Pandas & Data Analytics and Data Science Case Studies:
Health Care Analytics & Diabetes Prediction
Africa Economic, Banking & Systematic Crisis Data
Election Poll Analytics
Indian Election 2009 vs 2014
Supply-Chain for Shipping Data Analytics
Brent Oil Prices Analytics
Olympics Analysis - The Greatest Olympians
Home Advantage Analysis in Basketball and Soccer
IPL Cricket Data Analytics
Predicting the Soccer World Cup
Pizza Resturant Analytics
Bar and Pub Analytics
Retail Product Sales Analytics
Customer Clustering
Marketing Analytics - What Drives Ad Performance
Text Analytics - Airline Tweets (Word Clusters)
Customer Lifetime Values
Time Series Forecasting - Demand/Sales Forecast
Airbnb Sydney Exploratory Data Analysis
A/B Testing
FAQ
FAQ area empty
Course curriculum
Chương 1 Course Introduction & the Importance of Data Analysts 5 bài · 36 phút
- Course Introduction Học thử 7:22
- The Importance of Data Analyst Học thử 9:53
- Why Data is the new Oil Học thử 6:37
-
Making Sense of Buzz Words, Data Science, Big Data, Machine & Deep Learning 7:27
-
The Roles in the Data World - Analyst, Engineer, Scientist, Statistician, DevOps 4:50
Chương 2 Download Code and Slides and Setup Google Colab 2 bài · 4 phút
-
Download Code and Slides
- Download Course Code, Slides and Setup Google Colab for your iPython Notebooks Học thử 3:45
Chương 3 Python Crash Course 7 bài · 51 phút
- Why use Python for Data Anakytics and Data Science? Học thử 3:05
- Python - Basic Variables Học thử 6:31
-
Python - Array/Lists and Dictionaries 11:09
-
Python - Conditional Statements 6:55
- Python - Loops Học thử 8:49
-
Python - Functions 5:29
-
Python - Classes 8:34
Chương 4 Pandas - Data Series and Manipulation 4 bài · 33 phút
-
Introduction to Pandas 2:47
-
Pandas 1 - Data Series 7:02
-
Pandas 2A - DataFrames - Index, Slice, Stats, Finding Empty cells, Filtering 17:31
-
Pandas 2B - DataFrames - Index, Slice, Stats, Finding Empty cells & Filtering 5:51
Chương 5 Pandas - Data Cleaning & Aggregration 3 bài · 45 phút
-
Pandas 3B - Data Cleaning - Alter Colomns/Rows, Missing Data & String Operations 8:46
-
Pandas 3A - Data Cleaning - Alter Colomns/Rows, Missing Data & String Operations 19:45
-
Pandas 4 - Data Aggregation - GroupBy, Map, Pivot, Aggreate Functions 16:39
Chương 6 Pandas - Feature Engineering & Joins/Merge/Concatenating 2 bài · 20 phút
-
Pandas 5 - Feature Engineer, Lambda and Apply 4:24
-
Pandas 6 - Concatenating, Merging and Joinining 15:21
Chương 7 Pandas - Time Series Data 1 bài · 10 phút
-
Pandas 7 - Time Series Data 9:56
Chương 8 Advanced Pandas 3 bài · 20 phút
-
Pandas 7 - ADVANCED Operations - Iterows, Vectorization and Numpy 11:17
-
Pandas 8 - ADVANCED Operations - More Map, Zip and Apply 4:29
-
Pandas 9 - Advanced Operations - Parallel Processing 4:24
Chương 9 Map Visualizations 2 bài · 16 phút
-
Map Visualizations with Plotly - Cloropeths from Scratch - USA and World 11:25
-
Map Visualizations with Plotly - Heatmaps, Scatter Plots and Lines 4:54
Chương 10 Statistics for Data Analysts & Visualizations 16 bài · 1 giờ 54 phút
-
Introduction to Statistics 4:20
-
Descriptive Statistics - Why Statistical Knowledge is so Important 3:47
-
Descriptive Statistics 1 - Exploratory Data Analysis (EDA) & Visualizations 16:19
-
Descriptive Statistics 2 - Exploratory Data Analysis (EDA) & Visualizations 6:22
-
Sampling, Averages & Variance And How to lie and Mislead with Statistics 3:16
-
Variance, Standard Deviation and Bessel’s Correction 9:22
-
Types of Variables - Quantitive and Qualitative 5:41
-
Frequency Distributions 4:41
-
Frequency Distributions Shapes 2:55
-
Analyzing Frequency Distributions - What is the Best Type of Wine? Red or White? 9:58
-
Covariance & Correlation - Do Amazon & Google know you better than anyone else? 11:35
-
Sampling - Sample Sizes & Confidence Intervals - What Can You Trust? 9:41
-
Mean, Mode and Median - Not as Simple As You'd Think 12:38
-
The Normal Distribution & the Central Limit Theorem 3:43
-
Lying with Correlations – Divorce Rates in Maine caused by Margarine Consumption 1:37
-
Z-Scores 8:16
Chương 11 Probability Theory 5 bài · 30 phút
-
Probability - An Introduction 1:40
-
Estimating Probability 5:14
-
Addition Rule 7:58
-
Permutations & Combinations 6:54
-
Bayes Theorem 7:49
Chương 12 Hypothesis Testing 4 bài · 24 phút
-
Hypothesis Testing Introduction 3:03
-
Statistical Significance 8:13
-
Hypothesis Testing – P Value 7:43
-
Hypothesis Testing – Pearson Correlation 5:25
Chương 13 Google Data Studio - Introduction & Setup 2 bài · 10 phút
-
All about Google Data Studio 5:06
-
Opening Google Data Studio and Uploading Data 4:27
Chương 14 Google Data Studio - Your First Dashboard 3 bài · 30 phút
-
Your First Dashboard Part 1 14:29
-
Your First Dashboard Part 2 10:02
-
Creating New Fields 5:37
Chương 15 Google Data Studio - Pivot & Dynamic Tables (with Filters) 2 bài · 10 phút
-
Pivot Tables 6:39
-
Dynamic Filtered Tables 2:53
Chương 16 Google Data Studio - Scorecards and Time Comparison 2 bài · 12 phút
-
Scorecards 6:10
-
Scorecards with Time Comparison 5:44
Chương 17 Google Data Studio - Bar Charts, Line Charts and Time Series Plots 3 bài · 21 phút
-
Bar Charts 8:44
-
Line Charts 7:01
-
Time Series and Comparitive Time Series Plots 4:52
Chương 18 Google Data Studio - Pie charts, Donut Charts, Treemaps & Scatter Plots 2 bài · 9 phút
-
Pie Charts, Donut Charts and Tree Maps 4:01
-
Scatter Plots 4:50
Chương 19 Google Data Studio - Geographic & Map Plots 1 bài · 7 phút
-
Google Data Studio - Geographic & Map Plots 7:21
Chương 20 Google Data Studio - Bullet and Line Area Plots 1 bài · 6 phút
-
Google Data Studio - Scatter Plots 5:32
Chương 21 Google Data Studio - Sharing your Interactive Dashboards 1 bài · 7 phút
-
Google Data Studio - Sharing your Interactive Dashboards 6:57
Chương 22 Retail Sales Dashboard for Executives 1 bài · 2 phút
-
Homework Project - Create Executive Sales Dashboard 2:19
Chương 23 Introduction to Machine Learning 3 bài · 17 phút
-
How Machine Learning enables Computers to Learn 3:24
-
What is a Machine Learning Model? 6:21
-
Types of Machine Learning 7:41
Chương 24 Linear Regressions 3 bài · 32 phút
-
Linear Regression – Introduction to Cost Functions and Gradient Descent 9:11
-
Linear Regressions in Python from Scratch and using Sklearn 14:18
-
Polynomial and Multivariate Linear Regression 8:29
Chương 25 Classification - Logistic Regression, SVM, Decision Trees, Random Forets & KNN 4 bài · 34 phút
-
Logistic Regression 11:39
-
Support Vector Machines (SVMs) 5:36
-
Decision Trees and Random Forests & the Gini Index 10:45
-
K-Nearest Neighbors (KNN) 5:44
Chương 26 Assessing Model Performance 3 bài · 46 phút
-
Assessing Performance – Confusion Matrix, Precision and Recall 22:37
-
Understanding the ROC and AUC Curve 6:39
-
What Makes a Good Model? Regularization, Overfitting, Generalization & Outliers 16:16
Chương 27 Neural Networks Overview 2 bài · 10 phút
-
Introduction to Neural Networks 2:07
-
Types of Deep Learning Algoritms CNNs, RNNs & LSTMs 7:38
Chương 28 Unsupervised Learning 4 bài · 32 phút
-
Introduction to Unsupervised Learning 4:56
-
K-Means Clustering 9:34
-
Choosing K – Elbow Method & Silhouette Analysis 7:50
-
K-Means in Python - Choosing K using the Elbow Method & Silhoutte Analysis 10:06
Chương 29 Dimensionality Reduction 3 bài · 21 phút
-
Principal Component Analysis 9:37
-
T-Distributed Stochastic Neighbor Embedding (t-SNE) 5:37
-
PCA & t-SNE in Python with Visualization Comparisons 5:21
Chương 30 Case Study 1 - Airbnb Sydney Exploratory Data Analysis 2 bài · 20 phút
-
Case Study Note
-
Understanding the Problem + Exploratory Data Analysis and Visualizations 19:53
Chương 31 Case Study 2 - Retail Product Sales Analytics 3 bài · 31 phút
-
Data Cleaning and Preparation 8:44
-
Sales and Revenue Analysis 10:34
-
Analysis per Country, Repeat Customers and Items 11:49
Chương 32 Case Study 3 - Marketing Analytics - What Drives Ad Performance 2 bài · 17 phút
-
Understanding the Problem + Exploratory Data Analysis and Visualizations 8:42
-
Data Preparation and Machine Learning Modeling 8:32
Chương 33 Case Study 4 - Customer Clustering for Travel Agency Customers 5 bài · 42 phút
-
Data Exploration & Description 6:47
-
Simple Exploratory Data Analysis and Visualizations 9:45
-
Feature Engineering 8:35
-
K-Means Clustering of Customer Data 13:05
-
Cluster Analysis 4:15
Chương 34 Case Study 5 - Text Analytics - Airline Tweets (Word Clusters) 3 bài · 24 phút
-
Understanding our Dataset and Word Clouds 7:01
-
Visualizations and Feature Extraction 10:17
-
Training our Model 6:31
Chương 35 Case Study 6 - Customer Lifetime Value (CLV) 2 bài · 14 phút
-
Understanding the Problem + Exploratory Data Analysis and Visualizations 7:05
-
Customer Lifetime Value Modeling 6:42
Chương 36 Case Study 7 - Health Care Analytics - Predict Diabetes 3 bài · 19 phút
-
Understanding and Preparing Our Healthcare Data 8:11
-
First Attempt - Trying a Naive Model 3:53
-
Trying Different Models and Comparing the Results 6:29
Chương 37 Case Study 8 - Africa Economic, Banking & Systematic Crisis Data 2 bài · 13 phút
-
Economic Dataset Understanding 5:14
-
Visualizations and Correlations 7:42
Chương 38 Case Study 9 - 2016 US President Election Analysis 9 bài · 55 phút
-
Understanding Polling Data 7:51
-
Cleaning & Exploring our Dataset 5:55
-
Data Wrangling with our Dataset 4:54
-
Understanding the US Electoral System 6:19
-
Visualizing our Polling Data 4:06
-
Statistical Analysis of Polling Data 3:43
-
Polling Simulations 10:42
-
Polling Simulation Result Analysis 7:19
-
Visualizing our results on a US Map 4:32
Chương 39 Case Study 10 - Election Results Analysis - Indian Election 2009 vs 2014 3 bài · 28 phút
-
Intro 7:33
-
Visualizations of Election Results 9:29
-
Visualizing Gender Turnout 10:59
Chương 40 Case Study 11 - Supply-Chain for Shipping Data Analytics 3 bài · 18 phút
-
Understanding our Dataset 4:04
-
Visualizations and EDA 9:21
-
More Visualizations 4:32
Chương 41 Case Study 12 - Sports Analytics - Olypmics Analysis - The Greatest Olympians 3 bài · 25 phút
-
Getting The Medals Per Country 9:30
-
Getting The Medals Per Country 9:30
-
Analyzing the Winter Olympic Data and Viewing Medals Won Over Time 5:42
Chương 42 Case Study 13 - Home Advantage Analysis in Basketball and Soccer 3 bài · 20 phút
-
Understanding Our Dataset and EDA 9:27
-
Goal Difference Ratios Home versus Away 5:09
-
How Home Advantage Has Evolved Over. Time 5:09
Chương 43 Case Study 14 - IPL Cricket Data Analytics 3 bài · 20 phút
-
Loading and Understanding our Cricket Datasets 7:25
-
Man of Match and Stadium Analysis 5:50
-
Do Toss Winners Win More? And Team vs Team Comparisons 7:08
Chương 44 Case Study 15 - Predicting the World Cup Winner (Soccer/Football) 4 bài · 31 phút
-
Understanding and Preparing Our Soccer Datasets 6:05
-
Feature Extraction using our Soccer Data 5:07
-
Predicting Game Outcomes with our Model 6:20
-
Simulating the World Cup Outcome with Our Model 13:30
Chương 45 Case Study 16 - Pizza Resturants Analysis 3 bài · 19 phút
-
Understanding our Dataset 6:48
-
Analysis Per State 4:46
-
Pizza Maps 7:24
Chương 46 Case Study 17 - Brewery and Pub Analysis 1 bài · 14 phút
-
EDA, Visualizations and Map 13:41
Chương 47 Case Study 18 - EDA and Forecasting Brent Oil Prices 3 bài · 23 phút
-
Understanding our Dataset and it's Time Series Nature 5:08
-
Creating our Prediction Model 5:07
-
Making Future Predictions 12:56
Chương 48 Case Study 19 - Time Series Forecasting for Sales 1 bài
-
Case Study 19 - Time Series Forecasting for Sales
Chương 49 Case Study 20 - Predicting Insurance Premiums 2 bài · 23 phút
-
Understanding the Problem + Exploratory Data Analysis and Visualizations 10:10
-
Data Preparation and Machine Learning Modeling 12:44
Chương 50 Case Study 21 – A/B Testing 5 bài · 40 phút
-
Understanding the Problem + Exploratory Data Analysis and Visualizations 10:49
-
A/B Test Result Analysis 5:37
-
A/B Testing a Worked Real Life Example - Designing an A/B Test 8:16
-
Statistical Power and Significance 6:58
-
Analysis of A/B Test Resutls 8:15
Chương 51 Covid-19 Data Analysis and Flourish Bar Chart Race Visualization 9 bài · 1 giờ 3 phút
-
Understanding Our Covid-19 Data 7:31
-
Analysis of the most Recent Data 5:46
-
World Visualizations 8:54
-
Analyzing Confirmed Cases in each Country 4:29
-
Mapping Covid-19 Cases 5:56
-
Animating our Maps 4:47
-
Comparing Countries and Continents 4:50
-
Flourish Bar Chart Race - 1 10:58
-
Flourish Bar Chart Race - 2 9:52
Requirment
-
Familiar with basic programming concepts
-
Highschool level math knowledge
-
Broadband Internet connection
Outcomes
-
Understand the value of data for businesses
-
The importance of Data Analytics
-
The role of a Data Analyst
-
Learn to use Python, Pandas, Matplotlib & Seaborn, Scikit-learn
-
Learn Visualization Tools such as Matplotlib, Seaborn, Plotly and Mapbox
-
Hypothesis Testing and A/B Testing - Understand t-tests and p values
-
Unsupervised Machine Learning with K-Means Clustering
-
Machine Learning from Linear Regressions (polynomial & multivariate), K-NNs, Logistic Regressions, SVMs, Decision Trees & Random Forests
-
Advanced Pandas techniques from Vectorizing to Parallel Processsng
-
Statistical Theory, Probability Theory, Distributions, Exploratory Data Analysis
-
Ananlytic Case Studies involving Retail, Health, Elections, Sports, Resturants, Airbnb, Uber and more!
-
Full Tutorial on Google Data Studio for Dashboard Creation
0 Student
1 Course
0 review