According to a recent survey, many users are still using Microsoft Excel spreadsheets to analyze and report on corporate data. These same users also spend much of their data-gathering time correcting out-of-date information in these Excel spreadsheets. So what are the real benefits of using Excel spreadsheets to analyze and report data? What additional benefits do business intelligence (BI) tools offer?
In this podcast, SearchCIO.com interviews data warehouse consultant Rick Sherman on the differences between BI tools and Microsoft Excel spreadsheets and how they can be used together in the enterprise to gather and analyze data.
BIOGRAPHY: Sherman, founder of Athena IT Solutions Inc., has more than 20 years' data warehousing and decision support systems experience. His work designing and implementing relational database for decision support systems began with Oracle in 1982. Sherman has worked on more than 50 data warehouse and data mart implementations across many industry groups, sourcing data from a variety of business applications. He has been an expert instructor and speaker at numerous data warehousing conferences and seminars.
Play now:
Download for later:
BI tools vs. Microsoft Excel spreadsheets
- Internet Explorer: Right Click > Save Target As
- Firefox: Right Click > Save Link As
This was first produced in January 2009