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 the Codecademy Terms of Service and Privacy Policy. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.Or sign up with
Skill level
BeginnerTime to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary50 hoursProjects
37Prerequisites
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.
Certificate of completion available with Pro
Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.
Take your skills into the real world with projects
Practice new skills, connect concepts, and put it all together to create something of your own.- portfolio Project
U.S. Medical Insurance Costs
Analyze a medical insurance costs dataset using Python. Explore the relationships between variables and investigate the role of attributes like age and location on medical insurance costs. - portfolio Project
Biodiversity in National Parks
Analyze and interpret data from the National Parks Service on the status of endangered species in some of the parks. Use your Python and statistics skills to better understand the status of various species. - portfolio Project
BI Data Analyst Final Portfolio Project
Bring together all of your data analytics skills into a portfolio project. Clean, analyze, and visualize, a dataset and then compile your results into a portfolio-worthy report.
- 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
Earn a certificate of completion
Show your network you've done the work by earning a certificate of completion for each course or path you finish.- Show proofReceive a certificate that demonstrates you've completed a course or path.
- Build a collectionThe more courses and paths you complete, the more certificates you collect.
- Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.
Our learners work at
Job-readiness checkerBeta
See how well your skills and experience match the job postings you’re interested in. Our job-readiness checker uses artificial intelligence to show you what you need to work on to qualify for a role.Try it outFrequently 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.
Everything you need for a Business Intelligence Data Analyst career
- Job-readiness checkerUse AI to evaluate how well your skills and experience meet the requirements of a job posting.Powered by AI
- Portfolio projectsApply what you're learning to create recruiter-ready projects for your portfolio.
- Interview simulatorUse AI to identify strengths and see how to improve your interviewing skills to land your dream tech job.Powered by AI
- Job listingsGet personalized job postings, connect with employers hiring tech talent, and easily apply for open roles.
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 Friendly54 hours - Free course
Learn the Basics of Programming with Codecademy
This course is for new programmers who aren't sure what they want to learn about. Take this course to jumpstart your learning journey!Beginner Friendly1 hour
Browse more topics
- Python3,508,751 learners enrolled
- Data Analytics2,335,213 learners enrolled
- Data Science4,342,620 learners enrolled
- SQL1,244,956 learners enrolled
- Data Visualization412,735 learners enrolled
- Code Foundations7,214,466 learners enrolled
- Computer Science5,667,308 learners enrolled
- Web Development4,826,907 learners enrolled
- For Business3,216,572 learners enrolled