Skip to content
Business Intelligence & Data AnalyticsCareer Path · Codecademy May 26, 2026 6 min read

Business Intelligence Data Analyst Career Path: What I Actually Learned Building SQL, Python & Tableau Skills

Business Intelligence Data Analyst Career Path: What I Actually Learned Building SQL, Python & Tableau Skills cover

I completed Codecademy's Business Intelligence Data Analyst Career Path, a project-based program (18 units, ~50 hours, 37 hands-on projects) built around one job function that nearly every company now needs regardless of size: someone who can pull data out of a database, clean and analyze it, and turn it into a report or dashboard that a manager can actually act on. That's the BI Data Analyst role, the bridge between raw operational data and business decisions.

The credential matters because the exact skill combination it teaches (SQL, Python, and dashboarding with Excel and Tableau) is the standard toolkit requested in Business Intelligence Analyst job postings across e-commerce, healthcare, logistics, and fintech, not just inside dedicated data-science teams. It's proof I can work with real, messy data end-to-end rather than only in a lab or classroom setting.

What I learned

  1. Learn SQL

    Writing SELECT statements, filtering and aggregating rows, and joining across multiple tables, the core language for pulling business answers directly out of a company's database.

  2. Python Fundamentals for Data Science (Part I & II)

    Core Python syntax, control flow, functions, and data structures, taught through data-science use cases rather than generic software-engineering examples.

  3. Portfolio Project: U.S. Medical Insurance Costs

    A hands-on project analyzing a real insurance dataset with pure Python (no external libraries) to answer concrete business questions about cost drivers.

  4. Python Pandas for Data Science

    Data cleaning, transformation, merging, grouping, and lambda functions using the pandas library, the standard tool for working with tabular datasets in any BI or analytics role.

  5. Principles of Thinking about Data

    Numerical reasoning and statistical thinking: how to frame a business problem as an answerable data question before writing a single query or line of code.

  6. Dashboards and Reporting with Excel and Tableau

    Building clear, decision-ready dashboards and visual reports with the two BI tools most frequently requested in Business Intelligence Analyst job listings.

  7. BI Data Analyst Final Portfolio Project

    A capstone combining data cleaning, exploratory analysis, and visualization into a professional report written for a non-technical stakeholder audience.

Tools & technologies

  • SQL
  • Python 3
  • pandas
  • Microsoft Excel
  • Tableau
  • Matplotlib

Applied in my projects

This BI skill set shows up directly in my Sales Prediction App with Django & ML, where I used Python, pandas, NumPy, and Matplotlib/Seaborn to clean sales data, explore trends, and expose predictions through a Django app for business users. It also underpins the data layer of my University Housing Management (FSBM) platform, where I designed and queried the MySQL schema powering student housing, payments, and admin reporting, the same SQL-first thinking this Career Path teaches, applied to a real production system rather than a classroom dataset.

Why this matters for employers

What makes this credential valuable to employers isn't the certificate itself; it's that it forces fluency in the two things every data-driven company runs on: SQL to pull the truth out of a database and Python/pandas to shape that truth into an answer. I write multi-table SQL queries against a production schema, clean and transform datasets with pandas, and package the result into an Excel or Tableau dashboard a non-technical stakeholder can act on without a walkthrough. Paired with my Spring Boot/React/MySQL and Django backend experience, that means I don't just build the system that generates the data; I can query it, analyze it, and report on it too: exactly the "full-stack plus analytics" profile mid-size teams and Moroccan tech employers look for when they can't yet justify a dedicated BI hire.

Verified certificate

Download the official certificate for this achievement.

  • business intelligence data analyst
  • BI data analyst certification
  • SQL for data analysis
  • Python data analyst skills
  • pandas data cleaning
  • Tableau dashboard developer
  • Excel business intelligence
  • data analyst portfolio Casablanca
  • full-stack data analyst Morocco

This certification is part of my Data & AI Engineer profile. All my credentials are on the certifications page.

Frequently asked questions

It's a beginner-level, project-based Career Path (18 units, roughly 50 hours, and 37 hands-on projects) covering SQL, Python, and pandas for data analysis plus Excel and Tableau for dashboards and reporting: the core toolkit of a working BI Data Analyst.

It's not a substitute for a university degree, but employers increasingly treat Codecademy Career Path certificates as verifiable proof of applied, hands-on skill, especially when paired with a visible project portfolio and GitHub history, which is how I present mine.

A BI Data Analyst queries existing data with SQL, cleans and analyzes it with Python/pandas, and communicates findings through dashboards and reports (Excel/Tableau) for business decisions. A Data Scientist leans more into statistical modeling and machine learning to predict outcomes.

At minimum: SQL for querying relational databases, Python with pandas for data cleaning and analysis, and Excel or Tableau for dashboarding. This Career Path covers all four, which is the standard combination requested in BI Data Analyst job postings.

Codecademy lists it at roughly 50 hours across 18 units and 37 hands-on projects, achievable part-time in about 2-3 months of consistent study.

Keep reading

All articles
Codecademy's Data Engineer Career Path: What It Actually Teaches
Data Engineering

Codecademy's Data Engineer Career Path: What It Actually Teaches

Codecademy's Data Engineer Career Path took me through Python, SQL, Pandas, PySpark, and MongoDB: the toolkit companies need to move data reliably from source to product, taught through graded, portfolio-grade projects rather than quizzes.

7 min read

Looking for someone with these skills?

I'm open to freelance projects, internships and full-time roles. Let's talk.