Posts

Showing posts with the label tableau desktop commands

Featured Post

Python Program: JSON to CSV Conversion

Image
JavaScript object notion is also called JSON file, it's data you can write to a CSV file. Here's a sample python logic for your ready reference.  You can write a simple python program by importing the JSON, and CSV packages. This is your first step. It is helpful to use all the JSON methods in your python logic. That means the required package is JSON. So far, so good. In the next step, I'll show you how to write a Python program. You'll also find each term explained. What is JSON File JSON is key value pair file. The popular use of JSON file is to transmit data between heterogeneous applications. Python supports JSON file. What is CSV File The CSV is comma separated file. It is popularly used to send and receive data. How to Write JSON file data to a CSV file Here the JSON data that has written to CSV file. It's simple method and you can use for CSV file conversion use. import csv, json json_string = '[{"value1": 1, "value2": 2,"value3

5 Tableau Features Useful for Data Analytics

Image
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers. CONNECTING TO LOCAL FILE  Tableau can connect to any local file or database such as Excel  Text File Access  Statistical File, or  Another Database file CONNECTING TO SERVER Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAP While working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to the Tableau repository so that any change made here will not affect the original source data. CONNECTING TO EXCEL FILE To connect