Geekcamp.SG

By Geeks. For Geeks.

Data Engineering for Analysts

By Hairizuan Noorazman

Analysts have always been creating reports which they can then use for analysing the performance of their business. Common tools they would use to do so are Spreadsheets but doing so would mean that they would have to recreate the report each time it is requested. In order to combat this, some would use R or VBA to automate some of the dataflows to make it easier to recreate those said reports.
I will be sharing on how one can use R to integrate different technologies out there such as Google BigQuery, Google Spreadsheets, Google Analytics and Slack in order to create automated data flows for users.