Share what you know with millions of people
Focus is the best place to turn what you know into remarkable content
0
Which BI systems integrate well with Microsoft Office products?
Which BI systems integrate well with Microsoft Office products? Which systems do not integrate so well?
Events
- Dos and Don'ts of Small Business Marketing May 29 @ 11 am PT
- Lead Nurturing 202: The Next Generation May 31 @ 11 am PT
- The Tricks to Paid Media June 6 @ 11 am PT
- Display Advertising for Brand Awareness June 20 @ 11 am PT
Related Activity
3 Answers
Bime Desktop is a BI solution that integrates well with MS Excel. The connection builder will automatically pick up the headings from your spreadsheet and put them into the schema, either as measures or attributes. You can then create new dimensions or attributes if you wish, and move things around to form hierarchies. It's very simple and easy to use.
It would really depend on what you have. But I would say that SQL Server with SS*S (SSAS - Analytical Services, SSIS - Integration Services, SSRS - Reporting Services) works with office. If you want an seamless integration that is rather nice for functionality and immediate customer use, no need for a huge Data Warehouse effort, then I would recommend the following.
-SQL Server Enterprise with SS*S installed (included in server cost)
-SharePoint 2010 w/ Enterprise CAL (Enterprise gives you PowerPivot. You also get Performance Point which can help.)
-Office 2010 w/ the PowerPivot Add-On (Free from the Office site and actually can be used with and/or without SQL/SharePoint)
If you haven't seen the demo's of PowerPivot (in SharePoint and Excel Add-on) then it is worth going to the MS site to take a look.
Hi Rick,
Take a look at the following link on IBM Cognos solutions for Microsoft. Cognos is the business intelligent solution Integrates performance management into your Microsoft environment to deliver powerful reporting, scorecarding and planning capabilities to everyone in your organization.
http://www-01.ibm.com/software/data/cognos/solutions/microsoft/
Please feel free to give me contact: jchou@ca.ibm.com
Answer This Question