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
3 monthsCertificate 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.
Hands-on learning
Don't just watch or read about someone else coding — write your own code live in our online, interactive platform. You'll even get AI-driven recommendations on what you need to review to help keep you on track.
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
Trends in Startups
In this project, we're going to practice aggregate functions in SQL so you can hone your skills and feel confident taking them to the real world. Using these functions will combine row values together and return a single result.
- 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
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 changeFrequently 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.
Looking for something else?
- Skill path
Master Statistics with Python
Learn the statistics behind data science, from summary statistics to regression models.Includes 9 CoursesWith CertificateIntermediate31 Lessons - Skill path
Learn Machine Learning
Learn the basics of machine learning to train your own models.Includes 7 CoursesWith CertificateBeginner Friendly12 Lessons - Which career is right for you?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