My Own Study Guide Flashcards
What type of layer can be created to make data easier to understand and use?
Metadata
How can you create a data extract?
- Connect to data
- Select Extract in upper-right corner
- Select Edit to open dialog box and choose options
- Save settings
- Select sheet tab
- Select location and enter a file name
- Save
What file type is an Excel file?
.xlsx
How do you connect to a .csv file?
In the Connect pane, select Text file and choose your file
How do you connect to a custom SQL query?
- Connect to your data
- On data source page, double click New Custom SQL
- Add your query to the text box using a single SELECT* statement
How do you connect to a data source on Tableau Server?
- In Tableau Desktop’s Connect pane, under Search for Data, select Tableau Server
- Select Connect and sign in with user name and password
- Select data to connect to and click Connect
- Select the sheet tab to start your analysis
How do you replace a data source for an existing worksheet?
- With the workbook open, select Data > New Data Source from the main menu
- Choose your new data source
- On the data source page, drag a table to the canvas to set up the data source
- Go to the sheet tab and select Data > Replace Data Source
- Select the Current data source and the Replacement data source from the dialog box
How can you organize data into folders in Tableau?
- In Data Pane menu, select Group by Folder
- Right-click field in Data Pane and select Group By > Folder
What type of join does a data bland create?
Left join
What connectors support Data Interpreter?
- Excel (.xlsx)
- Text (.csv)
- Google Sheets
How do you turn on Data Interpreter?
- Connect to a valid data source
- Drag a table to the canvas
- On data source page, select Use Data Interpreter
- In the Data pane, click Review the results
How do you pivot columns to rows?
Select two or more columns > Click drop down arrow next to name > select Pivot
How can you create a custom split for you field?
- On Data Source page, click drop down next to the field name, select Custom Split
OR - From the Data pane, right-click the field you want to split, select Transform > Custom Split
How do you create an extract filter?
Before creating your extract, click Add in the upper right hand corner of the Connect pane
What aggregations can be applied to dimensions?
- Minimum
- Maximum
- Count
- Count (Distinct)
How do you disaggregate data?
From main menu, select Analysis > Aggregate Measure, and deselect
How do you change the data type of a field?
Right click field > change data type, select new data type
How do you change the default sort for a field?
Right click field > Default Properties > Sort, select options
How is moving average calculated?
Add all data points in a specific period and divide the sum by the number of time frames
What is the primary use for the moving average calculation?
forecasting long-term trends
What is a running total?
A sequence of partial sums that’s updated each time a new number is added to the sequence
What does a compound growth rate calculation show?
The rate of return of an investment over time
How do you create a parameter?
From the Data pane drop down, select Create Parameter and select options
How do you create a set?
Select multiple fields from the data pane or view, right click one and select ‘Create Set’
What fields are ideal for creating a symbol map?
Longitude/Latitude in Columns/Rows, a measure in size, and a regional dimension in detail
What fields are needed to create a heatmap?
Dimension in rows, measure in text and color
What fields are needed to create a histogram?
Measure in rows and a bin created from that measure in rows
What fields are needed to create a Gantt Chart
Continuous date or time measure in columns, dimension in rows, continuous measure in size
What fields are needed to create a box plot?
Mark type circle, dimension in columns and detail, measure in rows, box plot reference line
What fields are needed to create an area chart?
Mark type area, dimension in columns, measure in rows, different dimension in color
What types of actions can you add to a dashboard?
- Filter
- Highlight
- URL
- Go to sheet
- Change parameter
- Change set values
How do you add an action to the dashboard?
Main menu > Dashboard > Actions
What is the DATEDIFF syntax?
DATEDIFF(‘date_part’, date1, date2)
What does DATENAME do?
Returns the requested date part of a given date as a string
What is the DATENAME syntax?
DATENAME(‘date_part’, date)
What does DATEPARSE do?
returns specifically formatted strings as dates
What is the DATEPARSE syntax?
DATEPARSE(‘date_format’, “date_string”)
What does DATEPART do?
returns the name of the specified date part as an integer
What is the syntax for DATEPART?
DATEPART(‘date_part’, date)
What is the syntax for CONTAINS
CONTAINS(“string”, “substring”)
What is the syntax for LEFT?
LEFT(“string”, “number of characters”)
What are three functions used to change casing?
LOWER, UPPER, PROPER
What do LTRIM, RTRIM, and TRIM do?
Remove spacing from the respective sides
What does the ZN function do?
Returns value if given expression isn’t null, or 0 if it is null
What is the syntax for a type conversion function?
TYPE(expression)
How do you remove grid lines
Main menu > Format > Lines > Grid Lines (none)