Good analysing, reporting end-user tool ??

  • Hi,

    I'm looking for a good analysing program for our end-users.

    It needs to be able to :

    1. build queries with a simple GUI(see MS Access)
    2. build pivot reports
    3. build regular reports
    4. save the reports
    5. save qeuries as templates
    6. export the results to other formats(excel)
    7. pass parameters with a simple GUI
    8. easily filter the results (see excel data filter)

    So it should be more or less the combination of MS Access and MS Excel, but only in read mode to the database.

    So any one using such a tool please let me know.

    Thanks

    Serge

  • You seem to have listed the available tools, allowing that level of freedom will surly allow the queries from hell to hit your database so good luck.

    I would have thought the office suite was the answer.  Could be Performance Point Server will do the trick, but I've not installed this yet to know for sure.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • The users will only get access to a datawarhouse not on the production db.

    But thanks for the info.

    rgds

  • you don't think a user can bring a DW server down with a query ? check out Business Objects !!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • I am a bit biased but you might want to take a look at Cizer's Products.   We have two core capabilities within our CNR platform.  One is the ability to design Reporting Services RDL compliant reports in the browser (think of it as zero footprint Report Design similar to Visual Studio's report designer).   The second capability is provided via our QuickQuery technology which gives users the ability to browse schema objects to which they have rights and then build a Reporting Services compliant RDL report via a few simple selections for included columns, filtering, sorting, and basic formatting including uploading a logo.

    We have videos and plenty of references on our website for how our technology works.   The best news is our technology is a cost effective addition that takes full advantage of the Reporting Services licensing you likely already own.    We also expose much of our functionality via webservices in a Drop In Reporting Development Kit.

    Our website is http://www.cizer.com.

    Drop me a line if you like tjohnson AT cizer DOT com.    I'd welcome the chance to discuss further.

    Cheers,

    Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)

    Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
    What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
    Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
    How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm

  • I also forgot to mention that we present the user with parameters from global parameter libraries which you can configure, provide fine grained data access permissions and support the ability to upsize QuickQueries into Reports which are then shared based on roles and the security model.

    Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)

    Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
    What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
    Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
    How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm

  • Have you looked at reporting service that came with SQL Server 2005?

  • I am totally impressed with Dimensional insight's Diver. Great for adhoc analysis and pretty intuitive but it would really depend on your users and how they want to use it.

  • Hi

    Here is another tip ExOpen Report, it's an Excel add-in, that makes the Excel Pivotable Wizard look like kindergarden.

    It's a Swedish company http://www.exopensystems.se, I started out with a 30-days trialversion, contact them so you can evaluate for yourself.

     

  • Don't use Cognos. It sucks.

    Don't use Hyperion.  Oracle just bought it, you don't know what would happen to this product.

  • Any one tried QlikView ? http://www.qliktech.com/Home.asp?id=4

    jeswanth .

    --------------------------------

  • Are the products compliant with SQL Server 2012? The available information seems to reflect the 2005 version and nothing more current.

  • I know this is a SQL Server and Microsoft flavour Forum, but I would try at least the Pentaho Reporting tools

    Paul Hernández
  • My first port of call would be Reporting Services:

    You can build a DW which allows users to create simple drag and drop reports but still provides enough flexibilty for advanced development of more in-depth reports. It plays quite nicely with sharepoint and can be scheduled using SQL agent to generate reports for emailing / publishing on sharepoint

    Oh did I mention it is free (as in it comes as part of the SQL bundle)

    The organisation I am at also use QlikView onto 2005 but I don't much care for it because it builds .qvd files which are its own data store

  • barbara.sorkin (6/11/2013)


    Are the products compliant with SQL Server 2012? The available information seems to reflect the 2005 version and nothing more current.

    Given how old this thread is, that is no surprise.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply