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
Python

How to Sort a Dictionary by Value in Python

Learn efficient methods to sort a dictionary by values in Python. Discover ascending and descending order sorting and bonus tips for key sorting.

Neetika Khandelwal

June 19, 2024

SQL

ROW_NUMBER SQL Function: How to Display Row Numbers

The ROW_NUMBER() SQL function assigns sequential integers to rows within a result set, optionally partitioning the data and ordering the rows within each partition.

Kevin Babitz

June 12, 2024

Excel

How to Create and Format a Combo Chart in Excel

To create a combo chart in Excel, select your data, go to the "Insert" tab, go to the "Charts" group, and choose "Combo Chart."
Elena Kosourova's photo

Elena Kosourova

June 12, 2024

Excel

A Comprehensive Guide to Calculating Skewness in Excel

Calculating skewness in Excel is a straightforward process: we use either the SKEW() or SKEW.P() function.
Arunn Thevapalan's photo

Arunn Thevapalan

June 12, 2024

Excel

A Comprehensive Guide to Using ANOVA in Excel

Learn the simplified process of conducting ANOVA in Excel, and interpreting the results with clear, step-by-step instructions.
Arunn Thevapalan's photo

Arunn Thevapalan

June 7, 2024

Excel

How to Clean Data in Excel: A Beginner's Guide

Learn essential data cleaning techniques in Excel, including removing duplicates, handling missing values, and maintaining consistent formatting.
Laiba Siddiqui's photo

Laiba Siddiqui

July 19, 2024

Python

Python timedelta: Working With Time Intervals in Python

In Python, timedelta is a data type within the datetime module used to represent durations or differences between two points in time.
Stephen Gruppetta's photo

Stephen Gruppetta

June 2, 2024

Excel

What is Data Validation in Excel? A Comprehensive Guide to Add, Edit, and Remove Data Validation Rules in Excel

Applying data validation in Excel is simple: Open the 'Data' tab. Go to the 'Data Tools' group. Click on the 'Data Validation' button.
Elena Kosourova's photo

Elena Kosourova

May 31, 2024

SQL

How to Create Comments in SQL

Review three methods to add comments in SQL: single-line comments, multiline comments, and inline comments using the following syntax: --, /*, and */.
Laiba Siddiqui's photo

Laiba Siddiqui

May 31, 2024