Data Analytics courses

Conducting A/B Test

2 hours

14 chapters

Intermediate

In the world of business, making decisions based on hard data rather than intuition can be the key to success. This course focuses on one crucial technique: analyzing A/B test data. The centerpiece of the course is a project where you'll conduct a detailed analysis of an A/B test. This project, which you can showcase in your CV, is hosted on Codefinity, allowing you to continually refine it and demonstrate your growing expertise.

View details

Data Analysis with Excel

2 hours

15 chapters

Intermediate

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.

View details

Excel for Beginners

4 hours

49 chapters

Beginner

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.

View details

Intermediate SQL

3 hours

25 chapters

Intermediate

This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.

View details

Pandas First Steps

4 hours

34 chapters

Intermediate

Pandas is an extremely user-friendly library for data analysis. It's also designed to handle large datasets, using data structures like DataFrame and Series. This makes it an invaluable tool for Data Science. In this guide, you'll get acquainted with a range of statistical functions, including how to find correlations, modes, medians, and maximum and minimum values within a dataset. You'll also learn how to handle missing values and manipulate specific values, as well as how to remove them.

View details

Excel Formulas

1 hour

15 chapters

Beginner

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

View details

Conducting Exploratory Data Analysis of Nobel Prizes

1 hour

6 chapters

Intermediate

We will delve into the concept of Exploratory Data Analysis (EDA) and explore its critical role within every Data Analysis process, particularly focusing on the analysis of Nobel Prizes. EDA serves as a foundational step that enables data scientists and analysts to uncover patterns, anomalies, and insights from data through visual and statistical methods.

View details

Introduction to Power BI

3 hours

32 chapters

Beginner

Power BI is an essential tool for any aspiring data analyst or business professional. Learn how to transform raw data into insightful visualizations and interactive dashboards, connect to various data sources, and create compelling reports for informed decision-making.

View details

Excel for Finance

3 hours

22 chapters

Intermediate

This advanced course will guide you from preparing raw data for analysis to building an automated dashboard. You will learn how to calculate the Profits & Losses for a small business, "The Artisan Bakery". Dive deep into the essentials of business analytics with practical, real-world applications and transform data into insightful, actionable outcomes.

View details

Extracting Text Meaning using TF-IDF

2 hours

12 chapters

Intermediate

This project focuses on the design and implementation of a robust text summarizer, built using Python. By harnessing the capabilities of Python’s Natural Language Toolkit (NLTK), participants will gain hands-on experience in processing and analyzing textual data. The project covers a range of NLP techniques essential for text summarization. Participants will develop skills in parsing text and extracting meaningful content, learning how to filter essential information from large volumes of text.

View details

Python Loops Tutorial

2 hours

22 chapters

Beginner

Python provides three ways for executing the loops. While all the ways provide similar basic functionality, they differ in their syntax and condition checking time. Today we start learning these loops. Welcome to Python Loops Tutorial!

View details

Advanced Techniques in pandas

8 hours

66 chapters

Intermediate

This course contains a lot of useful functions for a future data analyst. You will learn different ways of extracting data and even set conditions on it. After it, you will be familiar with the methods of grouping data. Also, you will learn how to preprocess data. Each section has its data set so that the course will be gripping.

View details

Ultimate NumPy

4 hours

28 chapters

Intermediate

Unlock the full potential of Python's most essential library for numerical computing, NumPy. This comprehensive course is designed to take you from a beginner's understanding to an advanced level of proficiency in NumPy. Whether you're a data scientist, engineer, researcher, or developer, mastering NumPy is essential for efficient data manipulation, scientific computing, and machine learning.

View details

Business Analysis Fundamentals

2 hours

18 chapters

Beginner

Navigating the intricacies of Business Analysis is a transformative journey that unveils the dynamic intersection of strategy, technology, and organizational objectives. Delve into the heart of this discipline, where professionals craft solutions, facilitate change and bridge the gap between business needs and IT capabilities.

View details

Identifying the Most Frequent Words in Text

1 hour

11 chapters

Beginner

In this project, we will be utilizing the capabilities of the Natural Language Toolkit (NLTK), a versatile and comprehensive library in Python designed for working with human language data. Our focus will encompass several core areas of natural language processing: tokenization, stemming, tagging and parsing. These NLTK features will form the backbone of our text processing and analysis tasks, making it an essential tool in our project for handling and extracting meaningful insights from language data.

View details