Comprehensive Retail Data Analysis using SQL
Introduction In this article we will be learning various SQL basics through examples by doing a comprehensive EDA on a Retail Sales Dataset The dataset...
Author: tinylarry.com
Guide to SQL Window functions: When and how to use them?
Introduction Window functions operate on a set of rows (window) and return an aggregated result hence the name “Window Functions”. Window Functions are extremely useful...
Guide to SQL joins: Intuition and Implementation
Introduction The purpose of a join clause is to combine rows from different tables, based on a related column between them which is known as...
Data Visualization in Python: Deciding the right graph to represent the data
Introduction Although choosing the best visualization to represent the data is a skill that is acquired over-time, there are definitely certain guidelines that must be...
Improving Visualization Aesthetics using Python
Introduction In this article we will be discussing how to improve the aesthetics of graphs using python and the best practices that should be kept...
Visually Analyzing Multivariate Relationships using Python
Introduction What are multivariate relationships? The relationships that exist between two or more variables are known as multivariate relationships. Various visual representations of multivariate relationships...
Outlier Detection and Treatment Using Python
Introduction What are outliers? Outliers in a dataset are those data points that are significantly different from the remaining data. Outliers lie outside the overall...
Data Cleaning Using Python: Missing Value Treatment
Introduction What is missing value treatment and why is it necessary? Missing values treatment is a phase of Data Cleaning in which the data practitioner...
Descriptive and Univariate Analysis using Python
Introduction What are descriptive and univariate analysis? Descriptive and univariate analysis is the first step of building data understanding. It is the phase in which...
