Business Intelligence Articles

(See also: BI & Data Warehousing Technology topic)

Best of Both Worlds: Combining R with SQL for Data Analysis [November 2017]
By Yuli Vasiliev
Using Oracle R Enterprise, unleash the power of Oracle SQL when performing data analysis with R.

Learning R for PL/SQL Developers - Part 2 [September 2017]
By Arup Nanda, Oracle ACE Director
2 part series that presents a fast ramp for learning R for DBAs who are already familiar with PL/SQL. Part 2 presents more advanced concepts of the R language such as evaluating conditions, executing loops, and creating program units such as functions.

Learning R for PL/SQL Developers - Part 1 [September 2017]
By Arup Nanda, Oracle ACE Director
2 part series that presents a fast ramp for learning R for DBAs who are already familiar with PL/SQL. In this series of articles, you will learn the R language elements in parallel to the PL/SQL language.

Integrating HFM with ODI Metadata Knowledge Modules [June 2017]
By Ricardo Giampaoli and Rodrigo Radtke
This article focuses on how you can achieve metadata load to Hyperion Financial Management using Oracle Data Integrator Knowledge Modules (KMs) built using the Java HFM API.

Machine Learning with R in Oracle Database [May 2017]
By Yuli Vasiliev
Learn to leverage the power of Oracle Database when performing data analysis with R.

Tell the Story [January 2017]
by Mark Rittman
Use Oracle Data Visualization Desktop to present information and insights.

Building a 100% Cloud Solution with Oracle Data Integrator [January 2017]
by Ricardo Giampaoli and Rodrigo Radtke
The "BI Guys from Brazil" illustrate how to create big BI projects with seamless ODI integrations on premise or in the cloud.

Social Network Analysis [September 2016]
by Mark Rittman
Use Oracle Big Data Spatial and Graph to analyze social networks.

Prepare, Secure, and Publish [March 2016]
by Mark Rittman
Automate ingesting, profiling, and transforming data so you can use it in the big data cloud and other environments.

Create a Data Reservoir with Oracle GoldenGate [November 2015]
by Mark Rittman
Replicate and stream data from Oracle Database 12c to Oracle Big Data Appliance.

The Young Person's Guide To Essbase Cube Design [October 2015]
by Martin Neuliep
This sample chapter from Developing Essbase Applications: Hybrid Techniques and Practices (2015, CRC Press), was written with the objective of providing you with the next level of information you need to succeed with Essbase after you've learned the basics.

Add Data Visualization and Discovery [September 2015]
by Mark Rittman
Add data visualization and discovery with Oracle Business Intelligence Visual Analyzer Cloud Service.

Automatically Generated Focused Aggregations for Essbase Block Storage Option [September 2015]
by Dmitry Kryuk
Dmitry Kryuk's article presents a process for automatically generating focused aggregations for Essbase and Hyperion Planning in order to run efficient focused calculations, allow users to work in a familiar manner, and keep budgets under control.

Taking Your OBIEE to the Next Level with SmartView VBA [June 2015]
by Steve Yeung
Steve Yeung's article walks you through an advanced approach to starting your own Smart View for OBIEE, using Excel Visual Basic for Applications (VBA). The objective is to inspire you with what you can do with Smart View by providing solutions that do not exist in the current OBIEE versions.

Upload, Model, Analyze, and Report [May 2015]
by Mark Rittman
Quickly load information to Oracle Business Intelligence Cloud Service and share the reporting.

Oracle BI Applications 11g: GoldenGate Integration [April 2015]
by Michael Rainey Oracle ACE
Oracle ACE Michael Rainey's technical article walks you through we'll walk through the architecture and setup for using GoldenGate 11g with Oracle BI Applications

Sentiment Analysis Using Oracle Data Miner [January 2015]
by Brendan Tierney
Use Oracle Data Miner to build a Sentiment Analysis model of customer product reviews.

In-Memory Analytics Speeds Business Intelligence [January 2015]
by Mark Rittman
Supercharge business intelligence with Oracle Database In-Memory.

Demystifying Hyperion EPM Versions, Patching, and Upgrading [January 2015]
by Eric Helmer
This article by Oracle ACE Director Eric Helmer "attempts to demystify the current Oracle versioning scheme for Hyperion-oriented customers, and to clarify when and how to apply patches and upgrades."

