Bronze Study Guide 9.0 Flashcards

1
Q

What is the difference between these Tableau desktop products: Personal, and Professional?

A
  1. Personal only connects to flat files (Excel, Access, CSV, and Tableau Data Extract.)
  2. No publishing to Server with personal.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the difference between these Tableau server products: Server, Online, and Public?

A
  1. Maintenance-Tableau Online (no SLA) and Tableau Public are maintained by Tableau, while Tableau Server is maintained by the customer.
  2. Data flow- Any data source can connect directly with Tableau Server. Non cloud based data sources must be pushed to Tableau Online via a data extract.
  3. Security- Data and visualizations are secure in Tableau Online and Tableau Server. Tableau Online complies with SSAE-16 and US-EU Safer Harbor principles, but is not HIPPA or FERPA compliant. Row level data can be protected in Tableau Public, but anyone can the visualizations published.
  4. Licensing-Tableau Server is licensed for the entire server. Tableau Online is licensed by the site. Public and Public premium is licensed by the individual user.
  5. Authentication- Tableau Public and Online are authenticated via a Tableau generated ID. Server authentication supports authentication or active directory. Server also supports authentication with trusted tickets, or SAML.
  6. Environment- Tableau Server, Online, and Public are all web based methods of sharing content from Tableau Desktop. Reader is desktop application to open and view content from Tableau Desktop.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Can I use Tableau Desktop on a Mac?

A

You sure can! Tableau Desktop can be installed on both Mac and Windows operating systems.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

I have a Mac work laptop, but they also give us Windows desktop workstations? Am I allowed to install on both?

A

Yes, as long as you are the only person who uses both of those computers, you can install it on both.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When I open Tableau on my Mac I am not able to connect to Netezza (or X database). Am I missing something?

A

While Tableau Desktop for Mac has all the same functionality as Tableau Desktop for Windows, unfortunately some database vendors have not developed drivers for Macs. Since Tableau uses the native database drivers to connect to all the databases you see in the ‘Connect To Data’ window, it is possible Tableau for Mac may only be able to connect to a subset of the databases you have in your organization.
However, this is a perfect time to use the Tableau Data Server! If another user has published a data source to the Tableau Data Server, you will be able to leverage that data source in your Tableau Desktop to connect to databases that you could not connect directly to from your Mac. In this scenario Tableau Server acts as a Proxy (middle-man) between you and the database to relay all queries and data between the two. This means you do not need to worry about having any drivers on your computer. Yay!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

If my co-worker who has Tableau Desktop for Windows sends me a workbook file, will I be able to open in in my Tableau Desktop for Mac?

A

Heck yea! All files are completely interchangeable between Windows and Mac as long as they use extracts. If you need a live connection to a database make sure those drivers are available on Mac.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Do Tableau products work in a virtual environment (VM)?

A

Yes! It’s recommended for dedicated hardware in a VM environment and provision it with minimum hardware requirements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What API support does Tableau offer?

A
  1. Tableau Data Extract API- Create a program to bring data from a non-supported data source into Tableau. The program will automate Tableau Data Extract datasource creation.
  2. Javascipt API- For deeply embedding vizzes inside intranet/extranet applications.
  3. Rest API- Representational State Transfer API. For server automation such as user/group replication, lifecycle management, portal wrappers.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Why use Tableau? What value does Tableau deliver?

A

Tableau allows anyone to explore and answer questions of their data. We enable powerful analytics with a focus on self-service; this promotes speed, ease, and powerful insights. While there is a learning curve, an Excel literate user will see increased productivity immediately, by spending more time asking questions of their data. The here is that users are able to quickly iterate through an analytical cycle of asking and being able to answer their own questions, which lead to more questions, and the cycle continues, They are able to this both independently and in collaboration with IT resources, Tableau customers have a more complete picture of their projects and more options when decision need to be made.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Who usually uses Tableau within a company?

A

Tableau’s mission is to help people see and understand their data. ‘People’ means anyone with questions about data, from elementary students, scientists, doctors, executives, anyone! There is lots of pent-up anxiety and curiosity that can be resolved through data analysis. Ask around? Who has enough information to feel comfortable making decisions and understanding what is and what is possible?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How long does it take to learn Tableau?

