VizCanvaz

Do you guys know about IFTTT? IF This Then That is really a cool service that makes your life easy. I was thinking of saving my Uber rides trip details to google sheets to track my monthly Uber usage and I found this cool service. It is a free way to get your apps talk to each other. You can automate most of your daily tasks using IFTTT .   There is n number of services available and it is free, you just have to download the app or go to the webpage to make it work. To create your fist IFTTT applet just click on My Applets and then on New Applet After that Click on +this and choose a service from the list and once it's done create that service.

To fetch data from API's is a little difficult task as it involves coding.In Tableau, we have to use web data connector to fetch data from API's and for that first, we have to create a webpage then publish the webpage to a webserver-all these are complex for an ordinary user. Even when we have to import data from a table in a webpage or from API XML output it involves coding to fetch the data or to automate the process. So today I am going to explain a better way of extracting data from API's and web pages without any coding. We can achieve this by making use of google sheets functions such as IMPORTHTML IMPORTXML IMPORTDATA IMPORTFEED To know more about IMPORTXML function you can use this link .But what if we have to fetch data from an API that returns JSON output. So by default, there is no function available in google sheets to import JSON data but by adding the below code written by Brad Jasper and Trevor Lohbeer aka FastFedora we can implement...

Google data Studio(GDS) is based on SaaS(Software as a service, cloud-based) model and in my first look it is a neat and clean visualization tool primarily focused on Google data sources. So for businesses who are into google analytics or Google products can create great visualizations in minutes using DATA STUDIO. It is a free tool for now and is still in beta version. Other than google providers GDS can connect to CSV and databases like MySQL, PostgreSQL .For all other data sources, there are third-party community connectors available. URL: https://datastudio.google.com/u/0/navigation/reporting The look and feel are similar to other Google products like Google Sheets & Docs and all the reports created are saved in google drive. Here goes the list of features that I liked the most in GDS 😊. Easy to share the reports and works similar to file sharing in google drive(even edit permission is possible). Easy to copy the reports and any reports can be used as a template ...