Oracle Data Visualization for Strategic Analytics

The world of analytics and data visualization continues to change at a rapid pace. New tools, processes, buzz words (Cloud anyone?) have penetrated our industry and can become overwhelming.  Most of these changes, though, are for the better – one of them being self-service data visualization. Solutions like Tableau, PowerBI, and Qlik have been around for several years, earning reputations as leaders in the self-service, easy, and sexy exploration of data.

Oracle Business Intelligence Enterprise Edition (OBIEE), although a great tool and long-time market leader, lacks ease of deployment, maintenance, and connectivity, and the freedom from “IT tyranny” access to data craved by business users – attributes already addressed by Tableau and others. For many years, I’ve listened to IT describe OBIEE as its enterprise Business Intelligence (BI) solution while business users use Tableau to connect to their own databases and spreadsheets because Tableau doesn’t require them to enter a ticket and potentially wait weeks for that new column to be added to their report.

Today, there is an Oracle tool – Oracle Data Visualization (DV), an Oracle Analytics Cloud (OAC) component,  that exceptionally meets the needs of business users.  Because it is part of a suite of products, Data Visualization also provides enterprise and financial reporting capabilities, advanced analytics and big data, mobile access, what-if scenario modeling, ingestion, preparation and transformation of data, and yes – you guessed it – Cloud.  Some highlights include:

  • Dynamic visualizations that can be organized into stories to be shared across the organization
  • Consumer (drag and drop) style with easy uploads, mashups, and exploration
  • Mobile authoring and consumption, device agnostic, and with dynamic design optimization
  • Connections to dozens of different sources, including SaaS, relational databases, big data tools, NoSQL, and others through JDBC/ODBC
  • Cloud and desktop versions with identical features

The full Oracle Analytics Cloud suite is a comprehensive solution that offers analytics and reporting tools to effectively address business requirements as well as accommodate different users within an organization (analysts, consumers, admins, etc.). Also included with OAC is Business Intelligence Cloud Service (BICS), a tool that is essentially “OBIEE in the Cloud.”  Data Visualization and BICS complement each other and address different needs, summarized in the following:


With continued rapid changes inevitable in technology, the future of Oracle Analytics Cloud will likely be promising as additional components are added. After seeing and supporting clients as they “take the plunge” into Cloud analytics, it becomes clearer that Data Visualization is Oracle’s strategic future of analytics.

See an overview of the history of Oracle DV and OAC as well as a demonstration of the products’ main features and wide array of possible sources in this webinar: The Strategic Future of Analytics…Starring Oracle Data Visualization

The True Power of Oracle’s Enterprise Planning Suite Unleashed at POET: A Case Study

Enterprise Planning and Budgeting Cloud Service“If you are going to change the world, you need a system to help get you there. For us, it was… about strategic opportunities. POET was at a crossroads. We needed a system that we could grow with and that could grow with us.”
Lezlee Herdina, Director of FP&A, POET

A privately held corporation headquartered Sioux Falls, South Dakota, POET LLC is a U.S. biofuel company that specializes in the creation of bioethanol. The 1,900-employee company produces 1.8 billion gallons of ethanol annually and has been granted 90 patents in the U.S. and abroad.

In this webinar, Edgewater Ranzal’s Managing Director and HSF Practice Director Ryan Meester speaks with Lezlee Herdina, POET’s Director of FP&A, to give us a behind-the-scenes look into POET’s Enterprise Planning Solution journey, from realizing that significant change was needed to an extensive evaluation process to the ultimate solution and, finally, to the company’s enduring vision going forward.

The Right Tool for the Right Job (RTRJ)

While Lezlee and the POET team were open to the insights and recommendations generated by their Ranzal analysts, they also had some specific goals in mind from the outset:

  • Provide seamless integration of financial and operational data
  • Create a platform for process improvement, including implementing greater automation in monthly processes improving efficiency and increasing time for value-add analysis
  • Achieve better communication, including ease of reporting
  • Reduce reliance on Excel models and associated version control issues
  • Improve data governance, with clarity of data model with common definitions to facilitate planning and reporting processes
  • Integrate operational and financial dashboards for performance measurement
  • Use of scenario analysis to drive M&A and strategic business decisions
  • Increase emphasis on cash perspective
  • Understanding when to use SmartView, Financial Reports, and Oracle Business Intelligence Enterprise Edition (OBIEE), as well as take full advantage of the strengths of each of the Reporting Tools
  • Keep it simple, and trust in the higher level nature of HSF
  • Recognize the important nature of the user experience
  • Ensure that data integrations are seamless for the end-user

To learn more about the POET team’s initial ongoing business challenges, the lessons learned, and the ultimate results, view a recording of True Power of Oracle’s Enterprise Planning Suite Unleashed at POETwebinar.

