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
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.
EDA: Diagnosing Diabetes
Inspect, clean, and validate a dataset on diabetes prevalence among females of Pima Indian heritage.
Handling Hotel Data in Excel
Use Excel to inspect and format hotel booking and cancellation data.
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
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.
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
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
Syllabus
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