Tableau Bronze Exam
My company is concerned about data governance. How can Tableau help me?
"What kind of governance concerns do you have? That means different things to different industries." Tableau Data Server is a great solution for governance. It provides governance by enforcing entitlements on the data connection itself. And remember - it is a continuum. So you can decide exactly where on the top down v bottom up spectrum you want to be.
Show me how to make a new dashboard.
1. Click the 'New Dashboard' icon in the tabs at the bottom of your workbook. 2. Choose Dashboard 'New Dashboard' from the toolbar. 3. Right click on a view or dashboard tab. Select 'New Dashboard'. 4. Quick click the carrot on the icon on tool bar of a chart with plus sign on right. Choose 'New Dashboard'.
What is a measure field? What is a dimensional field?
A dimension is a qualitative or categorical field in the data (for example Country). 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 (for example Sales). Measures typically produce and axes.
What is a group?
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.
What is a project?
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.
What is a tooltip?
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. Tooltips may be edited to include both static and dynamic text as well as other sheets in the current workbook (Viz in Tooltip)
How do I show an image webpage or text in a dashboard (dashboard objects)?
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.
Show me the capability to drill down into data.
Always ask what kind of drill down a customer is seeking. Tableau provides drill downs in hierarchies filters showing the underlying data and dashboard actions.
When I drag the fields out into the view some are blue and some are green : how come?
Blue pills are discrete and green pills are continuous. Discrete fields contains finite values. Continuous fields can display infinitely smaller points from one end of data to another by creating an axis in the view (think of a trend line of time that can get more granular down to the second). Discrete fields always result in headers being drawn whenever they are placed on the rows or columns shelves. Continuous fields always result in axes when you add them to the view. These roles are important because you may want to display your data continuously or discretely depending on what you are trying see and the data itself. You can switch between continuous and discrete data roles using the field menu. For a deeper understanding please see: Understanding Pill Types
Why does a live connect option matter? Are there benefits?
Connecting live can have important benefits such as: • It leverages the investment the customer has already made in their databases (e.g. security or speed). This avoids the time and expense of rebuilding this logic. • No scripting means they can connect and go with a few clicks - removing a big barrier for business users to start asking questions of their data • Their data stays vendor agnostic and open to all. When they import data typically only the vendor who imported it can then connect to it
What is the difference between 'Connect Live' and 'Extract'?
Connecting live is just as it sounds - you are establishing a live connection from Desktop to the original data source. When you drag-and-drop Tableau sends a query to the original data source leveraging its computational power and storage. When the data changes your live connection will reflect that once refreshed. When you use an extract you are taking a static snapshot of data from the original source and loading it into Hyper Tableau's own database technology. Now when you drag-and-drop the query goes to the Hyper extract protecting the original data source. Because it is a snapshot when the live data changes your view will not automatically reflect that. However you can put the extract on a refresh schedule (whole or incrementally append data) using Tableau Server (and Tableau Online depending on the data source).
How do I adjust the size of a dashboard?
Dashboard sizing options are on the left side of the dashboard user interface.Some sizes for blogs iPads and laptops make sizing easy for a certain display medium. If you are designing for mobile we have a feature to help called Device Preview.
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
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.
How do I replace a measure or dimension on the rows or columns shelf?
Drag and drop field over the current field on the shelf. The new field will replace the other field.
What languages does Tableau support?
English, French German SpanishBrazilian Portuguese Japanese Korean Simplified Chinese
When is best to use a live connection?
Good times to use a live connection can include: - If your database is already fast. Just connect and go! - If you need your data to refresh more often than every fifteen minutes we usually recommend a direct connection as well.
Outside of Tableau Server & Online how can I share results?
If you do not care about security or scalability two non-secure options are Tableau Reader or Tableau Public. Tableau Reader is an unsupported free and freely downloadable Windows application that lets anyone open & view Tableau packaged workbooks created in Tableau Desktop. Tableau Public lets Desktop users publish data visualizations for free to the web. Neither allows you to auto-refresh your data : it must be done manually. In some cases Reader and Public are great options. For most private data there are challenges. These are a few great questions to get customers thinking about if Tableau Reader can really meet their needs: • Do your executives like accessing dashboards on their mobile device? • Do you care if the data is not secure? Think of Reader like an Excel spreadsheet that can get mailed outside the organization. • Do you need to connect to large data sources? So large that you cannot mail out copies to everyone? • Does your data change often? Would you like consumers to have the dashboard with the latest information rather than the version you mailed to them last week?
How do I create a profit ratio?
In Tableau it is easy to write calculations to answer questions not already in your data! A really common example is: Right click in the Data window Create Calculated Field. This gets you to the calculation editor. Using Superstore you would then write the following: SUM(Profit)/SUM(Sales) Why is knowing this important? Because if you do not add the SUM's (instead doing Profit/Sales) you will get the wrong answer. Aggregate calculations are those that use aggregate functions. Examples of aggregate functions are SUM AVG MAX & MIN (there are a few others). Therefore an example of an aggregate calculation would be: Profit Ratio = SUM(Profit) / SUM(Sales) But what is special about aggregate calculations? The primary difference between aggregate and non-aggregate calculations is that aggregate calculations often can't be sensibly calculated for each row in the underlying data set - it normally only makes sense to calculate them when the data is aggregated. Consider the profit ratio example based on the following data: Order ID Sales Profit Profit Ratio (NA) 1 £100 £20 20% 2 £1 000 000 £500 000 50% The final column - profit ratio (NA) - is a non-aggregate calculation. This has been calculated on each row in the underlying data. BUT - this is not very useful in this situation sure it tells us the profit ratio for each sales transaction but it can't be used to summarize the profit ratio for our organization. If you average this value you'll get a misleading figure of 35% for the organization profit ratio when the organization profit ratio is actually very close to 50%. To correctly calculate the organization profit ratio we need to make use of aggregate functions thus creating aggregate calculations. Using the calculation SUM(Profit) / SUM(Sales) forces the sales and profit amounts to be totalled BEFORE the division occurs and as the table below now shows provides the correct answer for profit ratio of 50% (actually a tiny bit less the answer has been rounded). Order ID Sales Profit Profit Ratio (NA) 1 £100 £20 20% 2 £1 000 000 £500 000 50% TOTAL £1 000 100 £500 020 50%
What is our governance story? What is our governance philosophy?
In order to educate our customers and challenge them to think differently you must be able to articulate why we have built our data governance strategy the way we have. Traditional metadata/governance is top down. It assumes that the people at the top (IT) know exactly what you will need at the start - just like traditional BI reporting. 'We will come up with a dictionary of things that you can then leverage in your analysis.' In the Tableau world we believe that people are smart. We encourage creativity. We want people to be able to answer their own questions independently and the top down governance approach often does not serve that. For example historically you would start with many data sources and reports...and to make this easier to manage you would try to rationalize the content into fewer things. For example "We will take all the reports you build and go build a few uber-reports that cover everything you want! And on the data side we will build a warehouse." Top down governance plays really well with this restricting idea. But with Tableau we want to encourage people to explore and find answers. So we enable both top down and bottom up. With Data Server we say a central person can create and certify and share metadata models. But we will still encourage creativity on TOP of that. (For example when users click a shared data connection on Tableau Server then continue to enrich it by asking questions that cause them to create groups sets hierarchies calculations and so forth.) What we are saying is let the users go and answer their questions build their content and through that process the best practices will emerge. For example if the business always want to see profit ratio - they will go build it. It is not a matter of us at the start saying what do you want? Instead track what they do and their usage - and the most common way they calculate profit ratio will rise to the top. The key is that it is a continuum and the organization can choose what degree of top down or bottom up it needs for each of its unique use cases. This is incredibly powerful and not immediately apparent to most customers unless we educate them.
How can I sort by a measure value or a dimension? *Practice in Bronze Study Workbook
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.
As an administrator how can I see who is looking at content?
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.
What separates Tableau from competitors?
Many things. Our competitors change quickly so we do not focus on feature by feature details here. (For specifics see the Competitor tab in Sales Insight). What we focus on are the big picture differentiators that are true versus any competitor: 1. True self-service a. Enabled by exceptional ease of use for anyone who has questions about their data b. The UI is designed to enable users to stay in the flow of analytic thought rather than to be bogged down by wizards or pre settings that stem creativity. 2. Analytical depth 1. Tableau allows non-technical users to engage in complex analysis without requiring classical technical skills (i.e. database administration SQL coding or a masters degree in mathematics. A common user can build YOY growth box and whisker plots clustering etc.)Advanced users can employ Tableau's calculation builder to gain new insight into their data and even leverage external services such as R and Python.Data access and choice a. Tableau connects natively to almost any database / datasource a user requires (see connection window in Tableau for a full list)AWS data Google Bigquery support Redshift connectivity b. Query data live or in memory with Hyper based on the customer's need we don't force them to choose one or the other. 2. Hybrid deployment a. Cloud vs. on-prem vs. both b. We operate on any of the major public cloud services a competitor like Microsoft for example will not support AWS (competing cloud platform) 3. Tableau is a community a. Passionate customer base that are active in our website forums and Tableau User Groups (TUG) around the world.
What is metadata? (Note this is for you as a sales person to understand. Clients do not ask us this question.)
Metadata is 'data about the data'. It includes business definitions of the fields hierarchies business rules aggregation rules etc.
I see that Tableau has a forecasting model. Can I use my own model?
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.
Do I need to import my data into Tableau?
No. Tableau believes that you should be able to connect to your data in whatever way makes sense for you or your enterprise. You have two options with Tableau: connect live to your databases and files (leveraging the power you have already invested) or import your data into our lightning fast Hyper data engine. There are benefits to both approaches : our In-Memory or Live Data: Which Is Better? whitepaper does a great job outlining them. The biggest benefit is that with Tableau you get the choice. It is critical as a sales person you understand this point : it is probably our 2nd or 3rd biggest competitive differentiator. • Customer Consulting: this is a CRITICAL point for competing with Qlik! Our architecture aware data engine is still stomping them. This is a must-discuss item on Qlik deals.
When I make changes to metadata in Tableau are those changes written back to my database?
No. Tableau is read-only. We preserve the integrity of your underlying data sources while still giving you the ability to rename re-group re-alias etc your data in Tableau.
Do I need to set up any metadata or semantic layers before I can use Tableau?
No. This is a huge advantage to getting up and running quickly over many of our competitors. If you know the data simply point Tableau Desktop directly at your data source and choose what table(s) and view(s) you'd like to connect to and you are on your way. No pre-configuration necessary.
I have data from 2+ sources. How can Tableau help me?
One option is a cross-database join which is a row level join that allows you to create a single data source out of multiple disparate sources. You can then publish and share this source with the rest of your org. We also offer data blending which is a great way to do ad hoc analysis on multiple data sources. Blending is done at the aggregate level of the connected data fields.
How are targets or goals added to a chart?
One option is to right click on an axis and choose 'Add Reference Line.' Another option is 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.
I don't see my data source listed in 'Connect To Data'? What are my options?
One option is to 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. See Customizing and Tuning ODBC Connections You may also use Tableau SDK to write a 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. Another option for some customers is to build a Tableau Web Data Connector for data that lives on the web. Our Web Data Connector is an extensible framework to allow the Tableau community to connect to web based data sources.
What web browsers are Server & Online compatible with?
Our Tech Spec page is always up to date. It changes often enough we recommend looking there first.
What are pivot tables like in Tableau?
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 under the Analysis drop down from the toolbar.
How do I use search in Tableau Server?
Quick Search searches all content. Filtered Search only shows content relevant to the page you are on. For example if you are viewing a project page and you search a filtered search will only search the workbooks in that project.
How can I quickly filter out some data from a field?
Right click the field and choose Filter or Show Filter. A visual way to do this would be to use the data highlighter to see the data in context.
How do I see the underlying or row level data?
Select the data points of interest and right click select View Data.
How do I view Tableau on my mobile devices?
Server and Online views will render automatically on mobile devices. Tableau Server also offers a free companion app for Android iPhone and tablet etc. The mobile app is designed for: • Easy fingertip navigation and viz exploration. • To work offline - use snapshots when Wi-Fi isn't available.
What is a site?
Sites are independent environments for different organizations or groups on the same server. 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 do I update extracts on Tableau Online? Does this have to be a manual process?
Start with a question: "What data source are you connecting to?" 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. For all other data sources you will need to 'push' the data to Tableau Online in the form of an extract. Once you have an extract you can use Tableau Bridge to automate the refresh on a schedule.
What is Story Points? How does it differ from a dashboard?
Story Points build a narrative with data. Rather than turning your audience loose with a dashboard that can be explored many ways (that may or may not get your point across) Story Points let you share the path to discovery step by step helping your audience understand the evolution to an insight. And of course unlike static images interactivity remains so if your audience has a question you can explore it right there.
What are the differences between these Tableau Server and Tableau Online?
Tableau Online Tableau Server How long does it take to get up and running? Minutes. No installation or optimization required. Hours. Installation configuration and optimization needed. How can you access data? Live connections to cloud data bases : Online Sync for on-premise data. Live connections to cloud data and on-premise data. Can external users access dashboards? Yes. Only internet access is required no VPN requirement. Users must be logged into corporate VPN. How can users authenticate? Email and password (TableauID) SAML Active Directory via SAML IDP and OpenID Connect. Username and password Active Directory SAML Trusted Tickets and OpenID Connect. How can admins manage sites? Only site administration available. Each admin must be a named user. No server admins across sites. Site and server administration available. Admins can manage entire server and across multiple sites. What is the total cost? Per user per year subscription only. Perpetual license + maintenance subscription + hardware. We also support licensing per subscriptor per year for interactors. How to you upgrade to new releases? Upgrades are handled by Tableau and are done without effort from site administrators. Upgrades must be applied manually by a server admin. What hardware is needed? No hardware is needed. All infrastructure is provided and maintained by Tableau. Customer owns maintains and optimizes hardware. How does the license work? Each named user must have their own license. Named user license or a core license.
What is the major difference between Tableau Online and Tableau Server?
Tableau Online is simply a cloud based version of Tableau Server : we host it so you don't have to make a hardware investment or leverage internal IT resources that may already be strained.
What is the difference between these Tableau Desktop products: Personal and Professional?
Tableau Personal only connects to flat files (Excel Access CSV and Tableau Data Extract.) while Tableau Professional connects to flat files and servers (SQL Oracle Amazon Web Services Hadoop etc.). Tableau Personal cannot publish to Tableau Server or Tableau Online.
Why should I use Tableau Server or Online when Tableau Public and Reader are free?
Tableau Public is for people who want to share their data with the entire world with no security. Reader is like the Adobe Reader of data - no centralization no security local offline : just a data viz file floating around in your email. If like most organizations security and collaboration are important to you Tableau Server & Online are for you. They offer: 1. Security 2. Data governance/single source of truth 3. Live/auto-refreshed data connection 4. Zero footprint - end users access via a web browser
Does Tableau support email bursting or email subscriptions?
Tableau Server and Tableau Online do support subscribing groups and individuals with emails sent to an inbox on a schedule. Email bursting is not supported out of the box. • Customer Consulting: Many customers have built their own versions for bursting as well using TabCmd
What authentication models do you support?
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 and Kerberos SAP HANA and OpenID Connect authentication models.
How many data sources does Tableau connect to?
Tableau believes you should be able to connect to all the data you care about whether on-premise in the cloud big data like Hadoop or local files like Excel. We connect to several dozen data sources natively (plus many others through ODBC or Web Data Connector) and this list is growing all the time. The easiest way to see a current list is to open Tableau Desktop click 'Connect to Data ' and check out the current list right in the connection window.
What's the maximum number of rows Tableau can connect to at one time?
Tableau has no row limitation. Customers use Tableau to access petabytes of data because it only retrieves the rows and columns needed to answer your question. For example take a 100 million row database. Ask: what is the monthly sales trend for the last 2 years? Tableau retrieves 24 rows of data.
How do I build a map based on zip codes postcodes etc.?
Tableau recognizes common geographic data such as countries cities and zip code/postcodes. Simply double click on any of your fields that has a blue globe next to it. If you have custom mapping needs like sales territories street addresses or some international zip codes you can use custom geo-coding or you can create custom territories.
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....?"
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.
I am new to leading 'discovery conversations' in sales. What are some good basic discovery questions to start with?
The 8 Key Questions from the Discovery Session in Boot Camp are a great start (full slides here). Remember you do not have to ask all of these on a call. Keep it natural and connect as a human being first. 1. What's going on? (What prompted the engagement...LEAVE THIS OPEN ENDED) 2. What is YOUR role in the process? or How did YOU get roped into doing this? 3. What does YOUR current situation look like? (Can you give a specific example?) 4. Why isn't that working for YOU? 5. If I could wave a magic wand - What would YOU like it to look like? 6. Are there any deal breakers in YOUR (teams) validation process? 7. What risks (If ANY) do YOU see with getting this project completed? 8. How do I best work with YOU (teams) to earn your (teams) business? 9. In terms of optimizing YOUR status quo what's the urgency? Is there an iDate? OR What's the cost of doing nothing?
What is the Tableau Data Engine (powered by Hyper)?
The Data Engine is Tableau's high-performing analytics database for extracts on your PC. It compresses your data and uses columnar store : in some cases make the data faster to query. The Data Engine has the speed benefits of traditional in-memory solutions without the limitations that your data must fit in memory. And in Tableau's tradition of making powerful tools accessible to all there is no custom scripting needed to use the Data Engine.
What is the installation like for a Tableau Server?
This depends on the installation environment and available hardware. A single server is pretty easy - for example I downloaded and installed Tableau Server on my own computer without help. A cluster is relatively easy as well but you will need 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 call with our Customer Consulting team to gain a better understanding of your specific environment.
What is an Extract?
This is Tableau's own file type Hyper (.hyper) which is a snapshot of the data stored on disk and loaded into memory as required to render a Tableau viz. An extract 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. See Extracts at Hyper Speed: What you Need to Know blog Use cases to NOT use an extract: • when live updates are needed • to replace a data warehouse
In a live connection what performance should I expect?
This is a great opportunity to do discovery first: 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 may be possible to increase performance via extracting into Hyper.
There are several of us that use Tableau Desktop to analyze the same data is there a way for us to share Data Connections?
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. Data server also does connection pooling. That means all users connect through a single connection to the database rather than opening up multiple connections. IT loves this because it makes a lot easier to performance tune - to track the queries that are going to the database to spot if there is anything going wrong with them.
My users do not know how to connect to our database systems. The joins and table structures are completely foreign to them. I do not think they will be able to use Tableau.
This is exactly why we invented the Tableau Data Server (an underlying component of Tableau 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 where they are automatically hosted by the Data Server process. 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.
What is the Tableau Data Server? How should it be used?
Use Tableau Data Server for data manageability and governance. Data Server is a component of Tableau Server and Online that acts like a middle man between Tableau users and the data. It enables IT (and business users who are experts in the data source) to define data source connections that can be easily accessed by often less technical business users in Tableau Desktop. These connections are reusable and secure. This is a fantastic modern metadata approach that satisfies the requirement for both rapid ad hoc analysis and broader metadata management. IT can add value by providing a rich metadata layer (e.g. handle the joins permissions add hierarchies) - yet business people are empowered to modify and extend it (e.g. write their own calculations).
Data story. What is our data philosophy?
We believe in letting people connect to the data they care about regardless of where it is. Data prep should be easy. Combining disparate data sources into a single source should be easy. And we make it easy for you to model and change your data.
Since Tableau hosts Tableau Online what is the Service Level Agreement (SLA) you provide?
We follow the lead of Salesforce.com who does not have a standard SLA. It is better to let our customers evaluate us based on our actual performance. Customers can access http://trust.tableau.com to see the current status of our site as well as historical performance.
What is Tableau's deployment strategy?
We have a hybrid approach. You can do it on-premise. You can do it in cloud. You can do it on a public cloud. We support all of these. Read this great blog post.
How can I add Totals and Subtotals? *Practice in Bronze Study Workbook
We offer a lot of flexibility with totals now - you can remove them from color encoding move them around on the viz etc. This was a longstanding customer request. One option is to go to the Analysis menu option in the toolbar Totals. Another option is 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.
How does Tableau help me manage my data?
We take a VERY different approach than most to data access. We believe by default people are smart and creative and they should have access to as much data as possible. Metadata modeling: Because of this we have created the easiest most flexible most user-friendly capability for managing metadata in the BI space by far. For example to create a group or calculation you simply right click! (Grouping requires coding in many other BI products.) To create a hierarchy you simply drag-and-drop. You 'model' naturally as you ask questions of your data : you are never taken out of flow. This allows you to build metadata models quickly and flexibly. Models can be published centrally to the Data Server of Tableau Server or Tableau Online providing an easy starting point for end-users. Data integration: You can also now model your data on the fly using our data integration. Data integration is about taking different data sources and being able to model them in a valuable way.
What type of statistical analysis do you offer?
What are you looking for? We can help you do deep analyses like trend lines forecasting and clustering with ease. We can also extend your statistical power via integration with R and python. Note - sales pro tip: if you get the sense you are working with a data scientist you will want to get your PC/SC on the phone with this customer quickly. Your goal is to appease this person on the phone but do not claim to be SAS SPSS or R (purpose-built statistical packages).
When is Tableau Online NOT a better solution than Tableau Server?
When you: 1. Need to connect live to non-cloud databases. 2. Require your analytics to remain behind their firewall 3. Require data compliance (ex. HIPAA PCI FERPA)
When is Tableau Online a better solution than Tableau Server?
When you: 1. Want to get started quickly/ no IT or low IT support 2. Are a cloud preferred company 3. Do not want to deal with VPN through firewalls - like people on the go on iPads
When I open Tableau on my Mac I am not able to connect to Netezza (or X database). Am I missing something?
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.
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
Yes - right click on the measure and choose 'Measure Median'.
Can I write my own SQL?
Yes Tableau does support custom queries. But first we recommend you try a native connection where Tableau generatesthe query and then measure the performance. Often it will be faster.
Is it possible to export data or print PDFs?
Yes although first it is good to ask 'why would you want to do that?' You can export data as a .csv or as a crosstab to Excel (select data points right click View Data then use the Export All button). Printing PDFs is just like using a Microsoft Office product.
Is it possible to edit published Views?
Yes web authoring allows permissioned users to build and edit visualizations dashboards and stories.
Can I build Hierarchies in Tableau? *Practice in Bronze Study Workbook
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'
Do Tableau products work in a virtual environment (VM)?
Yes. Both Tableau Desktop and Tableau Server can be installed in a virtual environment. It is recommended to dedicate hardware in a virtual environment and provision it with at least the minimum hardware requirements.
Is it possible to embed the views in Server into another application or a portal?
Yes. It is easy to embed views into systems like SharePoint or a company portal. For information on selling Embedded Analytics visit the Embedded Analytics home on Sales Insight.
Can I use a table of data on a web page (e.g. Wikipedia or IMDB)?
Yes. Select the table and paste into a Tableau workbook via 'Data' in the toolbar.
Can I use Tableau Desktop on a Mac?
Yes. Tableau Desktop can be installed on both Mac and Windows operating systems. Note - you may not see all the same data connection options on Mac because Mac itself supports different database drivers.
Can I use Tableau Server on Linux?
Yes. Tableau Server can be installed on the Linux operating system. In addition be aware that native data sources may be different on Linux versus Windows and/or Mac.
Is Tableau Server secure?
Yes. Tableau Server is powers analytics for global banks hospitals intelligence agencies much of the Fortune 500 and thousands of other organizations as we speak. As an enterprise Business Intelligence Platform Tableau Server provides robust solutions for all aspects of security but following our philosophy of ease of use. The result is a solution that has rock solid security and is quick to deploy and easy to maintain. See the complete Tableau Server Security whitepaper here.
Does Tableau support multi-tenancy?
Yes. Tableau accomplishes this through sites.
Can I create a map incorporating my own custom spatial files?
Yes. Tableau supports a variety of spatial data including KML SHP and GeoJSON.
Is Tableau Online secure?
Yes. We know that data is among the most strategic assets an organization has and so we put the highest priority on maintaining the security and privacy of your data. In fact because we manage Tableau Online as one of the largest BI installations in the world it often has more robust security than a company can manage on its own. This includes a regular SOC II audit solid physical security data governance and privacy user access and authentication protocols and data encryption in transit. Tableau is also US-EU Safe Harbor self-certified. If a customer has more detailed security questions see Tableau Online Customer FAQ's for how to proceed.
What can I do to design my dashboards to look good on any device/however people look at them?
You can preview layouts for different devices in Desktop. This allows you to design customize and publish a single dashboard with optimized views for tablets and phones. Note! Device Designer does not support Story Points. • Customer Consulting: Device Designer sizing works based on window size not screen size. (For example you may have a window only partially expanded on your computer screen.) A published dashboard layout will share VizQL sessions and cache. A Server Admin can see the count of device using each type of layout in the Server Postgres database.
When I try and publish to Online I sometimes get an message about needing to take an extract. Why is this occurring and why does it only happen occasionally?
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). Tableau Online is not hosted within your network and since we cannot break through your firewall we require an extract. However With Tableau Bridge you can schedule refreshes to be pushed on a schedule to keep data fresh automatically.
I am 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?
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 gives a good overview.