Statistics for Data Enthusiast (Part 2) — Descriptive StatisticsStatistics 101: Exploring the Basics of StatisticsMar 151Mar 151
Statistics 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 22, 2024Apr 22, 2024
Optimizing 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 17, 2024Apr 17, 2024
Visualizing 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 12, 2024Jan 12, 2024
How 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
Published in10MS Tech BlogUnlocking 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
Published inLearning 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
How 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
Clean 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
How 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
