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 in Power BI: Star Schema Explained
Star schema modelling for Power BI: what fact and dimension tables are, why visuals query them efficiently, and a real 541,909-row flat export turned into a star, exposing the problems that break relationships, from non-unique keys to missing members, plus date tables, explicit measures and related design patterns.
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.
Data Modeling Interview Questions Explained
Data modelling interviews test design decisions, and real data forces them. Seven questions are answered by building a star schema from a year of real online retail orders: declaring the grain, where price belongs, messy product names, customers who changed country, unknown members, a date dimension and additivity.
Data Modeling in Redshift: A Practical Guide
How to model data in Amazon Redshift: a star schema written as Redshift DDL, why primary and foreign keys are declared but not enforced, how to choose column types, where distribution and sort keys fit, what to do with semi-structured data, and when a materialized view or a wide table is the better answer.