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

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

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

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

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

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

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

NumPy in a Nutshell

3 hours

21 chapters

Intermediate

NumPy is one of the basic packages for scientific computing in Python. The 'NumPy in a Nutshell' course will introduce you to such a powerful tool as NumPy, which is convenient for working with arrays of different sizes. After completing this course, you will be able to easily work with matrices, using various functions. In addition, during the course, you will learn basic methods for working with arrays that simplify code writing.

View details

Advanced Techniques in pandas

4 hours

33 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