Data Analytics

What you will learn

1. 1
   BeginnerWhat data analytics is and the analysis workflow

   From a business question to a decision, step by step.

2. 2
   BeginnerSpreadsheets and data cleaning

   Tidy tables, and fixing messy data before analysis.

3. 3
   BeginnerFormulas, lookups and pivot tables

   Summarise thousands of rows in seconds.

4. 4
   IntermediateStatistics you actually need

   Averages, spread, correlation and common traps.

5. 5
   IntermediateSQL for analysis

   Ask databases questions with SELECT, JOIN and GROUP BY.

6. 6
   IntermediateVisualisation and dashboards

   Pick the right chart and build a dashboard people can read in seconds.

7. 7
   AdvancedPython and pandas for analysis

   Automate analysis on bigger datasets with notebooks.

8. 8
   ProStorytelling, portfolio and getting paid

   Turn insight into decisions, and skills into income.