Dynamic Integrations for Multiple Hyperion Planning Applications [December 2014]
by Ricardo Giampaoli and Rodrigo Radtke
This article by Ricardo Giampaoli and Rodrigo Radtke describes how they implemented a smart EPM environment that uses Oracle Data Integrator (ODI) and Oracle Hyperion Planning repository, creating a centralized, reliable, responsive and extremely flexible development architecture to support business requirements.

Big Data Meets Business Intelligence [September 2014]
by Mark Rittman
Explore Oracle Big Data Lite Virtual Machine examples and tutorials to see how big data gets reported.

Go with the Flow [May 2014]
by Mark Rittman
Oracle Data Integrator 12c delivers new flow-based mappings and deployment specifications.

Speed Mobile [January 2014]
by Mark Rittman
Quickly deploy line-of-business mobile business intelligence apps with Oracle Business Intelligence Mobile App Designer.

Integrate and Analyze [November 2013]
by Mark Rittman
Combine structured and unstructured data for analysis and new insights.

Cookbook: Installing and Configuring Oracle BI Applications [August 2013]
by Oracle ACE Director Mark Rittman and Kevin McGinley
A step-by-step guide to installing, configuring, and loading an initial set of tables within Oracle BI Applications, using data sourced from Oracle E-Business Suite 12.1.

New Spaces for BI [May 2013]
by Mark Rittman
Integrate Oracle WebCenter Portal's Spaces feature and Oracle Business Intelligence Enterprise Edition to create custom business intelligence application pages.

Leveraging Oracle Scorecard and Strategy Management for Everyday BI Needs [November 2012]
by Kevin McGinley
A technical overview of the Oracle Scorecard and Strategy Management features in OBIEE.

Configuring Oracle Business Intelligence 11g MDS XML Source Control Management with Git Version Control [September 2012]
by Christian Screen
A tutorial for those interested in learning how to configure the Oracle Business Intelligence 11g ( metadata repository for development using the new MDS XML source control management functionality.

Lighten the Load [September 2012]
by Mark Rittman
Oracle Data Integrator 11g makes data loading flexible, restartable, and routine.

Working with the Summary Advisor [May 2012]
by Mark Rittman
Create in-memory aggregates for better performance on Oracle Exalytics In-Memory Machine.

On the Road with BI [Mar. 2012]
by Mark Rittman
Oracle Business Intelligence Mobile gives your iOS device the business.

Migrating Oracle Discoverer Data to Oracle Business Intelligence 11g [Feb. 2012]
by Edelweiss Kammermann
Plan your migration project, step by step.

Automating Oracle Business Intelligence Administration [Oct. 2011]
by Mark Rittman
Use the Oracle BI Systems Management API to automate administrative tasks.

Upgrade to Oracle Business Intelligence Enterprise Edition 11g [June 2011]
by Mark Rittman
Take advantage of the latest OLAP analysis, mapping, KPI, and scorecard features.

Putting Business Intelligence on the Map [Apr. 2011]
by Mark Rittman
Map geographies and business information together to see results.

Advanced Dimensional Design with Oracle Warehouse Builder [Apr. 2011]
by Yuli Vasiliev
Learn how to go beyond the wizards to build dimensional objects.

Cube Development for Beginners [Apr. 2011]
by Yuli Vasiliev
Get the basics of data warehouse development using Oracle Warehouse Builder 11g.

Take the Next Step [Mar. 2011]
by Mark Rittman
Use Action Framework to start business processes from report information.

Quickly Define KPIs and Scorecards That Use Them [Jan. 2011]
by Mark Rittman
Build key performance indicators and scorecards in your business intelligence metadata with Oracle Business Intelligence Enterprise Edition 11g.

Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases [Aug. 2010]
by Mark Rittman and Venkatakrishnan Janakiraman
Take advantage of new persistent calculation and allocation capabilities for planning and budgeting applications.

Oracle Essbase Studio Deep-Dive [Mar 2010]
by Christian Screen
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities.

Building a Cube [01-Jan-2010]
by Tracy McMullen and Edward Roske
Learn the basics of building an Oracle Essbase aggregate storage database.