Ivan Zakharchuk·Jun 21, 2021Window Functions In SQLMany times Data Engineers get confused when exactly to use Window Functions and when they are propriate over aggregate functions? The main…A response icon1A response icon1
Ivan Zakharchuk·Jun 14, 2021CASE 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…
InLevel Up CodingbyIvan Zakharchuk·Feb 24, 2021Importance 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…
Ivan Zakharchuk·Feb 8, 2021Generalization, 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…
Ivan Zakharchuk·Jan 25, 2021Graphics 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…
Ivan Zakharchuk·Jan 15, 2021List 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…