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