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?
See if you have what it takes to use Excel for accounting
Dig Deeper on Microsoft business intelligence platforms
Related Q&A from Brian Jordan
Expert Brian Jordan discusses three common mistakes that BI teams make when training business users and offers advice on how to avoid them. Continue Reading
Find some basic ways of improving BI performance at your company. Learn about in-memory analytics, columnar databases and how data aggregation ... Continue Reading
Are businesses deploying business intelligence dashboards and scorecards to workers other than managers and senior executives? Learn about high-level... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.