Data Analyst Foundation Track - Online Learning with Certificate

Data Analyst Foundation

Beginner

4.6

133 reviews

237 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

209

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

Discover how to navigate the Excel interface, use the Ribbon and Formula Bar, and enter data efficiently with AutoFill and Flash Fill. Build a solid foundation for working confidently in any spreadsheet.

Course Overview

Getting Acquainted with Excel

Excel Interface

Excel Data Entry

Explore Excel's formatting tools, including fonts, colors, currency, and custom number formats. Improve the clarity, readability, and appearance of your spreadsheets.

Excel Cell Formatting

Text Formatting in Excel

Number Formatting in Excel

Discover how to build Excel formulas using cell references and ranges, and apply core functions like SUM, AVERAGE, MIN, MAX, and COUNT with the Insert Function tool to automate everyday calculations.

Introduction to Formulas and Functions in Excel

Working with Excel Cell References

Essential Excel Functions

Using the Insert Function Tool in Excel

Master the skills needed to work with advanced Excel formulas, including IF, nested IF, AND, and OR functions. Apply conditional formatting and auditing tools to trace, evaluate, and troubleshoot complex calculations.

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

Build confidence in how to sort and filter data in Excel using AutoFilter and custom criteria, and organize it into structured, styled tables. Manage large datasets efficiently and pull out exactly the information you need.

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

Learn how to create and customize charts in Excel, from choosing the right chart type to editing series data, styles, colors, and trendlines. Turn raw numbers into clear, 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

Master adding, renaming, grouping, and rearranging worksheets, inserting or hiding rows and columns, and saving and opening workbooks safely. Protect your files with passwords and speed up your work with templates.

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

Discover how to retrieve single, multiple, and all columns from a table using the SQL SELECT statement. Learn to return distinct rows and limit the number of results returned by a query.

Challenge: Retrieving Individual Columns

Challenge: Retrieving Multiple Columns

Challenge: Retrieving All Columns

Challenge: Retrieving Distinct Rows

Challenge: 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

Discover how to organize query results using the ORDER BY clause. Learn to sort data by one or multiple columns and control the sort direction with ascending or descending order for clearer output.

Challenge: Sorting Data

Challenge: Population Sort

Challenge: Sorting by Multiple Columns

Challenge: Dual-Sort Query

Challenge: 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

Discover how to filter query results using the WHERE clause. Learn to test for equality and inequality, check values against a range, and identify NULL values in your data.

Challenge: Using the WHERE Clause

Challenge: North America Population Sort

Challenge: The WHERE Clause Operators

Challenge: Population Threshold Query

Challenge: Checking for a Range of Values

Challenge: Checking for No Value

Discover how to refine your search conditions by combining WHERE clauses with the AND and OR operators. Learn to use the NOT operator to exclude specific results from your query.

Challenge: Using the AND Operator

Challenge: Europe Region Sort

Challenge: Using the OR Operator

Challenge: America Regions Filter

Challenge: Using the NOT Operator

Challenge: Non-Europe Capitals Sort

Discover how to summarize table data using SQL aggregate functions. Learn to calculate averages and totals with AVG and SUM, count rows with COUNT, and find extremes with MAX and MIN.

Challenge: The AVG() Function

Challenge: Surface Area Selection

Challenge: Large Surface Area Average

Challenge: The COUNT() Function

Challenge: Continental Count

Challenge: The MAX() Function

Challenge: The MIN() Function

Challenge: The SUM() Function

Discover how to group data with the GROUP BY clause and summarize it using aggregate functions like COUNT, SUM, and AVG. Learn to filter grouped results with the HAVING clause and apply the correct order of SQL clauses in a query.

Challenge: GROUP BY Clause

Challenge: Order of Statements

Challenge: Total Ride Time for Each Subway Line

Challenge: Average Student's Grade

Challenge: Searching for the Top Math Students

Challenge: HAVING Clause

Challenge: Several Aggregate Functions in the Query

Challenge: More Complex Filtering

Discover how to write nested subqueries in WHERE and FROM clauses to answer more complex questions. Learn to combine query results from multiple tables using the UNION clause.

Nested Queries

Challenge: Non-tech Department Employees

Challenge: Using Inner Subqueries in the FROM Section

Challenge: Employees with More than Average Salary

UNION Clause

Challenge: Combining Table Results

Learn the secrets of combining multiple tables using INNER, LEFT, RIGHT, and FULL JOIN types. Practice writing joins that let you query related data across tables as a single unified result.

Challenge: JOIN 2 Tables

Challenge: Get Category by Product Price

Challenge: Get Minimum Price by Category

Challenge: Get Product Amount by Category

Challenge: LEFT, RIGHT and INNER JOINs

Challenge: Table Join

Challenge: FULL JOIN Usage

Explore the essentials of DDL and DML in SQL, from creating tables with CREATE and constraints to modifying them with ALTER, DROP, and TRUNCATE. Learn to insert, update, and delete records using INSERT, UPDATE, and DELETE statements.

Challenge: CREATE and Constraints

Challenge: ALTER and INSERT Operations

DROP and TRUNCATE

Challenge: 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

TEST E2E PROGRESS SQL

Description

test sql course e2e new task ui

TEST SQL COURSE E2E

This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.

Excel Beginner Course (copy) 1779794555568

Unlock the power of Excel for data analysis! In this course, you will acquire the essential skills and knowledge needed to harness Excel's full potential as a data analysis tool. From mastering formulas and functions to visualizing data with charts and graphs, you'll gain the expertise to confidently navigate Excel's features. Whether you're a beginner or looking to enhance your existing Excel skills, this course will equip you with the tools to excel in data analysis. Join us and take your data manipulation and interpretation abilities to the next level.

Introduction to SQL

This course offers an easy-to-follow introduction to the basics of SQL databases and the Structured Query Language (SQL). Through engaging video lessons and thoughtfully crafted exercises, you’ll explore essential concepts step by step. Each topic is explained in detail and paired with hands-on practice to ensure you not only understand but also retain what you’ve learned.

Excel Formulas Foundations

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.

QNA TEST COURSE

TEST QNA COURSE FOR TESTING CHAT IMPROVEMENTS

Excel Adventure

Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.

Excel Beginner Course

Excel for Beginners

Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

grid excel

test test

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.

Discover more Learning Tracks

track

Complete Claude Ecosystem

3 Courses

53 Tasks

Beginner

track

AI Toolkit for Business

4 Courses

75 Tasks

Beginner

track

AI-Assisted Web Developer

6 Courses

64 Tasks

Beginner

track

Business Intelligence Specialist

Intermediate

Python from Zero to Hero

7 Courses

3 Projects

133 Tasks

Beginner

new

track

Python for Data Science

5 Courses

3 Projects

167 Tasks

Beginner

new

track

Java Foundations

Beginner

C++ Developer

Intermediate

Python Programming for Beginners

Beginner

Supervised Learning Foundations

6 Courses

3 Projects

91 Tasks

Beginner

new

track

Backend Development with Node.js and Express.js

5 Courses

61 Tasks

Beginner

new

track

TEST TEST TRACK

0 Task

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.

Chosen 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

Complete Claude Ecosystem

AI Toolkit for Business

AI-Assisted Web Developer

Business Intelligence Specialist

Python from Zero to Hero

Python for Data Science

Java Foundations

C++ Developer

Python Programming for Beginners

Supervised Learning Foundations

Backend Development with Node.js and Express.js

TEST TEST TRACK

Why People Choose Codefinity

Chosen 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

Chosen by Employees of Leading Companies
and Students from Top Universities