Applied Data Analytics

No reviews yet
Advanced65 hoursOffsite

About this course

Learn a complete data analytics workflow — spreadsheets, SQL, Python (pandas), statistics, data cleaning, exploratory analysis, visualization/dashboards, A/B testing, and AI-assisted analysis — ending in an end-to-end capstone analysis presented to a stakeholder audience.

Who this course is for

Professionals who already have basic spreadsheet familiarity and want to become a competent, job-ready data analyst, or analysts wanting to formalize and extend existing skills with SQL, Python, and statistics. This is the Advanced-tier course in the analytics/data catalog.

Entry requirements

- Minimum age 16, comfortable using a computer and basic spreadsheet functions - A laptop able to run Python (setup covered in Module 6) - No prior SQL, Python, or formal statistics background required — this course builds each from the ground up before using it

Curriculum

Module 1: Foundations of Data Analytics (5 lectures)
  • VideoWelcome to Applied Data Analytics15 min
  • ArticleWhat Does a Data Analyst Actually Do?95 min
  • ArticleThe Analytics Workflow: Ask, Collect, Clean, Analyze, Communicate95 min
  • ArticleFour Types of Analysis: Descriptive, Diagnostic, Predictive, Prescriptive95 min
  • QuizModule 1 Quiz: Foundations of Data Analytics15 min
Module 2: Excel/Google Sheets for Analytics (5 lectures)
  • ArticleCore Formulas Every Analyst Needs (Step by Step)90 min
  • ArticleLookup Functions: VLOOKUP, INDEX/MATCH, and XLOOKUP90 min
  • ArticlePivot Tables, Step by Step90 min
  • ArticleBasic Charting for Quick Insights90 min
  • QuizModule 2 Quiz: Excel/Google Sheets for Analytics20 min
Module 3: SQL for Data Analysis (8 lectures)
  • ArticleYour First SQL Query: SELECT, WHERE, ORDER BY80 min
  • ArticleAggregating Data: GROUP BY and Aggregate Functions80 min
  • ArticleCombining Tables: JOINs, Step by Step80 min
  • QuizModule 3 Quiz A: SQL Fundamentals20 min
  • ArticleSubqueries and Common Table Expressions (CTEs)80 min
  • ArticleWindow Functions: Running Totals, Rankings, and More80 min
  • ArticleWriting Efficient Queries: A Beginner's Guide to Query Performance80 min
  • QuizModule 3 Quiz B: Advanced SQL20 min
Module 4: Statistics Fundamentals for Analysts (5 lectures)
  • ArticleDescriptive Statistics: Mean, Median, Mode, Standard Deviation90 min
  • ArticleUnderstanding Distributions (Normal, Skewed, and What They Mean)90 min
  • ArticleCorrelation vs. Causation: A Step-by-Step Way to Tell the Difference90 min
  • ArticleConfidence Intervals and Basic Hypothesis Testing, Explained Simply90 min
  • QuizModule 4 Quiz: Statistics Fundamentals20 min
Module 5: Data Cleaning & Preparation (5 lectures)
  • ArticleFinding and Handling Missing Data, Step by Step90 min
  • ArticleDetecting and Removing Duplicates90 min
  • ArticleSpotting and Handling Outliers90 min
  • ArticleStandardizing Formats and Fixing Inconsistent Data90 min
  • QuizModule 5 Quiz: Data Cleaning & Preparation20 min
Module 6: Python for Data Analysis (Pandas) (6 lectures)
  • ArticlePython Basics for Complete Beginners: Variables, Lists, and Loops95 min
  • ArticleGetting Started with Pandas: Loading Your First Dataset95 min
  • ArticleFiltering, Sorting, and Selecting Data in Pandas95 min
  • ArticleGrouping and Aggregating Data with Pandas95 min
  • ArticleTransforming Data: New Columns, Merging, and Reshaping95 min
  • QuizModule 6 Quiz: Python for Data Analysis20 min
Module 7: Exploratory Data Analysis (EDA) (4 lectures)
  • ArticleA Repeatable Process for Getting to Know a New Dataset90 min
  • ArticleSummarizing and Profiling Data, Step by Step90 min
  • ArticleVisual Exploration: Histograms, Box Plots, and Scatter Plots90 min
  • QuizModule 7 Quiz: Exploratory Data Analysis20 min
Module 8: Data Visualization & Dashboard Design (5 lectures)
  • ArticleChoosing the Right Chart Type for Your Data90 min
  • ArticleDashboard Design Principles: Clarity Over Decoration90 min
  • ArticleBuilding Your First Interactive Dashboard, Step by Step90 min
  • ArticleCommon Visualization Mistakes and How to Avoid Them90 min
  • QuizModule 8 Quiz: Data Visualization & Dashboard Design20 min
Module 9: A/B Testing & Experimentation Basics (4 lectures)
  • ArticleDesigning a Valid A/B Test, Step by Step60 min
  • ArticleCommon Statistical Pitfalls in Experimentation60 min
  • ArticleReading and Interpreting a Results Report Critically60 min
  • QuizModule 9 Quiz: A/B Testing & Experimentation15 min
Module 10: AI Tools for Data Analytics (3 lectures)
  • ArticleUsing AI to Accelerate Data Analysis, Step by Step75 min
  • ArticleVerifying AI-Suggested Findings Before You Trust Them75 min
  • QuizModule 10 Quiz: AI Tools for Data Analytics15 min
Module 11: Communicating Insights & Storytelling with Data (3 lectures)
  • ArticleStructuring a Findings Presentation for a Non-Technical Audience60 min
  • ArticleTurning a Chart into a Story: A Step-by-Step Framework60 min
  • QuizModule 11 Quiz: Communicating Insights15 min
Module 12: Capstone — End-to-End Data Analysis Project (1 lecture)
  • ArticleCapstone Brief: End-to-End Data Analysis Project60 min

Instructor

Uko Hanson

Reviews

No reviews yet.