Business Intelligence and Excel
By Shankerj
@Shankerj (241)
India
July 24, 2011 4:13pm CST
Initially I Used Advanced Excel Features to fulfill my business intelligence needs.
Later I started using some Advanced BI tools.
Many people, who use Advanced Business Intelligence tools, still copy the output from those tools to Excel for further analysis.
Many BI tool vendors have also provided Excel Add Inns with their tools.
Even If a BI tools comes with many advanced user friendly features, what makes a user to consider Excel for further analysis.
What makes excel so BI friendly,
Have you ever used Advanced features of Excel or any Other BI tool.
Please share your experiences,
2 responses
@dollar3235 (2062)
• India
24 Oct 11
You know Shankerj, there are people who are Excel freaks, I've seen people sending greeting cards in Excel files. It's as if, they can't live without it, that's why when it comes to use Excel for Business analysis, obviously, they prefer it as their first choice. It's not about the features, it's all about getting used to of an application. 
@bsetiadi (9)
•
8 Oct 22
No doubt.
Excel is excellent for processing data, if your data is less than 100.000 rows.
I have the same experience in BI tools and Excel things.
I think what people like from Excel is (compare to BI tool): in Excel you can color the cell, change the font type and size, remove the grid, delete or hide unwanted row easily, etc. It's about the layout.
We have ZAP BI in our company... and it is a great tool and the layout is very clean and neat. I created a great dashboard for the Marketing Manager and asked him to start playing it by filtering and selecting data.
But at the end, he wanted it to be printed or converted to Excel! ....... my God... :D
