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: 3 hours 10 min ago

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

Market Segmentation and Data Mining

Fri, 2015-04-03 18:30
1. Market Segmentation in the academic world  Market Segmentation is part of marketing process. It is described in Philip Kotler’s book as part of the step of defining the market strategy.The idea is to segment consumer market by some variables and to divide the market into different segments. Selecting the segments for your products is the result of the […]
Categories: BI & Warehousing

How to integrate Oracle Data Mining and Oracle BI

Fri, 2015-04-03 01:25
Here are the various ways that we can use Data Mining inside BI. We can build Advanced Analytics applications. The scoring function can be called within the opaque view or with EVALUATE function. The opaque view method may provide a better flexibility since multiple columns can be exposed. Here is an old Oracle white paper […]
Categories: BI & Warehousing

Data Mining Scoring Engine Development Process

Wed, 2015-04-01 20:29
Here is how I view data mining: The target is to build a scoring engine. It accepts an input and produces the output. The development process can be separate as Requirement, Design, Coding, and Deploy.  Similar to typical software development phases.
Categories: BI & Warehousing

Why Use Data Mining with Data Warehouse?

Wed, 2015-04-01 13:42
1. Use the data warehouse data as the training set Data Mining requires the training data to train the learning algorithm.  The data warehoucing processes provide the following services: Consolidate the data from different sources Aggregate the data: for example, we have the order return transactions but the training data can be # of returns […]
Categories: BI & Warehousing

Business Intelligence Cloud Service – Data Modeler

Mon, 2015-03-30 19:27
These video shows how the data are loaded to BI Cloud Service and are modeled as dimensions and facts. We do not need to use the BI admin tool to create model. For BICS, we can create model using the browser.
Categories: BI & Warehousing

Dimensional Modeling

Mon, 2015-03-30 11:06
Moved the content into a page – Dimensional Modeling
Categories: BI & Warehousing

Source Dependent Extract and Source Independent Load

Tue, 2015-03-24 17:40
Typical data warehousing ETL process involves Extract, Transform, and Load. The concept of Source Dependent Extract (SDE) and Source Independent Load (SIL) are unique part of the BI Apps ETL since BI Apps has a universal data warehouse. Since the staging schema are designed according to the universal data warehouse design, the logic of loading data […]
Categories: BI & Warehousing

BI Apps has an Universal Data Warehouse

Mon, 2015-03-23 13:48
BI Apps data warehouse design is based on an assumption that the data warehouse schema design is independent from OLTP system. The staging schema is an universal staging and the data warehouse is an universal data warehouse. The assumption is that no matter what the source system you are using, the business questions the BI […]
Categories: BI & Warehousing

Extracting Data from Cloud Apps

Thu, 2015-03-05 15:20
I think that it would be easier if the cloud application can be aware of the data integration needs and publish the interfaces proactively. Here are some basic requirements for the applications that can be considered as data integration friendly: 1. Publish the object data model This is required for source analysis. For example, here is […]
Categories: BI & Warehousing