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

Introduction to SQL

4 hours

41 chapters

Beginner

This course is perfect for beginners ready to explore the world of SQL. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.

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

33 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

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

Tableau Fundamentals

3 hours

38 chapters

Beginner

This corse provides a comprehensive introduction to Tableau's core features, empowering learners to create impactful data visualizations and dashboards. We will cover essential topics such as working with charts, filters, calculated fields, and parameters, as well as advanced techniques like combining data and creating interactive dashboards. By the end, you will have the skills to transform raw data into actionable insights with ease and confidence.

View details

Recognizing Handwritten Digits

2 hours

10 chapters

Advanced

In this project, our primary objective will be to delve into the identification of handwritten digits through the application of machine learning algorithms. This endeavor aims to harness the power of machine learning to effectively interpret and understand handwritten digits, showcasing the potential of these algorithms in processing and analyzing complex visual information.

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