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.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.sql

## Materialized Views in PostgreSQL

Learn how to store the results of a query with the help of materialized views in PostgreSQL.## 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

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.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.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.## Data Visualization with Power BI

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

## Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.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.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.## 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.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.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.sql

+2