Analysis Report One - What’s Your Data Strategy

Author

Your Name Here

Executive Summary

Summarize your core themes, findings and recommendations into a concise, high-level overview tailored for busy executives.

Introduction

Summarize the core arguments, frameworks, and foundational concepts from the assigned readings for the week into a cohesive introduction.

Research and Extensions

Include original research that updates the ideas in the provided readings, adding additional ideas and recent examples where appropriate.

Data Visualizations

Include the code and graphs for your two visualizations here (One offensive, defensive). You should describe your data and the visualization, together with an explanation of why the example is relevant for organizations today.

Warning

One note of caution. I’m teaching you certain concepts this week. Your code must focus on the topics contained in the practice. I don’t want to see the best query AI can dream up. I want to see the best you are able to do with what I am teaching.

Your queries may be loosly based on Practice queries, but they must extend or adapt the practice in interesting ways (again sticking to the practice concepts) if you want to score highly. Your goal is to show mastery of the week’s material.

Visualization One - Offensive

--I've completed this for you as a placeholder. Replace this with your query.
--SQL code in this block

SELECT CompanyName, Country, Region
FROM Suppliers
WHERE Region LIKE "%Europe%"
Important

Don’t forget to do you live edit when you present Visualization one. You must change your WHERE statement in some meaningful way, then rerun your visualization to show the change.

#ggplot visualization in this block. I prettied this up with labels to show what is possible.
ggplot(data = myquery1,
       aes(x = Country)) +
  geom_bar() +
  theme_minimal() +  # Cleans up the background grid lines
  labs(
    title = "Visualization showing number of suppliers in European regions",
    subtitle = "Data taken from Northwind",
    x = "Country",
    y = "No. of Suppliers in Country",
    caption = "Source: Northwind Sqlite"
  )

Visualization Two - Defensive

--Put your SQL code in this block
SELECT * FROM employees
LIMIT 2
#Put your ggplot visualization in this block

Recommendations for Industry

Translate your research and data findings into actionable, strategic recommendations for executives looking to improve operational or defensive data strategies.

References

Getting your citations out of Google Scholar and into your references.bib file takes just a few clicks.

  1. Go to Google Scholar and search for the paper you want to cite (for example: “What’s your data strategy”).

  2. Look directly underneath the search result for the Cite button (it looks like a double quotation mark ”). Click it.

  3. A pop-up window will appear showing standard citation styles (APA, MLA, etc.). At the very bottom of that pop-up, click the link that says BibTeX.

  4. A new page or plain text block will open showing some bibtex code. Paste that block of text into your [references.bib] file.

If you have multiple sources, just keep pasting them one after another down the file. You don’t need commas between the different articles; just separate them with a blank line to keep it clean. You can then cite them like this (DalleMule and Davenport 2017) and they will automatically appear in the references section.

DalleMule, Leandro, and Thomas H Davenport. 2017. “What’s Your Data Strategy.” Harvard Business Review 95 (3): 112–21.