Q

Tips on how to properly use Excel for business intelligence projects

Learn how to properly use Excel for business intelligence projects, including advice on governing and securing your data sources and putting data governance processes in place.

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

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?

Next Steps

See if you have what it takes to use Excel for accounting

This was last published in September 2010

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Interesting article with some good links. shows us some of the options available. 
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchAWS

SearchContentManagement

SearchCRM

SearchOracle

SearchSAP

SearchSQLServer

SearchSalesforce

Close