Beginner
Data Analytics 1.0
The complete data analytics course you need to transition into a high-paying tech role.
Over the course of 21 weeks, we will cover:
- Spreadsheets (Google spreadsheets, Microsoft Excel)
- Dashboarding (Looker Studio, Tableau, Power BI)
- Programming languages (R, SQL, Python)
- Career positioning (portfolios, resumes, applications)
Curriculum
- 28 Sections
- 57 Lessons
- 75h 2m Duration
Week 1 - Spreadsheets
2 Lessons
- 1 - What can a spreadsheet do?
- 2 - Solving a business case
Week 2 - Spreadsheets
3 Lessons
- 1 - Basic table and charts interpretation
- 2 - Simple functions and references
- 3 - Basic queries
Week 3 - Spreadsheets
2 Lessons
- 1 - Data visualisation
- 2 - Assignment 1
Week 4 - Spreadsheets
2 Lessons
- 1 - Data cleaning
- 2 - Getting ready to search for roles (Career session 1)
Week 5 - Spreadsheets
2 Lessons
- 1 - Data wrangling
- 2 - Assignment 1 (solution)
Week 6 - Spreadsheets
2 Lessons
- 1 - Basic statistic concepts (part 1)
- 2 - Statistical analysis (part 2) + Introduction to Mini project 1
Week 7 - Catch up/Career session
1 Lesson
- 1 - LinkedIn and Resumes (Career session 2)
Week 8 - Spreadsheets
1 Lesson
- 1 - Mini project (part 2)
Week 9 - Spreadsheets/Dashboarding
5 Lessons
- 1 - Catch up (a) + introduction to dashboarding
- 2 - Catch up (b)
- 3 - Mini project solved (part 1)
- 4 - Mini project solved (part 2)
- 5 - Introduction to Dashboarding
Week 10 - Dashboarding
3 Lessons
- 1 - Getting started with Looker Studio (part 1)
- 2 - Getting started with Looker Studio (part 2)
- 3- Dashboarding with Looker Studio
Week 11 - Dashboarding
2 Lessons
- 1 - Mini project (part 3)
- 2 - Introduction to Tableau
Week 12 - Dashboarding
1 Lesson
- 1 - Tableau (part 2)
Week 13 - Dashboarding
2 Lessons
- 1 - Power BI (challenge)
- 2 - Power BI (Introduction)
Week 14 - Career Positioning
2 Lessons
- 1 - Career chat (Networking and Job searches)
- 2 - Catch up + Q & A
Week 15 - Assignment 3
1 Lesson
- 1 - Assignment 3
Week 16 - Programming languages: SQL
3 Lessons
- 1 - Intro to SQL
- 2 - SQL CTEs and functions
- 3 - Customising Openrole
Week 17 - Programming languages: SQL
1 Lesson
- 1 - CTEs and functions
Week 18 - Programming languages: SQL
2 Lessons
- 1 - NULL values in SQL
- 2 - Aggregate functions in SQL
Week 19 - Programming languages: SQL
1 Lesson
- 1 - Subqueries and Assignment 4
Week 20 - Assignment Reviews
1 Lesson
- 1 - EC 3 Review
Week 21 - Programming Languages: SQL
4 Lessons
- 1 - Mini project (part 3) Review
- 2 - Careers in Data
- 3 - Power BI (conclusion) & SQL Revision
- Bonus Session: Getting Started in Big Data
Week 22 - Programming Languages: Python
2 Lessons
- 1 - Jupyter Notebook
- 2 - Structures in Python (part 1)
Week 23 - Programming Languages: Python
2 Lessons
- 1 - Data structures in Python (part 2)
- 2 - Conditional logic
Week 24 - Programming Languages: Python
2 Lessons
- 1 - Functions
- 2 - Mini Project (part 4)
Week 25 - Programming Languages: Python
2 Lessons
- 1 - For Loops
- 2 - For loops and text files
Week 26 - Programming Languages: Python
2 Lessons
- 1 - Importing libraries
- 2 - Importing libraries (part 2)
Week 27 - Programming Languages: Python
2 Lessons
- 1 - Troubleshooting as a data analyst
- 2 - Matrix operations in Numpy
Week 28 - Programming Languages: Python
2 Lessons
- 1 - Matrix operations in Numpy (part 2)
- 2 - Pandas
Related Courses
Beginner
Data Analytics with Jane (3.0)
Popular choice
- Database management and spreadsheets (Google spreadsheets, Microsoft Excel)
75h 23m
0
1
19
Intermediate