A

It’s extremely easy to install Tableau Desktop or Server, connect to data, and begin exploring data, but every customer has unique requirements. The learning curve really depends on the analysis and the environment where Tableau is deployed. To answer this question more precisely, let’s start a guided evaluation. Participation is mutual. We’ll guide you through a use case of your choosing. In return, we ask for your employee’s participation. You’ll see just how quickly YOUR employees can answer questions THEY have of THEIR own data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

We have a BI standard. How does Tableau differ?

A

Tableau is a qualitatively different software built to a higher standard, a human standard, than legacy tools in the market. We challenge you to find another software that is as easy for business users to ask and answer questions iteratively. Empowering users in this way makes a difference for every employee and for the organizational culture as well. Tableau’s DRIVE methodology tackles organizational and technical issues associated with broad based, self-service analytics roll-out.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

I have free analytical software, why buy Tableau?

A

A lot of our customers own free software. They choose Tableau because it’s the highest productivity and most enjoyable tool to use on the market. The Tableau purchase price is far less than the cost of user sanity and time. Tableau helps remedy some of the effects of free tools like a lack of a single source of data, missing collaboration, too many manual reports, or poorly made or missed decisions. Does this sound familiar?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How does Tableau help guarantee success?

A

Overall, Tableau software has one of the highest average customer satisfaction ratings for analytical software. We ensure success with our software in many ways.

  1. With your purchase, you enter into a customer success program where we contact you to make sure you are achieving an expected or higher ROI from Tableau.
  2. Maintenance that includes first come-first serve tech support help on any issue, including user implementation questions, and no cost upgrades to the latest release.
  3. Participation in Tableau’s community forum to share ideas with fellow members.
  4. Complimentary resources like A-Z tutorial videos, weekly live training, and articles available through Tableau.com.
  5. Tableau’s annual customer conference. We give you the best we have to offer in the form of support, interactive activities, customer speakers and customer collaboration.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What separates Tableau from competitors?

A
  1. Time to Value: Tableau takes less time to deploy than many other BI tools. No programming skills are required!
  2. Designed for Flow: Making the interface “disappear” has been a design goal since our founding 10 years ago. No other software allows the user to focus on the data as well as Tableau.
  3. Visual Analytics: In Tableau Desktop you define both the chart and the query in one step and can do so by directly interacting with the visualization rather than first defining a query, then taking the resulting table and applying it to a chart.
  4. Agile Data Connections: Tableau has 40+ tuned, live data connections to on premise, cloud and file based data sources. Keep your data where it is, we’ll connect to it and leverage your investment in data architecture, or you can create data extracts for fast I memory queries and sharing. Plus Tableau supplies a data engine for additional data support right out of the box.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What languages does Tableau support?

A

English

French

German

Brazilian

Portuguese
Spanish

Simplified

Chinese

Korean

Japanese

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the DRIVE program methodology?

A

Data democratization can have a transformative potential in the modern workplace. Does this mean the benefits magically appear by simply handing out software like lollipops at during the holidays? No.
Technical users are like ducks to water with new software and challenges, they enjoy it. However, it is the rest of the knowledge workers also have a great contribution to make. What’s the best way to successfully deploy this capability to them?
Our answer to this question involved researching best practices in our customer base and reverse engineering questions that such users typically ask. It turns out that sometimes the simplest questions are the hardest to answer:
• “Do I really need to learn a new tool?”
• “Is this important?”
• “What’s the benefit?”
• “How do I get started?”
• “What data is available?”
• “How much time will this take?”
• “What happens if I get stuck?”
We posed these questions rhetorically and developed a framework for answering them in a process called “Drive.”
DRIVE is four steps. It methodically blocks and tackles the organizational and technical issues associated with a broad based, self-service analytics roll-out.

