https://books.google.co.in/books?id=jVfjAQAAQBAJ&pg=PA47&lpg=PA47&dq=data+base+concepts+for+tableau&source=bl&ots=U-H9udwoXv&sig=WxPgXRJKUIwt_RIHj9Ekps4kVM0&hl=en&sa=X&ei=zNJeVdHbIYeWuASs0oOoBA&ved=0CEwQ6AEwBw#v=onepage&q=data%20base%20concepts%20for%20tableau&f=false
Friday, 22 May 2015
Join Database Tables with Tableau
Most TABLEAU users aren’t database experts. This post introduces a fundamental database concept joining tables. Seldom will your data source include every bit of information you need in a single table. Even if you normally connect to Excel it may be advantageous to use related data from more than one tab. As long as the data resides in a single spreadsheet or database and each table includes unique identifiers that tie the tables or tabs together, you can perform joins of these tables within Tableau. These identifiers are called Key Records.
Database joins can be complex, but the basic principle is to bring together related information in your view. In TABLEAU , you can define joins when you make your initial data connection or add them later. This example will use the Orders and Return tabs (tables) from the Superstore sample data set. Figure 2– 8 shows portions of both tables. The Orders table includes billing information. The
Returns tab includes the smaller returned order table. Start by connecting to the spreadsheet as you would if you were going to connect to one table. In the Connection Menu under Step 2, select Multiple Tables and click the Add Table button to expose the Add Table menu. Then select the Returns table as see in figure Super store orders and return tables
Database joins can be complex, but the basic principle is to bring together related information in your view. In TABLEAU , you can define joins when you make your initial data connection or add them later. This example will use the Orders and Return tabs (tables) from the Superstore sample data set. Figure 2– 8 shows portions of both tables. The Orders table includes billing information. The
Returns tab includes the smaller returned order table. Start by connecting to the spreadsheet as you would if you were going to connect to one table. In the Connection Menu under Step 2, select Multiple Tables and click the Add Table button to expose the Add Table menu. Then select the Returns table as see in figure Super store orders and return tables
Evaluation of Tableau
Strengths:
Weakness:
- The greatest strength of Tableau is its speed with which it analyzes hundreds of millions of rows and gives the required answers in seconds. This quality comes in very handy when fast business decisions need to be taken
- Another strength of Tableau is that it is very easy to use. It’s just basic drag and drop. One can start using Tableau even with no prior programming experience. With just basic MS Excel skills one can easily learn Tableau.
- The Dashboard of Tableau is very interactive and gives dynamic results. Rich visualizations can be created very easily.
Weakness:
- Tableau Software is an easy to use BI application, but still not a platform for developing analytic applications that can be broadly shared.
- Tableau Software allows users to only analyze what has happened. And, Tableau Software does not have any statistical or predictive capabilities (they do not support SAS, S+, R, ect. like Spotfire does). Therefore users cannot model or project the best cross-selling or up selling opportunities.
- Due to its not open-source based nature and market commodity, Tableau Software cannot be customized or integrated with other applications.
Tableau Overview
- Tableau product, queries relational databases, cubes, cloud databases, and spreadsheets and then generates a number of graph types that can be combined into dashboards and shared over a computer network or the internet.
- Tableau offers five main products: Tableau Desktop, Tableau Server, Tableau Online, Tableau Reader and Tableau Public. Tableau Public and Tableau Reader are free to use, Tableau Server and Tableau Desktop comes with a 14 day fully functional free trial period.
- Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag & drop to analyze data. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more.
- Tableau Server is a business intelligence application that provides browser-based analytics anyone can use. It’s a rapid-fire alternative to the slow pace of traditional business intelligence software.
- Tableau Online is a hosted version of Tableau Server. It makes rapid-fire business analytics easier than ever. Share dashboards with your whole company and with customers and partners— in minutes. Provide live, interactive views of data that let people answer their own questions, right in a web browser or on a tablet. And do it in a secure, hosted environment.
- Tableau Public is for anyone who wants to tell stories with interactive data on the web. It’s delivered as a service that allows you to be up and running overnight. With Tableau Public you can create amazing interactive visuals and publish them quickly, without the help of programmers or IT.
Tuesday, 19 May 2015
How to change null values as n/a in view?
We can handle the Null Values in 3 ways
1.Using Filter we can eliminate the Null Values.
2.Using Axis-->Format--> Marks --> Hide option we can hide the "Null values".
3.We can also use a calculated field to convert Nulls to Zeros using "IsNull" function.
Ex:IIF(ISNULL([Actual] ), 0, [Actual] )
1.Using Filter we can eliminate the Null Values.
2.Using Axis-->Format--> Marks --> Hide option we can hide the "Null values".
3.We can also use a calculated field to convert Nulls to Zeros using "IsNull" function.
Ex:IIF(ISNULL([Actual] ), 0, [Actual] )
Types of annotations?
The Annotation is a message that can be displayed for a mark/object.We have 3 namely.
Mark,
Point
Area
Process: Right click on object point or area and select --> "Annotate" --> Mark or Area or Point.
Point
Area
Process: Right click on object point or area and select --> "Annotate" --> Mark or Area or Point.
Subscribe to:
Posts (Atom)