In the press Closed loop Performance Management at H.Essers This case was first published in IBM Inspire"We have been able to do our financial closing each 10th of the month, Friday, 15 May 2015
Insights Oracle HFM Basics and comparison to SAP BPC In this insight, we try to do a side-by-side comparison of the main functionality of Oracle HFM against SAP BPC, 2 of the leading solutions in the Gartner Corporate/Enterprise Performance Management Magic Quadrant. Both solutions are trying to address one of the major functionalities of CPM : financial consolidation and management reporting.Short History of Hyperion-OracleHyperion started as an independent company IMRS in 1981. Its focus has always been on the EPM-market, initially consolidation.Some major milestones of the company included : Friday, 15 May 2015
Recommended books Building the Data Warehouse Bill Inmon is one of the true pioneers of data warehousing and his "Building the Data Warehouse” is an absolute must read for every self-respecting data warehouse professional. Thursday, 30 April 2015
Insights Drilling across Analysis Services cubes using Power Query IntroductionDrilling across different fact tables is a very important technique when analyzing data from a data warehouse. It gives us the possibility to analyze facts from different fact tables using conformed dimensions. Tuesday, 21 April 2015
Bi-kipedia SAP HANA SAP HANA is an in-memory database platform for processing high volumes of operational and transactional data in real-time. Sunday, 22 March 2015
Bi-kipedia Normalize The state of a database when all repeated values within the database have been removed by creating more tables. Relational OLTP systems are usually highly normalized. Data warehouses typically are not highly normalized.Normalizing data is a process defined by E.F. Codd and boils down to structuring the data into separate and multiple tables to avoid redundancy in the data. Sunday, 22 March 2015
Bi-kipedia Denormalize This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment. Sunday, 22 March 2015
Bi-kipedia Advanced analytics Advanced analytics can be defined as analysis that makes use of mathematical and statistical algorithms. Data mining and BI reporting tools can be used to support advanced analytics. These advanced analytics can be classified in three groups; descriptive analytics (grouping and segmentation), predictive analytics (patterns and anomalies) and optimization analytics (outcome strategies). Sunday, 22 March 2015
Bi-kipedia Driver parameters Drivers are parameters that are used in allocations. A frequently used driver in eg. budgeting is the sales amount. Sunday, 22 March 2015
Bi-kipedia Budgeting A plan of financial activity for a specified period of time indicating all planned revenues and expenses for the budget period. The goal of a budget is to indicate where the business wants to evolve to. Budgeting is setting up pre-allocated amounts for future revenues and expenses for your organization. Most companies will budget one year at a time. Some will budget for 3 years and some companies budget up to 5 years ahead. Sunday, 22 March 2015