Category Archives: Modeling/Architecture

Join me for a Webinar: “Ad-hoc Scenario Analysis Using Existing Infrastructure”

Posted on April 18, 2011 by Tom Huguelet

Tom Huguelet Please join me Tuesday for “Ad-hoc Scenario Analysis Using Existing Infrastructure” April 19, 2011 12:00 p.m. ET / 9:00 a.m. PT http://bit.ly/gpyXpr Hosted by SQL Server Magazine, sponsored by Tableau Software. I really had fun creating this webinar. Gave … Continue reading →

Posted in Business Intelligence, Community, Modeling/Architecture | Leave a comment

April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway?

Posted on April 12, 2011 by Tom Huguelet

April 2011 ITA BI Roundtable  – So what can I do with this “BI” stuff anyway? Here are the slides from today’s session.  

Posted in Business Intelligence, Community, Modeling/Architecture | Leave a comment

Is BI ready for Cloud Computing? Is Cloud Computing ready for BI?

Posted on February 8, 2011 by Tom Huguelet

The discussion today at the ITA BI Roundtable was “Is BI ready for Cloud Computing?  Is Cloud Computing ready for BI?” It was a lively discussion, with participants from both BI Backgrounds and Cloud Backgrounds. We used this following materials … Continue reading →

Posted in Business Intelligence, Community, Modeling/Architecture, Virtualization | Leave a comment

Time (Not Date) Dimension Table SQL code

Posted on April 14, 2010 by Tom Huguelet

I am seeing more call for Time Dimensions. By that I mean Time-of-Day Dimensions. So now I have to retrain myself to call Date Dimensions “Date” and Time Dimensions “Time”.As a follow up to this post, here’s some DDL and … Continue reading →

Posted in Modeling/Architecture, OLAP | Leave a comment

Devils and Angels of BI Architecture

Posted on March 10, 2010 by Tom Huguelet

Devil: You don’t need to set up a separate star schema databaseAngel: Yes you do. We don’t want to  interfere with the operational systemsDevil: It’s sooo much workAngel: We want to create a simplified schema to benefit our end usersDevil: … Continue reading →

Posted in Business Intelligence, Modeling/Architecture, SQL Server | Leave a comment

The “Million Dollar” BI Architecture Diagram

Posted on February 5, 2010 by Tom Huguelet

Anyone who has worked with me or taken training from me has seen some variant of this diagram. It’s not an original concept, although this version has been refined to include my personal experience with many Business Intelligence implementations, as … Continue reading →

Posted in Business Intelligence, Modeling/Architecture, SQL Server | Leave a comment

Example Code to build and populate a Date Dimension

Posted on January 25, 2010 by Tom Huguelet

OK, I’ve found myself searching for this code a half dozen times over as many weeks. That tells me that I : a) Need to keep better track of my source code b) Need to share it on my blog … Continue reading →

Posted in Modeling/Architecture, Star Schema | Leave a comment

Do as I say, not as I do

Posted on August 21, 2009 by Tom Huguelet

Perhaps that should be – Do as I say, not as Adventure Works and Project Real do SSAS modeling question: What’s the best approach to handling header/detail records? Approach #1) Use Measure Groups Approach #2) Consolidate via either ETL or … Continue reading →

Posted in Analysis Services, Business Intelligence, MDX, Modeling/Architecture, OLAP, Star Schema | Leave a comment