TDWI Best Practices Reports
TDWI’s Best Practices Reports are designed to educate technical and business professionals about new business intelligence technologies, concepts, or approaches that address a significant problem or issue. Research for the Best Practices Reports is conducted via interviews with industry experts and leading-edge user companies, and is supplemented by a survey of business intelligence professionals.
April 1, 2010
In most organizations today, data and other information are managed in isolated silos by independent teams using various data management tools for data quality, data integration, data governance and stewardship, metadata and master data management, B2B data exchange, content management, database administration and architecture, information lifecycle management, and so on. In response to this situation, some organizations are adopting what TDWI calls unified data management (UDM), a practice that holistically coordinates teams and integrates tools. Other common names for this practice include enterprise data management and enterprise information management. Regardless of what you call it, the “big picture” that results from bringing diverse data disciplines together yields several benefits, such as cross-system data standards, cross-tool architectures, cross-team design and development synergies, leveraging data as an organizational asset, and assuring data’s integrity and lineage as it travels across multiple organizations and technology platforms.
January 1, 2010
The finance department sits at the information nexus of the organization. It regularly collects financial and non-financial data from every business unit and consolidates that information into summary and detailed management reports. Finance can therefore be a powerful agent of organizational change. It can leverage the information that it collects to assist executives and line of business managers to optimize processes, achieve goals, avert problems, and make decisions.
December 28, 2009
Forward-thinking finance departments have figured out how to transform themselves from back-office bookkeepers to strategic advisors by partnering with the business intelligence (BI) team.
October 1, 2009
If you’re a data warehouse professional—or you work closely with one—you’ve probably noticed the many new options for data warehouse platforms that have appeared this decade. We’ve seen the emergence of new categories of data warehouse (DW) platforms, such as data warehouse appliances and software appliances. A new interest in columnar databases has led to several new vendor products and renewed interest in older ones. Open source Linux is now common in data warehousing, and open source databases, data integration tools, and reporting platforms have come out of nowhere to establish a firm foothold. In the hardware realm, 64-bit computinghas enabled larger in-memory data caches, and more vendors now offer MPP architectures. Leading database vendors have added more features and products conducive to data warehousing.
July 1, 2009
Webster’s Revised Unabridged Dictionary defines analytics as “the science of analysis,” and analysis as “the tracing of things to their source, and the resolving of knowledge into its original principles.” From a business perspective, these definitions imply that analytics is about understanding the root causes of business events and conditions. The upshot, of course, is that business people, armed with insights, will make the right decisions and take the appropriate actions to further their organizations’ tactical and strategic goals.
April 1, 2009
The amount and diversity of work done by data integration specialists has exploded since the turn of the twenty-first century. A lot of the growth comes from the emerging practice of operational data integration, which is usually applied to the migration, consolidation, or synchronization of operational databases, plus business-to-business data exchange.
January 9, 2009
Performance metrics are a powerful tool of organizational change. The adage "What gets measured, gets done," is true. Companies that define objectives, establish goals, measure progress, reward achievement, and display the results for all to see can turbo-charge productivity and gracefully move an organization in a new direction.
October 1, 2008
Who are your customers? Which products and services are they buying across your enterprise? How much business have they transacted with your enterprise so far this year? Where do they conduct business besides your firm?
April 1, 2008
Any time data crosses an organizational boundary, it should be governed, whether you’re sharing data among business units internally or publishing data to customers, partners, auditors, and regulatory bodies externally. Organizations are under renewed pressure to ensure that compliance and accountability requirements are met as the scope of data integration broadens. In response to this situation, many organizations are turning to data governance, which establishes policies and procedures for sharing data, as well as improving data’s quality, structure, and auditability.