Extract-Transform-Load + Tableau

Published: 21 June 2022
on channel: Agile Frontiers
58
1

Here's a demo of how I created a web page that displays the current Apple Refurbished prices for Mac computers.

It uses Node/Puppeteer to scrape the site (Extract)
Then Node/CSV to convert the JSON into CSV (Transform)
I store the CSV on my GoogleDrive (Load)
Finally, we give Tableau Public permissions to read my Google Drive
And embed the resulting Dashboard into an HTML file
Which I store on an AWS S3 Bucket to be served as part of my website.

Enjoy!

https://greg-smith.com/apple-refurb.html


On this page of the site you can watch the video online Extract-Transform-Load + Tableau with a duration of hours minute second in good quality, which was uploaded by the user Agile Frontiers 21 June 2022, share the link with friends and acquaintances, this video has already been watched 58 times on youtube and it was liked by 1 viewers. Enjoy your viewing!