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 bi

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

Business Intelligence (BI) RFI / RFP Template

Reporting and Analysis, Analytics, Data Warehousing, Workflow, Data Integration, Support, and System Requirements  

Evaluate Now

Documents related to » building the data warehouse bi

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 bi  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

More Data is Going to the Cleaners


WESTBORO, Mass., November 29, 1999 - Ardent Software, Inc. (Nasdaq: ARDT) today announced a strategic partnership with Firstlogic, Inc., the developer of i.d.Centric data quality software that helps companies cleanse and consolidate data in database marketing, data warehousing, and e-business applications. Under the partnership agreement Firstlogic will develop and support a link between its customer data quality tools and Ardent's DataStage Suite.

building the data warehouse bi  We recommend that customers building warehouses from legacy data, which is typically dirty or non-conformed, evaluate the solution provided by Ardent. The vendor should be questioned on how tightly the products will be integrated. 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 bi  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

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 bi  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

Has The BI Market Consolidation Been Crystal-Clearly Actuated? Part Three: Competition and User Recommendations.


Users choosing point planning or BI products should consider the integration infrastructure and effort needed to combine these products versus the cost and functionality issues of choosing an integrated CPM product suite (if still possible to find). Mission-critical issues like scalability, reliability, manageability and ease-of-use go without saying.

building the data warehouse bi  for CPM initiative towards building the entire Corporate Information Factory (CIF) would be to identify the most painful points and to try solving them by leveraging existing BI/analytics initiatives, while bewaring of being inflexible and of automatically settling for an incumbent vendor if its products and plans don not match up well to your strategic requirements. Also, one should not fall in the trap of low-hanging fruit and easily obtainable short-term return on investment benefits (ROI) at the Read More

Beyond the Basics: The Value of Integrated CRM


Customer relationship management (CRM) is more than just software or a set of processes--it's a business culture solidly focused on winning and keeping the right customers. A good CRM solution builds value to your business. Learn about the value of an integrated CRM suite.

building the data warehouse bi  the Basics: The Value of Integrated CRM Customer relationship management (CRM) is more than just software or a set of processes--it''s a business culture solidly focused on winning and keeping the right customers. A good CRM solution builds value to your business. Learn about the value of an integrated CRM suite. Read More

The Banking Industry: Planning the Road Ahead


Effective planning is integral to the success of a bank. It helps define and ensure the achievement of the organization’s objectives. Understanding and implementing the planning cycle, which leverages forecasting, operational metrics, and multidimensional analyses can help management determine the feasibility of a strategy. An enterprise-wide, integrated planning and forecasting environment that reaches business units, products, customer segments, and geographies can align non-financial performance targets with high-level financial targets and help banks meet their goals.

building the data warehouse bi  Banking Industry: Planning the Road Ahead Effective planning is integral to the success of a bank. It helps define and ensure the achievement of the organization’s objectives. Understanding and implementing the planning cycle, which leverages forecasting, operational metrics, and multidimensional analyses can help management determine the feasibility of a strategy. An enterprise-wide, integrated planning and forecasting environment that reaches business units, products, customer segments, and geograph Read More

The Many Angles to Dive into the BPM Water


These days, the concepts of business process management (BPM) have become more unified, and BPM functionality from different vendors seems to be more converged. However, organizations may have their own reasons for adopting BPM—different business features and requirements will lead to different matching points between adopting organizations and BPM solutions. In the mean time, BPM vendors are

building the data warehouse bi  solution focuses more on building an environment where processes can be easily modified and continuously improved (the fishing part) rather than providing pre-defined process sets to customers (the fish part). However, there are some BPM vendors striving to do both. I had a briefing with AuraPortal a while ago and learned that other than providing process modeling, execution, and monitoring tools packaged as AuraPortal BPMS [ evaluate the product ], the vendor also provides customer relationship Read More

The Miracle in Detroit: Putting the ROI into ITIL


IT managers understand the difficulty of demonstrating returns on investment for technology projects. The issue is particularly acute for large multiphase deployments, such as IT infrastructure library (ITIL) implementations: massive projects which are hard to sell to management, and which promise returns many years in the future—after significant investment. So how do you get management to buy into your vision?

