Search

SAP HANA is an in-memory database platform for processing high volumes of operational and transactional data in real-time.

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.

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.

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).

Drivers are parameters that are used in allocations. A frequently used driver in eg. budgeting is the sales amount.

Big data is a much discussed and hyped topic in IT land nowadays, but its true meaning is not always that clear and easy to define.

Analysis is the systematic process of separating or breaking down complex informational materials into smaller components in order to comprehend their relationships. It is a careful examination of facts and data to reveal the cause and effect, and other relationships in order to make conclusions that allow better decision-making and problem-solving.

Alerts and notifications refer to any automated signals or short messages that may be sent through a SMS, an email or an indicator in a dashboard or report. They are a call to action after a specific event has occurred. They are also used to assign tasks or inform the recipients about certain urgent issues. Alerts can be the result of the outcome of a report or specific queries.

A data scientist is a job title for an employee or business intelligence (BI) consultant who excels at analyzing data, particularly large amounts of data, to help a business gain a competitive edge. To do so, the employee is using statistical & data mining techniques. 

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.