#110 · Data modelling · 6.9 minSlowly Changing Dimensions in SQL: Type 1 vs Type 2
The same seven sales put 105 pounds in the West with type 1, and 40 with type 2.
Python 3.12.158 videos tagged "data warehouse".
#110 · Data modelling · 6.9 minThe same seven sales put 105 pounds in the West with type 1, and 40 with type 2.
Python 3.12.15
#256 · Data modelling · 6.6 minNine order lines, one fact table, three reports, and every report adds up to 64.
Python 3.12.15
#257 · Data modelling · 6.5 minA daily sales report said 108 pounds when the shop sold 54, and one rule fixed it.
Python 3.12.15
#258 · Data modelling · 6.4 minThe same nine order events become three fact tables, and the shipped orders took 2 days on average.
Python 3.12.15
#259 · Data modelling · 7 minJoining two fact tables made 25 pounds of refunds look like 50, and drilling across fixed it.
Python 3.12.15
#260 · Data modelling · 6.5 minTwenty lines of SQL, plus a small holiday table, build 365 days with fiscal periods, and the checks pass.
Python 3.12.15
#261 · Data modelling · 6.9 minOne big table took almost 5 times the space, and renaming one category touched 66,082 rows.
Python 3.12.15
#262 · Data modelling · 6.6 minThree loads into a tiny Data Vault in SQLite, and the third, a repeat, added 0 rows.
Python 3.12.15