Nonprofits and Data

last person joined: 8 days ago 

This group is for those interested in learning and sharing about all things data-related for nonprofits. The Nonprofits and Data group is for people using data to serve a mission, either directly or by improving nonprofits and the nonprofit sector. That includes everything from collecting data and managing databases to analytics, data visualization and data mining. Here are some examples of topics we discuss: using data to improve organizational effectiveness, measuring impact, using data for storytelling, tools for data management and analysis, figuring out the “right” data to collect, and learning skills to help us use data better.

Setting up a data warehouse

  • 1.  Setting up a data warehouse

    Posted Nov 26, 2018 10:17

    Hi everyone,

    I am working with a non-profit that has multiple data systems including Salesforce, an LMS, and several others - all of which, of course, were designed independently of each other so require quite a bit of manipulation in order to join the data from each system to data from another system. We also use Tableau for data visualizations. But, with so many data sources, it's becoming cumbersome to build and refresh these Tableau dashboards. We would like to build a data warehouse where we can pull of this data in, join in, clean it up, normalize it and then push it into Tableau via this one data source. My question is - has anyone worked with a consultant/consulting firm who can help us with the technical set up and design of the data warehouse? Recommendations would be very appreciated. Any feedback on the approach is also welcome; we are learning as we go!

    Best,
    Nandini



    ------------------------------
    Nandini Narula
    Montclair, NJ
    ------------------------------


  • 2.  RE: Setting up a data warehouse

    Posted Nov 27, 2018 13:31
    You can contact me, we've advised on and implemented these projects. Depending on your needs we may be able to help, or to refer you to a specialist partner.

    You can schedule with me directly at http://www.calendly.com/sage70/30min

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