Skip to main content
Category
Topics

Data Analysis Tutorials

Get insights on the latest tools & methods that you can use to analyze your data more effectively. Our data analysis tutorials will help you develop your skills.
Other topics:
GroupTraining 2 or more people?Try DataCamp for Business
Excel

How to Remove Duplicates in Excel: 5 Best Methods

Learn how to use Excel’s built-in features, formulas, and even Power Query to tackle duplicates, along with best practices and troubleshooting tips for handling complex datasets.
Laiba Siddiqui's photo

Laiba Siddiqui

November 14, 2024

Excel

How to Highlight Duplicates in Excel

Explore how you can identify duplicate entries in Excel using Conditional Formatting, the COUNTIF() formula, and Power Query. Learn best practices and troubleshoot issues.
Laiba Siddiqui's photo

Laiba Siddiqui

November 13, 2024

Excel

VLOOKUP() from Another Sheet: A How-to in Excel

See how to use VLOOKUP() to pull data from another sheet in your Excel workbook. Build confidence with practical examples and troubleshooting techniques.
Laiba Siddiqui's photo

Laiba Siddiqui

November 11, 2024

Python

Matplotlib Colormaps: Customizing Your Color Schemes

Enhance your visualizations with Matplotlib colormaps. Learn to pick the right colormap, adjust color classes, and troubleshoot common visualization issues.
Allan Ouko's photo

Allan Ouko

November 9, 2024

Python

Python Bar Plot: Master Basic and More Advanced Techniques

Create standout bar charts using Matplotlib, Seaborn, Plotly, Plotnine, and Pandas. Explore bar chart types, from simple vertical and horizontal bars to more complex grouped and stacked layouts.
Samuel Shaibu's photo

Samuel Shaibu

November 6, 2024

Data Science

Characteristic Equation: Everything You Need to Know for Data Science

Understand how to derive the characteristic equation of a matrix and explore its core properties. Discover how eigenvalues and eigenvectors reveal patterns in data science applications. Build a solid foundation in linear algebra for machine learning.
Vahab Khademi's photo

Vahab Khademi

November 5, 2024

Excel

How to Find P-Value in Excel: 3 Easy Methods

Learn how to find p-value in Excel using Excel functions like T.TEST() and Z.TEST(), by using the Data Analysis Toolpak, or through manual calculations. Equip yourself to make confident, data-backed decisions in Excel.
Jachimma Christian's photo

Jachimma Christian

October 31, 2024

SQL

SQL Remove Duplicates: Comprehensive Methods and Best Practices

Explore the different methods for filtering out and permanently removing duplicate rows using SQL. Learn the practical applications of how to remove duplicates in SQL Server, MySQL, and PostgreSQL.
Allan Ouko's photo

Allan Ouko

October 29, 2024

Data Analysis

Arithmetic Mean: A Foundational Tool for Data Analysis

Explore the arithmetic mean's role in data analysis. Learn its formula, applications, and how it compares to other kinds of means and other statistical measures, and understand when each is most useful.
Vinod Chugani's photo

Vinod Chugani

October 28, 2024

Data Science

Multicollinearity in Regression: A Guide for Data Scientists

Uncover the impact of multicollinearity on regression models. Discover techniques to detect multicollinearity and maintain model reliability. Learn how to address multicollinearity with practical solutions.
Vikash Singh's photo

Vikash Singh

October 28, 2024