Ranza Academy
Sign in
← Courses

Part of Deeptech & High-tech

Data Science for Practical Decisions

Move from a question to a reproducible analysis and a small predictive model. Learn data quality, descriptive statistics, SQL, visual reasoning, evaluation and responsible communication using a fictional delivery dataset.

Sponsored by Inscientech
24 hOnlineBeginnerDeeptech & High-tech

Objectives

  • - Translate a decision into measurable variables and a collection plan.
  • - Apply reproducible quality rules and retain an audit trail.
  • - Describe distributions and distinguish association from causation.
  • - Aggregate with SQL and design an honest chart.
  • - Compare a simple regression against a baseline on unseen later records.
  • - Deliver a reproducible recommendation with limitations and a monitoring plan.

Prerequisites

Percentages, averages and basic spreadsheets. Complete PY or demonstrate functions, loops and CSV reading.

Recommended tools

What professionals use for this course, with a free or open-source option wherever there is one.

  • Google SheetsFree

    Pivot tables and simple charts, without coding.

    Alternative to Excel

  • Google ColabFree

    Run Python in the browser, with nothing to install.

  • ThonnyOpen source

    A simple Python editor for beginners: it shows variables step by step.

  • DB Browser for SQLiteOpen source

    Write and test SQL queries on a file.

  • Kaggle LearnFree

    Free micro-courses: pandas, visualisation, machine learning.

  • Looker StudioFree

    Shared dashboards to monitor a measure.

    Alternative to Power BI

  • Orange Data MiningOpen source

    Analyse and model with visual blocks.

Lessons

  • Course OverviewReading · 10 min
  • 1.1 Questions and data contractsReading · 67 min
  • 1.2 Hands-on lab — Questions and data contractsReading · 101 min
  • 2.1 Cleaning without hiding evidenceReading · 67 min
  • 2.2 Hands-on lab — Cleaning without hiding evidenceReading · 101 min
  • 3.1 Statistics and exploratory analysisReading · 67 min
  • 3.2 Hands-on lab — Statistics and exploratory analysisReading · 101 min
  • 4.1 SQL and clear visual communicationReading · 67 min
  • 4.2 Hands-on lab — SQL and clear visual communicationReading · 101 min
  • 5.1 Prediction and honest evaluationReading · 67 min
  • 5.2 Hands-on lab — Prediction and honest evaluationReading · 101 min
  • 6.1 Responsible decisions and monitoringReading · 67 min
  • 6.2 Hands-on lab — Responsible decisions and monitoringReading · 101 min
  • Final exam — multiple choiceQuiz · 24 min
  • Final exam — written answersAssignment · 45 min
  • Final projectAssignment · 288 min
  • What next? Tools and your pathwayReading · 5 min