Using Median absolute deviation to find the outliers using SQL Server In real world scenarios, we often get skewed data distribution. Meaning, majority of the data are clustered around 1 area and the remaining few data points are away from the majority of the data. In statistics, the common way…

A comparison between MS Excel and SQL for data cleaning Objective The main objective of this article is to walk through a few ways to obtain clean data using MS Excel and SQL Introduction Data cleaning is the process of ensuring data is correct, consistent and usable. Data cleaning is really important…

A decentralized distributed machine learning technique without sharing raw data What is Federated Learning? Federated Learning also known as collaborative learning or a decentralized learning, a machine learning technique where a model is trained by keeping the training data decentralized. How cool is that? So why do we need federated learning? Before we start, let’s quickly go through how a model is trained in…