Niloy BiswasStatistics for Data Enthusiast (Part 1) — Probability DistributionsProbability distribution is a mathematical function that describes all the possible values and likelihoods that a random variable can…Apr 22Apr 22
Niloy BiswasOptimizing Costs in BigQuery: Leveraging Partitioning and Clustering for Efficient Data ManagementBigQuery leverages partitioning and clustering to manage large datasets efficiently. Partitioning divides a table into segments based on…Apr 17Apr 17
Niloy BiswasVisualizing 3D Population Density MapAs of 2024, Earth’s population stands at about 8.1 billion, with projections indicating a rise to nearly 10 billion by 2050. This dramatic…Jan 12Jan 12
Niloy BiswasHow to Create a 3D Population Density Map in RIn this post, we’ll learn how to create a 3D population density map using R. Let’s learn to create engaging 3D population density maps in…Dec 13, 2023Dec 13, 2023
Niloy BiswasUnlocking Geographic Insights: Visualizing User Data from BigQuery on a Map10 Minute School, the largest Ed-Tech platform in Bangladesh, is now reaching beyond 12 million registered users and serving 3.5 million+…Nov 4, 2023Nov 4, 2023
Niloy BiswasinLearning SQLUnlocking Insights: How to Decode Nested Google Analytics Data in BigQuery with SQLIn the realm of digital analytics, Google Analytics and Google BigQuery have emerged as premier tools, empowering brands to glean…Sep 4, 20231Sep 4, 20231
Niloy BiswasHow to Monitor BigQuery Usage and Costs on GCP with Interactive Visualizations in Looker StudioMonitoring BigQuery usage and costs is an essential aspect of managing data on Google Cloud Platform (GCP). BigQuery is a fully-managed…Apr 8, 20233Apr 8, 20233
Niloy BiswasClean Up Your BigQuery Database: A Step-by-Step Guide to Deleting Temporary Tables for Better…It’s easy for your database to become cluttered with thousands of temporary tables. These tables can be created for various reasons…Mar 3, 2023Mar 3, 2023
Niloy BiswasHow to Remove Duplicate Data from a SQL Table Using QUALIFY and ROW_NUMBER FunctionsRemoving duplicate data from SQL tables can be a challenge, but using the QUALIFY and ROW_NUMBER functions can make it easy. In this post…Feb 19, 2023Feb 19, 2023
Niloy BiswasConnecting the Dots: Joining Tables Across Databases with Metabase SQLJoining tables across databases in Metabase SQL can seem daunting at first, but with a little bit of knowledge and understanding, it can be…Jan 29, 20237Jan 29, 20237