A. Software
- tableau prep builder 2019.2
B. Data Connection
C. Sample PDF document
- A Systematic Review and Meta-Analysis of the Cognitive Correlates of Bilingualism (Odesope, 2010)
- Summary of coded studies and associated effect sizes table is on page 9, 10, and 11 of the article.
D. Data Interpreter
- select “Use Data Interpreter”
- drag “Page 9 Table 1” to “Add Data” canvas to start the flow
- Effect size is recognized as character variable
- In Input section, under Data Sample tab, select “Use all data”
E. Flow Development
- Click “+” next to “Page 9 Table 1” in the flow and select “Add Union”
- Union 1 shows there are 28 Rows of data with 7 Fields from “Page 9 Table 1”.
- drag “Page 10 Table 1” over the Union 1 icon in the flow which means that “Page 10 Table 1” will be added to Union 1.
- Union 1 now shows there are 58 Rows of data with 7 Fields from “Page 9 Table 1” and “Page 10 Table 1”.
- add “Page 11 Table 1” to Union 1.
F. Add Calculation Field
- Create a Calculated Field named [Effect Size] from the existing [Effect Size (g)]
- Use split function to trim the ‘*’ from the string and then use float function to convert string to float.
- Click ‘+’ next to Union 1 icon and select “Add Output”
- Click Output icon to run flow
- The output.hyper file will be generate under the c:\user\username\documents\My Tableau Prep Repository\Datasources\ folder
F. Use Case
- Systematic Review/Meta-analysis