Data Analyst Bootcamp
This bootcamp provides a comprehensive introduction to the field of data analysis. You will learn to use essential tools like SQL, Excel, Tableau, Power BI, and Python to clean, analyze, and visualize data. The curriculum is project-based, designed to build a portfolio and prepare you for a data analyst role.
What you’ll learn
- Write SQL queries to extract, clean, and analyze data from databases
- Build dashboards and reports using Excel, Tableau, and Power BI
- Use Python with the Pandas library to manipulate and visualize complex datasets
- Complete multiple guided projects to build a professional data analyst portfolio
- Gain foundational knowledge of cloud data services in Azure and AWS
- Prepare for job applications with resume guidance and interview practice
Inside the course
10 milestones, 84 lessons. Every lesson comes with hands-on tasks and active-recall checks — you practise it, not just watch it.
- 1
Introduction to Data Analysis
Begin your journey by understanding the structure of this data analyst bootcamp and the overall career path for a data analyst.
- The Path to Becoming a Data Analyst
- 2
SQL for Data Analysis
Learn the fundamentals of database management and querying with SQL. Start with installation and basic statements, progress to advanced techniques like joins and window functions, and apply your skills in data cleaning and exploratory analysis projects.
- Installing MySQL and Creating Databases
- Using the Select Statement in MySQL
- Using the Where Clause in MySQL
- Using Group By and Order By in MySQL
- Comparing Having vs. Where in MySQL
- Using Limit and Aliasing in MySQL
- Performing Joins in MySQL
- Using Unions in MySQL
- Using String Functions in MySQL
- Using Case Statements in MySQL
- Writing Subqueries in MySQL
- Using Window Functions in MySQL
- Using Common Table Expressions (CTEs) in MySQL
- Creating Temp Tables in MySQL
- Creating Stored Procedures in MySQL
- Using Triggers and Events in MySQL
- Project: Data Cleaning in MySQL
- Project: Exploratory Data Analysis in MySQL
- Data Analyst Bootcamp Overview
- 3
Data Analysis with Excel
Master essential Excel skills for data analysis. You'll work with pivot tables, formulas, and advanced lookups, and learn techniques for data cleaning, conditional formatting, and creating effective charts, culminating in a complete project.
- Creating Pivot Tables in Excel
- Using Formulas in Excel
- Using XLOOKUP in Excel
- Applying Conditional Formatting in Excel
- Creating Charts in Excel
- Techniques for Cleaning Data in Excel
- Full Data Analysis Project in Excel
- 4
Data Visualization with Tableau
Develop your data visualization capabilities using Tableau. This section covers installation, creating calculated fields, building various visualizations, and joining data sources to build a comprehensive beginner project.
- Installing Tableau and Creating a Visualization
- Using Calculated Fields and Bins in Tableau
- Creating Visualizations in Tableau
- Using Joins in Tableau
- Full Beginner Project in Tableau
- 5
Business Intelligence with Power BI
Dive into Microsoft Power BI to transform raw data into actionable insights. Explore Power Query for data transformation, manage data relationships, use DAX for calculations, and build a full guided project with powerful visualizations.
- Installing Power BI and Building a Visualization
- Using Power Query in Power BI
- Creating and Managing Relationships in Power BI
- Using DAX in Power BI
- Using Drill Down in Power BI
- Applying Conditional Formatting in Power BI
- Using Bins and Lists in Power BI
- Creating Popular Visualizations in Power BI
- Full Guided Project in Power BI
- 6
Python Fundamentals for Data Analysis
Build a strong foundation in Python programming for data analysis. You'll cover core concepts from variables and data types to loops and functions, then apply them to build your first two Python projects.
- Installing Jupyter Notebooks with Anaconda
- Understanding Variables in Python
- Working with Data Types in Python
- Comparison, Logical, and Membership Operators in Python
- Using If/Else Statements in Python
- Using For Loops in Python
- Using While Loops in Python
- Creating Functions in Python
- Converting Data Types in Python
- Project: Building a BMI Calculator with Python
- Project: Building an Automated File Sorter with Python
- 7
Data Acquisition and Manipulation with Python
Use Python's powerful libraries to acquire and manipulate data. Learn web scraping techniques to gather data from websites, then use the Pandas library for in-depth data cleaning, transformation, and exploratory analysis, culminating in portfolio-ready projects.
- Inspecting Web Pages with HTML for Web Scraping
- Web Scraping with BeautifulSoup and Requests
- Using find() and find_all() in BeautifulSoup
- Project: Scraping Data from a Real Website
- Reading Files in Pandas
- Filtering Columns and Rows in Pandas
- Working with Indexes in Pandas
- Using Group By and Aggregate Functions in Pandas
- Merging DataFrames in Pandas
- Creating Visualizations with the Pandas Library
- Project: Data Cleaning in Pandas
- Project: Exploratory Data Analysis in Pandas
- Portfolio Project: Amazon Web Scraping Using Python
- Portfolio Project: Automating Crypto Website API Pulls
- 8
Career Development and Portfolio
Prepare for the job market by building your professional presence and honing your interview skills. Create a portfolio website, craft the perfect resume, and practice solving SQL interview questions of increasing difficulty.
- Creating a Data Analyst Portfolio Website
- Crafting the Perfect Data Analyst Resume
- Solving Easy SQL Interview Questions
- Solving Medium SQL Interview Questions
- Solving Hard SQL Interview Questions
- Solving Very Hard SQL Interview Questions
- 9
Cloud Data Fundamentals
Gain an introduction to essential cloud data services on both Azure and AWS. You will learn about data storage, database management, data integration, and analytics tools in the cloud, providing a foundation in modern data architecture.
- Azure Account Setup and Free Credits
- Using Blob Storage and Storage Accounts in Azure
- Using Azure SQL Databases
- Getting Started with Azure Data Factory
- Getting Started with Azure Synapse Analytics
- AWS Account Setup and UI Walkthrough
- Using S3 Storage in AWS
- Using Amazon Athena in AWS
- Using AWS Glue DataBrew and Glue
- Using AWS Quicksight
- 10
Final Steps and Certification
Complete your bootcamp journey with final career advice. Learn how to leverage LinkedIn for job searching and find out how to receive your data analyst bootcamp certification.
- Using LinkedIn to Land a Job
- Downloading Your Bootcamp Certification
Start learning today
One payment, yours for good. Sign in with the email you check out with and the course unlocks automatically.
Browse all courses