Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

Business Intelligence Data Analyst

via Codecademy Path

Go to class Write review
Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.

Syllabus

  • Welcome to the BI Data Analyst Career Path
    • Discover what you will learn on your journey to becoming a Business Intelligence Data Analyst!
  • Learn SQL
    • Learn SQL — a popular language that’s used for communicating with databases and working with data.
  • Python Fundamentals for Data Science (Part I)
    • Build a foundation in programming with Python with a focus on Data Science!
  • 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.
  • Portfolio Project: U.S. Medical Insurance
    • Use your understanding of Python syntax to sort and analyze data about U.S. medical insurance costs!
  • Python Pandas for Data Science
    • Learn how to use the Python pandas library and lambda functions for Data Science.
  • Principles of Thinking about Data
    • Learn how to reason about data and gain a solid understanding of how to think about data numerically.
  • Exploratory Data Analysis in Python
    • Learn about exploratory data analysis (EDA) techniques for Data Science
  • Principles of Data Visualization
    • Bring data and visualization together to tell compelling data stories with eye-catching visuals.
  • Data Visualization Fundamentals with Python
    • If a picture is worth a thousand words, then a visualization is worth more than a thousand data points. Learn how to make them here!
  • Principles of Analyzing Data
    • Learn about different types of analyses, including exploratory, causal, and inferential analyses and how to combat bias in each.
  • Data Wrangling, Cleaning, and Tidying
    • Clean, well-structured data is essential to data science but cleaning data requires both a keen eye and technical skills. Develop both here!
  • Communicating Data Science Findings
    • Communication is an important part of your work as a data scientist. Learn best practices for effectively explaining your analysis.
  • Data Science Foundations Portfolio Project
    • Use your knowledge of data analysis to interpret data about endangered animals for the National Park Service.
  • Learn Microsoft Excel for Data Analysis
    • Learn how to analyze and visualize data in Microsoft Excel!
  • Learn Tableau for Data Visualization
    • Learn the basics of data setup and visualization in Tableau.
  • BI Data Analyst Final Portfolio Project
    • Show off your knowledge of data analytics by developing your final portfolio project on a topic of your choice.
  • BI Data Analyst Final Review
    • Review what you learned in the Business Intelligence (BI) Data Analyst Career Path and explore ways to deepen your knowledge!

Reviews

Start your review of Business Intelligence Data Analyst

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.