Tips on how to properly use Excel for business intelligence projects

What’s your opinion on using Excel for business intelligence projects?

    Requires Free Membership to View

    Login

We’re OK with Excel BI use as long as the data is secured in some fashion. Excel is by far the most widely used technology for BI and reporting. It’s a useful tool, but the data being sourced and then stored in spreadsheets must be governed and secured so that Excel users are utilizing the same information as all of an organization’s other BI users are.

We still see way too many companies allowing business users to be mavericks and use Excel for BI purposes however they see fit. What is the point of putting data governance processes in place and consolidating and validating your data, only to give your users the ability to do what they will outside of that controlled environment?

This was first published in September 2010

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top