Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

RFM Analysis in Oracle BI Apps

Posted by Dylan Wan on April 24, 2015

I wrote the article RFM Analysis earlier.  We recently posted a more detailed description about how Oracle BI Apps implements this concept in the product.

Customer RFM Analysis

RFA related customer attributes are good examples of aggregated performance metrics as described in this design tip from the Kimball Group


Design Tip #53: Dimension Embellishments
By putting this type of aggregated performance metrics to the dimension table as dimension attributes, the users of BI can easily use it to group, to sort, and to filter customers.

Using the Recency, Frequency, Monetary Score is an easy way to differentiate the customers and help you focus on the valuable customers.

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s