Skip to main content

Data Analytics – Introduction to Hyperion


A popular saying among industry professionals
“data is the new oil”
Implies that data, when harnessed (or, like oil, “refined”) 
properly, can provide high value.


Contents - 
 1. Data Analysis.
 2. Data Analytics.
 3. Business Intelligence.
 4. Enterprise Performance Management (EPM).
 5. Oracle Hyperion Introduction - History.
 6. Oracle Hyperion - Essbase and Planning.
                                   - Planning , Budgeting , Forecasting.
 7. Oracle Essbase Architecture.

Data Analysis 
Data Analysis is separating out a whole into parts, study the parts individually and their relationships with one another.
For example - if we have a whole data set and we are doing analysis on it means we pull sample data set from the whole data and then learn more about it and how it is related to the other samples.

Data Analytics
Data Analytics is the principle or logic that drives the analysis.
For example - As mentioned in before example when we pull the sample and do analysis on it, the techniques or logic we are using to analyse the sample is analytics.

Data Analysis Vs Data Analytics
Data Analysis is focused on understanding the past; what happened.
Data Analytics focuses on why it happened and what will happen next.

Business Intelligence 
Business intelligence involves handling complex technologies and strategies that allow end users to analyse the data and perform decision-making tasks to improve their business.

OLAP - Online Analytical Processing
  • OLAP is the technology behind many Business Intelligence (BI) applications.
  • OLAP performs multidimensional analysis of business data.
  • OLAP - Business Performance Management, Planning, Budgeting, Forecasting, Financial Reporting, Analysis, Simulation Models, Knowledge Discovery, and Data Warehouse Reporting
  • MOLAP - Cube Based we use in EPM tools.

Enterprise Performance Management 
Enterprise Performance Management (EPM) software helps you analyse, understand, and report on your business. EPM is  designed to help organizations plan, budget, forecast, and report on business performance as well as consolidate and finalize financial results (often referred to as “closing the books”).



Oracle Hyperion 
1. It is a EPM tool.
2. Hyperion consists of its own product portfolio belonging to areas like Planning and Budgeting, Financial Consolidation, Profitability and Cost management, Strategic Finance, etc.
3. The main purpose is to help the mid and top level management to gain insight into the relevant tasks like budgeting, forecasting, financial consolidation, profitability analysis, etc

Oracle Hyperion - History
1.1981 - IMRS founded by Bob Thomson and Marco Arese, and launches financial and management consolidation software called 'Micro Control' in 1983.
2.1991 - IMRS becomes a public company and launches a Windows-based successor to 'Micro Control' called 'Hyperion'.
3.1998 - Hyperion Software merges with Arbor and the combined company is renamed Hyperion Solutions..
4.Oracle announced on March 1, 2007 it had agreed to purchase Hyperion Solutions Corporation for $3.3 billion in cash. On 18 April 2007 transaction was completed.
5.Most popular version of Hyperion were 9.3.1, 11.1.1.3,11.1.2.x  versions
6.Currently 11.1.2.4 is running on the market

Planning, Budgeting, Forecasting
Planning - Planning is the process of transforming the strategic goals and objectives of the organization into tactical goals and objectives at the operating level of an organization.
Budgeting - Budgeting is the process of setting revenue and expense targets for a specified period of time, with the budget that results from the process being used to plan and control the allocation of resources. 
Forecasting - Forecasting is a process related to budgeting and planning.  It uses accumulated historical data and management expectations about the future to predict financial outcomes for future months or years.

Hyperion - Essbase and Planning 
Essbase is a database.
Planning is an application that uses Essbase!

Hyperion Essbase 
Essbase is Extended spreadsheet database is an Online Analytical Processing (OLAP) multidimensional database server that extracts data from a wide range of data sources, files, and spreadsheet; calculates and aggregates this data; providing fast access to the results, using a dimensional model. Essbase brings analytics to the business user and enables the business to quickly access business scenarios, forecast outcomes and perform what-if analyses to identify trends.
Hyperion Planning 
Hyperion Planning is an excel and web-driven planning, budgeting and forecasting application to help connect operational assumptions to financial outcomes. Hyperion Planning sits in an application server (relational layer that sits on top of Essbase); between the Essbase database and the client tools that work with it; integrating financial and operational planning processes; leading to improved business predictability. Planning does so by leveraging Essbase multidimensional data model as well as standard relational database management platforms.
Hyperion Essbase Architecture





Comments

Post a Comment

Popular posts from this blog

Business Intelligence

Business Intelligence You must be wondering what is the above imageor title is about. Yeah, it is about the first project I get into. Where the client was using all the above process to generate a report, which will help them to manage their financial planning. So now you must be having an idea that what this blog is about i.e; using Business Intelligence, EPM, ETL and ERP how the financial decisions are taken. Here the client uses the different processes to achieve their goals. So let’s dive in and try to understand the process.  Note - In this blog, you will get an overview of each process and its high-level architecture. Enterprise Resource Planning -  Firstly let's start with  Enterprise resource planning (ERP),  most of the companies store data through ERP. It is a process whereby a company manages and integrates the important parts of its business. ERP system stores both operational and non – operational data. An ERP management information system int
8 comments
Read more

Smart View connection

Smart View connection Before connecting Oracle smart view with essbase. You need to download it from oracle website and install it. installation is easy process..next next next ...finish... Below is the link for downloading smart view. https://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-2412371.html Smart-view Connection – Download Excel and Oracle Smart-view from the web. Open MS Excel – Go to File -> Options Go to Add-in                    Go to Mange and select COMM Add-ins and Click Go Select Oracle Smart View for office and Click OK After the above step you see a SMARTVIEW option in the last of Excel ribbon. Click it!    Now to connect the smart-view with the Essbase server. Click the Panel option. You see an Smart-view panel on the right side. Click the Shared Connections.    After clicking Shared Connections option on the Smart-View P
Post a Comment
Read more

Hyperion Essbase - Administration Services

Administration Services in Essbase. In this blog i m going to briefly discuss about Hyperion Essbase Administration Services. It is this core part of Essbase for managing data in the database. Introduction about Administration Services in Essbase  –   It’s a cross-platform administration tool for Essbase It consists of three tiers Administration Services Architecture – ·         Client Tier (Administration Services Console) – it’s a Java-based client console also called as EAS console (Essbase Administration Services Console). It’s a UI to manage Essbase Environment.              Middle Tier (Administration Server) – it’s a Java-based server maintains communication, session, and security information between console and Essbase server. It uses HTTP and TCP/IP protocols to communicate.        Database Tier (Essbase Servers) – One or more Essbase servers store and process multidimensional database information. Essbase servers can be installed sepa
1 comment
Read more