Business Analytics solutions help Financial Services organizations of all sizes thrive by enabling them to discover new ways to strategize, plan, optimize business operations, and capture new market opportunities.
Know More about Your Organization. Gain more insight across more data and drive better outcomes.
Drive Insight and Innovation. Fast, easy insight into your business can mean the difference between failure and success.
Business Analytics gives you smart new ways to see the signals in your data. Do your own visual analysis to find new patterns at a glance. Blend any data with a click, then share insights as a visual story.
Plan and forecast with greater precision. Accelerate your financial close and reporting process, with greater transparency and confidence.
Life Sciences & Health
Put Gibney Consulting’s depth of experience with hundreds of EPM systems to work for your business. Leverage our expertise for your business.
Engineering & Construction
Problem: The Hyperion Financial reports developed by another consulting company did not meet the clients requirements
Solution: After discussing the issues with the current set of reports we developed a plan, prioritized tasks and executed the plan. After 1 week all high priority were accepted by the users and after 4 weeks all reports were complete.
Problem: The chart of accounts were permanently changed and 2 new dimensions needed to be added to the Hyperion Planning application.
Solution: The solution required the old chart of accounts to be remapped to a new chart of accounts and also the two new dimensions added based off a mapping table. This was solved using SQL DTS, SQL Server relational database and Hyperion Planning.
Problem: Allied Irish Banks wanted the ability to analysis their data at an aggregated level and then easily drill back into the details
Solution: The solution was to develop an Essbase Integration Services application combined with a star schema relational database. This allowed end users to to drill back to the relational database details from the Essbase Excel Add-In.
Problem: Complex modelling was being performed in Excel. Different plan iterations were cumbersome and slow. Financial Analysis and Reporting were also inflexible.
Solution: The solution was to implement Essbase to perform the heavy calculations and then use SmartView Excel Add-In which allowed users to still leverage the power of Excel. Plan iterations which typical were taking 2 weeks to perform were now taking 2 hours.
Problem: The business had outgrown existing Hyperion Planning application.
Solution: The solution was a complete redesign and redevelopment of the application with the current set of business requirements. Minimum maintenance and maximum flexibility were key drivers in this solution.
Problem: Complex Budgeting and Forecasting processes for a large number of entities and employees.
Solution: The solution significantly simplified the planning process by leverage the power of ODI, Hyperion Planning, Essbase and Financial Reports. It also allowed for maximum flexibility in the model as business requirements evolved over time.
Problem: Prospect Mortgage had a dynamic and complex reporting requirement with existing reports changing frequently and the addition of new reports.
Solution: The reporting solution was delivered using a Data Mart, Hyperion Essbase Studio, Hyperion Essbase, SmartView and Financial Reporting
Problem: Existing Budgeting and Forecasting excel models were very slow and inflexible
Solution: Designed and Developed new Budgeting and Forecasting model with maximum speed and flexibility
Problem: Onsite Otsuka Hyperion Administrators overwhelmed with user requests and development tasks
Solution: We provided support services to augment onsite Hyperion Administrators and provide backup at critical periods
Problem: The old Freelance model was excel based and therefore inflexible and prone to error
Solution: Designed and Developed new Freelance model that much more flexible and accurate
Problem: Existing Transfer Pricing model did not provide enough detail for deep analysis
Solution: Designed and Developed new Transfer Pricing model with enhanced capabilities for deep analysis
Data maps are maps between a source application and a reporting application. In PBCS this would typically be a Source Planning Application (BSO) and a Target Reporting Application (ASO). But could also be a Source Workforce Planning Application (BSO) and a Target Income Statement Application (BSO). In the example below we willMay 15, 2018
Data maps are maps between a source application and a reporting application. In PBCS this would typically be a Source Planning Application (BSO) and a Target Reporting Application (ASO). But could also be a Source Workforce Planning Application (BSO) and a Target Income Statement Application (BSO). From an Essbase/Hyperion Planning world then Data MapsMay 14, 2018
PDF Version of this blog is in the link above. Click to download. This step by step process shows you how to unpivot data using Excel Power Query for loading into PBCS. What is Excel Power Query? In Excel 2010 and Excel 2013 it is an Excel Add. In Excel 2016 itMay 9, 2018
This step by step process shows how to create Dashboards in PBCS. The process is relatively straightforward. PBCS allows you to turn any Web Form into a chart which can be displayed in a dashboard. In the example below, we are using the Vision application that comes with PBCSNovember 7, 2017
Would you like to speak to one of our consultants over the phone? Just submit your details and we’ll be in touch shortly. You can also email us at email@example.com if you would prefer.