In the first phase, Discovery, we ask whether the organization truly wants to empower business users. Organizations that proceed with Drive believe that the substantial benefits of self-service outweigh the costs of enablement. We identify sponsors and then do a traditional gap-analysis to determine what is required to have a successful journey.
The next step, Prototyping, is when we work with a cross-functional group to flesh out visualization, data governance, technical and operational issues. We also build up a gallery of useful and inspiring work.
After that, during Foundation Building we operationalize what we’ve learned to provide the answers, support, and encouragement that business users require. In this phase we setup the Center of Operations to manage the technical aspects and the Center of Evangelism to manage the program.
Scale-up is the end-game, more of a finishing line. Introducing the value proposition, tools, and programs created in earlier steps to change the analytic culture, one business unit at a time. We know that we now have answers to the questions that business users will ask and a strong programmatic framework in place to support them. We’re not just dropping software on the business users; we’re planning and preparing for change in a responsible way, knowing we’ll be successful.
DRIVE, like the idea of giving tools and opportunities to think critically and creatively by more people across the organization, is mainly just common-sense.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the installation like for a Tableau Server?

A

This depends on the installation environment and available hardware. A single server is pretty easy. A cluster is relatively easy as well but will take time to align and configure each server within the cluster. For optimum performance always make sure there is more hardware than the minimum requirements. We recommend a guided evaluation to gain a better understanding of your specific environment. It will decrease deployment time and help us troubleshoot any issues in the future.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What web browsers is server compatible? Do I need an app?

A

Tableau Server, Online, and Public are compatible with Android Browser, Internet Explorer, Safari, Mozilla Firefox, and Google chrome for a desktop, laptop, tablets and mobile phones. A free Tableau app is available for Android and iOS tablets, but not necessary for server access. The app provides nothing different than web based access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Does Tableau support email bursting or email subscriptions?

A

Tableau Server and Tableau Online do support email subscriptions sent to your inbox on a schedule. Email bursting is not supported out of the box. It’s possible to set up with any command-line email program (like febootimail)” …. This leverages the “get” method which can render a report as PDF, PNG, XLS, or TWBX. Point out that there are 3rd party solutions such as Push Intelligence from MetricInsights that add bursting and data-driven alerts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is data server? How should it be used?

A

Use Tableau Data Server for data manageability and governance. Data Server is a Tableau Server component that acts like a middle man between Tableau users and the data. Create reusable data connections that are secure. Many workbooks may use one data connection from Tableau Data Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

There are several of us that use Tableau Desktop to analyze the same data, is there a way for us to share Data Connections?

A

This is exactly what Tableau’s Data Server is designed to do – share data. All of the effort to connect to a data source and its associated metadata can be reused by publishing the Data Connection to Tableau Server. Then, the data connection, its calculations, sets, defaults and other metadata can be used securely by many people.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

My company is concerned about Data Governance. How can Tableau help me?

A

“What kind of governance concerns do you have? That means different things to different industries.” Tableau Server provides the governance to prepared content by enforcing entitlements to dashboards and visualizations. Data Server provides governance by enforcing entitlements on the data connection itself.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What is the Purpose of Guest Access?

A

A Guest user is available in Tableau Server to allow unauthenticated users without an account on the server see and interact with an embedded view. When enabled, the user can load a web page containing an embedded visualization without signing in. This option is only available with a core-based server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

How is Guest Access enabled?

A

Server > Settings
Although this setting is server wide you can control guest access on a site by site basis using view permissions. If a view does not have guest access enabled then guests will never be able to see the view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

How do I use Search in Tableau Server?

A

Quick Search searches all content
Filtered Search only shows content relevant to the page you are on. For example if you are viewing the project page a filtered search will finrd projects matching the search terms (and filters)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

As an administrator, how do I view recently viewed views

A

Look at the bottom of a view or dashboard on Tableau Server. If you are an administrator there will be a link “Who has seen this view?”
An administrator can also see who has been looking at a particular views from the Tableau Server status page.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What authentication models do you support?

A

Tableau Server supports local authentication and active directory authentication. The models are mutually exclusive. To change models, a Tableau Server will need reconfiguration. A Tableau Server can also work with trusted tickets and SAML for a single sign on experience or Kerberos authentication model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Is it possible to embed the views in Server into another application or a portal?

A

