Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Data Analyst Foundation | Codefinity
dsa banner mobiledsa banner

Unsure where
to begin?

Track
Certificate

Data Analyst Foundation

4.8+
2192 reviews
Beginner
This track equips you with essential skills and technologies for data analysis. Starting with Excel, you'll learn data organization, manipulation, and visualization. Show more
Excel
SQL
Power BI
Boost your Tech Skills!
with up to 55% off
What you'll get with our subscription:
  • Access to 85+ top-rated coursesAccess to 85+ top-rated courses
  • AI-driven LearningAI-driven Learning
  • Workspaces for practicing your skillsWorkspaces for practicing your skills
  • Personalized study tracksPersonalized study tracks
  • Certificates of completionCertificates of completion
Training 2 or more people?
Get your team access to Codefinity courses anytime, anywhere.
Try Codefinity Teams
What you will learn
  • You will learn how to efficiently organize, analyze, and visualize data using Excel, mastering essential spreadsheet skills.
  • 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.
  • You will be able to combine your Excel, SQL, and Power BI skills to analyze data from multiple sources and present comprehensive insights.
  • chapters
    147 chapters
  • hours
    12 hours
  • tasks
    97 tasks
Trusted by employees of leading companies
GoogleIntelTwitterFedExMetaNikeAmazonMicrosoftTesla
Learning track content
Module 1 / Excel for Beginners
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.
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.
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.
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.
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.
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.
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.
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.
In this section, we will learn how to combine WHERE clauses with the AND and OR operators. We will also find out how the NOT operator works.\n\n\n
Module 3 / Intermediate SQL
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.
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.
Module 4 / Introduction to Power BI
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.
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.
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.
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.
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.
Requirements
  1. A computer with a browser - all browsers are supported.
  2. Your enthusiasm to enhance your tech skills.
  3. Everything else needed to start learning and practicing is already included in this course.
Over 200,000 5-star ratings and counting
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
Yuliana Cadavid
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides…
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Adrien Morel
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
Yuliana Cadavid
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides…
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Adrien Morel
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Certificate of Completion
Data Engineer
Certificate of Completion
Showcase your newly acquired skills. You've earned it
Become a Development expert
  • Interactive exercisesInteractive exercises
  • Learning videosLearning videos
  • AI-assistant on all coursesAI-assistant on all courses
  • Workspaces for designing your own projectsWorkspaces for designing your own projects

Ready to get started?

ProBest intro offer
UltimateA complete experience to kickstart your career
85+ Top-Rated coursesBenefit accessBenefit access
Completion certificatesBenefit accessBenefit access
AI-Copilot in all coursesBenefit accessBenefit access
20+ hands-on Real-world projectsBenefit accessBenefit access
Personalized study tracksBenefit accessBenefit access
Unlimited workspacesBenefit accessBenefit access
Boost your Tech Skills!
with up to 55% off
What you'll get with our subscription:
  • Access to 85+ top-rated coursesAccess to 85+ top-rated courses
  • AI-driven LearningAI-driven Learning
  • Workspaces for practicing your skillsWorkspaces for practicing your skills
  • Personalized study tracksPersonalized study tracks
  • Certificates of completionCertificates of completion
Training 2 or more people?
Get your team access to Codefinity courses anytime, anywhere.
Try Codefinity Teams
We're sorry to hear that something went wrong. What happened?
some-alt