Architecture
- All
- Analytics
- Architecture
- BI Guidebook
- BI Industry Analysis
- BI Myths, Trends & Hype
- BI/DW Index
- BI/DW on a Shoestring
- Big Data
- Business & IT Issues
- Business Intelligence
- Cloud Computing
- Courses and Training
- CPM
- Data Governance
- Data Integration
- Data Mining
- Data Modeling
- Data Preparation
- Data Quality
- Data Shadow Systems
- Data Warehousing
- DW/BI Events
- Enterprise Data Mgmt
- ERP
- ETL
- Industry Research
- Master Data Management
- Modernization
- On-Demand Index
- People, Process, Politics
- Published Articles
- Self-Service BI
June 20, 2018
A modern data architecture for business intelligence and analytics has to support structured, unstructured, and semi-structured sources, as well as hybrid integration and also meet the […]
December 28, 2017
Understanding the data integration process is central to self-service BI and data architecture design, consultant Rick Sherman says in an end-of-year look at data management trends. […]
October 26, 2017
I’m excited to share with you that I’ll be presenting two unique sessions at DATAVERSITY’s Data Architecture Summit in Chicago, IL on November 13-16, 2017. I’m also […]
April 12, 2016
The 20th annual Enterprise Data World (EDW) Conference is recognized as the most comprehensive educational conference on data management in the world. Rick Sherman will be conducing […]
May 11, 2015
I’m speaking at Data Summit 2015 on Tuesday May 12 in New York. If you’re attending, please come to my session and say hello! B102: Creating […]
March 20, 2013
Continuing the discussion on analytical hub design, here’s the second part of my post on the architecture principles. If you missed the first two principles (1. […]
March 14, 2013
As I discused the other day in Why you need an analytical hub, enterprises need to spend time looking forward, rather than just backwards at historical […]
March 11, 2013
Enterprises are flooded with a deluge of data about their customers, prospects, business processes, suppliers, partners and competitors. It comes from traditional internal systems, cloud applications, social networking and […]
March 8, 2013
In his article in Big Data, Bob Eve offers this quote from Professors Andrew McAfee and Erik Brynjolfsson of MIT: “Companies that inject Big Data and […]
January 11, 2012
One of the debates one hears when designing a data warehouse is that it should be normalized. Specifically, they say to use a third normal form […]
January 11, 2011
The first part of this article discussed columnar database software and other technologies that can help boost analytics performance. But regardless of which analytical database technology […]
January 10, 2011
Demand from business users for actionable information is ever-expanding. And with business managers and workers seemingly connected 24/7 via their iPhones, BlackBerrys, iPads and other devices, […]
January 6, 2010
Athena IT Solutions is looking for data warehousing and business intelligence consultants for contract jobs in Massachusetts. Senior Data Warehouse Architect Senior Data Warehousing/Business Intelligence Program/Project […]
September 18, 2009
A recent flurry of news articles in the database industry has reinforced my perceptions that the software titans have lost touch with current market needs. The PR […]
December 11, 2008
My new podcast with Smart Data Collective discusses how too many IT projects provide only short-term solutions. Management ends up frustrated not only because of the […]
November 21, 2008
In my DM Review columns, “The Accidental Architecture” and “Recovering from the Accidental Architecture,” I discussed whether people understood the “why” of best practices, such as dimensional modeling […]
November 19, 2008
People involved in business intelligence (BI) and data warehousing (DW) projects are very familiar with terms such as facts, dimensions, attributes, surrogate keys and slowly changing […]
October 16, 2008
In my article “The Accidental Architecture,” I discussed how enterprises have evolved their data warehousing (DW) and business intelligence (BI) projects without a planned architecture. This […]
October 14, 2008
When you plan to build a house, you start with what you want and can afford. You decide on architectural style, size and number of rooms. […]
September 11, 2008
Conventional wisdom states that you should build a data warehouse (DW) and then populate data marts from it. This data architecture is called a hub and […]
May 12, 2008
People involved in business intelligence (BI) and data warehousing (DW) projects are very familiar with terms such as facts, dimensions, attributes, surrogate keys and slowly changing […]
May 25, 2007
Operational business intelligence (BI) can be an integral part of a portfolio of BI solutions. But before you put it to use, see my May DM […]
January 18, 2007
As a coach of my sons’ soccer teams, I’ve noticed something that occasionally holds back the ambitious players. Rather than focusing on basics, such as learning […]
November 22, 2006
Microsoft is trying to change the perception that its database, SQL Server 2005, is not ready for the big leagues in regards to handling large data […]
June 1, 2006
Been there, done that. That’s how we ended up with multiple data warehouses, data marts, and ERP, CPM and SCM solutions that need to be reconciled. […]
November 12, 2005
As we discussed in my previous column, big data warehouses are back in style. In a 2004 TDWI study, 60 percent of respondents indicated that they were adopting […]
November 12, 2005
Just like boot-cut jeans and fuel-efficient cars, big data warehouses are coming back in style. Take a trip down memory lane, when IBM introduced the corporate […]
June 12, 2005
In part 1 of this article we discussed the ugly duckling called an operational data store (ODS). Rather than discussing the conventional wisdom and, quite frankly, the […]
June 12, 2005
What do you call that thing that’s holding your data? Don’t know? Then it must be an operational data store (ODS). No term has been muddied […]
May 12, 2005
Religious wars. We have them in IT all the time. Everyone debates architecture. The “high priests” of our trade guard it. The approaches espoused by Ralph […]
April 12, 2005
The thought of meta data management doesn’t exactly inspire whoops of joy from the average IT manager. However, like flossing, it’s one of those things you’ve […]
March 12, 2005
If you’re trying to architect or build a cost-effective, productive business intelligence (BI) program, it’s important that you thoroughly understand the data franchising component of the […]
May 13, 2004
In a previous article, I discussed the importance of adhering to product and technology standards to increase both the ROI of your IT investments and the value […]
December 13, 2003
In an earlier column, I provided an overview of the five data integration framework (DIF) components. This month, I will examine the first component –information […]