________________ is hosted by Tableau to share our visualisations publically with the world.
Correct Answer: D
Explanation Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public ("vizzes") can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users. Check it out : https://public.tableau.com/en-us/s/
Question 7
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
Correct Answer: B
Explanation TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access. Create a .twbx with file-based data sources 1) Select File > Save As. 2) Specify a file name for the packaged workbook in the Save As dialog box. 3)Select Tableau Packaged Workbooks on the Save as type drop-down list. 4) Click Save. 5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose. The following files are included in packaged workbooks: --> Background images --> Custom geocoding --> Custom shapes --> Local cube files --> Microsoft Access files --> Microsoft Excel files --> Tableau extract files (.hyper or .tde) --> Text files (.csv, .txt, etc.)
Question 8
Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?
Correct Answer: D
Explanation Follow the steps to get the correct answer : January 2018 * We are talking about dates, so use the Time series sheet as follows: * Next, the following should be your view and clearly, January 2018 is the lowest point: Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/
Question 9
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
Correct Answer: A
Explanation This is true, indeed! The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
Question 10
Larger image What is this view referred to as in Tableau?
Correct Answer: C
Explanation Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace. The Data pane includes: Dimension fields - Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments. Measure fields - Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency. For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green. Calculated fields - If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields. For more information on calculated fields, see Create Custom Fields with Calculations. Sets - Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets. Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau. Parameters - Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.