Yes. It’s possible and easy to embed views into systems like SharePoint or a company portal.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Does Tableau support multi-tendancy?

A

Yes. Tableau accomplishes this through sites.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What is a site?

A

Sites are independent environments for different organizations or groups on a single server system. Each site’s projects, workbooks, data, and user lists are isolated from those of other sites. A system administrator can only see every site and perform actions such as creating sites and making system-wide changes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What is a project?

A

A project is a collection of related workbooks within a site. When publishing a report to a project, the default action is to copy security from that project to the report. This makes setting up project security an important part of deployment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

What is a group?

A

A group is a collection of Tableau Server users. Groups make it easier to manage multiple users. Create groups locally on the server or import from Active Directory. Active Directory groups will need to be synced on a regular basis to keep the server up to date.

34
Q

Is it possible to edit views?

A

Yes, web authoring allows permissioned users to have a Tableau Desktop light experience for building or editing views.

35
Q

What is the general permission model Tableau Server follows?

A

Tableau follows a cascading permissions model. It will first ask if the user has been explicitly allowed, denied, or inherits permission. If inherited, Tableau will go to the group level and ask the same question. If denied or inherited, the user will not have that permission.
Tableau Server has an easy to follow permission visual right in the server. You can see who has permissions and why + easily understand the effects of changing a permission for a group or single user.

36
Q

What is the difference between Tableau Online and Tableau Server?

A

What is the difference between Tableau Online and Tableau Server?

37
Q

When I try and publish to online I sometimes get an error about needing to take an extract, why is this occurring and why does it only happen occasionally?

A

You will see this happen when you are trying to publish a workbook that is connected to an internal server or a file stored on a local drive, such as a SQL server within your company’s network. As Tableau Online is not hosted within your network we require an extract to access the data. If you are connecting to a local file such as some cloud based data sources such as Google Big Query; this will not be necessary.

38
Q

What’s the maximum number of rows Tableau can utilize at one time?

A

Tableau is not restrained by the number of rows in a table. Customers use Tableau to access petabytes of data because it only retrieves the rows and columns needed to answer your question. Let me share some customer use cases focusing on big data.
Example- 100 million rows database. Answer what is the monthly sales trend for the last 2 years? Tableau retrieves 24 rows of data.

39
Q

I have data from 2+ sources. How does Tableau work with disparate data sources?

A

If the data has common entries and/or field names data blending might work. It’s Tableau creating a query for each datasource, then it blends (aggregates) data based on common fields to both datasources. There are some techniques to help compensate for different field names, but the data may need to be cleaned up to complete the analysis.
Data Blending does not create row level joins and is not a way to add new dimensions or rows to your data. If blending with a cube, a field from the cube must be on the view first to make it the primary data source. Cubes cannot be a secondary data source.

40
Q

How do I update extracts on Tableau Online? Does this have to be a manual process?

A
  1. Start with a question: “What data source are you connecting to?”
  2. For cloud applications like Google Analytics or Salesforce.com, Tableau Online can automatically update snapshots of your data (Tableau Data Extracts) on a scheduled-basis. For data warehouses based in the cloud, such as Google BigQuery and Amazon Redshift, Tableau Online can connect directly. This live connection means you do not have to create extracts since BigQuery and Redshift support fast query for large amounts of data over the Internet.
  3. For all other data sources you will need to ‘push’ the data to Tableau Online in the form of a Tableau Data Extract (TDE) . Once you have a TDE the data you have three options for updating this. 1. Manually republish the workbook or data source with new data, 2. Refresh the tableau Data Source from your local machine, or 3. You can use the command line tools to update the files locally and push these to Tableau Online on a schedule.
41
Q

Can I use a table of data from a website?

A

Yes. Select the table and paste into a Tableau workbook via ‘Data’ in the toolbar.

42
Q

I don’t see my datasource listed in ‘Connect To Data’? What are my options?

A

