Home > Uncategorized > Make Peace In The BI-Versus-Excel Battle

Make Peace In The BI-Versus-Excel Battle

Managers fear Microsoft Excel undermines business intelligence, but sometimes, it’s the best solution in a fast-paced business environment.

Beyond job security, there are a number of valid reasons that Excel plays a powerful role in business intelligence, such as:

  • Familiar user interface – Attendees acknowledged that Excel is the preferred interface for power users, but managers and front line workers prefer dashboards and easier- to- use tools (they were wowed by SAS’s Email integration)
  • Ability to tweak a report, whether to sort, filter, pivot, or remove a column
  • Extensive formula library
  • Access to multiple data sources – Excel’s ability to combine data from multiple data sources is a must-have requirement for many types of analyses
  • Ability to “massage” the data – Few attendees said they use Excel for data cleansing, but several people spoke of changing group roll ups.
  • Ideal prototyping environment where users themselves can build applications.

By Cindi Howson, InformationWeek

April 11, 2011

Read the full article at: http://www.informationweek.com/news/software/bi/229401300

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: