The answer should be no in my opinion… for large amounts of data Excel is not the right tool by itself, and usually BI is all about analyzing large amounts of data.
However, the comfort of using Excel to analyze numbers isn’t something that’s going away any time soon.
What makes it a BI tool?
• Excel can be (and is often) used for operational reporting, by connecting to databases, and also for analysis and dashboards using pivot tables and charts (plus the power of VBA — Visual Basic for Applications).
• Excel does not necessarily have to be embedded in other applications.
• Excel certainly has sufficient market presence, well exceeding the stipulation above.
• Excel comfortably crosses $40 million in revenues, even when constrained for reporting and analysis usage. (Microsoft Office accounts for some $10 billion annual revenue, give or take a couple.)
Is Excel a Complete BI Solution? | The Intelligent Enterprise Blog
Searching Google for Sheet1 filetype:xls shows us there is a long way to go before getting rid of Excel.
Results 1 - 10 of about 2,000,000 for sheet1 filetype:xls. (0.28 seconds)
No comments:
Post a Comment