We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

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 wmcknight@mcknightcg.com.

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

August 2010 Archives

Do we need business intelligence (BI) tools to be successful?
Get William's take on whether you need business intelligence (BI) tools to be successful and learn how about low cost BI including cheap and open source BI tools.

Fastest way to learn business intelligence (BI)
Find out how you can learn business intelligence (BI), get business intelligence training and discover why analytics is the key to marketing efforts in this BI tip.

Data architect careers: The benefits of working at a System Integrator
Working as a data architect at a consultancy or System Integrator can be challenging, but has benefits. Find out the career value of working at a System Integrator, as advised by William McKnight.

Posted August 20, 2010 3:27 PM
Permalink | No Comments |

Now that the B-Eye Network is fully ensconced in the Tech Target family, I wanted to bring to your attention the "tips" I've been providing to searchdatamanagement.com (also part of Tech Target) over the years.

A consolidated list of tips can be found here on MDM/DW/BI topics such as ETL order, slowly changing dimensions, quick BI, customer matching, data quality, data modeling, standards, using cubes, star vs. snowflake, data mining techniques, planning, project management, and archiving data.

A few favorites are:

Should business intelligence analysis tie in with operational reports?
Read about William's rules for tying business intelligence (BI) system content back to the sources and what "percentage of tolerance" he recommends.

Should a data steward have direct SQL access for reporting purposes?
Find out when a data steward should have direct SQL access and how to request SQL access to get data directly from the data warehouse for reporting and analytical purposes.

Who should the business intelligence team report to?
Learn which department the business intelligence (BI) team should report to -- and why.

I've recently begun the Data Warehouse Strategy Q&A Section.  You can pose questions to me there.  Here are my first two:

How will the Sun acquisition affect Oracle data warehouse strategy?
Find out how Oracle's acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI software plays in Oracle's strategy.

When to use a DBMS and the future of data warehousing data management
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of data warehouse architecture.


Posted August 13, 2010 8:50 AM
Permalink | No Comments |


Search this blog
Categories ›
Archives ›
Recent Entries ›