Download Tableau: A Comprehensive Guide to Data Visualization and more Exams Computer Science in PDF only on Docsity!
What is Tableau? - Answers -A data visualization software. What is Tableau's purpose? - Answers -To create visual representations of raw data. What panes are located on the start window? - Answers -- Connect
- Open
- Discover What window are you brought to when you open a document? - Answers -Data source window What are the three types of joins? - Answers -- Inner join (default)
- Left join
- Right join Inner join (default) - Answers -Each table (tab in spreadsheet) is compared for common fields (keys). Only records present on both now appear. Left join - Answers -Designates the table (tab in spreadsheet) on the left as the "primary" table and adds details from the right table when they appear. Missing data appears as "null". Right join - Answers -Designates the table (tab in spreadsheet) on the right as the "primary" table and adds details from the left table when they appear. Missing data appears as "null".
TABLEAU
EXAM
QUESTIONS
AND ANSWERS
What is boolean? - Answers -Boolean means "yes or no" and is symbolized by 'T/F' icon. How do you go back and forth between the Start and Workspace areas? - Answers - Click the multi-color pluses (+ + +'s) arranged in a circle. (Logo button) What are the different kinds of Tableau file types? - Answers -- Workbook
- Datasource
- Data extract
- Bookmark
- Packaged workbook What is on the toolbar? - Answers -Buttons like save and undo. Many of these buttons are contextual to what's going on in the sheet. Is there a limit to how much you can undo? - Answers -No Does Tableau automatically save your work? - Answers -No What does the data pane show? - Answers -The data pane lists all open data sources, and within those sources there applicable fields. The pane is broken out into dimensions and measures. The data pane will also show any set of parameters we may have. What does the status bar the the bottom show? - Answers -Shows the number of marks in the view as well as other summary information What can the analytics pane do? - Answers -Can bring out pieces of our analysis directly as drag and drop elements. If they're not relevant to the type of view, certain elements will be greyed out. How do shelves (also known as cards) work? - Answers -A view can be built by dragging and dropping fields from the date pane into the canvas directly, or onto the shelves. What are the different types of shelves? - Answers -- Columns shelf
- Rows shelf
- Pages shelf
- Filter shelf What is the marks card? - Answers -The marks card is made up of several other shelves, each of which can have fields placed on them and can be clicked on to edit their characterisitics. Depending on the composition of the view, there can be multiple marks cards, one for each measure. When are legends created? - Answers -Legends will automatically be created when a field is placed on the color, size or shape shelf.
How do you split data? - Answers -Click to open the menu and select split When is a custom split needed? - Answers -When not all of the data is the same (example: some employees have extra identification at the end of their employee number) When does Tableau create a pill? - Answers -When we bring a field into the view from the data window. What does the pill color indicate? - Answers -Whether the pill is continuous or discrete. What color are discrete pills? - Answers -Blue What color are continuous pills? - Answers -Green Are text and categories discrete or continuous? - Answers -Discrete What area are you brought to once you connect data? - Answers -Workspace area. What can you do in the workspace area? - Answers -You can work with sheets, dashboards, and stories. What area do you enter when you click 'Sheet1'? - Answers -Design area How do you create more vizes? - Answers -Add more sheets. In what window can you change the data type? - Answers -Data source window What kinds of data types are there? - Answers -- Text
- Date
- Date and time
- Numerical
- Geographic
- Boolean. When can numbers be discrete? - Answers -When they take one of a limited set of distinct, separate values. When are numbers continuous? - Answers -If they can take any value in a range. What do dimensions set? - Answers -The granularity, or the level of detail in the view. What are dimensions usually? - Answers -Categorical fields such as order priority and city.
What type of data are usually measures? - Answers -Numerical data such as shipping costs. What do dimensions come out onto the view as? - Answers -Themselves What do measures come out onto the view as? - Answers -Aggregates Most of the time are dimensions discrete or continuous? - Answers -Discrete Most of the time are measure discrete or continuous? - Answers -Continuous What does filtering on a discrete pill do? - Answers -Brings up options related to the specific lists of values for that pill. What does filtering on a continuous measure pill do? - Answers -Filtering on a continuous measure pills asks first if we want to filter at the row-level or aggregate level, then brings up options for continuous ranges. What does a measure on color default to? - Answers -A filled map. What does a dimension on color default to? - Answers -A symbol map. What does a continuous pill on color show? - Answers -A color gradient. What does a discrete pill on color show? - Answers -A palette of distinct colors. What will happen if the date icon is blue in the data window? - Answers -The default when we bring out the pill will be discrete, otherwise it will be brought out as continuous. Continuous vs. discrete dates - Answers -The options on top are discrete dates, the lower section are continuous dates. How can you create a calculated field? - Answers -Right click in the data window and select create calculated field. How can you add a comment to a calculated field? - Answers -// What indicates a calculated field? - Answers -The little equal sign in front of the field. What are quick table calculations? - Answers -A set of pre-defined commonly used computations How can you tell that something is a table calculation? - Answers -The delta symbol on the pill. What does the ZN function do? - Answers -Returns a zero whenever there is a null.
What does limit the use of color to one primary color scheme mean? - Answers -Try to limit the use of color to expressing one dimension or one measure. You can effectively add a secondary use of color in the same dashboard if that secondary use of color employs a more muted color scheme. What colors are visible to most color-blind people? - Answers -Grey scale and blue/orange color pallets How should you incorporate small instructions near the work to make navigation obvious? - Answers -Placing instructions in the title bard of the worksheet that triggers the action is a good way to remind people of the availability of the action. Another alternative is to place the instruction in tooltips that appear when hovering over marks. This method offers the advantage of having the instructions appear in more complete text without crowding the dashboard space. How can you show that text denotes an instruction? - Answers -By using a consistent font style and color for the instructions What are crosstabs? - Answers -Crosstabs are useful visualizations for looking-up specific values when you know exactly what you're looking for. Crosstabs are not the best visual style for quickly discovering trends and outliers. What does remove all non-data ink mean? - Answers -Remove any text, lines, or shading that doesn't provide actionable information. Remove redundant facts. If a company logo isn't required for promotion purposes - remove it. Ruthlessly eliminate anything that doesn't help your audience understand the story contained in the data. What is achieving fast load times dependent of? - Answers -The size and complexity of your data as well as the type of datasource you are using.
