Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Includes Python 3, SQL, pandas, Matplotlib, Tableau, Excel, and more.
Create free account
By signing up, you agree to our Terms of Service & Privacy Policy. This site is protected by reCAPTCHA and the Google Privacy Policies & Terms of Service.Or sign up with
Skill level
BeginnerTime to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary50 hoursCertificate of completion
YesPrerequisites
None
About this career path
BI Data Analysts use data to deliver business insights and are in high demand in every industry. This Career Path covers the basics you will need to earn a job as a BI Data Analyst in the shortest time possible. You’ll learn how to analyze data, build dashboards, and deliver impactful reports. Along the way, you’ll build portfolio-worthy projects that will help you get job-ready.
Syllabus
18 units • 46 lessons • 37 projects • 35 quizzes- 1
Welcome to the BI Data Analyst Career Path
Discover what you will learn on your journey to becoming a Business Intelligence Data Analyst!
- 2
Learn SQL
Learn SQL — a popular language that’s used for communicating with databases and working with data.
- 3
Python Fundamentals for Data Science (Part I)
Build a foundation in programming with Python with a focus on Data Science!
- 4
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.
- 5
Portfolio Project: U.S. Medical Insurance
Use your understanding of Python syntax to sort and analyze data about U.S. medical insurance costs!
- 6
Python Pandas for Data Science
Learn how to use the Python pandas library and lambda functions for Data Science.
- 7
Principles of Thinking about Data
Learn how to reason about data and gain a solid understanding of how to think about data numerically.
Projects in this career path
- Project
Create a Table
Build fluency in SQL manipulation. We're going to practice creating tables in SQL so you can hone your skills and feel confident taking them to the real world. - Project
New York Restaurants
Practice writing the most common types of queries. - Project
Analyze Hacker News Trends
Query Hacker News data using SQL to discover trends.
- The progress I have made since starting to use codecademy is immense! I can study for short periods or long periods at my own convenience - mostly late in the evenings.ChrisCodecademy Learner @ USA
- I felt like I learned months in a week. I love how Codecademy uses learning by practice and gives great challenges to help the learner to understand a new concept and subject.RodrigoCodecademy Learner @ UK
- Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.John-AndrewCodecademy Learner @ USA
Our learners work at
Frequently asked
Career paths teach you exactly what you need to start a new career. Curated by our team of experts, career paths contain a collection of courses, projects, prep for technical interviews, and more. By the end, you’ll be ready to start interviewing for entry-level jobs in the career of your choice.
Start your new career faster
Learn the skills
This expertly curated career path gives you all the knowledge and experience you need to start this career.Prep for interviews
Assess if you're ready to apply for jobs, then build your confidence with code challenges and practice questions.Get hired
Showcase your skills with a Codecademy professional certification and connect with employers directly.
Become a Data Analyst
Start my career changeLooking for something else?
Related resources
Related courses and paths
- Career path
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.Includes 22 CoursesWith Professional CertificationBeginner Friendly70 hours - Skill path
Data Science Foundations
Learn to clean, analyze, and visualize data with Python and SQL.Includes 15 CoursesWith CertificateBeginner Friendly56 hours - Career path
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.Includes 24 CoursesWith CertificateBeginner Friendly85 hours
Browse more topics
- Python4,588,360 learners enrolled
- Data Science5,854,826 learners enrolled
- SQL1,625,291 learners enrolled
- Data Visualization463,058 learners enrolled
- Data Analytics3,960,183 learners enrolled
- Code Foundations13,305,462 learners enrolled
- For Business9,809,169 learners enrolled
- Computer Science7,533,248 learners enrolled
- Web Development6,940,907 learners enrolled