Data Analyst

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

DiplômeCertification OpenClassroomsDuréeÀ plein temps : 12 mois

Une formation flexible 100% en ligne

Démarrez à tout moment votre nouvelle carrière ! Disponible à temps partiel ? Pas de problème, étudiez à votre rythme.

Des projets professionnalisants

Apprenez les compétences clés de votre futur métier en validant 7 projets tirés de cas concrets d’entreprise.

Un accompagnement personnalisé

Bénéficiez de sessions de mentorat hebdomadaires avec un expert du métier.

Certification OpenClassrooms

Décrochez la certification « Data Analyst Apprenticeship ».

Data

Data Analyst

DiplômeCertification OpenClassroomsDuréeÀ plein temps : 12 mois

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.

 

Votre certificat

  • OpenClassrooms est un établissement privé d’enseignement à distance déclaré au rectorat de l’Académie de Paris.

  • À l’issue de votre formation, sous réserve de validation de vos compétences par un jury, vous obtiendrez le certificat d’établissement OpenClassrooms « Data Analyst Apprenticeship ».

Data

Data Analyst

DiplômeCertification OpenClassroomsDuréeÀ plein temps : 12 mois

Une pédagogie basée sur la pratique

  • Obtenez des compétences clés en validant des projets professionnalisants.

  • Progressez à l'aide d'un expert du métier.

  • Gagnez un véritable savoir-faire ainsi qu’un portfolio pour le démontrer.

Les projets et compétences en détail

projet 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!
Durée10 heures
Compétences acquises dans ce projet
  • Adopt a lifelong learning mindset
projet 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.
Durée40 heures
Compétences acquises dans ce projet
  • Design research projects that apply valid scientific techniques
  • Design projects that consider the domain context and user needs in system implementation
  • Determine whether statistical methods are appropriate
  • Design research projects that use information obtained from baselines or historical data
  • Design projects that consider domain and user needs in the choice of analysis techniques
  • Collect datasets and samples which are suitable for specific projects
projet 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.
Durée30 heures
Compétences acquises dans ce projet
  • 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
  • Analyze statistical data to identify differences in relationships among sources
projet 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.
Durée40 heures
Compétences acquises dans ce projet
  • Design software applications or programming for statistical modeling and graphic analysis
  • Develop code to implement the system
  • Implement secure systems that adhere to relevant legislation and apply ethical measures
  • Maintain the system implementation
  • Configure database systems
projet 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.
Durée30 heures
Compétences acquises dans ce projet
  • Evaluate sources of information to determine any limitations
  • Process large amounts of data for statistical modeling and graphic analysis
  • Prepare data by organizing information, checking for inaccuracies, and adjusting the data
projet 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.
Durée40 heures
Compétences acquises dans ce projet
  • Present statistical and nonstatistical results, using data visualizations
  • Report results of statistical analyses in the form of tables, charts, and dashboards
projet 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.
Durée10 heures
Compétences acquises dans ce projet
  • 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

Un accompagnement individuel & privilégié

  • Bénéficiez de sessions individuelles hebdomadaires avec un mentor expert du métier.

  • Progressez rapidement dans vos projets grâce à son excellence dans le partage de son savoir-faire.

La communauté OpenClassrooms

  • Comptez sur une communauté soudée d’étudiants prête à vous aider 24h/24, 7j/7.

  • Partagez vos questions et vos doutes avec des centaines d'étudiants, de mentors et de diplômés sur un réseau social privé.

Nous sommes là pour vous aider

Vous avez une question ? Notre équipe est là pour vous répondre du lundi au vendredi de 9h00 à 19h00, heure en France métropolitaine.