Find beginner-friendly tutorials below for those who are new to the community.

Pandas and Plotly Tutorials - Python Libraries for Data Analysis and Visualization respectively

Data Analysis and Visualization in the retail/FMCG sector
Analyzing the ‘BigMart Sales’ dataset with the help of pandas library and learn the fundamentals of plotly by visualizing the result using simple yet interactive graphs.
Data Analysis of the ‘Spotify’ dataset using the Pandas library
Building a strong foundation through the pandas library by working on the ‘Spotify’ dataset. We will discuss some very basic tools that pandas provide to help gain insights into any dataset in the music domain.
Analyzing the Flipkart Sales Dataset using Pandas and Plotly
Let’s learn to do a deep analysis of the Flipkart sales dataset using the pandas and plotly libraries. We will take into account various features to gain key insights into our data.
Analyze Chipotle orders dataset using Pandas for an ordering app
Pandas is a very powerful library enabling you to perform analytic operations with ease and speed. If you need to draw valid conclusions from your data, Pandas should be your first choice. In this series of posts, I’ll show you how to use this feature-packed Python data analysis library.
Video Game Sales Analysis
Analyzing the ‘Video Game Sales Analysis’ dataset with the help of pandas library and learn the fundamentals of plotly by visualizing the result using simple yet interactive graphs.
Customer Churn Analysis
Analyze customer churn using a telecom company dataset. Identify different attributes and answer questions like “Are we losing customers?” and “If so, how?”
Analyzing Startup Investment
Analyzing the startup investment dataset to gain insights about how different features are related to startups across the globe.
Pandas Group By - Key areas you should watch out for
We surveyed Stack Overflow questions related to Pandas Group By and came across few areas that have been repeatedly discussed - Computing multiple statistics for each group Sorting within groups Extracting the first row in each group Extracting multiple statistics for each group Common aggregation…

SQL Queries - Exercises for Beginners

Getting Started with SQL Queries - Exercises for Beginners Part-1
Here’s a selection of the most useful SQL queries every beginner must practice. This article will not only provide you with the answers but also the explanation to each query.
Getting Started with SQL Queries - Exercises for Beginners Part-2
Here’s a selection of the most useful SQL queries every beginner must practice. This article will not only provide you with the answers but also the explanation to each query.
Getting Started with SQL Queries - Exercises for Beginners Part-3
Here’s a selection of the most useful SQL queries every beginner must practice. This article will not only provide you with the answers but also the explanation to each query.
Getting Started with SQL Queries - Exercises for Beginners Part-4
Here’s a selection of the most useful SQL queries every beginner must practice.
A Query For Your Business Problem
This post walks you through the SQL queries in the Kaggle python notebook and shows you how to visualize them using Tableau. We are taking the following dataset for our reference: Dataset: Used Cars DatasetHow has the price of vehicles changed over the years?Thinking about buying a used car?
A Query For Your Business Problem - Part 2
IntroductionBy seeing your interest in the previous SQL queries posts, we have curated this series to work any query in a more structured way by firstly understanding the objective behind carrying out this activity. Secondly, by working out the query in Kaggle to get the desired table. Thirdly, by…
Learn SQL in a browser with PostgreSQL and pgweb
PostgreSQL is a very versatile database. If you want to learn SQL, then a quick way to start is to 1) grab some data you want to analyze 2) insert into a PostgreSQL table and 3) use a SQL client such as pgweb and get started analyzing data. You can

Other

DBeaver vs Python: Two Methods To Run Your Queries
This is a step-by-step guide on how to run your SQL queries using Dbeaver and Python.
Import data from Kaggle to Google Colab
Learn to import Kaggle dataset into Google Colaboratory using seven easy to follow steps.
Explore the Twitter graph dataset and learn how to analyze complex graphs using simple exploratory data analysis (EDA)
Cover ImageIntroduction Twitter logoMost of us think of Twitter as a social network, but it’s actually something much more powerful! Twitter is a social news website. It can be viewed as a hybrid of email, instant messaging and SMS messaging all rolled into one neat and simple package. It’s a