Data Analyst Apprenticeship

Prepare, analyze and visualize data to help your team and business make better decisions.

Training period

12 months full time

Training duration

200 hours supervised

A flexible online program

Imagine starting a brand-new career at any time! Can’t commit to full-time? No problem, study at your own pace.

Real-world projects

Acquire the most relevant skills by completing 7 projects based on those required in your future career.

Individual learning support

Benefit from weekly mentoring sessions with an expert in the field.

OpenClassrooms Certification

Leave the path with the “Data Analyst Apprenticeship” certification.

DataData Analyst Apprenticeship
Certification

OpenClassrooms Certification

Training period

12 months full time

Training duration

200 hours supervised

Data Analysts are at the core of a business. What are their responsibilities?

A Data Analyst's job is to analyze data and transform it into highly valuable metrics for a company. They are responsible for both data collection and data processing as well as guaranteeing data integrity.

A Data Analyst reports the results to various departments in the company. Therefore, a Data Analyst will need to develop communication and reporting skills to support decision-making processes.

Data plays a vital role in companies: 

  • 43% of companies are experiencing skill gaps in data analytics*
  • 72% of C-Level executives say they have to create a data culture inside their business**

*Beyond hiring: How companies are reskilling to address talent gaps, McKinsey & Company, Feb. 2020; **Is Your Business Masquerading as Data-Driven?, Harvard Business Review, May 2020.

What Skills Will You Learn During Your Training?

Over the course of this training program, we'll teach you a variety of skills, including how to:

  • Collect, compile, and clean raw data (often from lots of different sources).
  • Tell stories by helping analyze, interpret, visualize, and report on what secrets are in the data.
  • Draw conclusions and make recommendations that will help your business to grow.
  • Organize and manage how your company stores, archives, and deletes data securely, and legally.
  • Help predict the future by modeling, forecasting, and anticipating what might come next.

In addition to these technical skills, you will learn transversal or “soft” skills, which will help you grow as a software developer and allow you to progress in your career.

How Do OpenClassrooms Apprenticeships Work?  

Apprenticeship programs combine paid on-the-job learning with online project-based instruction that equips employees for high-demand careers in data, technology, and business development.

Here’s how it works:

  1. Onboarding (2-3 weeks prior to start of apprenticeship): Familiarizes both the apprentice and the employer with the training components and requirements. 
  2. Pre-apprenticeship (3 months of training): Provides the apprentice with scenario-based project learning coupled with weekly mentorship and skills building courses in preparation for the formal apprenticeship program.
  3. Apprenticeship (12 months on-the-job, with one day per week of instruction): Continues to build apprentice’s skills via on-the-job training, corresponding online instruction, and weekly one-to-one mentoring sessions. 
  4. Get certified! Following completion of the apprenticeship program, apprentices earn an industry-recognized and nationally portable credential from the U.S. Department of Labor. 

Online But Never Alone! 

Before, during, and after the training program, you’ll be accompanied by humans:

  • One-to-one weekly mentorship sessions with a professional in the field, in partnership with OpenClassrooms, who’ll provide you with support and guidance to complete your projects.
  • OpenClassrooms staff who’ll help you succeed in your apprenticeship.
  • Our global community of student peers with whom you’ll be in regular contact through our online platform. 
Fayçal, one of the OpenClassrooms mentors on the Data Analyst path
Fayçal, one of the OpenClassrooms mentors on the Data Analyst path

“Sometimes students are afraid that others will judge them, or simply afraid of failing. My role as a mentor is to remind them that they’re in training, and they’re here to try as many things as possible. The more they try, the more feedback they’ll get on their work. This approach feeds their curiosity and helps them to go faster!”

What Our Students Say About This Apprenticeship

Anthony, student on the Data Analyst program
Anthony, student on the Data Analyst program

“After 2 months on the Data Analyst path, I learned how to use a database and the SQL and Python languages. It’s so exciting: after just 4 projects, I can already do so many things!” 

Sonia, student on an apprenticeship
Sonia, student on an apprenticeship

“The projects are very concrete on the training program. This ‘real life’ aspect is reinforced by the apprenticeship. What I learn in my training, I can apply at work.”

Are You Eligible for This Apprenticeship Program?

To be eligible for this apprenticeship, you must demonstrate proof of the following prerequisites:

  • Be 18 years of age or older and have the right to work in the U.S.
  • Hold a high school/secondary school degree, vocational certificate, or equivalent.

Technical prerequisites:

  • fundamentals of probability, statistics, and linear algebra (high-school degree level)
  • programming language (HTML, SQL, Python ...)
  • manipulating data (Excel, BI tool ...)

