Making Dashboard in Excel from the SQL Queries

  • Hi,

    Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along with the summary in Excel file.

    I would like to automate this thing and want to know if i can achieve excel output for dashboard on a click of button.

    Please help.

  • bhaskar.thapa (7/20/2015)


    Hi,

    Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along with the summary in Excel file.

    I would like to automate this thing and want to know if i can achieve excel output for dashboard on a click of button.

    Please help.

    Quick suggestion, use PowerQuery to feed straight into a PowerPivot and model your graphs and pivot tables from there.

    😎

  • have used a coupe of techniques for this:

    1. VBA in Excel including a refresh parameter which polls database for results

    2. SQL Server Reporting Services which has a refresh parameter built in - a little more work to configure ReportServer and ReportManager though

Viewing 3 posts - 1 through 2 (of 2 total)

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