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
Data Modeling: Star Schema, Snowflake and Data Vault
The three main warehouse modelling approaches compared by building each from the real Chinook database: a star with 3 tables, a snowflake with 6 and a data vault with 11, the joins the same question needs in each, why all three give identical answers, what each optimises for, and how teams combine them.
Schema Evolution: Handling Changing Data Structures
How to handle changing data structures, using a real public dataset whose schema changed three ways in three years: detecting an added column, a renamed column and five type changes, why a strict merge refuses and a permissive one keeps both spellings, reading by name, compatibility rules, and safe practices.
Star Schema vs Snowflake Schema in Power BI
Star versus snowflake schemas for Power BI models: what a snowflake dimension is, why Microsoft generally favours a single flattened table, a real five-table product dimension flattened into one with every key kept, what flattening quietly drops, and the situations where keeping separate tables makes sense.