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

Appliance Power: Crunching Data Warehousing Workloads Faster and Cheaper than Ever


Appliances are taking up permanent residence in the data warehouse (DW). The reason: they are preconfigured, support quick deployment, and accelerate online analytical processing (OLAP) queries against large, multidimensional data sets. Discover the core criteria you should use to evaluate DW appliances, including performance, functionality, flexibility, scalability, manageability, integration, and extensibility.

building the data warehouse olap  Power: Crunching Data Warehousing Workloads Faster and Cheaper than Ever Appliances are taking up permanent residence in the data warehouse (DW). The reason: they are preconfigured, support quick deployment, and accelerate online analytical processing (OLAP) queries against large, multidimensional data sets. Discover the core criteria you should use to evaluate DW appliances, including performance, functionality, flexibility, scalability, manageability, integration, and extensibility. Read More

The Truth about Data Mining


It is now imperative that businesses be prudent. With rising volumes of data, traditional analytical techniques may not be able to discover valuable data. Consequently, data mining technology becomes important. Here is a framework to help understand the data mining process.

building the data warehouse olap  same dataset, or by building multiple models by tuning the same algorithm until the desired level of accuracy is achieved. Predictions against the model can be compared to known results to arrive at a measure of accuracy. It is advisable to separate data used for testing a model from data used to train a model. A cumulative gains chart is among several techniques that test the accuracy of a model. In a cumulative gains chart, the accuracy of a model is estimated for a target value chosen by the user. For 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

Technology and the Lean Enterprise: Building an Infrastructure That Drives the Highest Value to the Customer


Across the industrial machinery and components industry, successful lean initiatives are increasing as manufacturers recognize the key enabler of continuous improvement and eliminating waste—technology. This white paper presents six brief case studies of manufacturing companies that have built an underlying technology infrastructure to support a foundation for increasing their value to their customers.

building the data warehouse olap  and the Lean Enterprise: Building an Infrastructure That Drives the Highest Value to the Customer Across the industrial machinery and components industry, successful lean initiatives are increasing as manufacturers recognize the key enabler of continuous improvement and eliminating waste—technology. This white paper presents six brief case studies of manufacturing companies that have built an underlying technology infrastructure to support a foundation for increasing their value to their customers. 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

The Old ERP Dilemma - Should We Install The New Release?


If you have an older ERP system, and you have decided to continue to pay maintenance, you should be getting periodic releases from the vendor. The frequency of these releases varies, but for each new release, you have a decision to make. Should you install the new release or not?

building the data warehouse olap  Old ERP Dilemma - Should We Install The New Release? What To Know Before You Even Think About It    Before you even start to decide on taking the release, you need to understand some of the realities set by the vendor. Most vendors have a policy about how long they support an old release, but with most, the practice does not follow the policy. You need to probe beyond the policy statement to find out the truth. Remember that the vendor wants you to continue to pay maintenance and if they stop Read More

Training for the Many… Learning for the One: How Successful Organizations Recognize the Difference and Use Technology to Deliver Both


Winston Churchill once said, “Personally, I’m always ready to learn, although I do not always like being taught.” Formal training and informal learning can be combined to create powerful education opportunities for groups and for individuals. Include personalization in the mix and you have a recipe for almost certain success. It sounds straightforward, but is the implementation of such programs as simple as it seems?

building the data warehouse olap  for the Many… Learning for the One: How Successful Organizations Recognize the Difference and Use Technology to Deliver Both Winston Churchill once said, “Personally, I’m always ready to learn, although I do not always like being taught.” Formal training and informal learning can be combined to create powerful education opportunities for groups and for individuals. Include personalization in the mix and you have a recipe for almost certain success. It sounds straightforward, but is the 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

The Need to Rethink the WAN


Technological advances have evolved at an exponential rate over recent decades—we’ve seen the advent of the Internet, cloud computing, virtualization, and several other technologies. But the wide area network (WAN) technologies that are currently in use in most branch offices have changed little since the 1990s.

Business environments today are experiencing unprecedented growth and change, and IT departments are losing visibility and control. Traditional WAN technologies are a mismatch for modern branch networks that need to be up and running quickly. The demand for adaptability, awareness of costs, and the need to run and monitor business-critical processes are indicating the necessity for a new WAN technology paradigm.

New WAN services based on the latest technologies have not been deployed by traditional service providers, primarily because they require an initial financial outlay which companies are not prepared to make. But they are poised to succeed multiprotocol label switching (MPLS), and are the most viable alternative for supporting application performance while dealing with increased network traffic and the connectivity demands of cloud computing and mobile access.

In this white paper, the characteristics of WAN technology and the limitations of traditional WAN technology, including complexity, are explored. This paper also discusses some new approaches, such as a hybrid WAN, which are better suited to supporting fast-changing business and technology environments.

building the data warehouse olap  Need to Rethink the WAN Technological advances have evolved at an exponential rate over recent decades—we’ve seen the advent of the Internet, cloud computing, virtualization, and several other technologies. But the wide area network (WAN) technologies that are currently in use in most branch offices have changed little since the 1990s. Business environments today are experiencing unprecedented growth and change, and IT departments are losing visibility and control. Traditional WAN technologies are Read More

Customer Centricity: The Devil Lies in the Details


The purpose of this white paper is to help readers understand the importance of customer-centricity in today's highly competitive and constantly evolving business landscape. Its aim is to remove misconceptions and guide you to achieve "true" customer-centricity.

building the data warehouse olap  Centricity: The Devil Lies in the Details The purpose of this white paper is to help readers understand the importance of customer-centricity in today''s highly competitive and constantly evolving business landscape. Its aim is to remove misconceptions and guide you to achieve true customer-centricity. Read More

Measuring the Success of Lean: Selecting the Best Mileposts for the Never-ending Journey


As manufactures adopt lean principles, the process inevitably involves developing metrics for measuring their progress. But measurements are linked throughout the organization, not just on the manufacturing floor but in accounts payable and other back office processes. This white paper emphasizes the need to focus on strategy deployment.

building the data warehouse olap  the Success of Lean: Selecting the Best Mileposts for the Never-ending Journey As manufactures adopt lean principles, the process inevitably involves developing metrics for measuring their progress. But measurements are linked throughout the organization, not just on the manufacturing floor but in accounts payable and other back office processes. This white paper emphasizes the need to focus on strategy deployment. Read More