#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.1519 videos tagged "sqlite tutorial".
#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
#125 · SQL and analytics · 6.7 minSix made-up sales pivot into 3 rows in SQLite, which has no PIVOT or LATERAL keyword.
Python 3.12.15
#250 · Data modelling · 6.6 minWith foreign key checks off, SQLite accepted a repair for bike 99, which does not exist.
Python 3.12.15
#252 · Data modelling · 6.9 minThree ordinary changes broke a flat table of 5 rows; four tables took all three.
Python 3.12.15
#253 · Data modelling · 6.5 minA source renumbered 3 customers; natural and hash keys ended up with 6 rows, a surrogate key kept 3.
Python 3.12.15
#254 · Data modelling · 6.8 minWithout constraints SQLite loaded all 8 rows, 5 of them bad; with constraints only 3 got in.
Python 3.12.15
#255 · Data modelling · 6.5 minFour students' fees add up to 3,200 pounds; summed after joining through a bridge table they came out as 5,500.
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
#263 · Data modelling · 6.8 minA messy CSV summed straight from raw says 99 pounds; after bronze, silver and gold it is 86.
Python 3.12.15
#265 · Data modelling · 6.6 minOne price correction stored three ways; only the bitemporal table answers all 4 questions as asked.
Python 3.12.15
#266 · Data modelling · 6.4 minTwo late clicks made an append-only job report 7 sessions; rebuilt from event time there were 4.
Python 3.12.15
#267 · Data modelling · 6.9 minThree orders' shipping adds up to 9 pounds; after flattening the JSON into item rows it summed to 17.
Python 3.12.15
#272 · Data modelling · 6.7 minA retry loaded 3 payments twice into a table with no key, and 75 pounds became 150.
Python 3.12.15