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…7 min read·Apr 22, 2024----
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…5 min read·Apr 17, 2024----
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…5 min read·Jan 12, 2024----
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…5 min read·Dec 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+…5 min read·Nov 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…7 min read·Sep 4, 2023----
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…5 min read·Apr 8, 2023--2--2
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…3 min read·Mar 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…2 min read·Feb 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…3 min read·Jan 29, 2023--5--5