BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Portfolio-level KPIs | Main | Is your project on time, on budget, on the mark? »

June 29, 2009

A Fact Qualifier Matrix Example

Here is an example of using a Fact Qualifier Matrix (FQM) for development of a BI solution that we created for managing and optimizing IT project performance:








An FQM is something that I learned about years ago from Steve Hoberman (http://www.stevehoberman.com/) who I felt was THE best I have ever heard at explaining data modeling and concepts regarding building data models for data warehouses. That's my plug for Steve, my way of paying back for the great class and book of his that helped me on many projects.

During that training on building data warehouses, we practiced using FQMs as a way to utilize process-oriented requirements engineering and specifications top-down from the perspective of the business users.

Of course, this is somewhat of a no-brainer in the world of software development. But I loved the way this seemed to work in a lab or classroom setting for a technique to build a data warehouse dimensional model that was clearly meeting a busines need and solving business problems.

Haven't we all come across data warehouse designs and dimensions designed that are undocumented, cannot be traced back to requirements and have you scratching your head wondering where this came from and why on earth has it been architected this way?

Not to say that the fact-qualifier matrix is the cure all.

But take a look at the same screenshots I included above. We asked business users the questions from the Excel tab on the first screenshot. Then we mapped the answers to dimensions on the left and facts on the top to create a matrix that can then be used to create a logical design. The notations on the dimensions were used to signify hierarchies in the dimensions and dimensions that may need special handling based on the complexity of the source data.

Posted by Mark Kromer at June 29, 2009 11:45 PM

Comments

Ali - You can find a template of this FQM and more on BI requirements analysis at my site TechProdo here: http://www.techprodo.com/phpbb/viewforum.php?f=4

Posted by: Mark Kromer at January 6, 2010 9:21 PM

Great BI resource.

Thanks

Posted by: OracleApps at October 17, 2010 1:16 PM

Book marked - will return in in a few days to check rest threads.

Posted by: swarovskiemu at May 16, 2011 7:36 AM

Wow! This can be one particular of the most helpful blogs We've ever arrive across on this subject. Actually Wonderful. I am also a specialist in this topic therefore I can understand your hard work.

Posted by: London escort at May 16, 2011 3:40 PM

When I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks!

Posted by: www.Allegro.pl at May 16, 2011 5:32 PM

I've been surfing online more than three hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my view, if all web owners and bloggers made good content as you did, the web will be much more useful than ever before.

Posted by: escort agency at May 17, 2011 1:32 AM

Hej, trafiłęm na Twoją stronę przez wyszukiwarkę. Widzę, że jest tu sporo interesujących rzeczy, będę tu zaglądał. Czekam na kolejne wpisy.

Posted by: fotografia slubna at May 17, 2011 6:33 AM

Post a comment




Remember Me?