none
creating charts, dashboards

    שאלה

  • I have an SQL database that I have created several views in. I need to create some charts, graphs, and grids using these views. In essence I need to create a Dashboard SharePoint web site. How can I create my dashboard web site with charts, graphs, etc and connect to my sql views? None of my data is financial data so KPI's at this time aren't need, or are measures, demensions, etc. I just need to create some charts and some graphs and some graphs will have to have drill down capability.

    I was looking at using Dashboard designer and performance point, however, my data is shaped for such a use, is there another way I can accomplish what I want using SharePoint?

    thanks

    יום רביעי 20 יוני 2012 19:41

תשובות

  • SSRS (sql reporting services) is great for that. Charts, grids, conditional formatting, you name it. Once your report is deployed to SSRS, you can use report viewer web parts to display the report as part of your sharepoint dashboard. Report Builder 3 is a free download that you can get to start building reports. And, you can get report samples from here: http://msftrsprodsamples.codeplex.com/

    Also:

    http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/SQL-Server-2012-reporting-services.aspx
    http://msdn.microsoft.com/en-us/sqlserver/cc511478.aspx


    Mike G.

    יום שלישי 26 יוני 2012 13:06
  • M g has some great advice below in regards to SSRS reports.  If you want to utilize the charts and grid functionality within the dashboard designer, your data source has to be a cube in Analysis services.  That is how you can utilize the dimensions and measures.  you can find a helpful guide here http://msdn.microsoft.com/en-us/library/ms170718.aspx if you are unfamiliar with creating cubes within SQL. Thanks,


    יום חמישי 28 יוני 2012 14:41

כל התגובות

  • Hi,

    Thank you for your post.

    I'm trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

    Thanks & Regards,
    Emir


    Emir Liu

    TechNet Community Support

    יום חמישי 21 יוני 2012 12:00
  • Hey CSharpCoder1,

    From your post, it sounds like you want to create a dashboard that pulls information from a SQL table.  The Enterprise BI site with the use of the Dashboard Designer is perfect for accomplishing this.  Once you configure PerformancePoint (PPS) you can launch the dashboard and create a new data source like you see in the picture below

    After you have created the data source, you can create a dashboard and add a chart (s), strategy maps, KPI details, grids, etc to the dashboard along with filters to fit your need. I recommend that you use at least SP1 with the December CU if you want to have cascading filters on the dashboard.  Let me know if this is not the information you wanted, or if i misinterpreted the questions. Thanks,


    • נערך על-ידי baileybb123- MSFT יום שישי 22 יוני 2012 18:10 Edit
    • הוצע כתשובה על-ידי m g יום שני 02 יולי 2012 10:35
    יום שישי 22 יוני 2012 17:48
  • I looked at that, however, none of my data has measures or demensions, its all just a straight pull from views that contain calculations, so of my dashboards will be in a grid format, some are bar charts, some are pie charts, etc but the data isn't structured with measures or demensions, I'm not sure if that makes a difference
    יום שלישי 26 יוני 2012 12:42
  • SSRS (sql reporting services) is great for that. Charts, grids, conditional formatting, you name it. Once your report is deployed to SSRS, you can use report viewer web parts to display the report as part of your sharepoint dashboard. Report Builder 3 is a free download that you can get to start building reports. And, you can get report samples from here: http://msftrsprodsamples.codeplex.com/

    Also:

    http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/SQL-Server-2012-reporting-services.aspx
    http://msdn.microsoft.com/en-us/sqlserver/cc511478.aspx


    Mike G.

    יום שלישי 26 יוני 2012 13:06
  • M g has some great advice below in regards to SSRS reports.  If you want to utilize the charts and grid functionality within the dashboard designer, your data source has to be a cube in Analysis services.  That is how you can utilize the dimensions and measures.  you can find a helpful guide here http://msdn.microsoft.com/en-us/library/ms170718.aspx if you are unfamiliar with creating cubes within SQL. Thanks,


    יום חמישי 28 יוני 2012 14:41
  • I know you're asking about SharePoint solutions, but when you said, "None of my data has measures or demensions, its all just a straight pull from views that contain calculations," I wanted to mention Tableau (tableausoftware.com).

    Our SharePoint admins will not turn on PerformancePoint Services, so our division's dashboards will probably be in Tableau. It connects to a lot and doesn't care what the data looks like.

    יום שישי 29 יוני 2012 21:42