Codecademy logo
Sign up

Become a Data Analyst

Made with❤️ in NYC © 2022 Codecademy

This path covers the basics for becoming a Business Intelligence Data Analyst in the shortest time possible and with little emphasis on coding.

About this Career Path

  • Organize data using minimal code: Use Excel, Python, and SQL to talk to databases and manipulate tables.
  • Turn data into insights: Generate reports, dashboards, and data visualizations to see the big picture and drive decision-making.
  • Prepare for your career: Get job-ready with portfolio projects and more.

Beginner

Skill level

$87,000

Average salary (US)

4,000+

Recent learners

Start my career change

Projects you’ll build

Lyft Trip Data

Practice using multiple tables in SQL so you can hone your skills and feel confident taking them to the real world.

View project

EDA: Diagnosing Diabetes

Inspect, clean, and validate a dataset on diabetes prevalence among females of Pima Indian heritage.

View project

Handling Hotel Data in Excel

Use Excel to inspect and format hotel booking and cancellation data.

View project

Top companies trust Codecademy to level up their teams. Learn more

Career Path

Business Intelligence Data Analyst

No matter the industry, organizations everywhere need help interpreting data to learn ways they can improve their business — that’s where Business Intelligence Data Analysts come in. Get the specialized skills and portfolio you need to start your career as a BI Data Analyst in this curated career path.

Includes Excel, Tableau, Matplotlib, Python 3, SQL, pandas, and more

Write live code, build projects, and practice for interviews

Finish in 3 months with a certificate of completion

Start my career change

Reviews from other learners

"Lessons are in a logical order, with easy to follow applications and projects, and full explanations given for everything taught, in multiple ways; so that no matter how you learn, Codecademy can help you."

Robert
Codecademy Learner @ USA

"Codecademy has launched my learning and comprehension progress beyond what I thought possible."

Norman
Codecademy Learner @ USA

"Codecademy is the best place to learn out there! Most of the other courses just have videos. Codecademy has a platform on which we can code and we get instant feedback."

Jefrin
Codecademy Learner @ India

Looking for something else?

Which career is right for you?

Learn which careers and languages suit your personal interests and strengths best in this short and free resource.

Pick a career

Computer Science

Learn Computer Science fundamentals, build a professional portfolio, and prepare for an entry-level role in tech.

Career Path

Beginner friendly, 82 lessons

View Career Path

Data Scientist: Machine Learning Specialist

If you want to turn human language into data and get an introduction to AI, this is the career path for you.

Career Path

Beginner friendly, 81 lessons

View Career Path

Syllabus

See all 18 units

Welcome to the BI Data Analyst Career Path

Discover what you will learn on your journey to becoming a Business Intelligence Data Analyst!

1

Learn SQL

Learn SQL — a popular language that’s used for communicating with databases and working with data.

2

Python Fundamentals for Data Science (Part I)

Build a foundation in programming with Python with a focus on Data Science!

3

Python Fundamentals for Data Science (Part II)

Continue building your Python Skills while applying them to real data science challenges including finding and working with real data.

4

Portfolio Project: U.S. Medical Insurance

Use your understanding of Python syntax to sort and analyze data about U.S. medical insurance costs!

5

Python Pandas for Data Science

Learn how to use the Python pandas library and lambda functions for Data Science.

6

Principles of Thinking about Data

Learn how to reason about data and gain a solid understanding of how to think about data numerically.

7

18 units • 37 projects • 46 lessons

Start my career change