Make Peace In The BI-Versus-Excel Battle
April 11, 2011 No CommentsI would have thought that by now business intelligence tools and Microsoft Excel would be happily coexisting. In some cases they are, but a larger number of Excel users, managers, and BI professionals simply seem battle weary.
This week at TDWI in Washington, DC, I taught an updated course on “BI & Excel: Friends or Foes?” I last taught this course four years ago. I learned my first lesson about BI and spreadsheets the hard way back in the early 1990s. At the time I was the project manager for a reporting system based on a custom transaction system. Typical of many IT projects, I gathered business-user requirements, went away for a couple months (at least it wasn’t a year!), and we developed some parameterized reports on the mainframe.