building the data warehouse bi  Miracle in Detroit: Putting the ROI into ITIL IT managers understand the difficulty of demonstrating returns on investment for technology projects. The issue is particularly acute for large multiphase deployments, such as IT infrastructure library (ITIL) implementations: massive projects which are hard to sell to management, and which promise returns many years in the future—after significant investment. So how do you get management to buy into your vision? 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 bi  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

A Roadmap to Data Migration Success


Many large business initiatives and information technology (IT) projects depend upon the successful migration of data—from a legacy source, or multiple sources, to a new target database. Effective planning and scoping can help you address the associated challenges and minimize risk for errors. This paper provides insights into what issues are unique to data migration projects and to offer advice on how to best approach them.

building the data warehouse bi  Roadmap to Data Migration Success Many large business initiatives and information technology (IT) projects depend upon the successful migration of data—from a legacy source, or multiple sources, to a new target database. Effective planning and scoping can help you address the associated challenges and minimize risk for errors. This paper provides insights into what issues are unique to data migration projects and to offer advice on how to best approach them. Read More

BI on the Go . . . So, Who’s Using Mobile BI?


In this first of two posts, TEC senior BI and data management analyst Jorge García presents some of the main findings of the TEC 2014 mobile survey on the usage of mobile BI offerings by enterprises—who's using mobile BI offerings and from which vendors, and which industry is showing the interest in mobile BI solutions.

building the data warehouse bi  on the Go . . . So, Who’s Using Mobile BI? Piggybacking off of the success of the most recent TEC Buyer’s Guide, the 2014 Buyer''s Guide on Mobile BI applications , we took the opportunity to survey users of mobile business intelligence (BI) applications and collect their impressions in regard to these tools. Most of the results of this survey with more than 250 respondents were captured in an Infographic . Additional information garnered from the survey, while not conclusive, may provide a glance Read More

Optimizing the Mobile Workforce: Maximizing the Value of Your Investment in Mobility


Today, enterprises leverage mobility for more than just communication. They want to maximize the productivity of the mobile workforce. That means choosing mobile devices, applications, policies, and services aligned with enterprise goals. What matters most to enterprises today is equipping the mobile workforce for success at the right cost and with acceptable security.

Optimizing the mobile workforce is a matter of finding the right balance between cost, security, and usability. Usability correlates with productivity, which is maximized by the right devices, applications, and support. Optimizing all these factors is a significant challenge, but taking a systematic approach can help an enterprise maximize the value of investment in mobility.

building the data warehouse bi  the Mobile Workforce: Maximizing the Value of Your Investment in Mobility Today, enterprises leverage mobility for more than just communication. They want to maximize the productivity of the mobile workforce. That means choosing mobile devices, applications, policies, and services aligned with enterprise goals. What matters most to enterprises today is equipping the mobile workforce for success at the right cost and with acceptable security. Optimizing the mobile workforce is a matter of finding Read More

The Critical Role of the Enterprise Product Catalog: Cost, Time-to-market, and the Customer Experience


Many companies now combine services in pre-packaged, high-value bundles to reduce customer churn rates. And these bundled services have proved to bring returns. But they also bring complexity—some major service providers may have over 150 product catalogs. Get tips on how to overcome the problems of bundling, and avoid catalog duplication in your product or service offering, with product information management (PIM).

building the data warehouse bi  Critical Role of the Enterprise Product Catalog: Cost, Time-to-market, and the Customer Experience Many companies now combine services in pre-packaged, high-value bundles to reduce customer churn rates. And these bundled services have proved to bring returns. But they also bring complexity—some major service providers may have over 150 product catalogs. Get tips on how to overcome the problems of bundling, and avoid catalog duplication in your product or service offering, with product information Read More

The Importance of a Single Product for Data Quality and Data Integration


Companies are fighting a constant battle to integrate business data and content while managing data quality. Data quality serves as the foundation for business intelligence (BI), enterprise resource planning (ERP), and customer relationship management (CRM) projects. Learn more about software that unifies leading data quality and integration solutions—helping your organization to move, transform, and improve its data.

building the data warehouse bi  Importance of a Single Product for Data Quality and Data Integration Companies are fighting a constant battle to integrate business data and content while managing data quality. Data quality serves as the foundation for business intelligence (BI), enterprise resource planning (ERP), and customer relationship management (CRM) projects. Learn more about software that unifies leading data quality and integration solutions—helping your organization to move, transform, and improve its data. Read More