View all Tracks
Build Your Data Analysis Skills and Portfolio
Every company collects data, but few people know how to turn it into answers. Data analysts find the patterns in the numbers and explain them so others can make better decisions. You don't need any coding experience to start.
This track follows the full Data Analysis curriculum. You'll start with Python basics: variables, loops, conditionals and data structures. You'll use them to clean up messy data and organize it into something useful.
Next, you'll learn the statistics behind analysis, like mean, median and standard deviation. You'll apply them to real datasets in spreadsheets and turn the results into charts. Then you'll query databases with SQL, and with SQLAlchemy you'll read, edit and analyze records stored in a database.
After that, you'll move into the tools analysts use every day. You'll use Pandas in JupyterLab to explore, combine and clean data from multiple sources. You'll build clear graphs with Matplotlib and Seaborn, and you'll pull data from APIs into your own analysis. Along the way, you'll practice data storytelling: presenting what you found so that other people understand it and can act on it.
Finally, you'll learn to use AI coding assistants. You'll prompt them, check their output and improve the code they generate.
By the end, you'll be able to take a real question, find and clean the data, analyze it and present the answer.
Start your journey as a data analyst with this Track!
Ready to start learning?
Treehouse offers a 7 day free trial for new students. Get access to 1000s of hours of content. Learn to code, land your dream job.
Start Your Free Trial
-
Course
- 1
- 2
Intro to Data Analysis
An introduction to the concepts, tools, and terms for data analysis.
-
Course
- 1
- 2
- 3
- 4
Python Basics
Learn the building blocks of the wonderful general purpose programming language Python.
-
1 minInstruction
How to Install Python
If you’d like to become a Python developer, installing Python onto your computer is one of the first steps. So far, you may have been working in an online Python editor, such as Treehouse Workspaces. In these workshops, we'll talk about why it’s beneficial to install Python. We'll also walk you through how to do so step by step....(continue reading)
Viewed -
1 minInstruction
Practice Python Basics
Programming, like any skill, requires practice. Watching a video can teach you a skill, but practicing can make it stick. Here are some workshops to help you practice the ideas and skills you learned in Python Basics....(continue reading)
Viewed -
Course
- 1
- 2
- 3
Introducing Lists
Lists are a powerful data type that allows you to store multiple ordered values in a single container. You are gonna love them.
-
2 minInstruction
How to Battle Imposter Syndrome
Recognize that everyone has doubts about their abilities, but this common feeling can be overcome by understanding that you'll never know everything, and studying, practice and building cool technology will help you become a better, more confident developer....(continue reading)
Viewed -
Course
- 1
Basic Math for Data Analysis
Basic math concepts learned through traditional schools may have been forgotten or not utilized for a long time. This workshop is to remind students how to calculate basic statistics and refresh their memory on terminology.
-
3 hoursInstruction
Project 1 - A Number Guessing Game
Build a console number guessing game that prompts a player to choose a number between a specified range of numbers....(continue reading)
Viewed -
Course
- 1
Introducing Tuples
Learn about a Python data structure that's similar to lists but with one key difference!
-
Course
- 1
- 2
- 3
Functions, Packing, and Unpacking
Learn the ins and outs of Python functions, how to send and receive values to functions, and all about Python packing and unpacking.
-
Course
- 1
- 2
Python Sequences
Discover several types of Python sequences, many ways of sequence iterations, and all of the common sequence operations.
-
Course
- 1
- 2
Introducing Dictionaries
Another useful Python data structure is the dictionary. Learn how to write one and use one in your day-to-day Python code.
-
95 minWorkshop
Python Sets
Dive into the basics of Python Sets! A set is an unordered collection of unique elements without duplicates. Elements are identified by membership rather than position. This workshop will introduce you to how to create and manipulate sets as well as how to perform common set operations.
Viewed -
13 minPractice
Practice Cleaning Data
Practice accessing data and cleaning it for use in other functions or programs.
Viewed -
4 minInstruction
Build a Learning Mindset
...(continue reading)
Viewed -
6 hoursInstruction
Project 2 - A Basketball Stats Tool
Build a console-based basketball team statistics tool to help you divide up a group of players into teams and then provide a team analysis....(continue reading)
Viewed -
Course
- 1
- 2
- 3
- 4
- 5
Spreadsheet Basics
A spreadsheet is an electronic document that arranges data in a table by using columns and rows. Among other things, spreadsheets let you store, manipulate, share and analyze data. They're used in business to help make complicated decisions like where to open a new restaurant location, where to build a wind farm, or where to expand a business' marketing efforts. Spreadsheets aren't just for business use either. A household expense spreadsheet can help you determine when you will be able to afford a new car or take your next trip. In this course, you'll learn the basics of spreadsheets including the parts of a spreadsheet, spreadsheet vocabulary, how to import data, how to make complex calculations, how to reference data in different cells, and how to use spreadsheet functions. You'll also learn best practices for formatting spreadsheets, protecting your data, and more, all using Google Sheets, which is free and very similar to Excel. When you're done you'll have built an entire spreadsheet complete with data, complex functions and formulas and colorful and meaningful formatting.
-
26 minWorkshop
Intermediate Spreadsheets
Are you ready to learn more about working with spreadsheets? This workshop will explore concepts such as conditional formatting, lookup functions, pivot tables, and error checking using Google Sheets. Expand your toolset as a data analyst and take your spreadsheet game to the next level!
Viewed -
42 minWorkshop
Data Visualization with Google Sheets
Did you know that Google Sheets is a great tool to tell stories with your data? This workshop will guide you through five different ways to visualize your data with Google Sheets and ultimately improve the story you're trying to tell to stakeholders!
Viewed -
10 hoursInstruction
Project 3 - Analyze Olympic Data
Analyze Olympic data from 1896-2016....(continue reading)
Viewed -
18 minWorkshop
Python Virtual Environments
If you're building apps with Python, you'll most likely be using third-party libraries and therefore need to use a virtual environment. This workshop will explain what Python virtual environments are. Then, you'll learn to use the venv tool to work with virtual environments, and how to install packages specific to your project. Finally, you'll learn how to replicate your virtual environments with others, such as fellow students, clients, or your development team. You will finish the workshop with a solid understanding of how to use virtual environments to maintain project dependencies and avoid conflicts with other Python projects.
Viewed -
Course
- 1
- 2
- 3
SQL Basics
In SQL Basics, we’ll take a look at what databases are and how you can retrieve information from them. Databases can store massive amounts of information to be retrieved at a later date. Databases act as the memory for dynamic web sites or mobile apps.
-
Course
- 1
- 2
- 3
- 4
Modifying Data with SQL
At the heart of a dynamic application is a database. Whether the application is an eCommerce, sports team, social network, or productivity app on your phone, the data needs to change over time. In this course, we'll take a look at the underpinning SQL statements that are needed for every dynamic application.
-
Course
- 1
- 2
SQLAlchemy Basics
Creating a SQL database including model creation and CRUD using SQLAlchemy.
-
Course
- 1
- 2
- 3
- 4
- 5
- 6
Querying Relational Databases
Building off of previous SQL courses, this course will begin to introduce the student to more complex database concepts. Students will learn to think about data as sets and subsets and practice achieving desired query results via such operations as inner and outer joins, unions and except. They will also be introduced to the concepts of Set Theory and Database Normalization to aid in understanding good query practices.
-
14 minWorkshop
CSV and JSON in Python
CSV and JSON files are two very common formats for storing and retrieving data. Both have great support in the Python language. Let's see how to take advantage of each of these file types.
Viewed -
42 minWorkshop
Relational Databases With SQLAlchemy
Learn how to interact with multiple tables through relationships using Python's SQLALchemy.
Viewed -
10 hoursInstruction
Project 4 - Grocery Store Inventory
Build a console application that loads existing inventory data from CSV files into a SQLite database using Python’s SQLAlchemy....(continue reading)
Viewed -
15 minWorkshop
Introduction to Anaconda
Learn why you want to use Anaconda, and then learn how
Viewed -
15 minWorkshop
Jupyter Notebooks
The Jupyter project has an amazing tool for Python, Julia, R, and other languages. Learn how to install Jupyter Notebooks, use them, and install kernels for other languages.
Viewed -
Course
- 1
- 2
- 3
Introduction to NumPy
NumPy is short for Numerical Python. It is the fundamental package for scientific computing. You will see it at play in just about everywhere Python needs to deal with data. This course gives a gentle introduction to the powerful library.
-
Course
- 1
- 2
Introduction to pandas
Pandas provides fast, flexible, and expressive data structures that have been designed to make working with relational or “labeled” data not only easy, but also intuitive. It’s the fundamental high-level building block for doing practical and real-world data analysis in Python.
-
33 minWorkshop
Analyzing Books with Pandas
Walkthrough an analysis of books using Python's Pandas.
Viewed -
8 hoursInstruction
Project 5 - Pet Shelter Analysis
Analyze pet shelter data using Python's pandas library to uncover insights and answer stakeholder questions....(continue reading)
Viewed -
Course
- 1
Basic Statistics for Data Analysis
Basic statistics concepts learned through traditional schools may have been forgotten or not utilized for a long time. This course is to remind students how to calculate basic statistics, solidify understanding of the terminology, and determine which graphs might be most useful in displaying data.
-
Course
- 1
- 2
- 3
Introduction to Data Visualization with Matplotlib
Get started creating charts with the Python library, matplotlib, an industry-standard data visualization library. Matplotlib provides a way to easily generate a wide variety of plots and charts in a few lines of Python code. It is an open-source project that can be integrated into Python scripts, jupyter notebooks, web application servers, and multiple GUI toolkits. Whether you are exploring sample data available on the internet, or your own business data, learning matplotlib is a great place to start your data visualization journey.
-
Course
- 1
- 2
- 3
- 4
Data Visualization Foundations
What is data visualization? A simple answer might be something like the graphic representation of data. But to get a better understanding of what practitioners of data visualization do, let’s start with the term data. By data, I mean raw, unorganized facts and numbers. Practitioners of data visualization take raw, hard-to-grasp data and turn that data into information by providing context and a purpose.
-
Course
- 1
- 2
- 3
Intro to Seaborn
The Seaborn module is a Python visualization library based on Matplotlib. It provides a higher-level, more convenient way to create common statistical plots and is well-suited for labeling and presenting statistical graphics. This course will help you get started with Seaborn by walking through the structure of its library, showing how to create key charts in Seaborn, and comparing the results with equivalent plots created with Matplotlib.
-
6 hoursInstruction
Project 6 - Graphing Video Game Sales
Analyze video game sales data to uncover trends and insights that could help inform business decisions....(continue reading)
Viewed -
45 minWorkshop
Combining Data for Analysis
In this workshop, students are introduced to common methods used to combine multiple datasets, specifically merge and concatenation. Students will use Pandas, a powerful data analysis tool built on top of Python. After completion, students are equipped to combine datasets for further analysis and manipulation.
Viewed -
Course
- 1
Regular Expressions in Python
Regular expressions are one of the tools that every programmer needs, but is often scared of. In this course, we'll explore the re module that Python provides and learn to write regular expressions for many different situations.
-
Course
- 1
- 2
Preparing Data for Analysis
Learn how to clean and prep data for analysis using spreadsheet tools and Python's Pandas.
-
8 hoursInstruction
Project 7 - Musical Analysis
Prepare and analyze Spotify song data by combining multiple CSV files into a single dataset using Python's pandas library....(continue reading)
Viewed -
Course
- 1
- 2
- 3
- 4
Python Dates and Times
As a Python developer, you will inevitably come across the need to use dates and times in your projects. This course will teach you how to use Python to work with dates and times. You will learn how to manipulate and format dates, calculate time differences, and explore the built-in datetime module. By the end of this course, you will have a solid understanding of how to handle dates and times in Python for a variety of applications. Throughout this course, we'll work together to build a simple app that will utilize this new concept and solidify your understanding.
-
Course
- 1
Introduction to REST APIs
Many of the APIs you'll encounter on the Web use an underlying design idea known as REST, which stands for Representational State Transfer. Understanding what and how a REST API provides will help you build better and stronger APIs for your users.
-
33 minWorkshop
Data from APIs
Use Python to gather data from an API and save it to a CSV file.
Viewed -
16 minWorkshop
Presenting an Analysis
Learn the fundamentals for creating a presentation to highlight your analysis for stakeholders.
Viewed -
6 hoursInstruction
Project 8 - Movie API Analysis
Gather data on 10 Best Picture Oscar-winning movies using a movie API, analyze the information in JupyterLab, and create a presentation to share your findings....(continue reading)
Viewed -
Course
- 1
Introducing Large Language Models
Large Language Models like ChatGPT are rapidly transforming natural language processing and shaping the future of technology. In this microcourse, learn more about this fascinating type of machine learning model specifically trained to understand and generate natural language text. This microcourse was written with the help of ChatGPT. The video was produced using Synthesia, an AI video creation platform.
-
2 minWorkshop
What Is AI? What Is ChatGPT?
In this video, we explore the fascinating world of AI and introduce ChatGPT, a language model designed to understand and respond to human language. Join Dustin as he dives into the basics of artificial intelligence and learn how ChatGPT is transforming the way we interact with technology.
Viewed -
8 minWorkshop
ChatGPT for Beginners
Are you curious about ChatGPT, the advanced language model that can engage in conversation? In this beginner-friendly video, we introduce you to the fascinating world of ChatGPT. Whether you're a developer, a language enthusiast, or just someone intrigued by AI, this video is the perfect starting point. If you've ever wondered how to interact with ChatGPT and harness its power, we've got you covered. You'll learn how to formulate questions, handle responses, and create engaging conversations with this cutting-edge technology.
Viewed -
14 minWorkshop
Debugging with ChatGPT
Join me in this exciting video as we harness the power of ChatGPT, the AI coding assistant, to debug our code. Discover how AI can revolutionize your debugging process and help you squash those pesky bugs in record time! Whether you're a seasoned developer or just starting out, this video showcases the potential of AI-driven debugging.
Viewed -
29 minWorkshop
No-Code Prompt Engineering
Explore prompt engineering for no code development by enhancing your AI coding skills in this interactive workshop. Learn to craft clear, powerful prompts that enable AI tools to work smarter and faster, transforming your no code development process. Whether you're new to AI or already coding, you'll discover actionable strategies to streamline your workflow, solve challenges more efficiently, and achieve superior results from every prompt. Join us for a hands-on experience that will elevate your AI coding game and empower your no code projects.
Viewed -
2 minInstruction
Explore Popular AI Tools for Developers
Explore different AI tools that can assist your coding journey, whether through conversational help or automated code support....(continue reading)
Viewed -
4 minWorkshop
Meet Cursor and Experience AI-Driven Coding
This workshop explores Cursor, an AI-powered code editor designed to make coding more efficient and intuitive. You’ll learn how it helps with code suggestions, completions, error detection, and even running terminal commands—all within your workflow. It’s a practical session for developers looking to write cleaner code with less friction.
Viewed -
5 minWorkshop
Create Apps Faster with Windsurf
In this workshop, Christian walks through Windsurf, an AI-powered coding tool built with Codeium. It’s a look at how AI can help automate parts of the development process and make building a bit smoother. Whether you’re experienced or just curious about where coding is headed, this gives you a real glimpse into how tools like Windsurf are starting to shape the future of software development.
Viewed -
18 minWorkshop
Introduction to GitHub Copilot
This workshop explores the capabilities of GitHub Copilot, a powerful coding tool. It demonstrates how Copilot assists developers in various scenarios, such as code completion, debugging, and documentation. Furthermore, students will learn how to use Copilot to enhance their coding productivity and efficiency.
Viewed -
10 hoursInstruction
Project 9 - Grocery Store Inventory (AI-Assisted Rebuild)
Prompt an AI coding assistant of your choosing to build a console application that loads existing inventory data from CSV files into a SQLite database using Python’s SQLAlchemy....(continue reading)
Viewed -
60 minExam
Data Analysis Final Exam
Data Analysis Final Exam
-
Track Completion
This track includes:
- Intro to Data Analysis 16 min
- Python Basics 3 hours
- How to Install Python 1 min
- Practice Python Basics 1 min
- Introducing Lists 105 min
- How to Battle Imposter Syndrome 2 min
- Basic Math for Data Analysis 25 min
- Project 1 - A Number Guessing Game 3 hours
- Introducing Tuples 13 min
- Functions, Packing, and Unpacking 65 min
- Python Sequences 65 min
- Introducing Dictionaries 36 min
- Python Sets 95 min
- Practice Cleaning Data 13 min
- Build a Learning Mindset 4 min
- Project 2 - A Basketball Stats Tool 6 hours
- Spreadsheet Basics 2 hours
- Intermediate Spreadsheets 26 min
- Data Visualization with Google Sheets 42 min
- Project 3 - Analyze Olympic Data 10 hours
- Python Virtual Environments 18 min
- SQL Basics 2 hours
- Modifying Data with SQL 79 min
- SQLAlchemy Basics 3 hours
- Querying Relational Databases 2 hours
- CSV and JSON in Python 14 min
- Relational Databases With SQLAlchemy 42 min
- Project 4 - Grocery Store Inventory 10 hours
- Introduction to Anaconda 15 min
- Jupyter Notebooks 15 min
- Introduction to NumPy 2 hours
- Introduction to pandas 3 hours
- Analyzing Books with Pandas 33 min
- Project 5 - Pet Shelter Analysis 8 hours
- Basic Statistics for Data Analysis 22 min
- Introduction to Data Visualization with Matplotlib 75 min
- Data Visualization Foundations 76 min
- Intro to Seaborn 76 min
- Project 6 - Graphing Video Game Sales 6 hours
- Combining Data for Analysis 45 min
- Regular Expressions in Python 110 min
- Preparing Data for Analysis 79 min
- Project 7 - Musical Analysis 8 hours
- Python Dates and Times 2 hours
- Introduction to REST APIs 30 min
- Data from APIs 33 min
- Presenting an Analysis 16 min
- Project 8 - Movie API Analysis 6 hours
- Introducing Large Language Models 20 min
- What Is AI? What Is ChatGPT? 2 min
- ChatGPT for Beginners 8 min
- Debugging with ChatGPT 14 min
- No-Code Prompt Engineering 29 min
- Explore Popular AI Tools for Developers 2 min
- Meet Cursor and Experience AI-Driven Coding 4 min
- Create Apps Faster with Windsurf 5 min
- Introduction to GitHub Copilot 18 min
- Project 9 - Grocery Store Inventory (AI-Assisted Rebuild) 10 hours
- Data Analysis Final Exam 60 min