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
Designing Fact and Dimension Tables
Practical rules for designing fact and dimension tables: declaring the grain, choosing transaction, snapshot or factless fact tables, why averages and distinct counts must not be summed, shown on three million taxi trips where an average of averages nearly doubled the true fare, junk dimensions, and keys.
BigLake and External Tables in BigQuery
BigQuery can query files where they lie, through an external table or a BigLake table. Both point at the same files; what differs is who needs access to the bucket and how finely access can be controlled. This guide explains the difference with a worked access model, the DDL, metadata caching, limits and when to load.
Pivot Tables in Excel: A Complete Tutorial
A complete Excel pivot table tutorial: preparing data so pivots work, building a first summary, choosing between sum, count and average, showing values as percentages and running totals, grouping dates into months and quarters, filtering with slicers, refreshing correctly, and the mistakes that produce wrong totals.