Setting up Time Dimensions for Resolutions in a Star-Schema...
Read MoreHow to model when header table has values?...
Read MoreHow to deal with changes in Power BI dimension tables?...
Read MorePower BI star (constellation) schema: 2 fact tables with relation between each other...
Read MoreHow to model a header detail requirement when header has values that cannot be apportioned to detail...
Read MoreOrder of duplicate keys in non-clustered indexes [SQL Server]...
Read MoreSSIS Surrogate Key incrementation...
Read MorePower BI Data Modelling - why is this bad design?...
Read MoreHow to handle repeating values in fact table due to few numeric columns being at a higher grain?...
Read MorePostgreSQL ON CONFLICT add new entry with new timestamp...
Read MoreHow to create relationships with many fact tables in Power BI?...
Read MoreCalculation based on 2 fact tables (plan/actual comparison)...
Read MoreHow to populate fact table with Surrogate keys from dimensions...
Read MoreUsing hash keys instead of integer keys on Redshift...
Read MoreCount Distinct Values in one column table related to another column table Power BI DAX...
Read MoreHow to represent different business facts in a single fact table?...
Read MoreIs a star schema a denormalized schema?...
Read MoreStar Schema - Unify data with varying structure from different sources...
Read MoreHow different fact tables are handled to share some common dimension tables in data marts in star mo...
Read MoreShould I use multiple fact tables for each grain or just aggregate from lowest grain?...
Read MoreHow to get the precise surrogate key for the incomming fact records...
Read MoreStar schema for tables with overlap periods...
Read MoreSpotfire for cross fact table joins using conformed dimensions...
Read MorePython Cubes OLAP Framework - how to work with joins?...
Read More