Data Analytics use-case

I wanted to see how far I could go using Termux as my data analytics platform running PostgreSQL and R ggplot. It seems entirely possible to convert a large ecological dataset into a modest data warehouse with fact and dimension tables. This project is in design phase and I hope to implement it over the next year. I'm looking for any suggestions or other Data Sciency examples.