Course curriculum

    1. Introduction and setup

    2. All Jupyter Notebooks Required for the Course

    3. All Excel materials required for the course

    1. Part 1 - variables, data types, implied probabilties

    2. Part 2 - Boolean expressions, complement, addition, multiplication rules

    3. Part 3 - SQL. Introducing DuckDB, SELECT, FROM, VALUES, SUM

    1. Part 1 - Functions, parameters, overlapping events, data frames

    2. Part 2 - Normalisation, applying the addition rule

    3. Part 3 - Boolean masks

    4. Part 4 - Combining boolean masks (Python's version of IF AND, IF OR)

    5. Part 5 - SQL. CASE WHEN, THEN, aliasing with AS

    6. Part 6 - SQL. WHERE

    1. Part 1 - Lists, list comprehensions, SUM(), zip function

    2. Part 2 - Custom overround functions

    3. Part 3 - Overround redistribution, custom function

    4. Part 4 - SQL. VALUES

    1. Part 1 - Math.comb, custom binomial function

    2. Part 2 - Looping for a PMF, dictionaries, APPPEND

    3. Part 3 - binomial function for goal in next n minutes

    4. Part 4 - SQL. GROUP BY, WHERE filters, UNION ALL

    1. Part 1 - Custom Negative Binomial Function

    2. Part 2 - Range() to iterate through trials, appending dictionaries, .to_string

    3. Part 3 - Filtering to sum probabilities

    4. Part 4 - SQL. Tables of trial counts, ORDER BY, filtering with WHERE

About this course

  • £795.00
  • 55 lessons
  • 11.5 hours of video content

Discover your potential, starting today