Use the standard ODBC (Open Database Connectivity) option listed in the data connection window. While this connection option may not be as robust as a native connection, it does provide the ability to use the driver for connecting to your database. If you run into performance issues, I recommend extracting the data into a Tableau Data Extract. We can also provide some guidance to tune the connection.
http://kb.tableausoftware.com/articles/knowledgebase/customizing-odbc-connections?lang=en-us
You may also use Tableau Data Extract API to write program to access and process your data to create a Tableau Data Extract. We support developers on Windows and Linux platforms for Python/C/C++/Java.

43
Q

What is the difference between ‘Connect Live’ and ‘Extract’?

A

Connecting live to a database leverages it computational processing and storage. New queries will go to the database and reflect new or updates in the data.
An extract will make a static snapshot of the data to be used by Tableau’s data engine. The snapshot of data can be refreshed on a schedule as a whole or incrementally append data. One way to set up these schedules is via Tableau Server.

44
Q

In a live connection, what performance should I expect?

A

What are your performance requirements? Is performance an issue with your current solution or solutions you’re exploring?
In a live connection, performance speed is based on how fast your data sources can process requests made by Tableau. If live connection to a data source is too slow, it’s possible to increase performance via a Tableau Data Extract (TDE) in the Tableau’s Data Engine.

45
Q

What is a Tableau Data Extract?

A

This is Tableau’s own file type, which is a snapshot of the data. A TDE is a powerful analytical tool because it compresses the data pulled from any database and use all parts of a computer’s memory. A TDE can be configured to pull a portion of data based on a condition; roll up granular data to a higher aggregation; or pre-filter data before bringing it into Tableau. http://www.tableausoftware.com/about/blog/2014/7/understanding-tableau-data-extracts-part1
Do not use a TDE when live updates are needed, to replace a data warehouse, for more than a couple 100 million rows (data cardinality dependent). Sometimes data is slow and Tableau won’t be able to improve its performance.

46
Q

What is the Tableau data engine?

A

It’s an analytical database designed to achieve instant query response, predictive performance, integrate seamlessly into existing data infrastructure, and is not limited to loading entire data sets into memory. The core of the structure is columnar-based that compresses the data.

47
Q

Does Tableau support stored procedures?

A

I know running these subroutines are common, but may I suggest trying Tableau without them first. Often there is better speed performance. If stored procedures are necessary, Tableau supports stored procedures for SAP Sybase, Microsoft SQL Server, and Teradata.

48
Q

I want to write SQL.

A

To measure performance let’s try a connection where Tableau generated the query. Often custom SQL will fill Tableau Desktop’s cache quicker and slow performance. However SQL will sometimes be faster because it can utilize native, proprietary database filter routines.

49
Q

I can’t connect to my data, help!

A

Please share the error message you’re receiving with me and Tableau’s technical support. I’ll try to troubleshoot this on the fly, but if I also want to completely solve the issue. Would you mind if I schedule additional support if needed?

50
Q

Do I need to set up any metadata or semantic layers before I can use Tableau?

A

Nope! Tableau offers very quick and easy direct connectivity to over 40 types of databases (plus tons other through ODBC). Simply point Tableau Desktop directly at your database and you can choose what table(s) and view(s) you’d like to connect to and you are on your way. No pre-configuration necessary.

51
Q

When I make changes to metadata in Tableau, are those changes written back to my database?

A

No. Tableau is a completely read-only set of products. We preserve the integrity of your underlying datasources while still giving you the ability to rename, re-group, re-alias, etc your data in Tableau.

52
Q

Can I build Hierarchies in Tableau? *Practice in Bronze Study Workbook

A

Yes, you can easily create a hierarchies in Tableau. The easiest way is to drag and drop a dimension on top of another one- voila! Alternatively you can multi-select a set of dimensions, right-click, and choose ‘Hierarchy’->Create Hierarchy’

53
Q

(OBJECTION) My users do not know how to connect to our database systems. The JOINS and table structures are completely foreign to them. I don’t think they will be able to use Tableau.

A

This is exactly why we invented the Tableau Data Server. Think of it as a centralized repository for all you metadata. Users who are familiar with the data can pre-build some data sources and publish them to Tableau Server. Then other Desktop users can choose to connect to ‘Tableau Server’ in the ‘Connect to Data’ screen and they will be presented with the pre-built sets of metadata they are allowed to access. No need for your users to know the complexity of the joins or calculations or underlying structure.

