Home > Systems Channel Tips > Database Management Services > Integrating business intelligence software with Microsoft Excel
Systems Channel Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

DATABASE MANAGEMENT SERVICES

Integrating business intelligence software with Microsoft Excel


Hannah Smalltree, SearchDataManagement.com. Site Editor
07.03.2007
Rating: --- (out of 5)


Systems Channel Update
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


IT Reseller Takeaway: Typically business intelligence (BI) software vendors try to woo users away from Excel and on to their tools. But a number of vendors have recently announced tighter integration with Excel and other Microsoft products. As a channel professional, what could this mean for you? Perhaps there are opportunities and services within this partnership that you can bring to your customers. This excerpt from an article on our sister site, searchDatamanagement.com, tells us how the partnership came about, why the vendors caved and its implications in the BI world.


More on Business Intelligence
Business intelligence software ROI

Business analytics crash course: BI and BPM tools and trends

Business intelligence as a managed service

Business intelligence (BI) software vendors seem to be following the old adage, "If you can't beat 'em, join 'em."

The "'em" in this case is Microsoft Excel, the spreadsheet program that some experts have called the king of BI, thanks to its analytical features, familiar interface and ubiquitous presence on desktops. BI software vendors have long been challenged by Excel's stranglehold and have typically responded by trying to get users off the familiar interface and onto their tools, according to John Hagerty, vice president of research with Boston-based AMR Research. But users still like Excel because they interact with Office daily, and they're comfortable with the interface.

For years, vendors had responded with basic Excel integration functionality. This often meant the ability to save BI reports in an Excel format, Hagerty explained. While this was helpful for some, it didn't do much to solve the integrity issues introduced by spreadsheets. The result of saving a BI report as an Excel sheet was often a spreadsheet with a point-in-time snapshot of BI data, disconnected from source systems, which could then be manipulated and emailed, causing the potential for data discrepancies, Hagerty said.

Recently, BI vendors have announced tighter integration with Excel and other Microsoft Office products. This year brought a spate of announcements from, among others, Ottawa-based Cognos, which unveiled Go! Office; Paris-based Business Objects, which introduced Live Office; and New York-based Information Builders, which recently introduced Quick Data for WebFocus at its user conference, piquing the interest of attendees. While there are nuances to the various products, most of them have similar functionality -- enabling users to access cubes, refresh data and do analysis from within the Excel interface without having to go into the BI system at all. It appears that BI vendors are now embracing Excel, Hagerty said, instead of trying to woo users away from it.

Read the entire article at searchDataManagement.com


Rate this Tip
To rate tips, you must be a member of SearchSystemsChannel.com.
Register now to start rating these tips. Log in if you are already a member.




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Data Mining, Analytics and Business Intelligence Consulting
Business intelligence software immune to recession
How to work with business intelligence vendors
Introduction to business intelligence tools and reporting
Bridging the IT/business gap in business intelligence projects
Business intelligence consulting: Problems and solutions
SSIS brings business intelligence services prospects
Systems products to pay attention to
Stay competitive with Software as a Service business intelligence services
RDBMS performance monitoring tools
SQL Server capacity planning

Database Management Services
SQL Server 2008 Reporting Services for high-availability deployment
SQL Server 2008 Reporting Services for Internet deployment
Key features in SQL Server 2008 Reporting Services editions
SQL Server 2008 hardware and software requirements
Optimizing SQL Server 2008 performance
SQL Server 2008 features study guide
How to automate database integration
Using continuous database integration and a database 'sandbox'
Troubleshooting a failed SQL Server 2008 installation
Microsoft SQL Server 2008 guide

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

HomeNewsTopicsITKnowledge ExchangeTipsMultimediaWhite PapersBlogsEvents
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2006 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts