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 […]
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. […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]