Basics of Dimensional Modeling
Introduction of how to design a star schema dimensional model for new BI developers
2014-09-09
7,974 reads
Dimensional modeling
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.
2011-10-31
8,079 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.
2009-08-26
3,651 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.
2009-07-31
1,914 reads
RE: April CTP Released today
Interesting Chris ... I have to download it again I think. hmmm ... this integration is important to me as I like playing with the CLR objects ... Let me get my hands dirty on the April CTP now ...Vinod Kumarwww.ExtremeExperts.com
2005-04-21
Stored Procedure Fails Only When Called By Agent
I have three stored procedures that do the flowing tasks: 1. connect to and add logins for 12 remote (WAN) SQL servers2. Drop data on the local server and re-add it table at a time from each remote server, one at a time, for 5 tables.3. Disconnect from the sites.These stored procedures work fine when run from Query […]
2004-05-06
2 reads
RE: best way to denote a numbered item
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-08-25
RE: Best practice when to use an index
quote: quote: If its an internet app then not very much x huge audience = major headache. I didn't get this at first, either, but it's: If an internet app, then: (small performance hit)*(huge audience) = (major headache)
2003-06-25
RE: DTS fails to run when called from a Agent Job
What are you doing inside the pkg? Are you using cubes? Make sure the account running sql agent have permissions in the places where DTS is working. JFB
2003-06-23
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers