Discuss

last person joined: 13 hours ago 

Ask a question. Give advice. Share resources. Looking for software or hardware recommendations? Want to know how others are using text messaging in their work? Trying to find examples of IT policies? The NTEN Discuss forum is a great resource for all of the above and more! It's the general discussion list for the NTEN community, and folks all over the US (and the world) are sharing their questions, answers, and news about nonprofit technology.

Open Source Data Visualization Tool?

  • 1.  Open Source Data Visualization Tool?

    Posted Jun 25, 2019 12:56
    NTENners,

    My team at New America is looking for open-source data visualization tools. Simply put, we have data that is feeding into an API that was developed to be platform agnostic and can be plugged into any visualization tool.

    We're committed to using open source tools wherever possible, and we think it's possible in this case, but we're not familiar with the landscape.

    Any great open source data viz tools out there?

    Thanks in advance!
    Dahna Goldstein
    Tech Accelerate


  • 2.  RE: Open Source Data Visualization Tool?

    Posted Jun 26, 2019 09:03

    Hi Dahna, we've looked at some options for this in the past year and here's what we've found. In terms of free, Metabase looks to be a decent option. For non-free (and non-open-source), Microsoft PowerBI is reasonable, but it depends if their licensing fits with your needs (it does actually have a free option, with some limits).

     

    If you're doing all the calculations and logic yourself and just need a tool that does the graphs, amcharts does a good job. We've also used carto for several project (which is specific to just doing mapping).

     

    Hope this helps!

     

    Thanks,

    Martin

     


    Martin Hansen
    Senior Consultant / R&D Lead
    519.725.7875 x2120 | 888.817.3048


    http://www.peaceworks.ca/sites/default/files/sig/pwsqlogo.png

    PeaceWorks™ Technology Solutions
    101 - 554 Parkside Drive,
    Waterloo ON  N2L 5Z4
    www.peaceworks.ca

     

    Mission driven technology solutions

    http://www.peaceworks.ca/sites/default/files/sig/facebook.png

    http://www.peaceworks.ca/sites/default/files/sig/bcorp.png

    http://www.peaceworks.ca/sites/default/files/sig/linkedin.png

    http://www.peaceworks.ca/sites/default/files/sig/rss.png

    This communication is intended for only the party to whom it is addressed and may contain information that is privileged or confidential. Any other distribution, copying or disclosure is strictly prohibited and is not a waiver of privilege or confidentiality. If you have received this telecommunication in error, please notify the sender immediately by return email and delete this message from your computer.

    Please note: If you do not wish to receive promotional emails from us, please reply to this message indicating your preference and we will refrain from sending further promotional emails.

     




    Tech Accelerate


  • 3.  RE: Open Source Data Visualization Tool?

    Posted Jun 26, 2019 09:41
    There are many, depending on your specific needs. Do you need mapping tools? Network visualizations? Analytics? Dashboarding? A good collection of various tools can be found here - https://www.hackerearth.com/blog/developers/20-free-and-open-source-data-visualization-tools/ If you can share your specific use case, I may be able to narrow it down a bit.


    ------------------------------
    Isaac Shalev
    http://www.sage70.com
    Stamford CT
    @Sage70
    isaac@sage70.com
    ------------------------------

    Tech Accelerate


  • 4.  RE: Open Source Data Visualization Tool?

    Posted Jun 26, 2019 11:58

    Thanks, Isaac.  This is a great list.  The main intended use at this point is creating dashboards.  Any specific tool suggestions would be appreciated!

    Best,

    Dahna



    ------------------------------
    Dahna Goldstein
    Bretton Woods II Fellow
    New America
    Silver Spring
    dahnag@gmail.com
    646- 831-0317
    ------------------------------

    Tech Accelerate


  • 5.  RE: Open Source Data Visualization Tool?

    Posted Jun 26, 2019 13:16
    Metabase, Dashboards by Keen, Mozaik, and Re:Dash are good options. Again though, it will depend on the specific DBs you want to connect to and what types of data you track. A web analytics dashboard is different from a dashboard for monitoring engineering data, which is different from a KPIs dashboard. Different solutions are suited to different use-cases.

    ------------------------------
    Isaac Shalev
    http://www.sage70.com
    Stamford CT
    @Sage70
    isaac@sage70.com
    ------------------------------

    Tech Accelerate


  • 6.  RE: Open Source Data Visualization Tool?

    Posted Jun 26, 2019 14:35
    Fantastic. Thanks so much. And that makes sense. We can dig in from there. 
    Much appreciated,



    Tech Accelerate


  • 7.  RE: Open Source Data Visualization Tool?

    Posted Jun 27, 2019 10:33
    Hi Dahna,

    I know it's not open source, but Tableau does have a good nonprofit program and I know a number of nonprofits have gotten a lot of value from it.

    Disclosure: I work for Salesforce, and they have recently acquired Tableau. No, I have no idea what this means, and can't comment on it.

    ------------------------------
    Marc Baizman
    Evangelist
    Salesforce
    San Francisco, CA
    ------------------------------

    Tech Accelerate


  • 8.  RE: Open Source Data Visualization Tool?

    Posted Jun 27, 2019 13:55
    Also worth noting that Tableau has excellent community supports through the Tableau Service Corps. Free, high quality troubleshooting and consulting!



    ------------------------------
    Gregor Thomas
    ------------------------------

    Tech Accelerate


  • 9.  RE: Open Source Data Visualization Tool?

    Posted 20 days ago
    Of the ones Isacc listed "Metabaes" tends to be the easiest to use but is still difficult to set up with below-average support, IMO. 90% of dashboards can be done  with  Power View, Power Query, or Power Pivot in MS excel with similar effort.

    ------------------------------
    Ellery July
    Saint Paul, MN
    ------------------------------

    Tech Accelerate


  • 10.  RE: Open Source Data Visualization Tool?

    Posted 19 days ago
    Thanks, all, for the ongoing suggestions.  We're still working through our approach, and I'm happy to report back once we've figured things out, if it's of interest.

    Thanks again,
    Dahna



    Tech Accelerate


  • 11.  RE: Open Source Data Visualization Tool?

    Posted 21 days ago
    Maybe a small twist on this Dahna,

    We have introduced a "Dashboard as a Service" that is implemented in several schools systems and the Chesapeake Bay Foundation  - specifically with metrics around membership, giving RoI, mission outcomes, education and events.   The tool is built utilizing "open source",  but is specifically targeted for organizations that can't afford  expensive BI tools (Tableau subscriptions,  etc.), AND the associated  build-out and complex technical maintenance operations.....KPI maintenance, ETL, monitoring ..i.e. organizations that need a economically attractive turnkey solution configured and operated on their behalf.

    We have off the shelf ETL connectors to several NfP systems (Salesforce, Blackbaud, etc.) that draws data out nightly to update the dashboard as configured.

    Happy to discuss and demonstrate what we have done for CBF - feel free to contact me anytime.
    thanks
    Rob

    ------------------------------
    Robert Bowell
    Senior Vice President
    Tandem Conglomerate
    robert.bowell@tandemconglomerate.com
    301.704.1741
    ------------------------------

    Tech Accelerate


  • 12.  RE: Open Source Data Visualization Tool?

    Posted 18 days ago
    Hi Dahna,

    Looks like you've got a lot of great suggestions, but wanted to throw some other ideas into the mix. My company, First Turn Media, works extensively with nonprofits and open source. We have started to do extensive work on data visualization, and recently did an exciting project with Galapagos Conservancy explicitly around data visualization that included dashboards. We use a backend CMS/database and an API, and the most common tools we use are graphql (originally created by Facebook but now open source), and we also use React, as well as some exciting open source mapping tools. I'd be happy to chat with you on ways to integrate these for high performance and intuitive dashboards.

    Best,
    Emily

    ------------------------------
    Emily Frazier
    Owner
    First Turn Media
    Burlington, VT
    ------------------------------

    Tech Accelerate