Data Warehousing | How-to Guides for running your business from Business.com

Data warehousing is the comprehensive organization and storage of your company’s digital data, be it financial, customer information, or sales. With data storage services, you have access to this repository, which is available for analysis and reporting to further business growth. As a window into your enterprise, data warehousing becomes the basis for forecasting and strategic decision-making as well as the foundation of customer relationship management (CRM).

When shopping for data warehousing solutions, consider the following:

1. Data warehousing as the foundation of business intelligence.
2. Data warehousing solutions and platforms.
3. Data warehouse management services and consultants.
4. Data storage services.

Action Steps
The best contacts and resources to help you get it done

Data warehousing as the foundation of business intelligence

Data that exists in fragmented, departmental silos cannot be mined and put to work, leaving management with an incomplete view of the company. Through data warehousing solutions, a single, consistent repository of enterprise data is created that is culled and analyzed to become the basis of an overall business intelligence strategy.

I recommend: Informatica Corporation offers a number of data warehousing solutions, including a webinar and online tools to assess your needs. To optimize data for warehousing and reporting, consider Extract, Transform and Load (ETL) tools from iWay Software. Data Mirror’s Integration Suite allows you to load data warehouses from multiple sources in real time enabling better business decisions. For a wealth of resources about data warehousing, visit The Data Warehousing Institute (TDWI), which offers certification, webinars, onsite education and links to vendors with data warehousing solutions.

Data warehousing solutions and platforms

Oracle, SAS, SAP BW, Microsoft, Sybase and MySQL are the big players in business intelligence and, therefore, data warehousing solutions. Written as large enterprise systems, their components are often modular and can be integrated into more specific systems as HP did with Oracle to create HP's Business Intelligence Data Warehousing platform.

I recommend: The HP Neoview Enterprise Data Warehouse is an Oracle-based business intelligence and data warehousing solution. MySQL is an open source database that runs on multiple platforms allowing developers to build database applications in the language of their choice.

Data warehouse management services and consultants

Most data warehouse management consultants are either with the consulting branch of a solution provider or offer solutions based on a combination of partner technologies.

I recommend: Knightsbridge Solutions, HP’s information management practice, offers a package of data warehouse management services including data warehousing. TUSC is a business intelligence consulting agency that specializes in Oracle data management software solutions. Kalido’s enterprise data management service assists clients in developing departmental data warehouses, enterprise data warehouses and networked data warehouse solutions.

Data storage services

While its implications in terms of accessibility and security should be carefully scrutinized, outsourcing your data warehousing to online or offshore data storage services has the advantages of greater capacity plus off-site backup for your data.

I recommend: Bleum Software Outsourcing uses Microsoft technologies for outsourcing data warehouse management in the banking and telecom industries. Amerivault’s data warehouse management services offer automatic backups and remote data recovery.

Tips & Tactics
Helpful advice for making the most of this Guide

Approach data warehouse management as part of a larger business intelligence project.
Include all customer-related data in your data warehousing efforts for better marketing and customer service.
Look for data warehousing solutions that are properly scaled to your business size and industry, allowing for future growth.
Data management software is an ever-evolving part of business intelligence. Stay abreast of new developments via industry newsletters, conferences and webinars.

The official source of Data Warehousing is the Data Warehousing page at Business.com

More Featured Listings

Data Warehousing
Analyze, Report and Track Complex Data in Real Time. Get the IBM eBook.
Get the eBook
www.IBM.com

Microsoft SQL Server® 2008 - Free Trial
Download the Free 180-day Trial of SQL Server® 2008 Enterprise Edition!
Try It Out | Ways To Save | Read White Paper | Learn More
Microsoft.com/SQLServer2008

Stop Buying Storage
No More Hardware. Maximize Storage Capacity with Data Management Software.
Get Storage | Data Protection | Archiving | Contact Us!
www.symantec.com

SAS Data Warehousing Software
Learn how to Manage Data Better with SAS Data Warehousing- Information Kit that includes TDWI Report and Whitepaper Explains- Get InfoNow!
www.SAS.com