Data Analysis with Excel

2 uren

15 hoofdstukken

Halfgevorderd

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.

Toon details

Introduction to SQL

4 uren

41 hoofdstukken

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.

Toon details

Excel for Beginners

4 uren

49 hoofdstukken

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.

Toon details

Intermediate SQL

3 uren

25 hoofdstukken

Halfgevorderd

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.

Toon details

Pandas First Steps

4 uren

33 hoofdstukken

Halfgevorderd

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.

Toon details

Excel Formulas

1 uur

15 hoofdstukken

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.

Toon details

Conducting Exploratory Data Analysis of Nobel Prizes

1 uur

6 hoofdstukken

Halfgevorderd

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.

Toon details

Excel for Finance

3 uren

22 hoofdstukken

Halfgevorderd

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.

Toon details

Extracting Text Meaning using TF-IDF

2 uren

12 hoofdstukken

Halfgevorderd

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.

Toon details

Tableau Fundamentals

3 uren

38 hoofdstukken

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.

Toon details

Recognizing Handwritten Digits

2 uren

10 hoofdstukken

Gevorderd

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.

Toon details

Advanced Techniques in pandas

4 uren

33 hoofdstukken

Halfgevorderd

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.

Toon details