To learn more about our Enterprise Planning solutions, visit

Missed the webinar? View Recording Here.

Introducing Strategic Modeling: Oracle’s HSF Cloud Offering

It’s no secret that Oracle, along with the rest of the software industry, has been moving swiftly to the Cloud over the past few years.

Within Oracle’s Enterprise Performance Management platform, this transition began in 2014 with the launch of Planning and Budgeting Cloud Service (PBCS). In 2016, Oracle added out-of-the-box content to solve specific business challenges in areas like Workforce Planning and Capital Planning and bundled that with existing PBCS functionality to create Enterprise Planning and Budgeting Cloud Service (EPBCS).

Now in 2017, Oracle continues the impressive build-out of its Cloud offering with the introduction of Strategic Modeling, a new product that facilitates long-range planning and financial modeling in the Cloud.

As part of Oracle’s EPBCS bundle, the Strategic Modeling module is available at no additional cost to customers who already have purchased EPBCS. While Strategic Modeling is “new” in the sense that this functionality has never before existed in its Cloud offering, the module actually has its roots in Oracle’s Hyperion Strategic Finance (HSF) product and will look similar to HSF for those who are familiar with its on-premise capabilities.

Take Your Strategic 264

Robust. Flexible. Versatile.

Strategic Modeling provides customers with a multitude of out-of-the-box functionalities built to simplify and enhance financial modeling processes.

In particular, it adds robust capabilities in the area of Balance Sheet and Cash Flow forecasting that were either missing or limited in prior incarnations of the EPBCS suite. It also adds scenario-modeling capabilities that can be created and driven by end users on the fly as they are responding to questions or requests from Senior Management.

While Strategic Modeling provides significant incremental capabilities to EPBCS, it also leverages many common components of the suite to make the user experience consistent. For example, it provides both a Web and an Excel user interface allowing users to create models and report in the tools with which they are already comfortable. The user interface, navigation, data integration and reporting capabilities are the same across all components of EPBCS, which provides a seamless user experience across the platform.

Strategic Modeling Capabilities

Organizations often try to build strategic plans in Excel or by extending the time horizon of their budgeting applications. All too often, these patchwork solutions fall short primarily because they make use of tools that were not intended for strategic planning.

Strategic Modeling, on the other hand, was built specifically for this purpose and provides numerous out-of-the-box capabilities to address challenges in this area. The following is a sampling of some of the key pre-built capabilities that organizations can utilize to streamline and enhance their strategic planning processes:

  • Fully Integrated Financial Statements: The standard template that ships with Strategic Modeling contains an integrated Income Statement, Balance Sheet and Cash Flow Statement. The Balance Sheet will automatically balance based on the cash position as derived on the Cash Flow Statement. The circularity inherent in Interest Income/Expense calculations (i.e. as Cash increases, Interest Income increases, which leads to more Cash) is automatically solved for by the system.
  • What-if Capabilities: Strategic Modeling greatly facilitates the process of creating on-the-fly scenarios and comparing them against the base case or other scenarios. Scenario Modeling capabilities are designed for end users to create and run and provide immediate results to key strategic questions.
  • Robust Funding Capabilities: Strategic Modeling has a Funding Routine that allows users to specify a prioritized order of how cash deficits will be funded (e.g. Sell Marketable Securities, Draw upon a Revolver or Issue Commercial Paper, Issue Long-Term Debt or Equity) and how cash surpluses will be utilized (e.g. Pay Down Debt, Share Buyback, Dividends, Buy Marketable Securities).
  • Debt Scheduler Utility: A guided user interface allows for easy input of the parameters for a new debt issuance. Strategic Modeling then will calculate and perform all of the accounting for items such as Accrued Interest, Amortization of Debt Issue Costs and Current Portion of Long-Term Debt.
  • Integrated Enterprise Planning: Strategic Modeling is part of Oracle’s EPBCS Suite and as such benefits from tight integration with the other processes (Financials, Capital, Projects, Workforce) and the reporting cubes of EPBCS. This integration allows users to quickly and easily move data from their detailed budgets and operating plans to their strategic plans within Strategic Modeling. Once the strategic plan is complete, data can be easily exported as higher-level targets to seed the budget process.

Whether you own already own EPBCS and are interested in deploying the Strategic Modeling module, you are an existing HSF customer looking to move to the Cloud or you are new to Oracle and its Cloud offerings, Strategic Modeling has a compelling use case for all organizations looking to improve their modeling and strategic planning capabilities.

Register for our “Take Your Strategic Planning to New Heights” webinar: Please join us for our webinar on July 18, 2017, to see a demo of Strategic Modeling in action and to learn more about its capabilities — register here.

Missed the webinar? View the recording here.