Home My Library

Transform Your Career with Our Data Analyst Bootcamp

Join our immersive bootcamp designed to equip you with the essential skills and knowledge needed to excel as a data analyst. Whether you're just starting out or looking to enhance your expertise, our structured curriculum will guide you through Excel, SQL, Power BI, and more, preparing you for a successful career in data analysis.

Stay Informed and Be the First to Know!

Register your interest in our upcoming bootcamp and be the first to receive exclusive updates, early access, and special offers. Enter your full name and email below to stay connected and ensure you don't miss out on this transformative opportunity. Your journey to becoming a data expert starts here! 

We won't send spam. Unsubscribe at any time.

As a passionate educator and coach, Matt brings his wealth of knowledge to help you navigate and master the complexities of Data Analysis. He is committed to ensuring you develop and can apply new-found skills to take your career to the next level

Learn about Matt

With over a decade of experience in financial services, consulting and project management, Aston specializes in the power of mindset. He is dedicated to providing guidance of how to set, achieve and exceed your ambitious goals

Learn about Aston

Data Analysis for Beginners - Online Bootcamp & Coaching

  1. Introduction to your Bootcamp

    3 lessons
    1. Your Bootcamp Structure
    2. Personalised Coaching Experience
    3. How to Navigate your Content

  2. Week 1 _ Excel - Data Entry

    24 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 1

    2. Dive into Learning: Self-Study Curriculum

      1. Introduction
      2. Downloading Excel
      3. Excel Introduction
      4. Active Cell
      5. Entering Data
      6. Auto-Fit
      7. Auto-Complete
      8. Entering Numbers
      9. Inserting & Deleting Columns/Rows
      10. Auto Sequencing
      11. Navigating Edges
      12. Selecting Cells
      13. Number Formatting
      14. Numbers & Fractions
      15. Currency & Accounting
      16. Percentage
      17. Date Format
      18. Time Format
      19. Data Entry quiz

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 1

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 1
      2. Challenge Answers & Feedback: Week 1
      3. AI (Copilot) - Week 1

  3. Week 2 _ Excel - Formatting & Editing

    17 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 2

    2. Dive into Learning: Self-Study Curriculum

      1. Editing a cell
      2. Bold, Italics & Underline
      3. Autofill
      4. Borders
      5. Fill & Font
      6. Copy & Paste
      7. Alignment
      8. Formatting quiz
      9. Sorting
      10. Filter
      11. Find and Replace
      12. Editing quiz

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 2

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 2
      2. Challenge Answers & Feedback: Week 2
      3. AI (Copilot) - Week 2

  4. Week 3 _ Excel - Formulas 1

    16 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 3

    2. Dive into Learning: Self-Study Curriculum

      1. Download File
      2. Signs
      3. Functions
      4. Auto sequence with calculations
      5. Sum
      6. Sumif
      7. Sumifs
      8. Count
      9. Countif
      10. Countifs
      11. Min Max Average

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 3

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 3
      2. Challenge Answers & Feedback: Week 3
      3. AI (Copilot) - Week 3

  5. Week 4 _ Excel - Formulas 2

    14 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 4

    2. Dive into Learning: Self-Study Curriculum

      1. IF/ELSE
      2. VLOOKUP
      3. TRIM
      4. Left/Right
      5. Find
      6. LEN/MID
      7. Replace
      8. Calculations quiz

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 4

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 4
      2. Challenge Answers & Feedback: Week 4
      3. AI (Copilot) - Week 4

    5. End of Unit Reflection - Excel

      1. Reflection and Coaching

  6. Week 5 _ SQL - Operations / Logistics

    12 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 5

    2. Dive into Learning: Self-Study Curriculum

      1. SQL Introduction
      2. DOWNLOAD SQLITE
      3. Create a Database
      4. Importing Tables
      5. Introduction to SQL
      6. Sam's Favourite Word
      7. Comments
      8. SELECT
      9. SELECT DISTINCT
      10. WHERE

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 5

  7. Week 6 _ SQL - Basics

    17 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 6

    2. Dive into Learning: Self-Study Curriculum

      1. ORDER BY
      2. AND
      3. OR
      4. NOT OPERATOR
      5. UPDATE
      6. DELETE
      7. TOP/LIMIT
      8. MAX & MIN
      9. COUNT
      10. SUM
      11. LIKE
      12. IN
      13. BETWEEN

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 6

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 6
      2. Challenge Answers & Feedback: Week 6

  8. Week 7 _ SQL - Advanced Queries 1

    6 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 7

    2. Dive into Learning: Self-Study Curriculum

      1. ALIASES
      2. GROUP BY
      3. JOIN
      4. Key Takeaways

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 7

  9. Week 8 _ SQL - Advanced Queries 2

    6 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 8

    2. Dive into Learning: Self-Study Curriculum

      1. PLACEHOLDER - SQL Workshop

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 8

    4. Real-World Application: Business Scenario

      1. Challenge Details: Week 8
      2. Challenge Answers & Feedback: Week 8

    5. End of Unit Reflection - SQL

      1. Reflection and Coaching

  10. Week 9 _ Power BI - Getting Started

    12 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 9

    2. Dive into Learning: Self-Study Curriculum

      1. Power BI intro
      2. Download PBI
      3. Get DATA
      4. Power Query
      5. New Query
      6. Merge Query
      7. Load Data to Model
      8. Data Transformation quiz
      9. Report view
      10. Report Editor Intro

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 9

  11. Week 10 _ Power BI - Advanced

    27 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 10

    2. Dive into Learning: Self-Study Curriculum

      1. Text box
      2. Bringing Data into visualisations
      3. Styling Visuals
      4. Conditional Formatting
      5. General Formatting
      6. Filters
      7. Slicers
      8. Pie chart
      9. Donut Chart
      10. More Visuals
      11. Column Chart
      12. Map Visual / Sync Slicers
      13. Slicer Interactions
      14. Duplicating / Hiding Pages
      15. Create new Hidden Pages
      16. Visualisations Quiz - Power BI
      17. Buttons
      18. Bookmarks
      19. Navigating Reports quiz
      20. Add a DAX column
      21. Today's Date
      22. DAX Measure
      23. Save & Publish
      24. DAX quiz
      25. Key Takeaways

    3. Deep Dive: Technical Insights

      1. Technical Session: Week 10

  12. Week 11 _ Excel - Power Query

    8 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 11

    2. Dive into Learning: Self-Study Curriculum

      1. Fetching Data
      2. Power Query Editor
      3. Power Query - Adding Columns
      4. Conditional Column
      5. Close & Load
      6. Key Takeaways
      7. Power Query quiz

  13. Week 12 _ Excel - Visualisation

    11 lessons

    1. Weekly Kick-Off: Setting the Stage

      1. Weekly Kick-Off: Week 12

    2. Dive into Learning: Self-Study Curriculum

      1. Tables
      2. Slicers
      3. Pivot Tables
      4. Pivot Charts
      5. Conditional Formatting
      6. Save As
      7. Visualisations Quiz - Excel

    3. End of Course & Next Steps Reflection

      1. Congratulations!
      2. Project for Portfolio
      3. Next Steps - Coaching

  14. Week 12 - Your Coaching Pathway

    1 lesson
    1. Choose your Coaching Pathway for Weeks 13–16

  15. Week 13 - 16_Career Development

    5 lessons

    1. Bespoke 121 Career Coaching

      1. Week 13 Coaching
      2. Week 14 Coaching
      3. Week 15 Coaching
      4. Week 16 Coaching

    2. Resource Library: Tools for Success

      1. CV Template