QUESTION

You have been hired by a US company who wants you to analyze the data to identify trends and investment opportunities. This will give you the opportunity to practice your “analytics mindset” by following the four-step process: ? Ask the right questions, ? Extract, transform and load relevant data, ? Apply appropriate data analytics techniques, and ? Interpret and share the results with stakeholders. Required: Use Tableau and complete the following Identify at least four questions that you want to examine given your task (above) and the available data (attached). Justify your choice of question. Explain which variables from the dataset(dimensions and/or measures) you use to answer each question and why. Create at least one chart per question. Explain and justify your design choices: chart type, design elements, formatting, etc. Answer the question: describe and summarize the main findings and insights you gain from your analysis.

Tableau Assignment 3

Use the CSV file State_Dept_DATATABLE for this assignment. The dataset contains information from the Business Information Database System (BIDS) hosted by the US State Department which provides US businesses with leads on international commercial and investment opportunities. You can find more information here: https://bids.state.gov/faq.

You have been hired by a US company who wants you to analyze the data to identify trends and investment opportunities. This will give you the opportunity to practice your “analytics mindset” by following the four step process:

? Ask the right questions,

? Extract, transform and load relevant data,

? Apply appropriate data analytics techniques, and

? Interpret and share the results with stakeholders.

Required: Use Tableau and complete the following

1. Identify at least four questions that you want to examine given your task (above) and the available data (attached). Justify your choice of question.

Hint: Keep your goal in mind when doing this which is to analyze the data to identify trends and investment opportunities for your client.

2. Explain which variables from the dataset (dimensions and/or measures) you use to answer each question and why.
3. Create at least one chart per question.
4. Explain and justify your design choices: chart type, design elements, formatting, etc.
5. Answer the question: describe and summarize the main findings and insights you gain from your analysis.

Real world data often has missing values and may contain errors. “Null” values as well as values that appear to be out of place (or make no sense) should be excluded from your analysis. Important: Include a note in your chart whenever you choose to exclude data and describe the reason!

Please submit a Word document including your analysis and copies of your charts/views (see here for a tutorial: https://help.tableau.com/current/pro/desktop/en-us/save_export_image.htm) as well as your Tableau file.