data analysis

How to Add, Subtract, Divide and Multiply in Spreadsheets

Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.
8
8
data manipulation
+1

Conditional Formatting in Spreadsheets

Learn how to utilize conditional formatting with one or multiple conditions and how to color cells by custom criteria with the help of a dataset.
7
7
sql

Materialized Views in PostgreSQL

Learn how to store the results of a query with the help of materialized views in PostgreSQL.
12
12
must read
r programming
+3

Leveraging the best of both Python and R

Learn how to use Python and R in conjunction with each other to utilize the best of both in a single data science project.
must read
r programming
+3
34
34
must read
data visualization

Graphs in Spreadsheets

In this tutorial, you'll learn how to create visualizations to display data and gain more meaningful insights with spreadsheets.
must read
data visualization
21
21
sql

Cleaning Data in SQL

In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.
18
18
r programming
+1

SQLite in R

In this tutorial, you will learn about using SQLite, an extremely light-weight relational database management system (RDBMS) in R.
10
10
must read
python
+3

Data Visualization with Power BI

Learn how to analyze and display data using Power BI and make better, more data-driven decisions.
42
42
sql

Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.
8
8
python
+1

Introduction to Factor Analysis in Python

In this tutorial, you'll learn the basics of factor analysis and how to implement it in python.
21
21
data manipulation

Pivot Tables in Spreadsheets

Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.
17
17
must read
sql
+1

Video: Answering Real-World Questions with SQL Queries

In this video tutorial, you'll break down real-world questions to construct complex queries using CASE statements, subqueries, and common table expressions.
9
9
sql
+2

CASE Statements in PostgreSQL

In this tutorial, you'll learn how to write conditional queries in PostgreSQL using the PostgreSQL CASE conditional expression.
9
9
sql
+1

10 Command-line Utilities in PostgreSQL

In this tutorial, learn about 10 handy command-line utilities in PostgreSQL which can enable you to interact with databases efficiently.
9
9
sql
+2

SQL with PowerBI

In this tutorial, you'll learn how to connect PowerBI to a Microsoft SQL Server database and then analyze the data to get insights.
27
27