--- title: Build your first dashboards and run your own analyses in just one week description: Join the data revolution. By learning SQL and data visualization, you'll be more autonomous and more impactful at any organization. image: https://info.lewagon.com/hubfs/CamilleHuguenot_LeWagon_Photoshoot_2025_HD-26%20(1).jpg --- [![Le Wagon's logo](https://info.lewagon.com/hubfs/v4_placeholders/logo-v4.svg)](https://www.lewagon.com) [Apply now](https://info.lewagon.com/en-gb/intensive-tech-courses#apply) [![Le Wagon's logo](https://info.lewagon.com/hubfs/v4_placeholders/logo-v4.svg)](https://www.lewagon.com) ![Close](https://info.lewagon.com/hubfs/icons/icons-v5/menu_close.svg) [Apply now](https://info.lewagon.com/en-gb/intensive-tech-courses#apply) ![⭐️](https://info.lewagon.com/hubfs/icons/icons-v5/star.svg) ![⭐️](https://info.lewagon.com/hubfs/icons/icons-v5/star.svg) ![⭐️](https://info.lewagon.com/hubfs/icons/icons-v5/star.svg) ![⭐️](https://info.lewagon.com/hubfs/icons/icons-v5/star.svg) ![⭐️](https://info.lewagon.com/hubfs/icons/icons-v5/star.svg) 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. - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Job-ready skills you can learn quickly and apply immediately. [Apply now](https://info.lewagon.com/en-gb/intensive-tech-courses#form) Download syllabus ![advisors](https://info.lewagon.com/hs-fs/hubfs/logo-v5/advisors.png?width=164&height=56&name=advisors.png) ## Want to learn more about this data analytics course? Download the Data Analytics Essentials syllabus to get all the details. ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Discover the tools you’ll learn ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Explore available funding options ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Access full program details ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) See the day-by-day breakdown ![CamilleHuguenot\_LeWagon\_Photoshoot\_2025\_HD-26 (1) copie](https://info.lewagon.com/hs-fs/hubfs/CamilleHuguenot_LeWagon_Photoshoot_2025_HD-26%20(1)%20copie.jpg?width=544&height=560&name=CamilleHuguenot_LeWagon_Photoshoot_2025_HD-26%20(1)%20copie.jpg) ### 40h to acquire key data skills ### 5 days of immersive, expert-led training designed for professionals, entrepreneurs and recent graduates ### £1000 £200 OFF for early sign-ups! Overview ## Improve your data analytics skills At the end of this skill course, you will: - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Master Google Sheets and conduct comprehensive analysis - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Become autonomous in SQL - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Build visualisations with Looker Studio - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Solve a real business case with data [Apply now](https://info.lewagon.com/en-gb/intensive-tech-courses#apply) ![Data Analysis Le Wagon V2-2](https://info.lewagon.com/hs-fs/hubfs/Data%20Analysis%20Le%20Wagon%20V2-2.png?width=547&height=400&name=Data%20Analysis%20Le%20Wagon%20V2-2.png) ## This course is made for you if... - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) You work with data and want to become more autonomous in using analysis and visualisation tools. - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) You want to build automated dashboards to communicate insights clearly and independently. - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) You use SQL, Looker Studio or Google Sheets but aren’t yet fully leveraging their potential to boost your career. [Apply now](https://info.lewagon.com/en-gb/intensive-tech-courses#apply) ![CamilleHuguenot\_LeWagon\_Photoshoot\_2025\_HD-33-1](https://info.lewagon.com/hs-fs/hubfs/CamilleHuguenot_LeWagon_Photoshoot_2025_HD-33-1.jpg?width=547&height=400&name=CamilleHuguenot_LeWagon_Photoshoot_2025_HD-33-1.jpg) 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. ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Sept 1st - Sept 5th ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) 9am - 6pm ##### Lecture (9.00 - 10.30) ![arrow](https://info.lewagon.com/hubfs/icons/icons-v5/arrow-right.svg) Grab a coffee and join an interactive session where your instructor will walk you through the key concepts of the day. ##### Challenges (10.30 - 17.30) ![arrow](https://info.lewagon.com/hubfs/icons/icons-v5/arrow-right.svg) 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) ![arrow](https://info.lewagon.com/hubfs/icons/icons-v5/arrow-right.svg) 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 syllabus Want to learn more about this data analytics course? Download the Data Analytics Essentials syllabus to get all the details. ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Discover the tools you’ll learn ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Explore available funding options ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Access full program details ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) See the day-by-day breakdown - Day 1 – Structure your data thinking - Day 2 – Become confident in SQL - Day 3 – Visualise your insights - Day 4 & 5 – Solve a real business case with Data ### Google 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](https://info.lewagon.com/hs-fs/hubfs/tools-v5/logo_google_sheets.png?width=28&height=28&name=logo_google_sheets.png) Google Sheets ![SQL](https://info.lewagon.com/hs-fs/hubfs/tools-v5/logo_sql.png?width=28&height=28&name=logo_sql.png) 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](https://info.lewagon.com/hs-fs/hubfs/tools-v5/logo_sql.png?width=28&height=28&name=logo_sql.png) SQL ![BigQuery](https://info.lewagon.com/hubfs/tools-v5/icon-google-big-query.svg) 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](https://info.lewagon.com/hs-fs/hubfs/tools-v5/logo_looker.png?width=28&height=28&name=logo_looker.png) 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](https://info.lewagon.com/hs-fs/hubfs/tools-v5/data_visualization.png?width=28&height=28&name=data_visualization.png) Data Visualisation ![Data Sourcing](https://info.lewagon.com/hs-fs/hubfs/tools-v5/data_sourcing.png?width=28&height=28&name=data_sourcing.png) Data Sourcing ![Looker Studio](https://info.lewagon.com/hs-fs/hubfs/tools-v5/logo_looker.png?width=28&height=28&name=logo_looker.png) Looker Studio ## Apply now and start analysing data in just 5 days ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-white.svg) Join a community of 29,000+ alumni ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-white.svg) Apply in under 5 minutes ![✔](https://info.lewagon.com/hubfs/icons/icons-v5/check-white.svg) No pre-payment and no commitment ![Coursereport](https://info.lewagon.com/hubfs/logo-v5/v5_coursereport-b77f602706c9a62c6a597d61859bc78c3c885dd44e609c523a62f01fe76b70dc.svg) 4.98/5 [2,927 reviews](https://www.coursereport.com/schools/le-wagon) ![Careerkarma](https://info.lewagon.com/hubfs/logo-v5/v5_career_karma-3f08a11fa5230ba6e77d586412bdf1a3c3a7bffbda68d3a08ff07a8b02fbbcc9.svg) 4.9/5 [1279 reviews](https://careerkarma.com/schools/le-wagon/) ![Switchup](https://info.lewagon.com/hubfs/logo-v5/v5_switchup-4a9eea447c452d4bc3848b799115db4aa3dd25142a2779456efdf52ccd07e9aa.svg) 4.98/5 [2698 reviews](https://www.switchup.org/bootcamps/le-wagon) ### Apply form our methodology ## Boost your skills learning from data software experts With experienced teachers, you'll rapidly learn hands-on skills and build a strong foundation to further advance your career. - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Skills delivered by our expert instructors - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Instant boost in autonomy and productivity - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) Practical, actionable skills for your industry - ![✔️](https://info.lewagon.com/hubfs/icons/icons-v5/check-red.svg) A hands-on project to complete and present by the end of the week ![CamilleHuguenot\_LeWagon\_Photoshoot\_2025\_HD-25-1](https://info.lewagon.com/hs-fs/hubfs/CamilleHuguenot_LeWagon_Photoshoot_2025_HD-25-1.jpg?width=547&height=400&name=CamilleHuguenot_LeWagon_Photoshoot_2025_HD-25-1.jpg) ### Here’s why people like you choose Le Wagon - ![Quote](https://info.lewagon.com/hubfs/icons/icons-v5/icon-quote.svg) "Goal 100% achieved! The course format is designed for hands-on practice — and that’s what makes it so effective in my opinion. No lectures or theoretical classes. You learn by doing — there’s no secret to it!" ![Elodie Lapaque at Bright](https://info.lewagon.com/hs-fs/hubfs/elodie-lapaque-manager.jpeg?width=44&height=44&name=elodie-lapaque-manager.jpeg) Elodie Lapaque Digital Marketing Specialist - Bright - ![Quote](https://info.lewagon.com/hubfs/icons/icons-v5/icon-quote.svg) "The course provides a very solid foundation—whether it’s for advanced functions in Google Sheets, SQL queries, or using a data visualization tool." ![Hugo Cornu at Alegria Group](https://info.lewagon.com/hs-fs/hubfs/Hugo%20Cornu.jpg?width=44&height=44&name=Hugo%20Cornu.jpg) Hugo Cornu Growth Lead - Alegria Group - ![Quote](https://info.lewagon.com/hubfs/icons/icons-v5/icon-quote.svg) "With Le Wagon, we learn Data Analysis in an environment that closely mirrors our own. It quickly becomes clear how we can apply what we’ve just learned to our day-to-day work as project managers." ![Tony Chan at Heetch](https://info.lewagon.com/hs-fs/hubfs/Tony%20Chan.jpg?width=44&height=44&name=Tony%20Chan.jpg) Tony Chan Product Manager - Heetch FAQ ## Your questions answered ## I don't have any technical background, can I join the course? You don’t need any prior technical skills or technical background to join this course. This one-week course is intensive, so we expect learners to be motivated and curious. ## What are the payment options? Are there funding options available? We offer a 5% discount for upfront payments. Once we receive your application, one of our advisors will be available to guide you through the next steps. ## What is the format and schedule of the course? This intensive one-week course is designed for professionals and recent graduates looking to boost their skills, running from Monday to Friday, June 30 to July 4, from 9 AM to 6 PM. This programme is delivered in person, on our London campus. Explore our free courses ![Python](https://info.lewagon.com/hubfs/tools-v5/icon-python.svg) ![SQL](https://info.lewagon.com/hubfs/tools-v5/icon-sql.svg) ![JavaScript](https://info.lewagon.com/hubfs/tools-v5/icon-javascript-lg.svg) Get access to over 200 hours of expertly curated content. [Start now](https://start.lewagon.com) [![Logo LinkedIn](https://info.lewagon.com/hubfs/tools-v5/linkedin-logo.svg)](https://www.linkedin.com/school/le-wagon) [![Logo Facebook](https://info.lewagon.com/hubfs/tools-v5/facebook-logo.svg)](https://www.facebook.com/lewagon) [![Logo Youtube](https://info.lewagon.com/hubfs/tools-v5/youtube-logo.svg)](https://www.youtube.com/c/lewagon) [![Logo Meetup](https://info.lewagon.com/hubfs/tools-v5/meetup-logo.svg)](https://www.meetup.com/pro/lewagon) [![Logo Github](https://info.lewagon.com/hubfs/tools-v5/github-logo.svg)](https://www.github.com/lewagon) © 2024 Le Wagon, Inc. All rights reserved.