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 visualizations with Looker Studio
This course is for you if...
- You work with data and you want to be autonomous
- You know how to make graphs, but scaling and automation are a challenge
- You use SQL, Looker Studio, or Google Sheets but not to their fullest potential
curriculum
What you’ll learn in this Data Analytics Essentials course
In just 40h, you’ll master the fundamentals of data analytics, gaining the autonomy to conduct thorough analyses with confidence.
10h
Automate dashboards with Google Sheets
Data analysis uses a lot of tools for different functions (Data Warehouse, Data Lake, ELT…). Understand their uses and discover the modern analytical architectures used by the most dynamic tech companies.
In practice:
- Understand why tools like Snowflake, BigQuery or Looker are important
- Set up Shapr's automated management dashboards on Google Sheets
Tools you will learn:
8h
Become autonomous in SQL
Unlock the potential of SQL, the essential language for data analysis. Query any relational database with ease and reduce your dependency on technical teams.
- Create Shapr's Product Tracking Board.
- Analyze the impact of Marketing investments on Shapr's business.
Tools you will learn:
10h
Build visualizations with Looker Studio
In Data Analysis, form matters as much as substance. Learn how to make charts and automated dashboards that hit the mark with Looker Studio.
- Create an automated monitoring dashboard for a B2B funnel with data from a prospecting tool (Lemlist) and a CRM (Hubspot).
- Create an automated follow-up dashboard for Shapr's COMEX with data from a Data Warehouse (BigQuery) via SQL.
Tools you will learn:
12h
Conduct concrete data analysis
You have the data... so what's the next step? Acquire the analytical skills to make your data articulate.
What you will do in practice:
- Perform hands-on analyses to your own data
- Or apply your learning to data from our partners
Want to learn more about our Data Analytics Essentials course?
Understand the goal of this skill course
Get our syllabus week by week
Understand our methodology
Download our Data Analytics Essentials syllabus
Loading form...
our method
Boost your skills learning from data software experts
With skilled and helpful teachers, you'll rapidly learn hands-on skills and build a strong foundation to further advance your career.
-
Apply your skills to real-world data
-
Learn in an immersive, hands-on environment
-
Gain lifetime access to Le Wagon's learning platform
Authors & Teachers
Next sessions
Loading...
Discuss your career
Decide which course is the best for you
Learn more about your financing options
Explore our methodology
Only have one question?
Loading form...
FAQ
Your questions answered
Here’s what you need to know about technical prerequisites for each bootcamp:
- Web Development: No technical background is required. We look for motivated, curious, and social students. If this describes you, you’re ready to apply and complete the selection process.
-
Data Science & AI: Requires basic programming and math knowledge:
- Programming: Familiarity with data types, conditions, loops, functions, and data structures (arrays and dictionaries) in any language like Python, Ruby, or JavaScript.
- Mathematics: Comfort with high school-level functions, derivatives, and linear equations. We provide pre-bootcamp resources to help you brush up on linear algebra and statistics.
- Data Analytics: Beginner-friendly, with no prerequisites beyond motivation to start your tech journey.
- Data Engineering: Beneficial to have foundational skills in programming, databases, and data infrastructure. Successful data engineers often blend these technical skills with strong soft skills to solve complex data challenges. This bootcamp provides hands-on training to help you build or deepen these skills, whether you’re starting fresh or seeking advanced expertise.
Apart from a good internet connection, no! There are some tools to download, like Slack, but other tools (e-learning platforms and software) are accessible from your Internet browser.
Yes, Le Wagon’s online bootcamps are eligible to be fully or partially funded, depending on your country of residence and if you meet the criteria for funding support. To find out what options are available, simply select your country on our Bootcamp Financing Options page. If you have multiple funding options, our admissions team will assist you in choosing the best one during your admissions interview. If you have any questions or need more information about local funding options, feel free to reach out to our admissions team at online@lewagon.org.
Don't worry about it! Students with a project are invited to pitch their idea during the bootcamp while people without one are welcome to team up with them.
The satisfaction rate is calculated by the NPS: Net Promoter Score. For the data analytics essentials course, the NPS is 9.5/10 for sessions held in 2022.
You need to have some professional work experience in a technical environment to join our course. We also expect that our students be motivated, curious and social. If this sounds like you, then we'll be more than happy to have you on board!
Some cities offer specific funding options with local financial partners, like deferred tuition plans, student loans, with interesting conditions or Income Share Agreements (ISA). Learn more about our financing options.
