I would make one distinction between storing the data and analyzing and presenting the data.
When people think of analysis, they often move immediately to the presentation tools (e.g. Tableau, PowerBI, and Qlik). And each vendor will tell you that you can just take your data directly from wherever and put it in the tool and away you go.
However, I would suggest that you need to put the data in a database first unless you are really just using one very simple data source.
Which means, getting the data into a database (like SQL Server, which most small to mid-sized organizations have or can get fro free) and then analyzing it with the appropriate tool.
Also, once you have the data clean and in one place, you can start using Excel for analysis to figure out what you might want to do before you invest in another tool.
Red Three Consulting, Inc.
Helping social service agencies maximize revenue and results with data.
PO Box 280 Bronx NY 10463-0280
Data Warehouses can mean a lot of things – from creating more segments in your general ledger to tools specifically design to manage all the data and reporting for fortune 500 companies.
But I spend a lot of my life getting Excel, csv and other files into SQL server and then getting reports written.
I have a whole bunch of documentation which I've built for myself which I hope to put into edited formatted on just how to do this.
Let me know if you'd like a copy (shooting for March).
I did not see any special Nonprofit pricing for Chartio - but you can get free versions of Tableau and MS Power BI as a nonprofit - may have to pay for some premium features.
I think the Google option too is mostly free -
Stuart F. McClain, CPA (Inactive)
Regional Access Project Foundation
41550 Eclectic St. Palm Desert, CA 92260