You might have an analytics project where you need to add two data sources. But unlike combining strawberries and yogurt so that the ingredients mix smoothly, blending data can leave a bitter aftertaste if not done properly.
This is important specifically as business leaders look to larger and unfiltered data sources (think data lake) or data in multi-structured platforms such as Hadoop or NoSQL to derive insight.
The data may also be incomplete in both sources. For example, data source B might contain new dimensions that extend the attributes of data source A. Or data source B might contain new facts that you can use alongside the measures that already exist in data source A.
Oracle Data Visualization's Data Blending option allows you to control the type of data and how they are joined in a report.
In any given visualization using at least two data sources, the user can directly influence if the report should return all rows from each source, or only the rows that satisfy the matching join on one side or on the other side.
When you add more than one data source to a project, the system tries to find matches for the data that’s added. It automatically matches external dimensions where they share a common name and have a compatible data type with attributes in the existing data source.
For example, you may be aligning your sales territories in Europe and you need to do a cross comparison of population growth between 2009 and 2014. In one data source, you may have some the country codes (BEL, CZE, DEU, etc.) but not the all the country names filled in. With Oracle Data Visualization's Data Blending, you can align data so that the population synchronizes properly, allowing you to create a custom report or virtualization that takes advantage of the data despite the deviations.
The recording below shows how to leverage this option, and the influence in the result set in the report.
Of course, seeing is believing. If you like what you see and you want to try it for yourself, visit www.oracle.com/goto/datavisualization to learn more about Oracle Data Visualization and get your free trial.