Data Analysis Bootcamp™ 21 Real World Case Studies

Gain Business Intelligence Skills using Statistics, Data Wrangling, Data Science, Visualizations & Google Data Studio

  • 0.0 (0 Reviews)
  • 0 Students
  • 168 Lessons
  • Rajeev D. Ratan

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:

  1. The Importance of Data Analytics

  2. Python Crash Course

  3. Data Manipulations and Wrangling with Pandas

  4. Probability and Statistics

  5. Hypothesis Testing

  6. Data Visualization

  7. Geospatial Data Visualization

  8. Story Telling with Data

  9. Google Data Studio Dashboard Design - Complete Course

  10. Machine Learning - Supervised Learning

  11. Machine Learning - Unsupervised Learning (Clustering)

  12. Practical Analytical Case Studies

Google Data Studio Dashboard & Visualization Project:

  1. Executive Sales Dashboard (Google Data Studio)

Python, Pandas & Data Analytics and Data Science Case Studies:

  1. Health Care Analytics & Diabetes Prediction

  2. Africa Economic, Banking & Systematic Crisis Data

  3. Election Poll Analytics

  4. Indian Election 2009 vs 2014

  5. Supply-Chain for Shipping Data Analytics

  6. Brent Oil Prices Analytics

  7. Olympics Analysis - The Greatest Olympians

  8. Home Advantage Analysis in Basketball and Soccer

  9. IPL Cricket Data Analytics

  10. Predicting the Soccer World Cup

  11. Pizza Resturant Analytics

  12. Bar and Pub Analytics

  13. Retail Product Sales Analytics

  14. Customer Clustering

  15. Marketing Analytics - What Drives Ad Performance

  16. Text Analytics - Airline Tweets (Word Clusters)

  17. Customer Lifetime Values

  18. Time Series Forecasting - Demand/Sales Forecast

  19. Airbnb Sydney Exploratory Data Analysis

  20. A/B Testing




See more

FAQ

FAQ area empty

Course curriculum

51 chương 168 bài học 21 giờ 6 phút 7 bài học thử miễn phí
Chương 1 Course Introduction & the Importance of Data Analysts
Chương 2 Download Code and Slides and Setup Google Colab
Chương 3 Python Crash Course
Chương 4 Pandas - Data Series and Manipulation
  • 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
  • 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
  • Pandas 5 - Feature Engineer, Lambda and Apply 4:24
  • Pandas 6 - Concatenating, Merging and Joinining 15:21
Chương 7 Pandas - Time Series Data
  • Pandas 7 - Time Series Data 9:56
Chương 8 Advanced Pandas
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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)
  • Pivot Tables 6:39
  • Dynamic Filtered Tables 2:53
Chương 16 Google Data Studio - Scorecards and Time Comparison
  • Scorecards 6:10
  • Scorecards with Time Comparison 5:44
Chương 17 Google Data Studio - Bar Charts, Line Charts and Time Series Plots
  • 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
  • Pie Charts, Donut Charts and Tree Maps 4:01
  • Scatter Plots 4:50
Chương 19 Google Data Studio - Geographic & Map Plots
  • Google Data Studio - Geographic & Map Plots 7:21
Chương 20 Google Data Studio - Bullet and Line Area Plots
  • Google Data Studio - Scatter Plots 5:32
Chương 21 Google Data Studio - Sharing your Interactive Dashboards
  • Google Data Studio - Sharing your Interactive Dashboards 6:57
Chương 22 Retail Sales Dashboard for Executives
  • Homework Project - Create Executive Sales Dashboard 2:19
Chương 23 Introduction to Machine Learning
  • 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
  • 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
  • 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
  • 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
  • Introduction to Neural Networks 2:07
  • Types of Deep Learning Algoritms CNNs, RNNs & LSTMs 7:38
Chương 28 Unsupervised Learning
  • 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
  • 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
  • Case Study Note
  • Understanding the Problem + Exploratory Data Analysis and Visualizations 19:53
Chương 31 Case Study 2 - Retail Product Sales Analytics
  • 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
  • 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
  • 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)
  • 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)
  • 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
  • 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
  • Economic Dataset Understanding 5:14
  • Visualizations and Correlations 7:42
Chương 38 Case Study 9 - 2016 US President Election Analysis
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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)
  • 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
  • Understanding our Dataset 6:48
  • Analysis Per State 4:46
  • Pizza Maps 7:24
Chương 46 Case Study 17 - Brewery and Pub Analysis
  • EDA, Visualizations and Map 13:41
Chương 47 Case Study 18 - EDA and Forecasting Brent Oil Prices
  • 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
  • Case Study 19 - Time Series Forecasting for Sales
Chương 49 Case Study 20 - Predicting Insurance Premiums
  • 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
  • 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
  • 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

Instructor

...
Rajeev D. Ratan

0.0

  • ... 0 Student
  • ... 1 Course
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all