Posts

Showing posts from November, 2017

How to clear Tableau Desktop Qualified Associate Exam (TDQA 10).

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

Web Scraping and Automatic data refresh using Google Sheets and Tableau Public

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

Tableau Vs. QlikView

There are n number of data visualization tools available in the market and today I am going to compare the two leaders on Gartner's magic quadrant, Tableau, and QlikView. Tableau was founded in 2003 and is the market leader for five consecutive years. They have major five different products available in the market namely, 1.Tableau Desktop 2.Tableau Public 3.Tableau Online 4.Tableau Server 5.Tableau Reader Tableau Desktop  is the main tool that is used to create dashboards and visualization and is created in C++ programming language. Tableau desktop comes with 14 days trial by default and the cost of the professional edition is  840$  for a year. For more info, you can visit  https://www.tableau.com/pricing . Tableau Public  client is a free version and can be used to create dashboards and visualization like desktop and can open workbooks created by other authors that can be downloaded from the tab...

Contact Form

Name

Email *

Message *