When all else fails, Wikipedia.... http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products
RapidMiner and Pentaho Community Editions both look appealing. I hope to try them out soon. I also found the Ruby ActiveWarehouse and ActiveWarehouse-ETL projects which look pretty cool for Rails projects, but maybe a bit stale. Jason Jason Stirnaman Biomedical Librarian, Digital Projects A.R. Dykes Library, University of Kansas Medical Center jstirna...@kumc.edu 913-588-7319 >>> On 9/13/2011 at 04:37 PM, in message <4E6FCD17.CF3 : 5 : 23711>, Jason >>> Stirnaman wrote: Thanks, Shirley! I remember seeing that before but I'll look more closely now. I know what I'm describing is also known, typically, as a data warehouse. I guess I'm trying to steer around the usual solutions in that space. We do have an Oracle-driven data warehouse on campus, but the project is in heavy transition right now and we still had to do a fair amount of work ourselves just to get a few data sources into it. Jason Stirnaman Biomedical Librarian, Digital Projects A.R. Dykes Library, University of Kansas Medical Center jstirna...@kumc.edu 913-588-7319 >>> On 9/13/2011 at 04:25 PM, in message >>> <can7tqjapw78rpgzpu1l5qvoj6iw9rrkmzl+yeygqbov-gzo...@mail.gmail.com>, >>> Shirley Lincicum <shirley.linci...@gmail.com> wrote: Jason, Check out: http://www.needlebase.com/ It was not developed specifically for libraries, but it supports data aggregation, analysis, web scraping, and does not require programming skills to use. Shirley Shirley Lincicum Librarian, Western Oregon University linc...@wou.edu On Tue, Sep 13, 2011 at 2:08 PM, Jason Stirnaman <jstirna...@kumc.edu> wrote: > Does anyone have suggestions or recommendations for platforms that can > aggregate usage data from multiple sources, combine it with financial data, > and then provide some analysis, graphing, data views, etc? > From what I can tell, something like Ex Libris' Alma would require all > "fulfillment" transactions to occur within the system. > I'm looking instead for something like Splunk that would accept log data, > circulation data, usage reports, costs, and Sherpa/Romeo authority data but > then schematize it for data analysis and maybe push out reporting dashboards > <nods to Brown Library http://library.brown.edu/dashboard/widgets/all/ > > I'd also want to automate the data retrieval, so that might consist of > scraping, web services, and FTP, but that could easily be handled separately. > I'm aware there are many challenges, such as comparing usage stats, shifts in > journal aggregators, etc. > Does anyone have any cool homegrown examples or ideas they've cooked up for > this? Pie in the sky? > > > Jason > Jason Stirnaman > Biomedical Librarian, Digital Projects > A.R. Dykes Library, University of Kansas Medical Center > jstirna...@kumc.edu > 913-588-7319 >