Explaining the P-value in the most "ridiculous" way — P-value is not an easy and intuitive concept at first (especially if you read its definition on Statistics textbooks or Wiki pages). But, here, I try to explain it simply using a powerful word called "Ridiculous." You must ask why I use a word like ridiculous several times in the…

A few tips to improve the quality of your SQL queries and collaborate better — A data pipeline is stuck and needs someone's attention. Or a query needs to be refactored using a new table because one of the used tables is getting deprecated or unavailable. Or we need to add more to our SQL logic of a very old data pipeline. In all those…

Why is code review essential? And what are the best practices? — What is code review? We all write code, and we would love to commit our code to the main pool of codes. It is an exciting moment, and we cannot wait to see our latest masterpiece in the main repo. Let’s commit and merge. …

What you need to know before landing a data engineering role at large companies like FAANG — As a data engineer who works for a large FAANG company, I hear people frequently ask what skills are important to land a Data Engineering job at a well-known tech company? Many people think they need to be fluent in Spark or know everything about Hadoop systems to get a…

Or what are the Dimensional Design principles to make a good data warehouse? — For data scientists, machine learning models and visualization packages are essential tools. But more importantly, data scientists rely on data and data infrastructures to do their analytics and modeling. Without data and databases, all developed analytics tools and techniques are useless. Many data scientists get their data in raw formats…

Running and managing MySQL databases remotely — Running databases on local computers is easy and sometimes sufficient enough at the development step. But, deploying most applications needs to run databases on a remote server. There are thousands of solutions for deploying databases remotely. …

Getting valuable information from missing values. — When I load a new dataset, one of the first things I check is how many missing values we have. Seeing all those NaN values are disappointing and discouraging. It is not unusual to have columns with more than 50% missing values. We are all so excited about the new…

How to use Python Logging library tools for tracking code events and debugging — Logging is a popular solution for tracking events in a code or debugging. Many of us (Python programmers and data scientists) have this bad habit of using print() to debug and track events in our codes. Why using print() for logging and debugging is not a good practice? The print()…

Build MVPs with a few lines of code — Building Python applications that have graphical user interfaces and are doing sophisticated tasks might look difficult. In a recently published article (see the link below), I mentioned how only 7 Python libraries are needed to start building applications. Build Your First Data Science Application Seven Python libraries to make your first data science MVP application.towardsdatascience.com