Search code examples
Setting up Time Dimensions for Resolutions in a Star-Schema...


database-designdata-warehousestar-schema

Read More
How to model when header table has values?...


powerbidaxpowerbi-desktopdata-modelingstar-schema

Read More
How to deal with changes in Power BI dimension tables?...


powerbidatamodelstar-schema

Read More
Power BI star (constellation) schema: 2 fact tables with relation between each other...


powerbidata-warehousestar-schemafact-table

Read More
Generic vs Conformed dimensions...


databasedata-warehousedimensional-modelingstar-schema

Read More
How to model a header detail requirement when header has values that cannot be apportioned to detail...


powerbidimensional-modelingstar-schema

Read More
OLTP-STAGGING-DW-DUPLICATES...


data-warehousestagingstar-schemaoltp

Read More
Order of duplicate keys in non-clustered indexes [SQL Server]...


sqlsql-serverindexingstar-schema

Read More
Difficulty modeling Star schema...


database-designbusiness-intelligencestar-schemamulti-databasedatamart

Read More
Star-schema naming conventions...


sql-serverstar-schema

Read More
SSIS Surrogate Key incrementation...


ssisdata-warehousestar-schema

Read More
Star-Schema Design...


databasedesign-patternsdata-warehousestar-schemadimensional-modeling

Read More
Power BI Data Modelling - why is this bad design?...


powerbipowerbi-desktopdata-modelingdatamodelstar-schema

Read More
How to handle repeating values in fact table due to few numeric columns being at a higher grain?...


powerbidata-modelingdimensional-modelingstar-schemafact-table

Read More
PostgreSQL ON CONFLICT add new entry with new timestamp...


pythondatabasepostgresqlstar-schemastar-schema-datawarehouse

Read More
How to create relationships with many fact tables in Power BI?...


powerbirelationshippowerquerydata-modelingstar-schema

Read More
Calculation based on 2 fact tables (plan/actual comparison)...


powerbidaxpowerbi-desktopsummarizestar-schema

Read More
How to populate fact table with Surrogate keys from dimensions...


data-warehousedimensionsstar-schemasurrogate-key

Read More
Using hash keys instead of integer keys on Redshift...


database-designamazon-redshiftdata-warehousestar-schema

Read More
Count Distinct Values in one column table related to another column table Power BI DAX...


powerbidaxpowerquerypowerbi-desktopstar-schema

Read More
How to represent different business facts in a single fact table?...


data-modelingdata-warehousestar-schemafact-table

Read More
Is a star schema a denormalized schema?...


schemaolapstar-schemaoltp

Read More
Star Schema - Unify data with varying structure from different sources...


databasedata-warehousedimensional-modelingstar-schema

Read More
How different fact tables are handled to share some common dimension tables in data marts in star mo...


data-warehousesnowflake-schemastar-schemafact-tabledatamart

Read More
Should I use multiple fact tables for each grain or just aggregate from lowest grain?...


etldata-warehousedimensional-modelingstar-schemastar-schema-datawarehouse

Read More
How to get the precise surrogate key for the incomming fact records...


data-warehousestar-schema

Read More
Star schema for tables with overlap periods...


star-schemastar-schema-datawarehouse

Read More
Star schema design feedback...


data-warehousedimensional-modelingstar-schemastar-schema-datawarehouse

Read More
Spotfire for cross fact table joins using conformed dimensions...


spotfirestar-schema

Read More
Python Cubes OLAP Framework - how to work with joins?...


pythondatabaseolapstar-schema

Read More
BackNext