Data Analyst Foundation Track - Online Learning with Certificate

Data Analyst Foundation

Beginner

4.6

4040 reviews

56k+ Learners

This track equips you with essential skills and technologies for data analysis. Starting with Excel, you'll learn data organization, manipulation, and…

135

Chapters

Learning hours

124

Assignments

AI Assistant

Shareable Certificate

Outcomes

Track content

Related courses and projects

Testimonials

Features

Pricing

Outcomes

Track content

Related courses and projects

Testimonials

Features

Pricing

What you will learn

You will learn how to efficiently organize, analyze, and visualize data using Excel, mastering essential spreadsheet skills.

You will be able to combine your Excel, SQL, and Power BI skills to analyze data from multiple sources and present comprehensive insights.

You will gain the ability to write and optimize SQL queries to manage and extract insights from databases.

You will understand how to create powerful, interactive reports and dashboards using Power BI to present data-driven decisions.

Learning track content

Kickstart your journey with Excel by understanding its interface, basic functions, and essential data entry techniques. Learn how to navigate toolbars, worksheets, and master the fundamental elements to set a solid foundation.

Course Overview

Getting Acquainted with Excel

Excel Interface

Excel Data Entry

Dive deeper into Excel by exploring advanced data entry and formatting options. Sharpen your skills in text and number formatting, discover how to effectively use styles, and enhance spreadsheet readability and functionality.

Excel Cell Formatting

Text Formatting in Excel

Number Formatting in Excel

Unleash the power of Excel with an introduction to basic formulas and functions. Gain confidence in creating calculations, using cell references, and employing key functions like SUM, AVERAGE, MIN and MAX to automate and simplify your data analysis tasks.

Introduction to Formulas and Functions in Excel

Working with Excel Cell References

Essential Excel Functions

Using the Insert Function Tool in Excel

In this section, you will master advanced Excel formulas and functions, enhancing your ability to manage complex calculations. Learn to display and audit formulas, utilize nested and logical statements, and apply conditions effectively to streamline your data analysis tasks.

Displaying and Highlighting Excel Formulas

Mastering IF Logical Tests and Relational Operators in Excel

Using Nested IF Statements

Combining AND & OR in Excel

Auditing Excel Tools

Excel Conditional Formatting

Explore comprehensive techniques for sorting, filtering, and managing data efficiently. This section covers everything from basic data organization to advanced filtering and table management, ensuring you can handle and analyze data effectively.

Sorting Data in Excel

Filtering Data Using AutoFilter

Clearing and Reapplying Filters in Excel

Excel Rules and Advanced Search Techniques

Creating and Managing Tables in Excel

Excel Table Styles and Quick Formatting

Using Excel Table Tools

Dive into the art of data visualization using Excel's powerful charting tools. You'll learn to create various types of charts, customize them to enhance visual appeal, and manipulate data within charts to present clear and compelling visual stories.

Excel Chart Types

Creating a Basic Chart in Excel

Customizing Excel Chart Elements

Changing Chart Styles and Colors in Excel

Adding and Removing Chart Elements

Editing Chart Data in Excel

Adding Trendlines to Excel Charts

Gain proficiency in managing worksheets and workbooks within Excel. This section teaches you how to effectively organize and manipulate workbook elements, utilize formatting tools, and secure your work with passwords, providing a thorough grounding in workbook operations.

Managing Excel Worksheets: Add, Delete, Rename, and Rearrange

Grouping and Ungrouping Worksheets in Excel

Using the Format Painter in Excel

Inserting and Deleting Columns, Rows, and Cells in Excel

Hiding and Unhiding Columns and Rows in Excel

Saving Workbooks in Excel

Opening and Closing Workbooks

Protecting Excel Workbooks with Passwords

Using Excel Templates

Summary

In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Challenge: Find the Population of the Countries

Challenge: Find All Countries

Challenge: Find All Countries With Their IDs

Challenge: Find Country Capitals

Challenge: Find the Regions in Which All Countries Are Located

In this section, we’ll explore how to organize and prioritize the data returned by a query using the ORDER BY clause. Placed at the end of a SELECT statement, this clause lets you sort your results by one or multiple columns, either in ascending or descending order, enabling more meaningful and easily interpretable data output.

Sorting Data

Challenge: Population Sort

Sorting by Multiple Columns

Challenge: Dual-Sort Query

Specifying Sort Direction

Challenge: Sort the Countries by Region and Capital

Challenge: Sort Capitals in Descending Order

Challenge: Sort Countries in Ascending Order

Challenge: Find Countries, Their IDs, and Their Populations

Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Challenge: Find All Continents and Sort Them in Ascending Order

In this section, we will learn how to filter returned data using the SELECT statement's WHERE clause. We will learn how to test for equality, inequality, more and less significant than value ranges, and NULL values.

Using the WHERE Clause

