Course curriculum

    1. Welcome!

    2. Discussion Boards (Support)

    3. 🧑🏻‍🏫 One-to-one (Support)

    1. Getting started with Module 1

    2. How do we collect data? Starting with Spreadsheets

    3. Spreadsheets: Excel Data Types, Operations & References

    4. Filters, Removing Duplicates & Text to Columns in Spreadsheets

    5. Exercise: Vlookups

    6. Charts & Pivot Tables

    1. Brief

    2. Submission - Project 1: Customer Data Report Dashboard

    3. Hint (if you get stuck)

    1. Brief

    2. Submission - Project 2: Business Plan P&L Dashboard

    3. Hint (if you get stuck)

    1. Getting started with Module 2

    2. Data Collecting, Databases and Data Storage

    3. External data with API's

    4. SQL & NOSQL Databases

    5. Using Connectors to bring in data externally

    6. Practical Exercise: Importing data with Zapier

    7. What is a data warehouse?

    8. Dimensions & Metrics

    9. Common Keys Mapping

    10. Common Keys Mapping Example

    11. Getting Started with Google Data Studio

    12. Filters & Calculated Metrics, Fields & Measures

    13. Blending Data with BI Tools

    14. Power BI Walkthrough

    15. Tableau Walkthrough

    1. Intro to SQL

    2. Tables, Databases and Relations

    3. Relational Database Management Systems

    4. CRUD Operations

    5. Data Types

    6. Structured Query

    7. Practical SQL Exercise

    8. DROP

    9. CREATE & INSERT

    10. SELECT, COUNT & DISTINCT

    11. GROUP BY, ORDER BY & SUM

    12. UNION & UNION ALL

    13. Subquery

    14. JOIN, ON, BETWEEN and Comparisons

    15. Linode - Understanding Databases - Ebook

About this course

  • 70 lessons
  • 3 hours of video content
  • 6 projects