Ivan ZakharchukWindow Functions In SQLMany times Data Engineers get confused when exactly to use Window Functions and when they are propriate over aggregate functions? The main…Jun 21, 20211Jun 21, 20211
Ivan ZakharchukCASE Statements in SQLCASE statements in SQL very helpful when it comes to the problem where result depends on a specific condition that could be apply to…Jun 14, 2021Jun 14, 2021
Ivan ZakharchukinLevel Up CodingImportance of Data Preprocessing and Scaling in Machine LearningData preprocessing and normalization becomes very important when comes to implementation of different Machine Learning Algorithms. As data…Feb 24, 2021Feb 24, 2021
Ivan ZakharchukGeneralization, Overfitting, and Underfitting in Supervised LearningOne of the task when building the supervised learning model, whether it's for classification or regression, it is to create the model that…Feb 8, 2021Feb 8, 2021
Ivan ZakharchukGraphics Lies, Misleading VisualsDuring past decades we have witnessed the power of visual information. As our life becoming more busy and more intense, we have less time…Jan 25, 2021Jan 25, 2021
Ivan ZakharchukList Comprehension vs Loop.Diving deep in the world of Big Data we always looking for better tools to explore , operate and modify data. Any tool we would like to…Jan 15, 2021Jan 15, 2021