Problem
Possible Solution
Use of Latin names for species
Find and replace in xls. with common name.
See CITES Appendix
Animals are not grouped appropriately for Define categories and place animals into
your analytic purpose.
meaningful groups for each persona’s
analytical purposes. Justify the categorization
in the report.
Use different date standards (American Select one standard and ensure its applied
(
mm-dd-yy) vs European (dd-mm-yy)
consistently across XLS. This can be done by
formatting cells in xls.
Countries are not consistently named Find and replace in xls with common name
E.g., U.K., United Kingdome, Great
(
Britain or U.S.A, U.S. or United States or
Germany and Deutschland.
Quantities are supplied in different but Find the lowest quantity and transfer all
compatible measures (e.g., k.g., g, m.g.) – quantities into this amount e.g. – k.g. to m.g.
e.g., “comparing apples with apples”
Quantities are supplied in different and Separate the two sets for analytical purposes
incompatible measures
or make some sensible assumptions*
regarding comparisons and apply that
assumption consistently across the dataset.
*
You may need to make some assumptions regarding the data this is fine and usual, but all
assumptions should be clearly outlined and justified (i.e., sensible) and included in the report
see step 4. For example, “Gross/net trade outputs tend to overestimate trade levels, as
–
where different quantities have been reported by the importer and the exporter, the larger
quantity is presented in the output” – p. 9 – CITES Trade Database – User guide, version 8.
This document further outlines how the database defines different fields.
Note that Steps 1 and 2 are often iterative rather than sequential steps. In other words, design
of your MD model and data collection in Step 1, may inspire new possibilities of interesting
questions in Step 1, leading to additional data being collected (Step 2)
Step 3: Design of a BI application to answer the stated questions
Using the Excel file from Step 3 import your data set into Tableau.
Then proceed to use data visualisation features of Tableau to answer all questions for the
three personas, as stated in your design templates (in Step 1). For each persona provide some
recommendations based on your analysis to help them reach their goals.
Note that Step 3 may initiate another cycle of iterative design, prompting you to go back to
Steps 1 and 2 in order to expand or refine them.
Step 4: Reflection-on-action
This important step requires us to “step-back” and consider our design in broader
organisational and societal context. For the purposes of this assignment, you are required to
4