Lecture (9.00 - 10.30)
Grab a coffee and join an interactive session where your instructor will walk you through the key concepts of the day.
4,98/5 - 6,000+ student reviews
Build your first dashboards and run your own analyses in just 5 days
In one week at the London campus, you'll learn how to work with SQL and master data visualisation tools; empowering you to make smarter decisions, automate reporting, and impress stakeholders.
-
Job-ready skills you can learn quickly and apply immediately.
%20copie.jpg?width=544&height=560&name=CamilleHuguenot_LeWagon_Photoshoot_2025_HD-26%20(1)%20copie.jpg)
Overview
Improve your data analytics skills
At the end of this skill course, you will:
-
Master Google Sheets and conduct comprehensive analysis
-
Become autonomous in SQL
-
Build visualisations with Looker Studio
-
Solve a real business case with data
This course is made for you if...
-
You work with data and want to become more autonomous in using analysis and visualisation tools.
-
You want to build automated dashboards to communicate insights clearly and independently.
-
You use SQL, Looker Studio or Google Sheets but aren’t yet fully leveraging their potential to boost your career.
Learning Schedule
A typical day at the Le Wagon London Campus
Get a sneak peek into a day as a student on the Data Analytics Essentials course.
June 30th - July 4th
9am - 6pm
Challenges (10.30 - 17.30)
Work on a series of hands-on exercises and business-oriented cases with the support of your peers and instructors.
Recap Session (17.30 - 18.00)
Join your classmates to debrief with the instructor and review the essential concepts from the day.
Curriculum
What you'll learn
In just a week, become confident working with data using SQL, Google Sheets and Looker Studio – and start thinking like a data analyst.
Download the syllabusGoogle Sheets & First Steps in SQL
Get started with data the right way. In this module, you’ll explore core data concepts, master the essentials of Google Sheets and take your first steps in SQL, all while working on real-world datasets.
What you will do in practice:
- Discover key data concepts and start working with Google Sheets.
- Build your first dashboard from real company data (Shapr), covering KPIs, cohort analysis, funnels and more.
- Learn the basics of SQL and write your first queries to explore relational databases.
Software and languages you will learn:
Google Sheets
SQL
Joins, Aggregations & Advanced Queries
Take your SQL skills to the next level. This module dives into advanced queries, including joins, aggregations and subqueries - giving you the tools to independently explore and analyse real-world datasets.
What you will do in practice:
- Go deeper with SQL: filter by dimensions, use aggregations, master joins (INNER, LEFT, RIGHT, FULL) and subqueries.
- Explore large-scale datasets in a professional cloud-based environment used in companies: Google BigQuery.
Software and languages you will learn:
SQL
BigQuery
Build dashboards with Looker Studio
Bring your data to life with Looker Studio. In this module, you’ll learn to create clear, interactive dashboards and design impactful visualisations that tell a compelling story.
What you will do in practice:
- Understand the interface, how it works and the types of compatible data sources
- Turn raw data into meaningful and interactive dashboards.
- Use calculated fields, apply transformations and combine multiple data sources to enrich your insights.
Software and languages you will learn:
Looker Studio
Final Project
Put your skills to the test. You’ll take on a real-world analysis challenge using data from a partner company - define hypotheses, conduct the analysis, uncovering actionable insights and demo your project.
What you will do in practice:
- Tackle a full analysis challenge using data from a partner company.
- Structure a clear, relevant and actionable analysis
- Build a full dashboard to showcase your results
- Present your project to your peers
Software and languages you will learn:
Data Visualisation
Data Sourcing
Looker Studio
