Maximize e-commerce profitability with the power of data warehousing.
This book offers a start-to-finish blueprint for leveraging the power of data warehousing in e-business. Leading consultant William Lewis demonstrates exactly how to use data warehousing to support your transformation into a multichannel digital enterprise that delivers greater value and builds stronger customer relationships. Lewis demonstrates how to define e-business IT architectures that maximize existing databases and data warehouse resources; how to provide state-of-the-art e-business analytics via "data webhouses," and much more. Coverage includes:
Each chapter concludes with a running case study from a hypothetical brick-and-mortar company using data warehousing to support its transformation into a multi-channel digital enterprise.
Whether you're an e-business executive, IT professional, database specialist, analyst, architect, strategist, or marketer, Data Warehousing and E-Commerce will help you maximize the business value of every byte of data you own.
Click here for a sample chapter for this book: 0130911542.pdf
1. A Crash (or Collision) Course: A History of Data Warehousing.
The Current State of Data Warehousing and E-Commerce. It's the Data, Stupid! The Means to Many Ends. Business Trends and the Use of Data. Technological Underpinnings. Data Warehousing and E-Commerce at Tiosa Corporation.
Channels. The Value Chain. Channels and the Value Chain. Integration. Tiosa CorporationÕs Value Chain and Channels.
Why Do IT Architecture? Who's Doing IT Architecture? What is an IT Architecture, Anyway? Components of an IT Architecture. Developing and Using a Data Architecture for E-Commerce. Tiosa Group Initiates Data Architecture Management.
Successively Broader Scopes of Data. Interactive and Exploratory Data Analysis. Meta-data for E-Commerce and Beyond. The Business Intelligence Dissemination Lifecycle. E-Business Intelligence at Tiosa Group.
Data Representation: Logical Data Storage. Structured and Unstructured Data. Physical Data Storage. Data-Hardware Interfaces for E-Commerce. Data Storage for E-Commerce at Tiosa Group.
E-Commerce Data Integration. Data-Integration Infrastructure. XML, XML, and More XML. Transforming Data. Successively Broader Scopes of Data Integration. Enhancing the Data: Customer Matching and Householding. Assimilating External Data. Knowledge Management: The Input is the Issue. E-Commerce Data Movement at Tiosa Group.
E-Commerce and the Data Value Chain. A History of Data as a Product. E-Commerce Impact on Data Resources. Data Ownership. Data Specifications and Quality Data. Profiling of Production Data Resources. Refinement of Production Data Resources. The Data Product at Tiosa Group.
Project Management, in General-And Briefly. Tasks and Deliverables in an E-Commerce Project. Skills and Staffing: The E-Commerce Data Dream Team. Planning and Scheduling. The “Next” Project: E-Business Intelligence. Tiosa and the E-Commerce Data Dream Team.
Electronic Banking: EbizPioneer. Retail B2C: EbizDelivery. Financial B2C: EbizMoney. Financial B2B: EbizGlobal. Manufacturing B2B: EbizToolz. Outsourced E-Business Intelligence: EbizBI.
E-Commerce Software Standards. Data Versus Objects? Resolution and Accommodation? Tiosa Group: One Last Visit.
Web Analytics. Business Intelligence. Online Analytical Processing (OLAP). Turnkey Data Marts. Data Mining. Enterprise Information Portals. Specialized Database Products: Main-memory, XML, and Federated DBMS. Virtual Data Warehousing. Data Enrichment. Customer Data Vendors. Product Data Vendors. Payment Processing and Tax Data Vendors. Extract, Transform, and Load (ETL). Knowledge Management. Application Servers. B2C E-Commerce Servers. B2B E-Commerce Servers. Middleware and Enterprise Application Integration. Relational DBMS. Java and Object-Oriented Development. XML Development. Meta-data Management. Database Administration Tools.
What does data warehousing have to do with e-commerce? Is this one book, or really two? Data warehousing is a means to an end; e-commerce is much more an end in itself. But with the ever-increasing importance of data in the digital economy, businesses more than ever need to do their very best in managing every last penny of value out of their digital resourcestheir data. Effective decision support requires effective data management. Data warehousing is an admittedly loosely defined set of techniques and technologies designed to manage data for effective decision support. These same technologies are quite adaptable to managing data assets for e-business.
Data has "come out of the closet." Prior to the widespread implementation of e-commerce, data management was "just" an internal challenge for businesses. Now the rush to the Internet is on, and businesses, in order to stake out a position in the digital marketplace, must expose the state of their data to customers, partners, and even competitors. Ready or not, this requires data integration, or at the very least, an appearance of data integration. Data warehousing technologies are fundamental enablers of data integration.
In some ways, this book is an information portal. Much of its content is available from other sources, but "content aggregation" is often a worthwhile task. Much content has been aggregated here with the hope that some value has been added along the chain from supplier to consumer. There are original thoughts here too, some of which have been simmering during a multi-decade journey through the sometimes fascinating landscape of commercial information technology. Then there are also opinions strewn about here and there ... watch out and step carefully.Tiosa Corporation Enters the Digital Economy
Tiosa Corporation is a fictional company that we will use as an ongoing example and case study throughout this book. Tiosa is a mid-size firm that provides financial services to the energy and utility industry. It is currently poised at the brink of the digital marketplace on several fronts at once. As various facets of data warehousing and e-commerce are covered in the text, we will visit the offices of Tiosa Corp. to observe how this company confronts these issues as a result of embarking on a "digital strategy."
And away we go...