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
Web development course
You don't need any technical background to join our web development bootcamp. We expect 3 things from our students: be (extremely) motivated, be curious, be social. If this sounds like you, then we'll be more than happy to have you on board if you pass all the selection process.
Data science & AI course
The Data science & AI course requires some basic knowledge of programming and mathematics.
- How much programming do I need to know? Well, you must be comfortable with data types & variables, conditions, loops, functions and data structures like arrays and dictionaries (also called hashes in some programming languages). If you know those topics in other languages than Python (like Ruby, JavaScript, C++, etc.), you have the right programming prerequisites!
- How much mathematics do I need to know? In order to join our Data Science course, you also need a minimum level in Mathematics and to be familiar with concepts covered in high school's scientific section. We need you to be comfortable with functions, their derivatives & systems of linear equations. To get up to speed, some additional preparation work will be given to you before the bootcamp start to get a refresh of all these concepts as well as more advanced knowledge on linear algebra and statistics.
Data analytics course
The data analytics bootcamp is beginner-friendly, with no prerequisites required. What counts for us is that you’re motivated to start your new tech journey.
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.
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.
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.
