This project explores how to use R, Google Drive, Google Sheets, Github Actions and Tableau Public in conjunction to create an automated data pipeline.
Tableau Public is a free platform for exploring, creating and publicly sharing data visualizations online. The free-to-use nature of Tableau Public comes with some limitations, one of which is the restrictions around scheduled refreshing of the source data for your dashboards. If you have ever developed a Tableau Public dashboard that uses data that changes over time, you may have found yourself manually refreshing your data in the desktop application and then republishing to Tableau Public online.
This project describes one method of automating the data pipeline, by taking advantage of several additional free-to-use tools:
- R for data extraction, transformation and loading (ETL);
- Googlesheets and Google Drive for storing the clean data to be supplied to Tableau Public;
- Github Actions for automatic deployment.
The project uses dummy data generated in R to illustrate the methods. The dashboard containing the final output of this project can be found here.
See the Wiki for full documentation including requirements, examples, operational details and other information.
This project is licensed under the CC0 1.0 Universal license. See the LICENSE for details.
- Logo icon created by Uniconlabs - Flaticon
- Raise an issue
- Suggest a feature
- Anything else