5 Useful Tableau Features for Data Analytics

-
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers.


5 Useful Tableau Features for Data Analytics
5 Useful Tableau Features for Data Analytics

CONNECTING TO LOCAL FILE 

Tableau can connect to any local file or database such as
  • Excel 
  • Text File
  • Access 
  • Statistical File, or 
  • Other 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 Tableau repository so that any change made here will not affect the original source data.


CONNECTING TO EXCEL FILE


To connect to an excel file, click “Excel” on the left hand side. Navigate to the file on your computer and double click to open it. For this tutorial, I will use a sample file that comes with the installation called “superstore”. You should open the appropriate file that you will be working with.

Now you are in the data connection window. It looks like the following Notice that I have three sheets in this file Orders,People, and Returns. I can simply drag the table I want. If I drag more than one table,Tableau automatically creates the join between the tables.

Creating charts


Based on the data we connected is easy. At the bottom of the page, Click on a sheet, Tableau automatically separates the data into Dimensions and Measures.

Dimensions are the categorical fields. These fields will create labels in the chart. Measures are the quantitative fields. These are the numbers we want to analyze. They create axis in the chart. Sometimes, it might be confusing what type of chart should be used for a specific data. Tableau has an interesting feature called “Show me”. “Show me” is the list of the possible charts that can be created using different combination of data.

CREATING DASHBOARD


Tableau Dashboard contains all the related features intuitively interconnected to provide interactive and real-time dashboard experience for non-technical users. To create a dashboard, click “New Dashboard” icon at the bottom the page. 

Comments

Post a Comment

Thanks for your message. We will get back you.

Popular posts from this blog

How to Fix Python Syntax Errors Quickly

-
Image
In Python, you can call parsing errors Syntax errors. How to fix the syntax errors quickly, I can show in this post. Also, check Python Syntax Errors Cheat Sheet. Python Syntax Error. If you run the Python code, the interpreter first parses the logic. If any errors found, it is the developer's responsibility to fix them. Courtesy: Python documentation. >>> while True print('Hello world')   File "<stdin>", line 1     while True print('Hello world')                    ^ SyntaxError: invalid syntax How to Fix the Syntax Error First, check for the line number. In the above case, it is '1'. Then look for the symbol '^'. The issue is at the PRINT function. The reason is before the PRINT function you need a colon ':'. That is the reason, you are getting error. This is a syntax error. Find below the corrected logic: >>> while True : print('Hello world')   File "<stdin>", line 1     while Tr
Read more

Python Ideas to Remove HTML tags

-
Image
HTML and XML tags are common in the raw data. I have shown the best example of how to remove HTML and XML tags using BeautifulSoup. In Python, the prime step of  text analytics is cleaning . You can remove HTML tags using BeautifulSoup parser. Checkout Python Logic and removing HTML tags. When analyzing web data, consider the below examples for your projects. Python Ideas to Remove HTML tags How do I remove HTML tags using BeautifulSoup? Import BeautifulSoup Python Logic to Remove HTML tags Before and after executing the code 1. Import BeautifulSoup import BeautifulSoup from bs4 2. Python BeautifulSoup: How to Remove HTML Tags from bs4 import BeautifulSoup soup = BeautifulSoup ("<!DOCTYPE html><html><body><h1>My First Heading</h1><p>My first paragraph.</p></body></html>") text = soup. get_text() print (text) 3. Before and After Run Before Run Before Executing the code After Run Result after executing the code Bottom-lin
Read more

Hyperledger Fabric: 20 Real Interview Questions

-
Image
I am practicing Hyperledger. This is one of the top listed blockchains. This architecture follows R3 Corda specifications. Sharing the interview questions with you that I have prepared for my interview. Though Ethereum leads in the real-time applications. The latest Hyperledger version is now ready for production applications. It has now become stable for production applications. The Hyperledger now backed by IBM. But, it is still an open source. These interview questions help you to read quickly. The below set of interview questions help you like a tutorial on Hyperledger fabric. Hyperledger Fabric Interview Questions 1). What are Nodes? In Hyperledger the communication entities are called Nodes. 2). What are the three different types of Nodes? - Client Node - Peer Node - Order Node The Client node initiates transactions. The peer node commits the transaction. The order node guarantees the delivery. 3). What is Channel? A channel in Hyperledger is the subnet of
Read more

Python: Swap Two Strings no need to Define Third Variable

-
Image
Swap two strings no need to define third variable in Python explained. To achieve this, you need a tuple, explained with an example of how to do it. Python ideas How to Swap Two Strings in Python You can swap two strings in Python using a tuple. You can have multiple values in a tuple. In this example, I have given a and b. When you use the swap function, it swaps the values. def swap(a, b):  return b,a  Example to Swap Two Strings. i = "Hello world" j = "This is ApplyBigAnalytics"  i, j = swap(i, j)  print(i)  print(j)  Example to Swap Two Numbers. i = 1  j = 2  i, j = swap(i,j)  print(i)   print(j) The Result is: This is ApplyBigAnalytics  Hello world  2  1 Keep Reading The Real Purpose of Underscore in Python 
Read more

Calculate Circle Area the Logic You Need to write in Python

-
Image
In Python, you can calculate the circle area easily by using the function. The purpose of Python is to use in data analysis. You need this logic in many areas. You can use in your present finance projects or new ones. Benefits of function you can re-use the same code number of times Area of Circle=pi*r*r Area of Circle Steps Given - You Can do Using Two Methods, Explained Both Methods I have given steps to calculate the  area of a circle using two different methods. First I followed by creating a user-defined function. Next, directly I ran the formula in the interpreter. Method-1 Steps I have followed to Calculate Area Using Function Logged into Cent Os (Linux) Create .py module Import .py module into Python Execute .py module  1. Log in I have first logged into CentOS. You can see there '$'. 2. Creating .py module To create ".py" module. You can use the  vi editor command. You need 'import d
Read more