Actionable intelligence
Read more
Ad Hoc Reporting
Read more
Big Data
Read more
Business Intelligence
Read more
Cloud Computing
The cloud, or cloud computing, is a type of storage that uses a network of physical locations to store software, hardware and services that run on the internet rather than on your device. The cloud is an all-encompassing term that includes Read more
Cognitive Analytics
Cognitive Analytics is intelligent technology that covers multiple analytical techniques to analyze large data sets and give structure to the unstructured data. To put it simply, a cognitive analytics system searches through the data that exists in its knowledge base Read more
Collaboration
Read more
Dashboard
Read more
Data Aggregation
Read more
Data Exploration
Read more
Data Governance
Read more
Data Lake
Read more
Data Mashing
Read more
Data Mining
Read more
Data Modeling & Management
Build the Reports That You Need When You Need Them Data Modeling & Management Orbit’s data modeling functionality achieves highly-tuned queries by identifying the objects needed from multidimensional data relationships. You can build reports as per your business requirements to Read more
Data Scientist
Read more
Data Security
Read more
Data Visualization Dashboards
Simple, Intuitive, and Powerful Dashboards Data Visualization: Dashboards Orbit Reporting and Analytics brings all of your data together in real-time and interactive dashboards, so you can gain a clear view of your business – at a glance. View Data from Read more
Data Wrangling
Read more
Descriptive Analytics
Read more
Edge Analytics
Edge analytics is a method of data collection and analysis that uses an automated analytical data computation that is performed at a sensor or other device. This is performed before the data is sent to a centralized store. This process Read more
Financial Statements
Financial statements are reports on companies’ spending and fiscal positions. These statements can be audited by the government to prevent tax fraud and other illegal activities. Financial analysts use these statements to analyze a company’s performance, then use that information Read more
Hierarchies
These are the methods which use parent-child relationship to drill up/down the data. Hierarchies use parent-child relationships within the data, so that a user can go deeper in order to gain a better insight into the information they are responsible Read more
Hybrid Cloud
Hybrid cloud infrastructure is a combination of at least two cloud infrastructures, such as private, public or community, that remain individual but are connected by standardized technologies that allow data portability. On its most basic level, this means that hybrid Read more
JD Edwards
JD Edwards is a suite of enterprise resource planning (ERP) software from Oracle. Focused on a modern and simplified user experience, the purpose-built applications are aligned to create a seamless experience for end users that’s integrated with digital technologies. JD Read more
Key Performance Indicator (KPI)
A measure of key business objectives of an organization. A Key Performance Indicator (KPI) is a measure that determines how effectively, or ineffectively, organizations, projects or individuals achieve their key business objectives compared to their strategic objectives and targets. With Read more
Metadata
Metadata is data that contains information about other data. Metadata, in general, is used almost everywhere. The most common example is the use of meta tags in a web page. Search engines use these meta tags to identify a web Read more
Mobile BI
Mobile Business Intelligence (Mobile BI) is software that allows BI data to be viewed on a mobile device. Mobile BI has just recently become popular among BI users, and is helpful for remote workers that need information but do not Read more
Multi-tenant
Read more
OLAP
Read more
OLTP
OLTP is an initialism for Online Transaction Processing. This is a type of software program that is designed to support transaction-oriented application processing. Online transaction processing systems are used in business for handling processes like financial transactions, order entries, customer Read more
On-Premises
On-premises architecture is comprised of data, software and applications that are installed and operated from an in-house server and computing infrastructure. It utilizes the organization’s native computing resources. It is the traditional method for storing data and running enterprise applications, Read more
Pivot Table/Crosstab
Pivot tables and crosstabs are ways to display and analyze sets of data. Both are similar to each other, with pivot tables having just a few added features. Pivot tables and crosstabs present data in tabular format, with rows and Read more
Pixel Perfect (Printable Reports)
Pixel perfect describes reports where the user can manipulate the size and layout with precision. This includes allowing the user to change the size of the report, the size of the printed page, and the position of the different elements Read more
Predictive Analytics
A part of advanced analytics to make future forecasts. Predictive analytics are a part of advanced analytics that provide a probable picture of what might happen in the future. Considering the previous behaviors from the descriptive analytics, predictive analytics might Read more
Prescriptive Analytics
It provides a best course of action taking a clue from predictive and descriptive analytics. Prescriptive Analytics is the final stage of Business Analytics (BA) that takes insights from descriptive and predictive analytics to identify the best course action for Read more
Query
A database query is a means for extracting data from a database and formatting it in a readable form. When you’re searching for data from a database, you can submit a query to request specific information. However, a query needs Read more
SAP HANA
Read more
Scheduling
An automated process of refreshing the jobs or reports on a regular basis. Scheduling is a process of planning any event or a job at a required time. Similarly, on the technical front, scheduling helps in automating the required procedure Read more
Subject Area Modeling
An initial level of Enterprise Data Model (EDM), which provides a structure for organizing EDM by Subject Areas. A Subject Area Model, together with a Conceptual Model and a Conceptual Entity Model forms the complete structure of the Enterprise Data Read more
Tabular Data
The term “tabular” refers to data that is displayed in columns or tables, which can be created by most BI tools. These tools find relationships between data entries in one or more database, then use those relationships to display the Read more
Taleo
The Oracle Talent Acquisition Cloud (Taleo) is a data-enriched talent management software suite that helps organizations find, develop and retain prime talent. Taleo History Oracle acquired this cloud-based talent management software in 2012, though it was founded in 1999 by Read more
Home | Glossary

Data Warehouse

A data warehouse is loaded with data from numerous heterogeneous sources into a central repository for analytics. Data warehouses store multidimensional information in a way that allows analytics to be efficiently performed. Data warehousing helps organizations in effective decision-making, and is at the heart of business intelligence.

Unlike operational databases where data is frequently updated as transactions occur, updates are scheduled at intervals in a data warehouse. Additionally, data warehousing provides an organization access to current and historical data to analyze its performance to strategically plan its future.

Data warehousing supports Online Analytical Processing tools, which help in multi-dimensional data analysis. In data warehousing, data mining works together with OLAP operations to boost knowledge mining at multiple levels of abstractions.

Data warehousing uses three techniques to analyze data: Data Mining, Analytical Processing, and Information Processing. The functions of the data warehousing utilities are data extraction, data cleansing, data transformation, data loading, and refreshing.

Advantages of Data Warehousing

Data warehousing…

  • Provides higher data consistency.
  • Provides enhanced query performance.
  • Cleans the data using data cleansing.

Applications of Data Warehousing

Data warehousing is used in many businesses to easily combine data from multiple sources. For example, a business may combine customer information from its website, sales history from cash registers, and information from comment cards into one data warehouse. From there, data mining can be used to look for patterns that will help the company make informed business decisions.

Related Links

Streamlining ETL/ELT Processes

Oracle Cloud ERP Applications Data to Data Warehouse

Extracting Data for Data Warehouses

Automate and Sync Data with Amazon Redshift

Operational Reporting vs Analytics

Turn Your Data Challenges Into Opportunities. Get Started TODAY.


    Featured Resources / Insights

    Fact Sheet

    GLSense: Integrated Financial Reporting for Excel Users

    Download now

    Whitepaper

    Your Guide to Choosing the Right GL Reporting Solution for Oracle Fusion Cloud ERP

    Download now

    Webinar

    Unified Reporting from Oracle EBS, Oracle Cloud and Beyond

    Access now

    Blogs