Challenge: North America Population Sort

The WHERE Clause Operators

Challenge: Population Threshold Query

Checking for a Range of Values

Checking for NO Value

In this section, we’ll explore how to refine your search conditions by combining WHERE clauses with the AND and OR operators. We’ll also cover how the NOT operator can be used to exclude certain results.

Using the AND Operator

Challenge: Europe Region Sort

Using the OR operator

Challenge: America Regions Filter

Using the NOT Operator

Challenge: Non-Europe Capitals Sort

In this section, we will learn what the SQL aggregate functions are and how to use them to summarize table data.

The AVG() Function

Challenge: Surface Area Selection

The COUNT() Function

Challenge: Continental Count

The MAX() Function

The MIN() Function

Challenge: Large Surface Area Average

The SUM() Function

In this section, you will learn how to group and manage data effectively. We will introduce the GROUP BY operator for grouping data. Additionally, you will learn how to filter grouped data using the HAVING operator.

GROUP BY Clause

Order of Statements

Challenge: Total Ride Time for Each Subway Line

Challenge: Average Student's Grade

Searching for the Top Math Students Challenge

HAVING Clause

Several Aggregate Functions in the Query

More Complex Filtering

You will learn about nested subqueries, how to create them, and how to use them effectively.

Nested Queries

Challenge: Non-tech Department Employees

Using Inner Subqueries in the FROM Section

Challenge: Employees With More Than Average Salary

UNION Clause

Challenge: Combining Table Results

Here, you will learn how to combine multiple tables, allowing you to work with a unified table and simplify query creation.

JOIN 2 Tables

Challenge: Get Category By Product Price

Challenge: Get Minimum Price By Category

Challenge: Get Product Amount By Category

LEFT, RIGHT and INNER JOINs

Challenge: Table Join

Challenge: FULL JOIN Usage

Learn the fundamentals of Data Definition Language (DDL) and Data Manipulation Language (DML) in SQL, including how to create, modify, and delete database objects, as well as how to insert, update, and delete data within tables.

CREATE and Constraints

ALTER and INSERT Operations

DROP and TRUNCATE

UPDATE and DELETE

Dive into the world of Power BI and build a solid foundation. You'll cover everything from installation and setup to connecting data sources and creating your first report.

What is Power BI?

Installation and Setup

Overview of Power BI

Connecting to Data Sources

Basics of Power Query

Creating Your First Report

Explore essential data preparation techniques, including cleaning, transforming, and combining multiple data sources. You'll also tackle handling missing values, data profiling, and various data manipulation methods.

Data Cleaning and Transformation

Data Profiling and Exploration

Handling Missing Values

Creating Columns

Handling Multiple Data Sources

Appending and Merging Data

Pivoting Data

Master the fundamentals of data modeling, from understanding data models and creating relationships to getting the hang of DAX basics. You'll also learn to create measures and calculated columns.

Introduction to Data Models

Creating Relationships

DAX (Data Analysis Expressions) Basics

Measures, Quick Measures, and Calculated Columns

Discover various visualization techniques and customize visuals for better insights. You'll also explore advanced features like slicers, filters, and drill-down/drill-through capabilities to enhance your data analysis.

Creating Visualizations

Map and Tool Tips

Slicers and Filters

Drilldown and Hierarchies

Boost the usability and storytelling power of your reports by using themes, configuring report pages, and leveraging advanced features like the Analyze feature and identifying outliers. You'll also create groups, bins, and clusters for deeper insights.

Using Themes

Configuring Report Page

Using Shapes and Buttons

Creating Groups and Bins

Analyzing Features

Finding Anomalies

Boost your Tech Skills!

with up to 55% off

Features:

*Tracks not included in Pro plan

500+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks40+ hands-on real-world projects

Without cancellation, before the selected discounted intro plan ends, I accept that Codefinity will automatically charge $104 every 3 months until I cancel. Learn more about cancellation and refund policy in Subscription Terms.

Recommended Courses and Projects

Relational Database and Normalization

This course delves into the theory behind relational databases. You'll learn what they are and see how they differ from non-relational databases. Throughout the course, we'll walk you through the ins and outs of database design and familiarize you with various types of relationships. Additionally, you'll explore the concepts of normalization and normal forms, equipping you with the knowledge to craft efficient and optimized databases.

Excel Formulas

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

SQL Optimization and Query Features

Begin an exciting journey through SQL with Advanced Techniques in SQL. Learn about the important ACID properties that help keep data accurate in database transactions. Discover advanced ways to optimize your queries to improve database performance. Explore special SQL features like window functions, triggers, Data Control Language (DCL), and NoSQL databases. This will help you handle modern database management confidently and effectively.

Data Analysis with Excel

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Mastering Discounted Cash Flow Analysis with Excel

Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.

Introduction to Data Engineering with Azure

