http://www.sqlservercentral.com/Articles tagged Data Warehousing, Design posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this type of project. http://www.sqlservercentral.com/articles/Design/2832/2008/01/29http://www.sqlservercentral.com/articles/Design/2832/Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system. http://www.sqlservercentral.com/articles/Design/2823/2008/01/21http://www.sqlservercentral.com/articles/Design/2823/When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS. http://www.sqlservercentral.com/articles/DTS/2781/2007/12/31http://www.sqlservercentral.com/articles/DTS/2781/Developing an effective solution requires quality within and across all components of the BI architecture. http://www.sqlservercentral.com/redirect/articles/3225/2007/09/20http://www.sqlservercentral.com/redirect/articles/3225/A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.http://www.sqlservercentral.com/redirect/articles/3223/2007/09/06http://www.sqlservercentral.com/redirect/articles/3223/Smart CFOs and CIOs should consider making mobile BI available to employees as a way to improve productivity, extend BI adoption and improve operational efficiencies. http://www.sqlservercentral.com/redirect/articles/3191/2007/08/31http://www.sqlservercentral.com/redirect/articles/3191/This article provides an architecture and process framework to ensure data quality in a data warehousing environment.http://www.sqlservercentral.com/redirect/articles/3131/2007/08/02http://www.sqlservercentral.com/redirect/articles/3131/At the core of an enterprise BI/DW program is the data that is being made available to the business users who are looking to make better decisions using this information. Properly managing this information is the most critical activity of the enterprise BI team.http://www.sqlservercentral.com/redirect/articles/3068/2007/07/03http://www.sqlservercentral.com/redirect/articles/3068/Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. This article will show you how to make peace between them.http://www.sqlservercentral.com/redirect/articles/3028/2007/06/11http://www.sqlservercentral.com/redirect/articles/3028/In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.http://www.sqlservercentral.com/redirect/articles/2933/2007/03/21http://www.sqlservercentral.com/redirect/articles/2933/In response to the first part, new author Richard Gardner brings us a few more issues that you should be aware of when planning your data warehouse. http://www.sqlservercentral.com/articles/Design/2913/2007/03/20http://www.sqlservercentral.com/articles/Design/2913/BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.http://www.sqlservercentral.com/redirect/articles/2915/2007/03/20http://www.sqlservercentral.com/redirect/articles/2915/In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type. http://www.sqlservercentral.com/redirect/articles/2905/2007/03/19http://www.sqlservercentral.com/redirect/articles/2905/Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this type of project. http://www.sqlservercentral.com/articles/Design/2832/2008/01/29http://www.sqlservercentral.com/articles/Design/2832/Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system. http://www.sqlservercentral.com/articles/Design/2823/2008/01/21http://www.sqlservercentral.com/articles/Design/2823/When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS. http://www.sqlservercentral.com/articles/DTS/2781/2007/12/31http://www.sqlservercentral.com/articles/DTS/2781/Part 3 of Vincent Rainardi's data warehousing series looks at some of the situations and challenges of loading a fact table in a data warehouse. http://www.sqlservercentral.com/articles/Design/2769/2007/01/02http://www.sqlservercentral.com/articles/Design/2769/By doing a bit of groundwork and effectively controlling the scope of the metadata repository continuously throughout the project, few problems should arise.http://www.sqlservercentral.com/redirect/articles/2706/2006/11/27http://www.sqlservercentral.com/redirect/articles/2706/DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.http://www.sqlservercentral.com/redirect/articles/2665/2006/10/31http://www.sqlservercentral.com/redirect/articles/2665/Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data. http://www.sqlservercentral.com/articles/Design/2657/2006/10/24http://www.sqlservercentral.com/articles/Design/2657/Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business ruleshttp://www.sqlservercentral.com/redirect/articles/2626/2006/10/05http://www.sqlservercentral.com/redirect/articles/2626/This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.http://www.sqlservercentral.com/redirect/articles/2571/2006/09/20http://www.sqlservercentral.com/redirect/articles/2571/What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you. http://www.sqlservercentral.com/articles/Design/2593/2006/09/18http://www.sqlservercentral.com/articles/Design/2593/True business value lies in using the data model as an entry point for a program of data management that treasures data as the most valuable corporate asset.http://www.sqlservercentral.com/redirect/articles/2552/2006/08/22http://www.sqlservercentral.com/redirect/articles/2552/What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for. http://www.sqlservercentral.com/articles/Design/2556/2006/08/16http://www.sqlservercentral.com/articles/Design/2556/Master data management (MDM) and eXtensible Business Reporting Language (XBRL) are two key technologies that promise to address important information management issues. Ventana Research believes both will enable companies to reduce the cost, time and effort needed to collect, analyze and use information, whether for visibility, decision support or process execution. Some observers may see them as competing approaches, but in practice each has capabilities best suited to some applications and not others. Even where they overlap, the two may not be mutually exclusive. We advise companies that have not yet begun investigating XBRL and MDM to do so immediately, and all organizations should begin developing skills in using them. http://www.sqlservercentral.com/redirect/articles/2551/2006/08/16http://www.sqlservercentral.com/redirect/articles/2551/In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required. http://www.sqlservercentral.com/redirect/articles/2526/2006/08/02http://www.sqlservercentral.com/redirect/articles/2526/Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system. http://www.sqlservercentral.com/articles/Design/migratingdatawarehousesystemstosqlserver2005/2501/2006/07/31http://www.sqlservercentral.com/articles/Design/migratingdatawarehousesystemstosqlserver2005/2501/In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components. http://www.sqlservercentral.com/redirect/articles/2525/2006/07/31http://www.sqlservercentral.com/redirect/articles/2525/In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.http://www.sqlservercentral.com/redirect/articles/2528/2006/07/28http://www.sqlservercentral.com/redirect/articles/2528/