Data Analyst

Analyze data and model phenomena with realistic business cases. Start your career in Data Science now!
Data Analyst
At your pace
~ 12 months
Personal
mentor
Job guarantee
in 6 months
Bachelor's-level diploma
9 hands-on projects

Due to unprecedented growth, it is estimated that more than 200,000 jobs in the data sector will be created by 2020 in the U.S. alone.

Here at OpenClassrooms, we focus on roles high in demand, reverse-engineering our curriculum based on the skills needed to perform on the job.

We've built this one-year, bachelor’s-level diploma program in data analysis to enable our students to develop their careers in the growing data sector. This program is taught entirely online with one-on-one, weekly sessions with a dedicated mentor.

What will I do as a Data Analyst?

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 of the company. Therefore, a Data Analyst will need to develop communication and reporting skills to support decision-making processes.

The responsibilities of a data analyst are diverse. They include:

  • Gathering data: standardizing it while maintaining its integrity.
  • Interpreting data: identifying trends and helping others make sense of it.
  • Presenting data: creating dashboards, visualizations, and written reports.
  • Analyzing data: support decision-making to improve the company’s strategy.

How much will I earn?

Here is what you can expect to earn in your career as a Data Analyst:

US Income Estimates:

  • Beginner: $60,000 to $70,000 per year
  • Senior: $70,000 to $100,000 per year

UK Income Estimates:

  • Beginner: £22,000 to £30,000 per year
  • Senior: £30,000 to £48,000 per year

(source: glassdoor.com)

Roles in data analysis are in high demand for full-time employment. Freelance Data Analysts have charged up to $500 or £400 per day of work.

What are my job prospects?

Companies around the world are looking for Data Analysts both in start-ups and in large enterprises.

This program will prepare you for the following careers:

  • Data Analyst (6,000+ jobs on Indeed.com)
  • Marketing Analyst (10,000+ jobs on Indeed.com)
  • Business Intelligence Analyst  (5,000+ jobs on Indeed.com)

Who is eligible to enroll?

  • Required level: High school diploma, GCSE or equivalent
  • 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)
  • Access to a computer (PC or Mac), equipped with a microphone, a webcam and a good internet connection.

Technical prerequisites

  • Fundamentals of probability, statistics, and linear algebra (i.e. matrices multiplication).

What will I learn?

  • Perform database searches using SQL queries to retrieve relevant data.
  • Transform data into valuable information.
  • Create informative data visualizations.
  • Create dashboards and reports to facilitate the decision making process.
  • Apply key mathematical concepts for data analysis.

How will I learn at OpenClassrooms?

Our learning method is unique and revolves around two elements: professional projects and dedicated mentoring sessions.

Projects

At OpenClassrooms, learning is project-driven because that’s the fastest way to become proficient. Projects offer hands-on experience so you can hit the ground running when you start your new job.  

OpenClassrooms' Data-Analyst path has 9 projects that you’ll need to complete one at a time with the support of your mentor. You’ll receive a detailed brief with the context, deliverables and additional details. Then it’s up to you to go and make it real! To do this you’ll have to be creative, coming up with innovative solutions to the questions at hand.

Want to see an example of a project? Read our blog post here.

Mentorship

During your path, you will be allocated a mentor who will offer one-to-one support via weekly video conference sessions. This mentor will offer guidance on your projects, help define objectives and guide you until you reach them. Our mentors are dedicated professionals who are experts in their field and have experience in sharing their know-how with our students.

Your diploma

OpenClassrooms is an official private distance learning establishment registered with the Board of Education in Paris, France that grants its own diplomas as well as those of prestigious academic partners.

Upon completion of your studies and validation of your skills by an academic jury, you will earn a "Data Analyst" bachelor's-level diploma.
This diploma is at level 6 on the EQF (European Qualifications Framework).

This path will be the subject of a registration application with the National Directory of Professional Certifications (RNCP), France compétences, in order for the level of the diploma to be recognized by the State. This process takes 8 to 18 months. If the outcome is successful, the first students will be able to retroactively claim recognition by the RNCP. If the outcome is negative, the level of the diploma will not be recognized by the State.

If you have questions about its equivalence in order to undertake further study, contact your university or master's program.

Your Job Guarantee

At OpenClassrooms we are committed to helping you find your ideal job. We promise.

By following the learning path "Data Analyst", you’ll learn an exciting new profession with great career prospects.

What’s more, you’ll find a job within six months of graduating or we’ll give you your money back!

Find out more

Detailed projects and skills

project 1

Start your journey as a Data Analyst

It's time to step into your new role and find out what it means to be a Data Analyst. Take the time to also define your goals and your study schedule in this first project.
Duration30 hours
Skills acquired in this project
  • Adopt a lifelong learning mindset
  • Prepare for an interview for a Data Analyst position
project 2

24 hours in the life of a Data Analyst

Today you must provide a monthly report to your manager. What figures will you choose? Which graphs will you include in your presentation?
Duration40 hours
Skills acquired in this project
  • Describe the role of a Data Analyst
project 3

Improve your client's Social Media strategy

You have landed your first freelance job as a Data Analyst for an online magazine! Analyze your client's user data and make recommendations to better target their Social Media audience.
Duration50 hours
Skills acquired in this project
  • Prepare the database and dataset using SQL
  • Retrieve and analyze data using SQL queries
  • Apply relational algebra operations using SQL
  • Apply the concepts of the relational model using SQL
project 4

Conduct a public health study

You are responsible for setting the parameters for a study on malnutrition. To guide future research, you will have to designate data points, identifying trends and areas for improvement.
Duration70 hours
Skills acquired in this project
  • Use Python Data Science libraries to solve a business problem
  • Apply basic programming operations
  • Apply relational algebra operations using Python
  • Retrieve data from an external source
  • Use a notebook to facilitate programming and collaboration
project 5

Analyze your company’s sales

Your company provides you with their raw sales data and asks you to make sense of it. It's up to you to spot areas for growth and new market opportunities.
Duration80 hours
Skills acquired in this project
  • Describe a dataset using a univariate analysis
  • Transform a dataset for analysis
  • Describe a dataset using a bivariate analysis
project 6

Conduct a market analysis

You are employed in an agribusiness company that wants to expand internationally. You must therefore identify new countries to grow their business.
Duration100 hours
Skills acquired in this project
  • Perform a statistical test
  • Carry out a hierarchical clustering
project 7

Detect counterfeit notes

Your IT consulting company has a new client: a government agency in charge of anti-counterfeiting. Your mission: find a solution to detect counterfeit notes
Duration70 hours
Skills acquired in this project
  • Select the appropriate model to meet business requirements
  • Describe a dataset through principal component analysis
  • Perform a classification with the k-means algorithm
  • Select the appropriate classification algorithm
  • Apply a modeling technique
project 8

Make an income prediction

An international bank hopes to find new customers. From existing data, build a model to analyze and predict the income of prospective clients.
Duration80 hours
Skills acquired in this project
  • Select the appropriate model to meet business requirements
  • Apply an ANOVA
  • Apply a linear regression
project 9

Help your company visualize their progress

Your pharmaceutical company wants to easily and efficiently monitor their ongoing projects. Your goal: create a custom dashboard for the executive committee.
Duration120 hours
Skills acquired in this project
  • Create a dashboard to inform and assist decision making
  • Write a Data analysis report

Start toward the career of your dreams

At your own pace

$400 per month

Your perks:
  • Six-month job guarantee

  • bachelor's-level diploma

  • Flexible duration

  • Individual mentorship

  • 9 hands-on projects

Start nowNon-binding subscription

We are here to help

Schedule a call