Surfalytics
Module overview

Lesson 01 Free preview

Introduction to Module 1

Introduction to Module 1

Overview of 11 lessons covering analytics fundamentals, architecture, and career roadmap.

What this module is about

Module 1 is the foundation of the whole course. Before you write SQL or build a dashboard, you need a mental map of the field. What is data analytics? Who does what on a data team? How does data move from a source system to a report an executive reads? This module gives you that map.

Most beginners skip this step. They jump straight into tools. Then, in interviews, they can write a query but cannot explain where the data comes from, why the company needs it, or how their role differs from a data engineer’s. Hiring managers notice. The people who get hired are the ones who understand the system, not just one tool inside it.

What you will learn

The lessons in this module cover four big themes.

1. How analytics evolved

Analytics did not start with the cloud. It started with spreadsheets, then on-premise databases and data warehouses, then Hadoop and big data, and now the modern data stack built on cloud warehouses like Snowflake, BigQuery, and Redshift. Knowing this history matters for a practical reason: real companies run a mix of all these generations. You will meet an old SQL Server data warehouse and a new dbt project in the same job. Understanding why each layer exists helps you work with both.

2. The goal and role of analytics

Analytics exists to help a business make better decisions. That sounds obvious, but it changes how you work. A dashboard nobody uses is a failure, even if the SQL is perfect. In these lessons you will learn how analytics creates value: measuring performance, finding problems, testing ideas, and feeding data products. This is the “why” behind every technical skill in later modules.

3. Analytics architecture

You will learn a simple framework for any analytics solution: data sources, ingestion, storage, transformation, and consumption. Every company implements these layers with different tools — Fivetran or Airbyte for ingestion, Snowflake or BigQuery for storage, dbt for transformation, Tableau or Power BI or Looker for consumption. The tools change every few years. The layers do not. If you learn the layers, you can learn any new tool quickly.

4. Data job roles and your career roadmap

The job market uses many titles: data analyst, BI developer, analytics engineer, data engineer, data scientist. These lessons explain what each role actually does, how they overlap, and what employers expect at the entry level. Then you will build your own career roadmap: which role fits you, what skills it needs, and in what order to learn them.

The module also covers practical team topics — how data teams are structured, how they work with Agile, common file types you will meet (CSV, JSON, Parquet), and why spreadsheets are still a real analytics tool.

Why this matters for getting a data job

Interviews for entry-level data roles test more than SQL. Common questions include:

  • “Explain a data warehouse to a non-technical person.”
  • “What is the difference between a data analyst and a data engineer?”
  • “Walk me through how data gets from an application into a dashboard.”

Every one of these is answered in this module. Candidates who can explain the big picture stand out because most applicants cannot. This is cheap effort with a high payoff.

Common beginner mistakes

  • Learning tools before concepts. A person who knows the architecture can pick up a new BI tool in a week. The reverse is not true.
  • Chasing every job title at once. Pick one target role first. The lessons on job roles will help you choose.
  • Ignoring the business side. Analytics is a service to the business. Practice explaining technical work in business terms from day one.
  • Treating spreadsheets as beneath you. Excel and Google Sheets are everywhere. Being fast in them is a real, hireable skill.

How to work through this module

  1. Watch each lesson in order. They build on each other.
  2. After each lesson, write a two-sentence summary in your own words. If you cannot, rewatch.
  3. When you reach the job roles lessons, pick your target role and write it down. The rest of the course makes more sense with a target.
  4. Practice the interview question above: explain the flow from source system to dashboard, out loud, in under two minutes.

By the end of this module you should be able to describe the modern data landscape, name the layers of an analytics architecture, and say clearly which data role you are aiming for and why. That clarity is the foundation for every technical module that follows.

Next steps