Skip navigation.

Dylan's BI Notes

Syndicate content Dylan's BI Study Notes
My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management
Updated: 14 hours 24 min ago

ODI Agent

Thu, 2015-07-16 18:55
An ODI agent is a process running for performing the data integration jobs. The data integration jobs are ODI scenarios in ODI.   Each scenario can be regarded as an executable program. However, we do not run those ODI scenarios directly.  These jobs are executed by the ODI agent. – An ODI agent is a Java program.  It connects to […]
Categories: BI & Warehousing

Business Rules in Enterprise Apps and Data Mining Applications

Tue, 2015-05-26 20:55
Transaction system has several places to capture the decisions and has several places to capture the business rules. These are the potential places where the data mining scoring engine can be deployed. Here are typical “decisions” captured in the enterprise apps I can think of: Marketing  Marketing Strategy and Planning 4 Ps are the decisions […]
Categories: BI & Warehousing

Opportunities for Cloud based BI

Thu, 2015-05-21 18:33
Three opportunities for the future Cloud based BI: 1. Provide the tools for consolidating data  Investing the the data matching and merging technologies is too costly for on-premise BI implementations. Providing the services within the cloud BI will lower the cost. 2. Provide the External Data Bringing the external data into the individual on-premise env […]
Categories: BI & Warehousing

RFM Analysis in Oracle BI Apps

Fri, 2015-04-24 19:16
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 […]
Categories: BI & Warehousing

Conformed Dimension and Data Mining

Mon, 2015-04-20 20:48
I believe that Conformed Dimensions are playing a key roles in data mining.  Here is why: A conformed dimension can bring the data together from different subject area, and sometime, from different source system. The relevant data can be thus brought together.  Data Mining is a technique to find the pattern from the historical data. […]
Categories: BI & Warehousing