An intuitive guide. — Bias (in statistics) is anything that leads to a systematic difference between the true parameters of a population and the sampling statistics used to estimate those parameters. Let’s make this a bit intuitive…. Bias arises due to poor or inadequate sampling where sample is not the proxy of population. For…

Joins and Union operators are used heavily in Structured Query Language (SQL) for querying the data in relational databases such MySQL and PostgreSQL. In this article, I will discuss Union Operators such as UNION, UNION ALL, EXCEPT, INTERSECT. 🔔 Agenda Using UNION Using UNION ALL Using EXCEPT Using INTERSECT Operator Understanding Order…

What is a common table expression (CTE)? A common table expression or CTE is a temporary result set (or a virtual table). It temporarily saves the output of a query to write other queries that reference it. CTEs are short lived. CTEs are virtual tables which are created during the execution of a query, used by the…

A simple framework with 13 criteria… 💥💥💥 — Data Engineering is vast and rapidly evolving. It could be confusing to choose tools from the plethora of options. Data engineers need not be experts about every available tool and database, rather they must know how to choose the right technology for the specific task and anticipate the needs of…

Location Intelligence in Python — Business use-cases around Location Intelligence are quite fascinating to me. Since 2012, I have been learning about Geo Spatial data analytics. I used ArcGIS and Python for analysing and visualizing geo-data during my Masters program from Virginia Tech; and since then, I have solved a few business use-cases around it. …