Data Analysis Resources

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

In this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world...

The Ultimate Guide to Data Analysis in Excel

The Ultimate Guide to Data Analysis in Excel

Excel is all about data! Learn these simple but essential data analysis tools in Excel.

How to Use the Data Analysis Toolpak in Excel

How to Use the Data Analysis Toolpak in Excel

The Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat.

20 Most Helpful Python Interview Questions and Answers

Development

26 min

20 Most Helpful Python Interview Questions and Answers

Do you want to be ready for your next Python interview? Check out these top 20 Python interview questions and answers.

Excel Challenge 4: Analyze Data With Power Query

Excel Challenge 4: Analyze Data With Power Query

Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).

7 Python Code Examples for Everyday Use

Development

40 min

7 Python Code Examples for Everyday Use

Get familiar with some useful Python code examples to polish your development skills.

What Can I Do with Python: 15 Python Projects to Add to Your Portfolio

Development

14 min

What Can I Do with Python: 15 Python Projects to Add to Your Portfolio

Interested in coding and find yourself asking "What can I do with Python"? We break down some of the coolest things you can build with Python.

12 Most Useful Excel Functions for Data Analysis

12 Most Useful Excel Functions for Data Analysis

Learn 12 of the most useful Excel functions for data analysis, with free practice worksheet included!

Join 472,639 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

The Most Popular Uses for Python

Development

10 min

The Most Popular Uses for Python

If you've ever wondered "What is Python used for?", keep reading to find out all about this popular language!

A Beginner's Guide to Power Query, Power Pivot and Power BI

A Beginner's Guide to Power Query, Power Pivot and Power BI

We demystify the differences between Power Query, Power Pivot, and Power BI and show you how they all work together.

How (and When) to Use ANOVA in Excel: The Ultimate Guide

How (and When) to Use ANOVA in Excel: The Ultimate Guide

Looking to improve your processes by running an analysis of variance? Learn how to run one and two-way ANOVA in Excel with this step-by-step guide!

Top 4 Reasons Python is So Popular in 2024

Development

8 min

Top 4 Reasons Python is So Popular in 2024

if you're into programming, you've probably heard of Python programming language. Find out why Python so popular in 2024.

How to Create a Power BI Pie Chart

How to Create a Power BI Pie Chart

Want to make a Power BI Pie chart? Follow along with our step-by-step guide!

How to use PowerPivot in Excel: The Ultimate Guide

How to use PowerPivot in Excel: The Ultimate Guide

Learn how to use PowerPivot and take your data processing skills to the next level! We cover why and how to use PowerPivot with real business use c...

Power Query Tips: 10 Most Useful Commands

Power Query Tips: 10 Most Useful Commands

Check out these Power Query tips that will help you transform your data like a pro!

Big Data for Beginners: What You Need to Know

Big Data for Beginners: What You Need to Know

The field of Big Data is growing at a fast pace. But what is Big Data exactly? Check out our guide to learn Big Data for beginners.

RDBMS Basics: SQL Database Fundamentals

Development

11 min

RDBMS Basics: SQL Database Fundamentals

Learn RDBMS basics, which will help you store and query your data in SQL.

Business Intelligence vs. Big Data: What's the Difference?

Business Intelligence vs. Big Data: What's the Difference?

Wondering what the difference is between business intelligence and big data? We'll give you the lowdown!