Dylan's BI Notes

Subscribe to Dylan's BI Notes feed Dylan's BI Notes
My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management
Updated: 6 hours 54 min ago

Analytics apps or embedded analytics

Thu, 2017-02-16 21:02
An analytics apps should be an application.   We should not see it as a report solution or just a way to view or download data. A best analytics apps is an apps, and lets people forget about it is an “analytics” apps. If you keep the end user in mind and drive the design of […]
Categories: BI & Warehousing

Dashboard vs Report

Thu, 2017-02-16 15:00
A dashboard is a data driven application.  It is important to think about: Who is using this?  User Persona.  Different people may have different level of accountabilities and thus have different interests. When the user will need to use? How often? What business process the information will need to be available? What is the best […]
Categories: BI & Warehousing

Schema-less or Schema On Demand

Sun, 2017-01-29 20:53
I am trying to define what are the criteria for a schema-less, or a schema on demand data storage. In relational database, we use DDL, data definition language, to define schema. We have to create table first, before we can insert data into a table.  When we update data, we update the data by mentioning the […]
Categories: BI & Warehousing

Uncommonly Common

Thu, 2017-01-26 17:41
An interesting concept. Significant Terms Aggregation – Elastic Search
Categories: BI & Warehousing

Elastic Stack

Wed, 2017-01-25 00:13
This post comes from notes I took while learning Elastic Stack. ELK is a combination of three tools: Elastic Search Logstash Kibana When ELK is changed to Elastic Stack, there is a forth tool: Beat There are a lot of information on the net.  I do not want to repeat anything.  I will just write my impressions. […]
Categories: BI & Warehousing

HR Reporting

Mon, 2017-01-16 10:05
HR is an important business function in any company.  It supports business growth.  It also satisfies the compliance requirements.  Reports are required for supporting the HR functions. Typical HR Reporting Requirements HR reports are surrounding the HR function:  Human Resource Planning, Recruitment and Selection, Orientation and Training, Performance Appraisal, Compensation and Benefit. They serves many […]
Categories: BI & Warehousing

How to access Fusion Cloud for building custom BI?

Tue, 2016-12-20 11:22
It was a challenge when we tried to build a BI application for Fusion Cloud application as Fusion Cloud applications, unlike those acquired solutions, such as RightNow, Elouque, and Taleo, do not have web services at that time. It was the reason why Oracle BI Application Configuration Manager was introduced.  It fills the gap by […]
Categories: BI & Warehousing

Use REST API to get the data

Sat, 2016-11-26 10:37
We now see more and more data are available in REST API.  Here are some of the data sources I worked earlier: ServiceNow Table API, REST API for Oracle Service Cloud, Here is a check list to enable a data source for BI: 1. How does the service perform the authentication? In the case of […]
Categories: BI & Warehousing

BI without a data warehouse

Sun, 2016-09-18 11:36
When we think of a data warehouse, we are typically thinking of having a database that store the data and need to design the schema and the ETL program to populate the database.  If we take out the “database” from the above description, will it still be called a data warehouse? I think that a […]
Categories: BI & Warehousing

The future of data warehousing

Thu, 2016-03-17 05:17
Data warehousing is really about preparation of the data for reporting.  The assumption are: You can predicate what typical queries look like to some extent. The data need to be prepared to make the query easier or faster, or make more sense from the data . You know where the data come from and you […]
Categories: BI & Warehousing

How to support Team based security

Wed, 2015-12-16 11:44
Team-based security is referring to a specific data security requirement scenario. Team-based security means that the object being secured has a “team” associated with it.  The team members can access the objects. M:M relationship There is a many-to-many relationship.   A person may be added to multiple teams.  A team can be multiple members. In Siebel […]
Categories: BI & Warehousing

Multiple Tenant Support

Mon, 2015-11-30 15:57
The definition of multi-tenancy varies.  Some people think that the tenants are data stripping and adding a tenant ID to every table is to support multiple tenants. One of such example is Oracle BI Applications.  We added the tenant_id everywhere and assume that we can use it later to partition the data. In the cloud […]
Categories: BI & Warehousing

How to implement Union in ODI and OBIEE?

Mon, 2015-11-16 20:54
When do you need to use UNION in BI? You need to use UNION when you would like to combine the data sets as a single data set.  However, when do you exactly need to do this type of thing in BI or in data warehouse ETL?  Here are some real business cases: 1. Multiple Source […]
Categories: BI & Warehousing

Logical and Physical Schema in ODI

Tue, 2015-11-10 23:28
ODI Topology allows you to isolate the physical connection and the logical data source by defining the physical schema and logical schema. This object may be seen as redundant during development.  However, it is a very useful feature for supporting the Test to Production (T2P) process.  The objects in the design tab references only the logical […]
Categories: BI & Warehousing

Generate Date dimension in PL/SQL Table Function

Fri, 2015-10-30 10:50
Almost all data warehouse have a date dimension.  The purpose of the date dimension is to provide some pre-calculated grouping for dates.  It helps rolling up the data that entered against dates to a higher level, such as year, quarter, month, week, etc. In some system, source files are used in generating the date dimension.  […]
Categories: BI & Warehousing

Use initialization block in OBIEE

Wed, 2015-10-21 13:33
I just add a post about using initialization block in OBIEE. It is a feature I felt excited when I first see the tool. See Page: Initialization Block Before I worked on BI, I worked for EBS application development and was in charge of Multi-Org architecture for a period of time.  EBS Multi-Org is a […]
Categories: BI & Warehousing

Cloud BI Features – Amazon QuickSight

Sat, 2015-10-17 13:56
Here is a list of features available from Amazon QuickSight: Data Source Connect to supported AWS data sources Data Source Upload flat files Data Source Access third-party data sources Data Preparation Data Preparation Tools Visualization Build Visualizations Visualization Access all chart types Visualization Filter Data Data Access Capture and Share, Collaborate Data Access API/ODBC connection […]
Categories: BI & Warehousing

Data Mashup in OBIEE 12c

Wed, 2015-10-14 07:49
Data Mashup is a new feature from OBIEE 12c. It is one of the two main features that OBIEE 12c.  The other one is the visual analyzer. When I tested the data mashup features, it supports these two scenarios.  Extensible Attribute – Extended Dimension Attribute External Benchmark – Extended Fact Both features are accomplished without […]
Categories: BI & Warehousing

Amazon Quick Sight – BI on Cloud?

Thu, 2015-10-08 09:08
In my post Data Warehouses on Cloud – Amazon Redshift, I mentioned that what would be really useful is providing BI on Cloud, not just Data Warehouse on Cloud. I felt that BICS makes more sense comparing to Amazon Redshfit. I discussed with a couple of people last night in a meetup.  Some of them […]
Categories: BI & Warehousing

Do we really need semantic layer from OBIEE?

Mon, 2015-10-05 10:22
Not all BI tools have the semantic layer.  For example, Oracle Discoverer seems not having a strong semantic layer. This page summarizes what OBIEE semantic layer can do for you… BI Platform Semantic Layer I think that if these features can be accomplished in other ways and can be proven that they are not necessary, […]
Categories: BI & Warehousing

Pages