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!

Recently in Excel Category

As long as business intelligence has been around, the question of Microsoft Excel's role has existed.

This report from makes it clear that, in the BPM arena, as much as it has been tried to woo users off of Excel, that vision has not been achieved. Financials analysts continually wander back to the control that Excel gives them.

Most every BI professional who has engaged users has encountered the directive of "just give me the data and I'll pull it into Excel." I certainly have. It makes it hard to establish common functionality in modern OLAP tools for the enterprise. Many users are missing out on more functionality due to the perceived loss of Excel functionality.

I would still argue that there's a place for Excel in the BI environment. I would also argue that there's a loss of efficiency when it's the only tool in use for BI. There's no easy answer here, but there is a balance point that needs to be achieved.

A couple of the pillars we use for establishing a BI program is some top-down direction for the use of the OLAP tools for primary access. The other is giving training to users on the tools so they can feel comfortable with them.

Posted August 27, 2005 11:35 AM
Permalink | No Comments |

Search this blog
Categories ›
Archives ›
Recent Entries ›