dwtools

Current version: 0.8.3.9

Data Warehouse, Business Intelligence, data integration helpers. Unifies database connectors to DBI, RJDBC, RODBC, csv. Easy managing multiple simultaneous db connections. MDX like queries on cube class object. Data modelling helpers, denormalization of star schema and snowflake schema, basic normalization. And more.

Installation

library(devtools)
install_github("jangorecki/dwtools")

Features

For basic examples of each function see introduction vignette.

• db: simple database interface accross multiple various connections.
• CUBE: cube class object and MDX like queries on it.
• timing: measure function timing and process metadata, for extended logging see logR package.
• pkgsVersion: batch package version compare between libraries.
• joinbyv: batch join tables, denormalization of star schema or snowflake schema modeled data.
• build_hierarchy: basic hierarchy detection.
• eav: Entity-Attribute-Value data manipulation.
• shinyBI: shinyApp for making aggregates on star schema data.
• idxv: DT binary search on multiple keys, also known as Nth setkey.
• more in introduction vignette.

License

GPL-3.
Donations are welcome and will be partially forwarded to dependencies of dwtools: 19JRajumtMNU9h9Wvdpsnq13SRdZjfbLeN

Contact

J.Gorecki@wit.edu.pl