VizCanvaz

The nice way to create KPI's in Tableau with a good or bad indicator is to use the custom format option. Follow the below steps to create a cool looking KPI. At first, create a calculated field in Tableau based on your KPI definition. In my case, I am using the Profit Ratio calculated field in the Super Store sample dataset. Custom format used : ▲ +0"%"; ▼ -0"%"; ► 0"%" Happy Tableauing :)

The easiest way to fetch data from databases to Excel is using the Get Data option available under the Data Tab, Excel creates a query using the ODBC connection and fetches the data without the hassle of coding. But coding makes the process more flexible and is very dynamic. Here goes the details... 1) Download and install the snowflake ODBC driver either 32 or 64 bit depending on your MS Office Installation & OS from the SnowFlake portal, available under the Help menu. 2) Create a DSN with the correct connection properties. 3) Add the below reference if required in the visual basic editor and also change the DSN name in the VBA code. VBA Code...  '----------------------------------------------------------------------------------------------------------------------------------------- Sub VBA_SnowFlake_Connect() Dim sSQLQry As String Dim ReturnArray Dim Conn As ADODB.Connection Dim rs As ADODB.Recordset Dim DBPath As String, sconne...

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...

Preparation Time : Minimum 4 weeks for candidates with no prior Tableau experience. Tableau DQA is a 2 hours exam which consists of 36 questions, both theoretical and practical. All questions must be answered to complete the test(there is no negative marks) and 75 % score is needed to pass the test. Questions are either multiple-choice, multiple-answer, or True /False. TDQA10 . Total Time 2 hrs. Total Questions 36 Marks distribution 2,3&4 Total Points 100 Passing Points 75 Category Points Mod 1 - Data Connections 22 Mod 2 - Organizing and Simplifying Data 10 Mod 3 - Field and Chart Types 16 Mod 4 - Calculations 18 Mod 5 - Mapping 8 Mod 6 - Analytics 15 Mod 7 - Dashboards 11 Total 100 TDQA Preparation Materials Watch all the Tableau...

Recently I have figured out how to do web scraping using google sheets and to automatically refresh a dashboard on tableau public. So here it is…just sharing what I have learned. Tools I have used Tableau Public Desktop. Google Sheets. At first, you have to find out the live data source and import that data to google sheets. In my case, I have fetched the live air pollution data from  https://data.gov.in/catalog/real-time-air-quality-index  and next step is to import that data to google sheets. Input is an XML file and was available using API and I have got the access by registering and generating an API key. Next step open your google sheets and import the data using IMPORTXML function available in google sheets.   Format : IMPORTXML("URL","XPath") URL : link to your data source XPath : used to navigate through elements and attribute in XML ( https://www.w3schools.com/xml/xpath_intro.asp ). Same way there are different functions ...