Week 1 Quiz :Data Visualization and Communication with Tableau (Excel to MySQL: Analytic Techniques for Business Specialization)Answers 2025

Answer Key: Data Analytics Basics / SMART Goals

1. True/False – SQL skills most valued by recruiters
   ✔ True
   ❌ False

2. True/False – Only one “true” question exists in analytics
   ✔ False
   ❌ True

3. SMART acronym used in this course:
   ✔ Specific, Measurable, Attainable, Relevant, Time-bound
   ❌ Strategic, Measureable, Attainable, Relevant, Time-bound
   ❌ Specific, Measureable, Active, Realistic, Time-bound
   ❌ Specific, Measureable, Attainable, Realistic, Time-bound

4. First step in analytics project life cycle:
   ✔ Defining a SMART goal
   ❌ Making a data analysis plan
   ❌ Making a dashboard
   ❌ Analyzing data

5. Including the business metric ensures SMART goal is specific:
   ✔ False
   ❌ True

6. SMART criteria NOT met by the project goal (polo shirt returns):
   ✔ Reasonable
   ❌ Time-bound
   ❌ Specific
   ❌ Attainable
   ❌ Measurable

7. Stakeholders are those influenced/interested in project outcome:
   ✔ True
   ❌ False

8. Elicitation = writing a document listing requirements/objectives:
   ✔ False
   ❌ True

9. Non-key stakeholders in bank credit card project:
   ✔ the bank’s creditors
   ✔ the bank’s shareholders
   ✔ Individuals who applied for credit cards in the past, but were denied
   ❌ the bank, itself
   ❌ Individuals who will apply for credit cards in the future

10. At project start, meet stakeholders to understand:
    ✔ all of the above
    ❌ what problem the business is experiencing
    ❌ whether stakeholders agree on the problem
    ❌ what factors to consider
    ❌ what tools/results culture will accept

11. Strategies if SMART goal analysis not initially accepted (check all that apply):
    ✔ Write a persuasive white paper describing benefits
    ✔ Show executives examples of value from similar analyses
    ✔ Show prototypes of potential results
    ❌ Suggest implementing two analysis teams in parallel

12. Treat business metric as independent variable:
    ✔ False
    ❌ True

13. SPAPs should be altered after starting analysis:
    ✔ True
    ❌ False

14. Layers for making charts to assess independent variables in SPAP:
    ✔ Layers 2 and 3
    ❌ Layer 2
    ❌ Layer 3
    ❌ Use your judgment

15. Best charts for categories/subcategories in intermediate SPAP layers:
    ✔ Bar charts
    ✔ Pie charts
    ❌ Scatter plots
    ❌ Line charts

    Here’s a compact summary table for your Data Analytics / SMART Goals quiz:

    Q#	Topic	Answer / Key Point
    1	SQL skills value	✔ True
    2	One true question	✔ False
    3	SMART acronym	✔ Specific, Measurable, Attainable, Relevant, Time-bound
    4	First project step	✔ Defining a SMART goal
    5	Business metric ensures specificity	✔ False
    6	SMART criteria NOT met (polo shirt goal)	✔ Reasonable
    7	Stakeholder definition	✔ True
    8	Elicitation = writing requirements doc	✔ False
    9	Non-key stakeholders	✔ Bank’s creditors, ✔ Bank’s shareholders, ✔ Past denied applicants
    10	Stakeholder meeting purpose	✔ All of the above
    11	Persuading stakeholders to adopt analysis	✔ White paper, ✔ Show examples, ✔ Show prototypes
    12	Business metric as independent variable	✔ False
    13	SPAP alteration after starting	✔ True
    14	Layers to chart	✔ Layers 2 & 3
    15	Best charts for intermediate SPAP layers	✔ Bar charts, ✔ Pie charts