William McKnight
William McKnight brings process, organizational and architectural focus to building strategies and implementing master data management and data warehousing programs that have consistently, for many years, improved the productivity and performance for his clients including several global corporate giants. McKnight, award-winning consultant and author, can be reached at McKnight Consulting Group.
Recent Stories From this Author
How to Predict the Future and Act with Certainty
January 25, 2012 In information management, we can be certain that data volumes are growing, that more data and additional data types will be...
The Value Proposition for Columnar Databases
November 1, 2011 Columnar databases are an essential component of enterprise infrastructure for the storage of data needing specific workloads
Predictive Analytics: Beyond the Predictions
July 1, 2011 Probabilities and Tiered Reactions Derived From Predictive Models Align With Company Goals
Business Intelligence: When Mobility Matters
May 1, 2011 BI has long been discipline to deliver needed information at the right time and increasingly, the players are always plugged in
10 Ways to Screw Up Your MDM Implementation
March 1, 2011 Advice from the consulting trenches about how to get it wrong
Are you Ready for Data Governance?
January 1, 2011 Without rigorous preparation, data governance - and master data management - will never be successful
Data Quality for the Next Decade
November 16, 2010 Organizations with a vision for success must dedicate attention to data quality and modeling
Making Information Management the Foundation of the Future
September 1, 2010 Master data management is an iterative project, rolled out across the organization over time
CASE STUDY: Making Information Management the Foundation of the Future
July 27, 2010 Rent-a-Center (RAC) is a $3 billion dollar, 3,000 store leader in the rent-to-own business . On the verge of replacing...
MDM Project Management
May 1, 2010 Assess the profile of your MDM project management team to understand potential gaps
The Role of the Consultant: Be Conscious of Naming Conventions
March 1, 2010 The efficiency and convenience of having everyone on the same page with their references is unmistakable
90 Days to Success in Consulting
January 2, 2010 True value-added consulting is business, but it's also personal
Master Data Management and the Elephant
November 1, 2009 Each part of MDM has worth, but all the parts together provide the most value
Adding the Analytic Dimension to RFID
September 10, 2009 The real promise of RFID lies in collecting, managing, and analyzing massive amounts of information
Four More Sources of Poor Data Quality
May 19, 2009 How to develop a strategy to identify and understand the issues
The Evolution of Analytic Platforms
April 28, 2009 Companies of all sizes everywhere are engaging in business intelligence. When done properly, nothing adds value to business in...
Seven Sources of Poor Data Quality
March 20, 2009 Quantify types and extent of data quality problems to prioritize efforts
Customer Identification with DUNS
February 12, 2009 As organizations leverage data assets, syndicated data plays a role in MDM
A Catalyst for Recovery
January 29, 2009 Information management will play a major role in recuperating from our economic crisis
Information Management and the Financial Meltdown
November 6, 2008 The answer to Americas financial meltdown will involve information management
The Art of Leadership in IT
September 22, 2008 The prime mover for real improvement in IT could be leadership through positive attitude, delegation, vision, motivation and...
Information Architecture: From Bad to Worse to ... Better?
August 21, 2008 Information architecture in organizations has entered a period of regression rather than progression.
Five Top Mistakes in Information Management Governance
July 23, 2008 One of the most important tasks for effective information management is setting up the business governance over the program...
Building a Leadership Foundation
June 20, 2008 Ill suggest areas where information management leaders can look to build a leadership foundation.
Leadership and Information Management
May 20, 2008 We want to increase the leadership, influence and footprint of information management in the organization for one reason only...
The Face of Analytic Data Access
April 14, 2008 Investments in the online analytical processing paradigm give way to embedded of business intelligence, allowing analysts to...
Why You Need Master Data Management
March 18, 2008 Vendor hype drives business for a while, but soon MDM will have to prove its mettle.
The Data Warehouse Conundrum
March 18, 2008 The data warehouse faces a conundrum, and companies need to make a decision about it.
The Information in Chief Information Officer
January 30, 2008 The roads to BI include data warehousing, enterprise resource planning (ERP), customer relationship management (CRM), master...
Why You Need Master Data Management
January 17, 2008 The vendor hype machine is up and running, and master data management (MDM) will be in your favorite software...
Hospitality Industry Business Intelligence: Checking In
January 3, 2008 The wave of acquisition and consolidation has created new opportunities and demand for BI products and services across the...
Whats Hot in Business Intelligence: A Report From the BI Summit
November 5, 2007
Health Care Business Intelligence: The Time is (Still) Now
October 15, 2007 Far too often entrenched information is found in silos, and conservative cultures are working against progress.
The Four Pillars of RFID
October 1, 2007 Master data, operational business intelligence, concentration and analytics are the cornerstones of a sound information...
Moving Business Intelligence to the Operational World, Part 2
September 1, 2007
Moving Business Intelligence to the Operational World, Part 1
August 1, 2007
DW Design in the Real World, Part 5: Slowly Changing Dimensions
June 1, 2007
DW Design in the Real World, Part 4: Hierarchical Relationships
May 1, 2007
DW Design in the Real World, Part 3: Event-State Management
March 1, 2007
DW Design in the Real World, Part 2: Abstract Design
February 1, 2007
Data Warehouse Design in the Real World, Part 1
January 2, 2007
RFID for the Information Management Professional, Part 2
November 1, 2006
RFID for the Information Management Professional, Part 1
October 1, 2006
Managing Change in Information Management
September 1, 2006
Retail Trends Require Information Excellence
August 1, 2006
Get to the Point
July 25, 2006 Techniques for streamlining the exchange of information within an enterprise
Get to the Point
July 1, 2006
Building Business Intelligence
June 1, 2006
Building Business Intelligence
May 1, 2006
Justifying and Implementing Master Data Management
April 1, 2006 MDM is gaining traction because it entails the organization, management and distribution of corporately adjudicated...
The Perfect Match - 7 Steps to a Master Data Match, Part 2
February 1, 2006
The Perfect Match - Seven Steps to a Master Data Match, Part 1
January 1, 2006
Achieving Compliance and Managing Operational Risk, Part 2
December 1, 2005
Achieving Compliance and Managing Operational Risk, Part 1
November 1, 2005
Achieving BI Query Performance
October 1, 2005
RFID: An Opportunity for Business Intelligence, Part 3
September 1, 2005
RFID: An Opportunity for Business Intelligence, Part 2
August 1, 2005
RFID: An Opportunity for Business Intelligence, Part 1
July 1, 2005
What Does it all Mean?
June 1, 2005
Business Intelligence in Healthcare Today
May 1, 2005
Introducing the Data Warehouse Appliance, Part 2
April 1, 2005
Introducing the Data Warehouse Appliance, Part 1
March 1, 2005
Will Business Intelligence Replace the Business Analyst?
February 1, 2005
Text Data Mining in Business Intelligence
January 1, 2005
Successful BI Requires the Right Focus
December 1, 2004
Rafting Into the Business Intelligence Future, Part 2
November 1, 2004
Rafting Into the Business Intelligence Future, Part 1
October 1, 2004
The New Business Intelligence Architecture Discussion
September 1, 2004
Trend: Good Enough Isn't
August 1, 2004
Building Business Intelligence
July 1, 2004
Using Judgment in Business Intelligence
June 1, 2004
BI Business Value: Does it Come from the Program or the Projects?
May 1, 2004
Business Intelligence Return on Investment Issues
April 1, 2004 Many business intelligence (BI) programs calculate the financial ROI, and this calculation is being made with increasing...
Business Intelligence Continuums
March 1, 2004
"Re: William, You're Mortgage Applicat1on"
February 1, 2004
Hybrid Approaches to Business Intelligence
January 1, 2004
Data Warehousing Requirements Analysis, Part 2
December 1, 2003
Data Warehousing Requirements Analysis, Part 1
November 1, 2003
Building Business Intelligence
October 1, 2003
Overall Approach to Data Quality ROI, Part 2
September 1, 2003
Overall Approach to Data Quality ROI, Part 1
August 1, 2003
Two More Mistakes to Avoid for Mature Data Warehouses
June 1, 2003
Two Mistakes to Avoid for Mature Data Warehouses
May 1, 2003
Back to the Future: Data Mart Consolidation, Part 2
April 1, 2003
Back to the Future: Data Mart Consolidation, Part 1
March 1, 2003
Bringing Data Mining to the Front Line, Part 2
January 1, 2003
Business Intelligence in Enterprise Portals
December 1, 2002 More executives are realizing that the advantage of enterprise
portals is in sharing pertinent business information across...
Bringing Data Mining to the Front Line, Part 1
November 1, 2002
Data Warehouse Justification and ROI
October 11, 2002 This classic article was originally published in November 1999 in DM Review . The ideas are still relevant three years later.
Top 10 Characteristics of a BI/CRM Leader, Part 2
October 1, 2002
Top 10 Characteristics of a BI/CRM Leader, Part 1
September 1, 2002
Supporting KPIs with the Data Warehouse
August 1, 2002 Use data warehouse data to effectively score and support strategic business objectives, monitor progress in real time, drill...
Packaged Business Intelligence in Action
July 1, 2002
PBI in Action
June 1, 2002
Customizing Packaged Business Intelligence
May 1, 2002
Packaged Business Intelligence by Component
April 1, 2002
The Integration of PBI with Existing Data Warehouses
March 1, 2002
Packaged Business Intelligence (PBI)
February 1, 2002
The Workforce Management Data Mart
January 1, 2002
The Clickstream Data Mart
December 1, 2001
The Integration of Data Warehouse Data with Campaign Management
November 1, 2001 The data warehouse provides the empirical data that is needed to
determine the ideal size of the campaign market, develop...
E-CRM – A Definition
October 1, 2001
The CRM-Ready Data Warehouse
September 1, 2001
The Contact Center Data Mart, Part 1
July 1, 2001
Who Owns the Customer? Part 2
May 1, 2001
Who Owns the Customer? Part 1
April 1, 2001
CRM as a Competitive Strategy
March 1, 2001
Personalized Customer Lifetime Value
February 1, 2001
2001 Trends for CRM-Ready Data Warehouses
January 1, 2001
Best Practices Lead the Field
December 1, 2000
The Value Proposition for Data Warehousing Today
November 1, 2000
The E-Mail Marketing Revolution, Part 2
October 1, 2000
The E-Mail Marketing Revolution, Part 1
September 1, 2000
The CRM-Ready Data Warehouse
August 1, 2000
Quality and the Reverse Append, Part 1
July 1, 2000
The CRM Need for Atomic Data
June 1, 2000
The CRM-Ready Data Warehouse
May 1, 2000
Do You Know Who Your Best Customers Are?
April 1, 2000
Supersize My Customers
March 1, 2000
The CRM-Ready Data Warehouse
February 1, 2000 The development and management of successful customer relationships is a defining business strategy, and today's data...
Data Warehouse Justification and ROI
November 1, 1999 It is the task of many data warehouse promoters to formulate the economic expectations and determine the economic value of...









