locked
MSBI Tools Comparison RRS feed

  • Question

  • Hi All,

    Does anyone have any Tool comparison for Reporting in Microsoft Products or other third party tools like:

    1. SSRS

    2. Dundas

    3. Excel PowerPivot

    4. PPS

    etc.

    • Moved by Cleber Marques MSFT Thursday, March 1, 2012 3:11 AM (From:Microsoft Operations Framework -- MOF 4.0)
    Wednesday, February 22, 2012 4:28 PM

Answers

  • Hi Mayank,

    There are various tools available in Microsoft for reporting and dashboarding. It depends on the requirement what is to be used

    • Report Designer - This is the standard tool for creating SSRS reports and for deploying to a report server. It also supports Dundas charts, gauges, maps, sparklines etc.
    • Report Builder - This is a adhoc reporting tool with Office like environment for business users to create their own reports. This is available in Sharepoint 2010 as well as part of SQL Server 2012 enhancements.
    • PerformancePoint Services - This option is to be used to create KPIs and scorecards to implement enterprise dashboards in Sharepoint
    • PowerPivot - This is a self-service BI option available in Excel as an addin and available as a service in Sharepoint as part of SQL Server installation (2008 R2 and 2012). You can work with millions of data, import them into Excel and create Pivot tables and charts on top of it. It uses inbuilt Analysis service engine (Vertipaq) and high data compression to implement this.
    • Power View - This is a new feature that will be coming up in SQL Server 2012. It is a adhoc reporting tool accessible from a browser and is available in Sharepoint. It will be using Power Pivot models deployed on Sharepoint as datasource. It has some cool Silverlight features to create visually enhanced reports

    Regards

    Manoj

    ~Mark as Answer if found correct

    • Marked as answer by Challen Fu Tuesday, March 6, 2012 2:58 AM
    Thursday, March 1, 2012 4:48 AM

All replies


  • Sorry, but you have posted your question in a forum that talk about Microsoft Operations Framework (MOF), then I am moving your post to another forum and I hope you can get some help. But if you want you can try to find other forum by yourself:

    http://social.technet.microsoft.com/Forums/en-US/


    Hope that helps

    Regards,

    Cleber Marques

    Microsoft MVP & MCT | Charter Member: SCVMM & MDOP
    MOF Brazil Project: Simplifying IT Service Management
    My Blog | MOF.com.br | CleberMarques.com | CanalSystemCenter.com.br
    Thursday, March 1, 2012 3:05 AM
  • Hi Mayank,

    There are various tools available in Microsoft for reporting and dashboarding. It depends on the requirement what is to be used

    • Report Designer - This is the standard tool for creating SSRS reports and for deploying to a report server. It also supports Dundas charts, gauges, maps, sparklines etc.
    • Report Builder - This is a adhoc reporting tool with Office like environment for business users to create their own reports. This is available in Sharepoint 2010 as well as part of SQL Server 2012 enhancements.
    • PerformancePoint Services - This option is to be used to create KPIs and scorecards to implement enterprise dashboards in Sharepoint
    • PowerPivot - This is a self-service BI option available in Excel as an addin and available as a service in Sharepoint as part of SQL Server installation (2008 R2 and 2012). You can work with millions of data, import them into Excel and create Pivot tables and charts on top of it. It uses inbuilt Analysis service engine (Vertipaq) and high data compression to implement this.
    • Power View - This is a new feature that will be coming up in SQL Server 2012. It is a adhoc reporting tool accessible from a browser and is available in Sharepoint. It will be using Power Pivot models deployed on Sharepoint as datasource. It has some cool Silverlight features to create visually enhanced reports

    Regards

    Manoj

    ~Mark as Answer if found correct

    • Marked as answer by Challen Fu Tuesday, March 6, 2012 2:58 AM
    Thursday, March 1, 2012 4:48 AM
  • Hi Mayank

    Business intelligence tools are a type of application software designed to retrieve, analyze and report data. The tools generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart.

    You Will get more Reporting Tools as below more informations available on below link Comparison of reporting tools: 100% vendor independent

    1. Oracle Enterprise BI Server Version Vendor 11g1 Oracle
    2. SAP Business Objects Enterprise Version Vendor XI r4 SAP
    3. Microsoft BI tools (integrated BI offering*) 2008/2010 Microsoft
    4. SAS Enterprise BI Server Version Vendor 9.2 SAS Institute
    5. Microstrategy Version Vendor 9 Microstrategy
    6. IBM Cognos Series Version Vendor 10 10.1 IBM
    7. QlikView Version Vendor 11  QlikTech
    8. Board Management IntelligenceToolkit Version Vendor 7.1 Board International
    9. BizzScore Suite Version Vendor 7.3 EFM Software
    10. WebFOCUS Version Vendor 8 Information Builders
    11. JasperSoft (open source) 4.5 Version Vendor  JasperSoft
    12. Oracle Hyperion System Version Vendor 9 Oracle
    13. SAP NetWeaver BI Version Vendor 7.3 SAP
    14. Style Intelligence Version Vendor 11  InetSoft
    15. Pentaho BI suiteVersion Vendor  (open source) 4  Pentaho
    16. Tableau Software Version Vendor 6.1  Tableau Software

    Suhas_Akole


    Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

    Thursday, March 1, 2012 5:04 AM