Blog: William McKnight Subscribe to this blog's RSS feed!

William McKnight

Hello and welcome to my blog!

I will periodically be sharing my thoughts and observations on information management here in the blog. I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals. I have played many roles, but the perspective I come from is benefit to the end client. I hope the entries can be of some modest benefit to that goal. Please share your thoughts and input to the topics.

About the author >

William is the president of McKnight Consulting Group, a firm focused on delivering business value and solving business challenges utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures. William functions as strategist, information architect and program manager for complex, high-volume, full life-cycle implementations worldwide. William is a Southwest Entrepreneur of the Year finalist, a frequent best-practices judge, has authored hundreds of articles and white papers, and given hundreds of international keynotes and public seminars. His team's implementations from both IT and consultant positions have won Best Practices awards. He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA. William is author of the book 90 Days to Success in Consulting. Contact William at

Editor's Note: More articles and resources are available in William's BeyeNETWORK Expert Channel. Be sure to visit today!

December 2006 Archives

I have heard a lot about, though not worked on, the federal government's data warehouses. Some things are pretty clear. It is (they are?) large. This article cites 659 million records in the FBI's database. Look at the data sources - FBI records and criminal case files, Treasury, State and Homeland Security departments and the Federal Bureau of Prisons - more than 50 FBI and other government agency sources.

And look also at the benefits of data integration - 32,222 hours for a query down to 30 minutes or less.

There are 13,000 users and 1 million queries per month.

Actually, the article, written by a Washington Post Staff Writer, reads like any other data warehouse success story or case study - except those aren't bread and milk purchase transactions in there. CRM = Citizen Relationship Management anybody?
Technorati tags: Data Warehouse

Posted December 19, 2006 9:04 AM
Permalink | 1 Comment |

I've finally taken the plunge and launched a channel here at the B-eye-network on RFID. As I say there...This channel will focus on realizing the information potential of the automatic identification technology radio frequency identification (RFID). I believe that the value proposition for RFID will come in the mastery of the high volumes of data that the deployments will generate. Transformation of that data to actionable information, as has been done for ERP and numerous other operational systems, will be a high hurdle and require innovation.

Interrelated topics to the RFID information experience include master data management, techniques for managing large amounts of data and advanced levels of customer relationship management that come with detailed tracking capabilities. Stay tuned right here for knowledge to master the subject area of RFID and the innovation required to harness RFID information. I’ll use my background as an information architect and owner of numerous information management initiatives to create and share the relevant insights, advisement and commentary on the subjects, as well as other information management trends.

My blog will continue to discuss all information management topics. Please feel free to share your comments or content ideas with me at

Technorati tags: RFID

Posted December 15, 2006 1:43 PM
Permalink | No Comments |

Should your website change based on who's visiting it? X+1 says yes.

Some people say there is no such thing as coincidences. Well, I'm starting to believe it after reviewing X+1 and learning about some of the technology behind some major websites. X+1 is a customer interaction optimization tool that customizes your experience on their sites based on "anonymous attributes." All sites can pick up the site you came from, your bandwidth, the timestamp, your Prizm cluster, geography and probably several other attributes.

These attributes plus your actual clickstream on the site equal your site experience. X+1 uses its extensive intellectual property to optimize the experience according to corporate strategy, such as desire to emphasize a certain product set. The learnings are also helpful in determining a profile for marketing lists (which geographies are visiting and staying?) and clearly site registrations add to the possibilities.

Try this. Go to, then go to My first "hero image" is of the Highlander. Go to, then to My first hero image is the Prius. Go to, then to I see the Sienna first. Coincidence? Hardly.

Posted December 14, 2006 12:41 PM
Permalink | 1 Comment |

It seems every organization now wants to optimize. Optimize what? Optimize everything, but especially business processes. Global 360 is a business process optimization tool with a serious acknowledgement of the advances that business intelligence has made. It is a workflow tool but, after establishing the links from processes like cycle times, wait times, working times, and resource times to the tool, actually tracks the execution of each process in the visual workflow designer interface. So, you can sit there and watch business processes execute. However, what is really appealing is the "what if" simulation analysis. What if I streamlined a process with more people on it in peak times or upgraded the equipment to improve thoughput? See the results in terms of throughput AND COST with Global 360.

Technorati tags: Global 360, BPM
Business Process Management

Posted December 13, 2006 2:19 PM
Permalink | No Comments |

Ram Ramanathan, Senior Product Manager of SQL Server at Microsoft, and I, have prerecorded a webinar on the topic of SQL Server 2005. "In this webcast, we describe how Microsoft SQL Server 2005 provides a robust, scalable, and enterprise-ready data warehouse environment." A demo is included.

It is available at this link.

The format is Windows Media Player. Enjoy.

Posted December 12, 2006 2:22 PM
Permalink | No Comments |

Are you tired of searching for those RFID tags on your clothing? According to this article, IBM has developed a chipped tag, adopted by Marnien Management Ltd., that allows you to remove the antenna from the tag easily. I note that the chip itself will remain on the item, so reading will still be possible, but the read range will be limited without the antenna.

Perhaps this is a workable middle ground in the emerging battle between industry and privacy. It does clearly expose the tag to the consumer, which should be more important to privacy advocates than the easy ability to "rip off" the antenna. After all, most consumers are unaware of the tag. This would be a blow to data collection since many would get ripped off and put the consumer in more control of when their tag is read although surreptitious reads are still possible without an antenna.

Technorati tags: rfid,

Posted December 8, 2006 3:35 PM
Permalink | No Comments |

Search this blog
Categories ›
Archives ›
Recent Entries ›