X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 building the data warehouse olap

Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Warehouse Management System (WMS) RFI/RFP Template

Warehouse Configuration, Bin Location Setup, Receiving, Inventory Control, Packing and Shipping, Picking, Adaptability, Technology Configuration, Product Technology 

Evaluate Now

Documents related to » building the data warehouse olap

Ask the Experts Question: Do Organizations Really Need a Physical Data Warehouse Structure?


We recently had a question from one of our readers (through our Ask the Experts page) discussing QlikView’s approach to data collection. Reader’s Question “QlikView says its innovative way of collecting data and not needing a physical data warehouse (DW) structure is the right thing to do in DW/business intelligence (BI) solutions. Can one expect to build a sustainable / scalable corporate

building the data warehouse olap  as well as the building of dimensional hierarchies—for online analytical processing (OLAP). It seems impressive and merits further reading. •    The company does claim to support the “no data warehouse” model. Data from a number of sources can—in theory—be loaded into memory. Of course, memory requirements are proportional to the size of the data. •    Does the company support data quality and data cleansing? It seems to support data cleansing on the fly, but I think this needs some Read More

Distilling Data: The Importance of Data Quality in Business Intelligence


As an enterprise’s data grows in volume and complexity, a comprehensive data quality strategy is imperative to providing a reliable business intelligence environment. This article looks at issues in data quality and how they can be addressed.

building the data warehouse olap  A unified approach to building organization-wide application systems is paramount to ensure that entities are described consistently across multiple systems within an organization. Master data management is growing in importance and relevance. Although this article does not delve into this subject, it is important for organizations to put in place the necessary tools and processes for master data management. Data through the Looking Glass Data quality issues can certainly be minimized in data sources. Read More

Best Practices for a Data Warehouse on Oracle Database 11g


Companies are recognizing the value of an enterprise data warehouse (EDW) that provides a single 360-degree view of the business. But to ensure that your EDW performs and scales well, you need to get three things right: the hardware configuration, the data model, and the data loading process. Learn how designing these three things correctly can help you scale your EDW without constantly tuning or tweaking the system.

building the data warehouse olap  on Data Warehousing | Building the Data Warehouse | Term Data Warehouse Lists | Expensive Data Warehouse | Data Warehousing Provides | Data Warehouse Appliance Consists | Data Warehouse Info | Implementing Data Warehouse | Data Warehouse Process | Implementing Real Time Data Warehousing | Data Warehouse System Complete | Data Warehouse EDW | Data Warehouse Architecture EDW | Data Warehouse Concepts EDW | Data Warehousing Information Center EDW | Data Integration Paper EDW | Data Warehouse Software EDW | Read More

SAS Institute Shoots for the Two-Stop-Shop with new Release of Warehouse Administrator


SAS Institute, a vendor of integrated data warehousing, decision support and information delivery software, has announced the production availability of SAS/Warehouse Administrator® software, Version 2.1. With an open component-based architecture, improved data access and management capabilities, thin-client interfaces, and other enhancements, it is an important component of the new SAS® software V8.1.

building the data warehouse olap  find significant enhancements when building and designing warehouses and ETL (extraction, transformation and loading) processes. SAS/Warehouse Administrator is designed for the IT professional responsible for creating and managing data warehouse processes. It is a customizable solution that offers a single point of control making it easier to respond to the ever-changing needs of the business community. All the while, SAS/Warehouse Administrator is creating a new corporate asset called metadata which Read More

SAS/Warehouse 2.0 Goes Live


SAS Institute has announced the production availability of SAS/Warehouse Administrator software, Version 2.0. This new version provides IT the ability to proactively publish data warehouse information and track its usage, plus aggressively manage the process of change in the data warehouse.

