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…5 min read·Jun 21, 2021--1--1
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…3 min read·Jun 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…4 min read·Feb 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…4 min read·Feb 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…4 min read·Jan 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…4 min read·Jan 15, 2021----