These skills could be validated by having successfully completed OpenClassrooms pre-apprenticeship, an equivalent bootcamp, or the following courses: 

  1. Master the Fundamentals of Excel
  2. Learn Python Basics for Data Analysis.

Language: a good level of English (for non-native speakers, a CEFR level of B2, an IELTS band score of 6.5, or a TOEFL score of 80 is recommended).

Equipment: access to a computer (PC or Mac), headphones, a webcam, and a stable internet connection.

  • At least 8 GB of RAM and 100 GB of storage space available on your computer.
  • Administrator rights to your computer in order to install required programs.

 

Your certificate

  • OpenClassrooms is an online training educational establishment, declared as such by the French authority ‘le rectorat de l'Académie de Paris’.

  • Once you’ve completed your training program, and subject to validating your skills, you will receive the OpenClassrooms standard certificate "Data Analyst Apprenticeship".

DataData Analyst Apprenticeship
Certification

OpenClassrooms Certification

Training period

12 months full time

Training duration

200 hours supervised

A teaching method based on practical experience.

  • Acquire key skills for your future career with real-world projects.

  • Make progress with the support of an experienced professional.

  • Acquire concrete know-how and demonstrate it with a portfolio.

Detailed projects and skills

project 1

Dive Into Your Data Analyst Apprenticeship

Find out what you are going to learn during your apprenticeship and get to know your mentor. You will also define your learning goals in this first project!

10 hours supervised

Skills acquired in this project
  • Adopt a lifelong learning mindset
project 2

Analyze Requirements and Plan a Data Analysis Project

In this fictional project, you’re working for an agribusiness company that wants to expand their operations internationally. Gather and assess the data that’ll help them understand which countries they should invest in.

40 hours supervised

Skills acquired in this project
  • Determine whether statistical methods are appropriate
  • Collect datasets and samples which are suitable for specific projects
  • Design projects that consider domain and user needs in the choice of analysis techniques
  • Design projects that consider the domain context and user needs in system implementation
  • Design research projects that apply valid scientific techniques
  • Design research projects that use information obtained from baselines or historical data
project 3

Perform Initial Data Analysis and Modeling Based on Sales Data

For this second fictional project, you’re working for a natural food store chain that's about to launch an online marketing campaign. Help them target the best customer profile using previous sales data.

30 hours supervised

Skills acquired in this project
  • Analyze statistical data to identify differences in relationships among sources
  • Adapt statistical methods to solve problems in fields such as economics and engineering
  • Identify factors in data that could affect the results of research
  • Identify relationships and trends in data
project 4

Analyze an Existing Database and Retrieve Data

Work on a database project by taking an existing database in your company, studying its structure, and querying it. Consider how security, legislation, ethics, and maintenance affect database design decisions.

40 hours supervised

Skills acquired in this project
  • Design software applications or programming for statistical modeling and graphic analysis
  • Configure database systems
  • Develop code to implement the system
  • Implement secure systems that adhere to relevant legislation and apply ethical measures
  • Maintain the system implementation
project 5

Prepare Data for Analysis and Assess its Quality

Work on a data acquisition project and decide if the data is good enough to perform an analysis. Compile and clean the data using Python functions then evaluate its quality.

30 hours supervised

Skills acquired in this project
  • Evaluate sources of information to determine any limitations
  • Prepare data by organizing information, checking for inaccuracies, and adjusting the data
  • Process large amounts of data for statistical modeling and graphic analysis
project 6

Produce a Dashboard to Visualize Data

Help your company easily and efficiently monitor an ongoing project. Your goal is to create a customized dashboard using a dashboarding tool your company uses (Tableau, Power BI, Excel, etc.) to help them keep track of their progress.

40 hours supervised

Skills acquired in this project
  • Present statistical and nonstatistical results, using data visualizations
  • Report results of statistical analyses in the form of tables, charts, and dashboards
project 7

Keep Track of Emerging Data Analysis Industry and Technology Trends

Stay up to date with new technologies, products, and services relevant to the data analysis field. Identify relevant sources to keep up with emerging data analysis methods from industry and academic research.

10 hours supervised

Skills acquired in this project
  • Keep up to date on new technologies, products and services relevant to data analysis
  • Learn about new data analysis methods emerging from industry and academic research
  • Synthesize information gathered from knowledge management tools

One-to-one learning support

  • Benefit from weekly individual mentoring sessions with an expert in the field.

  • Progress rapidly through projects thanks to their expertise in sharing know-how.

The OpenClassrooms community

  • Count on our solid student community to give you support 24-7.

  • Share your doubts or queries with a comprehensive network of students, mentors, and graduates.

How exactly will I learn on an OpenClassrooms path?

From choosing what to study to starting their new career, our students describe their experiences and the support they received at every step of the way.

See step-by-step experience

Training program last updated on Jul 26, 2023