54
Q

What is a measure field? What is a dimensional field?

A

A dimension is a qualitative or categorical field in the data. Dragged into a view, a dimension produces headers in the view. A measure is a quantitative field in the data, meaning that the values in it can be aggregated together and are dependent on how dimension in the view are slicing the values. Measures typically produce and axes. Calculated measures can be qualitative.

55
Q

Whenever I drag and drop one of my Measures it always does a Sum. Can I change it to a Median? *Practice in Bronze Study Workbook

A

Sure – just right click on a measure (green) or column shelf and choose ‘Measure->Median’

56
Q

How do I replace a measure or dimension on the rows or columns shelf?

A

Drag and drop field over the current field on the shelf. The new field will replace the other field.

57
Q

What is the difference between discrete and continuous dates? When would you want to use a discrete date vs. a continuous one? *Practice in Bronze Study Workbook

A

Discrete dates return the DATEPART of the date, irrespective of what year/month/week/day in which it occurred. A discrete month would return Jan, Feb, Mar as discrete elements, while a continuous month would return Jan 14, Jan 15, Feb 14, Feb 15, as continuous points in time.

58
Q

How can I add Totals and Subtotals? *Practice in Bronze Study Workbook

A

On the left, switch from the Data Pane to the Analytics Pane and drag ‘Totals’ into your view. You will be presented with options for Subtotals, Column Grand Totals and Row Grand Totals.

59
Q

How can I sort by a measure value or a dimension? *Practice in Bronze Study Workbook

A

In the view, sort on an axis to sort by quantitative values or on dimensional header to sort alphabetically. You can also manually sort on the view by dragging dimension values into a new order. On the toolbar, use the quick sort buttons. Right click on a dimensional field on view card for more sorting options (sort order & sort by) or clear a sort.

60
Q

What are pivot tables like in Tableau?

A

Pivot tables in Tableau are crosstabs. Make any view a crosstab by right clicking the view tab and selecting “duplicate as crosstab.” Quick features to show are one click swap in the toolbar or totals on toolbar under the Analysis drop down.

61
Q

How do I see the underlying or row level data?

A
  1. In a tooltip, select the icon on the most bottom left (represented by columns.)
  2. In the data window, to the left of the field search, select the columnar icon.
62
Q

What is a tooltip?

A

A tooltip displays data details when you hover over one or more marks in the view. Use them to see data details that are not in the view. Tool tip quickly filter, remove a selection, or view underlying data. Tooltips may be edited to include both static and dynamic text.

63
Q

How are targets or goals added to a chart?

A

On the left, switch from the Data Pane to the Analytics Pane and drag the reference measure out into the view. Configure reference line to address the table, pane, or cell.

64
Q

What type of statistical analysis do you offer? *Practice in Bronze Study Workbook

A

What are you looking for? With just a couple clicks, you can access our analytics pane that has multiple options available with a single drag. Complicated analysis like creating trendlines, forecasting, or even Confidence Intervals are at your fingertips.

65
Q

I see that Tableau has a forecasting model. Can I use my own model?

A

No, Tableau uses a technique known as exponential smoothing. Tableau automatically selects the best of up to 8 models with the best being the highest forecast quality. You no longer need to be a data scientist to see what is in store for the future. In the edit window, turn on and off various options like seasonality. If you are interested in using a different model, I would suggest using our R integration to create your forecast.

66
Q

May I see an ANOVA table for a trendline?

A

After dragging out a trendline for our analytics pane, right click the trendline and select describe. All stats are now available without even having to calculate them.

67
Q

How do I know if my trend is significant?

A

Looking at the p-value in the ANOVA table you can determine if a trend is significant. A p-value of 0.05 or less is considered good.

68
Q

I have a low correlation, can I change the shape of my trendline?

A

Yes, right click any trendline and change it using edit to better fit your data.

69
Q

How do I build a map based on zip codes?

A

