BizTech_Blog_Header

BizTech Blog

Stephen Goldsmith

Stephen brings over 20 years of experience in helping organizations achieve a competitive advantage through improvements in business processes and information systems. With a history of building custom data warehouse solutions as far back as the early 90’s, Stephen has helped countless organizations uncover business knowledge from the vast amounts of data hidden in their operational manufacturing, financial, sales, marketing and project management systems. Stephen joined BizTech in 2010, as the Director of Business Intelligence and Analytics. His role builds upon the growing Business Intelligence market and positive results BizTech has experienced with Oracle’s packaged Business Intelligence applications.
Find me on:

Recent Posts

Whole Lotta Love: Closing the Books on Stressed Out Accountants

Author: Stephen Goldsmith Date: May 6, 2013 1:19:00 PM

Categories: Hyperion EPM

 

My last blog (Here, There and Everywhere: Business Intelligence on the Go) discussed how Companies can use Oracle 'Business Intelligence on the Go' tools to improve visibility into real data from almost any location in the world using little more than a cell phone. The response was very positive, perhaps owing to the fact that it had a Beatles theme to it. Fun, full of sunshine and hope, and providing answers to questions that many had pondered for seemingly forever, they and the article, was well received. After all, who doesn’t like the Beatles?

Read More

Here, There and Everywhere: Oracle Business Intelligence On The Go

Author: Stephen Goldsmith Date: Jan 25, 2013 3:54:00 PM

Categories: Oracle Business Intelligence

I am a self-proclaimed Beatles fanatic, as well an Oracle Business Intelligence and Mobile technology enthusiast. Believe it or not, these qualities aren’t necessarily mutually exclusive. Not anymore. When I think about the availability of Oracle Business Intelligence metrics, dashboards and reports on the go, I am often reminded of the great Beatles Song, Here, There and Everywhere (Paul McCartney’s favorite Beatles song.)

In today’s fast paced environment, managers need the latest information, access to reports, updates on customers and clients and the ability to see key performance metrics on a daily basis. The need to react to critical information almost instantaneously is the biggest change in the business world in the past ten years.

Read More

Consolidation and Reporting Simplified with Oracle Hyperion Financial Management

Author: Stephen Goldsmith Date: Dec 11, 2012 1:45:50 PM

Categories: Hyperion EPM

In all my years in accounting, by far the most difficult part of the month end close was the consolidation of entity general ledgers into one group of financial statements. Consolidation in Financial Accounting may best be described as a“ financial reporting technique that helps a firm summarize all operating data under a single set of financial statements in accordance with industry standards, accounting principles and regulations.”

Read More

Oracle Hyperion Planning vs. Other Budgeting Tools

Author: Stephen Goldsmith Date: Nov 19, 2012 3:13:00 PM

Categories: Oracle Business Intelligence, Hyperion EPM

Oracle Hyperion Planning: Simply the Best. By combining prepackaged software with business intelligence capabilities and proven best planning practices, next-generation enterprise planning solutions optimize business planning across the enterprise. With the right enterprise planning technology in place, you will be able to drive collaborative, integrated event-based planning at all levels of your organization and with all appropriate participants.

Read More

Integrate, Consolidate, Translate, and Validate using Oracle Hyperion Financial Management

Author: Stephen Goldsmith Date: Nov 1, 2012 9:52:00 AM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Oracle Hyperion Financial Management (HFM) is a comprehensive, Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution.

HFM utilizes today's most advanced technology, yet is built to be owned and maintained by the enterprise's finance team.

Read More

Less Paralysis, More Analysis

Author: Stephen Goldsmith Date: Oct 26, 2012 1:50:00 PM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Enterprise Performance Management (EPM) is defined as a management field of Business Performance Management which considers the visibility of operations in a closed-loop model across all facets of the enterprise. There are several emerging domains in the EPM field which are being driven by corporate initiatives, academic research, and commercial approaches including: Strategy Formulation, Business Planning and Forecasting, Financial Management, and Supply Chain Effectiveness.

Read More

Operating Room Business Intelligence, Lessons Learned from Manufacturing Companies

Author: Stephen Goldsmith Date: Oct 22, 2012 2:16:36 PM

Categories: Oracle Business Intelligence

With continued mounting pressures to reduce healthcare costs, healthcare providers can leverage the lessons learned in the 90’s by the world’s leading manufacturing companies. This blog is the first in a series of blogs that will discuss how healthcare organizations can employ manufacturing best practices to reduce costs, increase efficiency and improve patient satisfaction. Given that this is a business intelligence blog, the focus will be on how existing data can be transformed into information to achieve the aforementioned healthcare objectives.

The first area of focus, the operating room, has several manufacturing parallels. Think of an operating room as a machine that is very expensive to operate and has a fixed amount of capacity that must be optimally used to maximize utilization. Downtime due to poor scheduling or delays in preceding processes impacts utilization, output and customer satisfaction.

Read More

Four CSV files for OBIA Financial Analytics

Author: Stephen Goldsmith Date: Oct 22, 2012 11:42:00 AM

Categories: Oracle Business Intelligence

Group Accounts ranges varies from client to client and that is the reason why the user is given the ability to enter their input defining the group accounts for accounting purpose in OBIA.

But there is a standard anyone has to follow for defining the group accounts. There are three csv’s that help you define the group accounts and those group accounts fall into either Balance Sheet or P&L:

Read More

OBIEE 11.1.1.6.2 issues

Author: Stephen Goldsmith Date: Oct 22, 2012 9:54:00 AM

Categories: Oracle Business Intelligence

The latest bundle patch set has been available for OBIEE for a few months now. We have noticed an issue where the SQL generated by the RPD is different after the Patch set is applied.

Read More

Oracle Hyperion: A Better Plan for Planning

Author: Stephen Goldsmith Date: Oct 17, 2012 3:34:00 PM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Does this Typical Planning (Budget) Process sound familiar?

Read More