The Business Intelligence Guide
   BI Strategy | BI Program | BI Projects | BI Data | BI Infrastructure | BI User Tools | BI Vendors | Resource Guides | Articles | BI Blog | BIG Bookstore

Get a FREE Sample of the
The Total BI Guide
THE LOGICAL ORGANIZATION

and receive the
TLO NEWSLETTER
Just enter your details below

Email:
Name:
 
HOME
 
Business Intelligence
BI Strategy
BI Program Guide
BI Tools
- Dashboards
- Scorecards
- Operational BI
- Analytics
BI Software Solutions
Data Management
Databases
DataWarehouses
Decision Support
Marketing Tools
Industry Solutions
Case Studies
BI Surveys & Awards
RESOURCES
ARTICLES
BI EVENTS
BI NEWS
Sitemap

About the Author

View Gail La Grouw's profile on LinkedIn

Google+ Gail La Grouw

Bookmark and Share

Using Microsoft Excel in Business Intelligence


The mere hint of spreadsheets in business intelligence once brought tremors to most BI consultants, with spreadmarts depicting the worse possible scenario in uncontrolled data and multiple versions of the truth.

However, following the slow initial adoption to complex BI tools, the business intelligence market has reassessed the use of MS Excel, not as a holder of data, but as a more acceptable interface into the BI Data Warehouse.

The following brief video [sorry - no sound] demonstrates how to use MS Excel 2007 for business intelligence. [2:08]

 

 

Incorporating Microsoft Office into business intelligence has been a major step forward towards operationalising BI. User adoption increases significantly where commonly used interfaces are employed. By keeping the data management and analytical capabilities in the back room, and bringing insight to the desktop, business intelligence is gaining much wider acceptance across the enterprise.

Back To Top

Find Out About Our Leading Executive Guide To BI Strategy, Program & Technology


BI Tools Index | Advanced Analytics | OLAP | Cube Analysis | Ad Hoc Query Analysis | Data Mining | Alerting | Scorecards | Dashboards | Using A Dashboard | BI in BPM | MS Excel | Text Mining

Bookmark and Share
 


THE LOGICAL ORGANIZATION

A Strategic Guide To Corporate Performance Using Business Intelligence

THE COMPLETE BI MANUAL
FOR MANAGERS & CONSULTANTS

The Logical Organization Book Cover