building the data warehouse olap  find significant enhancements when building and designing warehouses and extraction, transformation and loading (ETL) processes, Nauta said. By tracking the usage of information in the warehouse, IT staff can identify and remove data that is not being used. Removing unnecessary data makes the warehouse more efficient and maximizes hardware investments. Market Impact Publish/Subscribe metaphors are becoming much more common in the data warehouse arena. The ability for users to subscribe (request Read More

The Importance of Mentoring in the Workplace


Oracle HCM luminary Row Henson along with Aaron Green tell the story of their mentor/mentee relationship. Pick up tips for structuring meaningful mentor programs in your organization.

building the data warehouse olap  Importance of Mentoring in the Workplace Read More

Streaming Data and the Fast Data Stack


Big data is data at rest; fast data is streaming data, or data in motion. A stack is emerging across verticals and industries for building applications that process these high velocity streams of data. This new stack, the fast data stack, has a unique purpose: to grab real-time data and output recommendations, decisions, and analyses in milliseconds.

This white paper will look at the emerging fast data stack through the lens of streaming data to provide architects, CTOs, and developers with fundamental architectural elements of the new fast data stack: a LAMP stack for streaming data applications.

building the data warehouse olap  verticals and industries for building applications that process these high velocity streams of data. This new stack, the fast data stack, has a unique purpose: to grab real-time data and output recommendations, decisions, and analyses in milliseconds. This white paper will look at the emerging fast data stack through the lens of streaming data to provide architects, CTOs, and developers with fundamental architectural elements of the new fast data stack: a LAMP stack for streaming data applications. Read More

Seeing the Future in Discrete Manufacturing: Paving the Way for Success


The evolution of global discrete manufacturing is ongoing. How executives at manufacturing companies answer questions and anticipate what will be the right answer six months, a year, or two years from now will determine the success of their company. Infor examines current industry trends and identifies what it believes to be the seven trends producing the greatest stress and change in discrete manufacturing today.

building the data warehouse olap  the Future in Discrete Manufacturing: Paving the Way for Success The evolution of global discrete manufacturing is ongoing. How executives at manufacturing companies answer questions and anticipate what will be the right answer six months, a year, or two years from now will determine the success of their company. Infor examines current industry trends and identifies what it believes to be the seven trends producing the greatest stress and change in discrete manufacturing today. Read More

The Birds, the B's and the Web


The Internet wing of media giant NBC purchased small business portal AllBusiness.com

building the data warehouse olap  Birds, the B''s and the Web Event Summary NBC Internet Inc. (NBCi) will pay $225 million in stock to purchase AllBusiness.com. AllBusiness.com is a business-to-business site offering advice and services to small businesses. NBCi will use it to develop additional business-to-business offerings. Market Impact AllBusiness.com is already an attractive small business portal with a rich variety of content and a marketplace provided by OnSite, which merged with Egghead in July 1999. The influx of money and Read More

ORSA, the Corner Stone of the Solvency II Regime


The move toward principle-based regulations across the European insurance world puts a strong emphasis on corporate governance programs. Under their Own Risk and Solvency Assessment (ORSA) plans, insurance firms have to align their enterprise risk management processes with their strategic business plans. This article looks, in more detail, at some of the main Solvency II ORSA requirements, and how European insurance companies can use enterprise risk management platforms to support these key management needs.

building the data warehouse olap  the Corner Stone of the Solvency II Regime The move toward principle-based regulations across the European insurance world puts a strong emphasis on corporate governance programs. Under their Own Risk and Solvency Assessment (ORSA) plans, insurance firms have to align their enterprise risk management processes with their strategic business plans. This article looks, in more detail, at some of the main Solvency II ORSA requirements, and how European insurance companies can use enterprise risk Read More

Warehouse Control Systems: Orchestrating Warehouse Efficiency


You’re probably already familiar with the role of a warehouse management system (WMS). But a warehouse control system (WCS)? In your warehouse, a WCS can play the role of a conductor by ensuring the individual pieces of material-handling equipment—such as conveyors and sorters—perform with harmony, precision, and efficiency. Find out how implementing a WCS execution system can complement your WMS’s planning abilities.

building the data warehouse olap  Control Systems: Orchestrating Warehouse Efficiency You’re probably already familiar with the role of a warehouse management system (WMS). But a warehouse control system (WCS)? In your warehouse, a WCS can play the role of a conductor by ensuring the individual pieces of material-handling equipment—such as conveyors and sorters—perform with harmony, precision, and efficiency. Find out how implementing a WCS execution system can complement your WMS’s planning abilities. Read More

It Isn't the Fall, It's the Sudden Stop


Skillful management of transitions is essential for IT professionals. It is not simple and it not recognized when it is done right, but when done wrong, the noise of the sudden stop rings in everyone's ears for a long time.

building the data warehouse olap  Transition Manager friend suggests building a plan to keep the lions focused on the goal; help the sheep feel comfortable following the lions; and if necessary, feed the mules to the lions.  Thoughtful consideration of what to preserve; what will be new and attractive; what should be carried forward; how to maintain high energy through the transition; and what bold goal will enable people to think past the change provides a strong foundation for transition planning. Consideration of people, process and Read More

Data Masking: Strengthening Data Privacy and Security


Many business activities require access to real production data, but there are just as many that don’t. Data masking secures enterprise data by eliminating sensitive information, while maintaining data realism and integrity. Many Fortune 500 companies have already integrated data masking technology into their payment card industry (PCI) data security standard (DSS) and other compliance programs—and so can you.

building the data warehouse olap   Read More

Manage the Change or Change the Management during an ERP Software Selection: The Change


Change happens all the time—but why are changes in our personal lives similar to those in our professional lives?  There are some major events that occur and change things forever. For an individual, such a change can be caused by marriage; for a company, by the selection of an ERP system. There is always a way out when relationships stop working (both between people and companies), but it can be

building the data warehouse olap  the Change or Change the Management during an ERP Software Selection: The Change Change happens all the time—but why are changes in our personal lives similar to those in our professional lives?  There are some major events that occur and change things forever. For an individual, such a change can be caused by marriage; for a company, by the selection of an ERP system. There is always a way out when relationships stop working (both between people and companies), but it can be painful—and Read More

The Linux Box


The Linux Box is a project management and consulting practice, specializing in open source technology and the Linux platform. The company helps its customers assess, select, customize, and deploy best-of-breed open source solutions. The Linux Box concentrates on knowledge transfer and training, applications development and porting, and network support services. The Linux Box was formed in 1999 and is headquartered in Michigan, USA.

building the data warehouse olap  Linux Box The Linux Box is a project management and consulting practice, specializing in open source technology and the Linux platform. The company helps its customers assess, select, customize, and deploy best-of-breed open source solutions. The Linux Box concentrates on knowledge transfer and training, applications development and porting, and network support services. The Linux Box was formed in 1999 and is headquartered in Michigan, USA. Read More