IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Partitioning and Clustering in BigQuery
Partitioning splits a BigQuery table into segments that a query can skip; clustering sorts the storage blocks inside them. This guide explains both, measures the effect with a model on 2.9 million real trip rows, shows why clustering column order matters, and lists the filters that quietly stop pruning.
Clustering Algorithms: K-Means, DBSCAN and Hierarchical
K-means, DBSCAN and hierarchical clustering compared on two datasets where their assumptions succeed and fail: round clusters versus interlocking shapes. How each algorithm works, choosing the number of clusters with the silhouette score, why feature scaling changes everything, and how to judge clusters without labels.