Simply double click on one of your fields that has a blue globe next to it. You can even use a filled map mark type. For specific mapping needs like street addresses, custom sales territories, or international zip codes you can import custom geo-coding if you have the latitude and longitude coordinates in your data.
*Tableau contains several built-in Geographic Roles with predefined longitude and latitude coordinates. Many of the roles extend internationally but some are limited to the U.S. only. http://kb.tableau.com/articles/knowledgebase/mapping-basics

70
Q

How does Tableau get the “Latitude (generated)” and “Longitude (generated) fields? [This could also be “I need to map zip codes in X country why isn’t it working….?”

A

Tableau relies on built in geographic roles to generate the latitude and longitude. If you right click on a field in the dimensions pane and select geographic roles you can see a complete list of the geographic roles we support.

71
Q

Show me the capability to drill down into data.

A

Always ask what kind of drill down a customer is seeking. Tableau provided drill downs in hierarchies, filters, showing the underlying data, and dashboard actions.

72
Q

How can I quickly filter out some data from a field?

A

Right click the field > Quick Filter

73
Q

(DEMO) I want to map all of the table sales in the east. Is there an easy way to plot just the data points that fall into that category?

A

You can easily select a mark or a group of marks and create a set – you can then use this set on another sheet to analyze the members that you included in the set.
Sets are custom fields that define a subset of data based on some conditions.

74
Q

We have a long list of products and I want an easy way for my end users to make selections but every time they check or uncheck a value the view updates is there a way for them to make all their selections first and then have the view update?

A

This can easily be accomplished by customizing your quick filter to add an apply button this will let you make selections that will not be applied until the button is pressed.

75
Q

I have specific sales product types within a higher category is there for me to select a category on a filter and then have the second filter reflect only the products types within that category?

A

This can be done by setting the second level of filtering to use only relevant values – in this case it would allow you to show only the product types within a category.

76
Q

What are Story Points? How does it different from dashboard?

A

Story Points is a way to build narrative from data; to tell a story. Story Points focuses on providing a platform for story building. Presenting data in this way can lessen time to communicate insight, increase depth of understanding, and increase memory of key concepts.
Dashboards are for comparing a monitoring data simultaneously.

77
Q

Show me how to make a dashboard.

A

a. Quick click icon on tool bar. Represented by a chart with a plus sign on the right.
b. Click new dashboard in in the view and dashboard tabs.
c. Select dashboard drop down in the toolbar. Select “new dashboard.”
d. Right click on a view or dashboard tab. Select “new dashboard.”

78
Q

How do I show an image, webpage, or text in a dashboard (dashboard objects)?

A

All of these options available in the dashboard window on the left of the dashboard user interface, below sheets. Drag and drop onto view. Pre select the option to be tiled or floating.

79
Q

How do I adjust the size of a dashboard?

A

Dashboard sizing options are on the left side of the dashboard user interface in the lower right corner. Some sizes for blogs, iPads, and laptops make sizing easy for a certain display medium.

80
Q

How do I share results?

A

Publish secure dashboards to Tableau Server or Tableau Online. A non-secure option is sharing with Tableau Reader.

81
Q

Is it possible to export data or print PDFs?

A

Of course! Export data as a .csv or as a crosstab to Excel. Printing PDFs is just like using a Microsoft Office product. The caveat is you’ll lose any of the great interactivity built into a view or dashboards. Since the end goal is not to have interactivity become static, Tableau is also not pixel perfect.

82
Q

I’m working with an Excel file in Tableau Desktop and I want to send my completed workbook to my coworker. She doesn’t have access to the data file on her machine, should I send her a .twb or a .twbx file? What is the difference between these two?

A

You will want to send her a .twbx file. Sending her a .twbx will package the underlying local files with the Tableau workbook so she will not need to have the excel file separately.
The .twb file will contain the information about what is on each sheet/dashboard/story within a workbook – such as what fields are in each view, how measures are being aggregated, the formatting and any other information pertinent to the workbook such as the type of connection and metadata changes you’ve made. The twbx. Contains all of this plus the local data sources.
This blog post does a great job at explaining more about file types: http://www.theinformationlab.co.uk/2013/12/02/tableau-file-types-and-extensions/