Master the essentials of data engineering with Microsoft Azure in this comprehensive course. Starting with foundational concepts like cloud computing, resource management, and storage solutions, you'll progress to hands-on training in Azure Data Factory (ADF), mastering ETL/ELT workflows, and advanced data transformations. Through practical examples and real-world problem-solving, you'll gain the skills to design, implement, and optimize scalable data solutions using Azure.

SQL Joins in Depth

Master the art of SQL joins with engaging, real-world examples and hands-on challenges. This course takes you from foundational join concepts to advanced multi-table queries, ensuring you can confidently analyze and combine data from multiple sources.

Functions in SQL

Master the use of built-in SQL functions to manipulate strings, dates, numbers, logical values, nulls, and JSON data. This course provides a hands-on approach to understanding and applying SQL functions in real-world scenarios, enhancing your data querying and transformation skills.

SQL for Data Analysis

A comprehensive beginner-friendly course designed to teach SQL from the ground up, focusing on practical data analysis skills. Through engaging explanations, real-world examples, and hands-on challenges, learners will master querying, transforming, and analyzing data using SQL.

Mastering CASE WHEN in SQL

A comprehensive course designed to help you master the CASE WHEN statement in SQL, from basic conditional logic to advanced use cases in data analysis and reporting. Through engaging theory and real-world tasks, you'll learn to write expressive, powerful queries that adapt to complex business requirements.

Window Functions in SQL

Master the art of analyzing data with SQL window functions. This course guides you through the core concepts, syntax, and practical applications of window functions, empowering you to perform advanced analytics and reporting directly in SQL.

SQL Data Types Explained

A beginner-friendly course that demystifies SQL data types, guiding you through their purpose, usage, and best practices. Learn how to choose the right data type for your data, avoid common pitfalls, and build robust, efficient databases.

Discover more Learning Tracks

track

Web Development with C#

Beginner

SQL from Zero to Hero

Beginner

С++ Essentials

Beginner

Game Development with Unity

Beginner

Become a React Developer

Intermediate

Full Stack Web Development

Beginner

Frontend Development Foundations

Beginner

Mastering Data Visualization

Intermediate

Machine Learning Mastery

Intermediate

C++ Mastery

Advanced

Java Web

Advanced

Become a QA Engineer

Beginner

Why People Choose Codefinity

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Step-by-Step to Stellar Results

Interactive coding environment

Jump into our interactive environment: write and run your code with real‑time feedback and success metrics—learn by doing at every step.

AI‑powered support

Leverage the built‑in AI assistant to explain errors, suggest fixes, or answer any question about your code—so you stay productive and never get stuck.

Check your progress

Wrap up each module with a quick quiz that delivers instant feedback, tracks your progress, and ensures you’ve mastered key concepts.

Promote your expertise

Earn your industry‑recognized certificate upon completion and share it on LinkedIn with one click—let your network see what you can do.

Trusted by Employees of Leading Companies
and Students from Top Universities

Full catalog access

One subscription opens up this course and our entire catalog of projects and skills.

Features:

500+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks40+ hands-on real-world projects

Try Codefinity with confidence – 30-day money-back guarantee included

To welcome you to Codefinity, we're offering up to 64% off on our courses. Plus, we have a 30-day money-back guarantee, so you can try us out risk-free.We truly look forward to welcoming you to our platform and are committed to making your learning experience easy, interactive, and fun.

Ready to get started?

Pro

Best intro offer

Ultimate

A complete experience
to kickstart your career

500+ Top-Rated courses

Completion certificates

Early access to new courses

40+ hands-on Real-world projects

Personalized study tracks

Unlimited workspaces

Instantly access 500+ courses

Unlimited Learning, Instant AccessGet full access to all courses and tracks, including video content, quizzes, and in-depth materials—start learning anytime.

Industry-Recognized CertificatesEarn certificates that validate your expertise and boost your career in tech, AI, data, marketing, and beyond.

AI-Assisted LearningGet personalized hints, real-time feedback, and AI-powered explanations to accelerate your progress.

Constantly Expanding: New Courses & Career TracksStay ahead with constantly updated courses, career roadmaps, challenges, and hands-on practice tests.

Build Skills That MatterMaster in-demand skills with courses in AI, data science, programming, marketing, automation, web development, and more.

Interactive & Seamless LearningEngage with hands-on projects, real-world exercises, and an intuitive learning experience — no extra tools needed.

What you will learn

Web Development with C#

SQL from Zero to Hero

С++ Essentials

Game Development with Unity

Become a React Developer

Full Stack Web Development

Frontend Development Foundations

Mastering Data Visualization

Machine Learning Mastery

C++ Mastery

Java Web

Become a QA Engineer

Why People Choose Codefinity

Trusted by Employees of Leading Companies and Students from Top Universities

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Instantly access 500+ courses

Trusted by Employees of Leading Companies
and Students from Top Universities