+ Reply to Thread
Results 1 to 9 of 9
  1. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #1

    Default Learniing to build dashboards in Excel and Access

    Anyone have any experience building out dashboards? I have found a few websites that claim to teach you for several hundreds of dollars.

    Is this one of those things where I should just banging out VBA in Excel and experiment with Youtube tutorials etc

    or

    Actually going through one of those training programs. I can already do advanced functions in Excel and Access so I am not sure if it's worth it.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    Feb 2012
    Posts
    2,426
    #2
    If you find anything, would you mind sharing. I'm a bit curious myself.

    But to be honest, I've always been a proponent of doing dashboards for reports in Powerpoint instead. It's easier to pull in slides from many areas and roll-them up as a package for reporting purposes.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #3
    I'm importing them into sharepoint now. I used to build them in PowerPoint. My goal is to build interactive reporting dashboards.

    Ill keep you posted
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Feb 2012
    Posts
    2,426
    #4
    Ah - I see what you mean.

    Just a thought....

    If you are looking for interactive dashboards, you may want to think about doing a simple web app with SSRS. It could be a way to build consolidated dashboards and reporting across the org. See Create a Reporting Services report by using Dashboard Designer

    I also played around recently with Pentaho which looks pretty cool - Community Wiki Home - Pentaho Community -*Pentaho Wiki
    Reply With Quote Quote  

  6. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #5
    I've developed a library to simplify the use of the Client Object Model in SharePoint 2010. I use this in conjunction with Kendo Data Viz and I build some pretty decent charts and graphs. This also allows me to easily integrate with non-SharePoint data that has some sort of JSON endpoint.

    HTML5 data visualizations for sleek business apps | Kendo UI DataViz

    Also, there isn't any reason a sophisticated admin who has some Visual Studio skills could not package these into reusable web parts with just a little bit of research.
    Last edited by RobertKaucher; 11-21-2012 at 02:04 PM.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #6
    Thanks for the follow up gents.

    I'll keep all posted as I move forward.
    Reply With Quote Quote  

  8. MCMLXXXVI :: L.O.A.D.B Xcluziv's Avatar
    Join Date
    May 2009
    Location
    ATL
    Posts
    507

    Certifications
    CIW Site Development
    #7
    You can build some pretty slick interactive dashboards with the new BI Stack used within SharePoint with the new features for SQL Server 2012. Using Excel Services, SSAS, SSRS, PowerPivot, PowerView and Performance Point you can build some intuitive dashboards. Using Microsoft Excel 2010 and downloading the PowerPivot plug-in for Excel you can create some quick Excel dashboards in no time via creating PowerPivot workbook.

    PowerPivot for Excel

    Use PowerPivot Workbooks on SharePoint
    Reply With Quote Quote  

  9. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #8
    Us poor users of Standard don't get all that fancy stuff, though...
    Reply With Quote Quote  

  10. MCMLXXXVI :: L.O.A.D.B Xcluziv's Avatar
    Join Date
    May 2009
    Location
    ATL
    Posts
    507

    Certifications
    CIW Site Development
    #9
    Rob, I've on downloadelyd the new features for SQL Server 2012 on our Dev server (using the development version). The Standard copy does not have the BI Stack....only the Development and Enterprise versions....now ask me how I know -_- . Tried installing those features multiple times until one of the Data Services guys looked it up and told me....
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks