Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Dimensional modeling Rss

   Items 1 to 4 of 4   

Basics of Dimensional Modeling

Introduction of how to design a star schema dimensional model for new BI developers  Read more...
By Derek Wilson 2014/09/09 | Source: | Category: star schema
Rating: |  Discuss |   Briefcase | 6,976 reads

Using The Kimball Dimensional Modeling Tool

Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.  Read more...
By Jim Nichols 2011/10/31 | Source: | Category: bi
Rating: |  Discuss |   Briefcase | 6,739 reads

Kimball University: Five Alternatives for Better Employee Dimension Modeling

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.  Read more...
By Additional Articles 2009/08/26 | Source: | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,233 reads

Attribute Discretization: Customize Grouping Names

Join BI Architect Bill Pearson as he continues to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...
By Additional Articles 2009/07/31 | Source: Database Journal | Category: business intelligence
Rating:  Rate this |   Briefcase | 1,757 reads
   Items 1 to 4 of 4   
bi (1)    
business intelligence (1)    
data warehouse (1)    
data warehousing (1)    
database (1)    
employee dimension (1)    
kimball (1)    
star schema (1)    
training (1)    
t-sql (1)