Analysis Report One - What’s Your Data Strategy

Author

Cameron O’Connor

Executive Summary

Data has become a critical organizational asset, requiring companies to balance both offensive and defensive data strategies. Offensive strategies use analytics and artificial intelligence to improve decision making, increase revenue, and enhance customer experiences, while defensive strategies focus on data quality, security, governance, and regulatory compliance. DalleMule and Davenport argue that organizations should establish a Single Source of Truth to maintain accurate and consistent data while allowing departments to create customized analyses that support business objectives. Recent developments in artificial intelligence further emphasize the importance of effective data management. Although AI can improve productivity, it is becoming widely accessible, making human creativity, innovation, and strategic use of data more important sources of competitive advantage. At the same time, examples such as TikTok’s recommendation algorithm and emerging threats like data poisoning demonstrate the need for strong governance and ethical oversight. Organizations that balance innovation with security will be better positioned for long-term success.

Introduction

In today’s business environment, data is one of the most valuable resources an organization can possess. Companies collect vast amounts of information from customers, employees, suppliers, and daily operations, but the ability to manage and use that data effectively is what creates real value. According to DalleMule and Davenport, organizations need a clear data strategy that balances offensive and defensive objectives. Offensive data strategies focus on using analytics and artificial intelligence to improve customer experiences, increase revenue, and support better decision-making. Defensive strategies emphasize protecting data through governance, security, regulatory compliance, and maintaining high data quality. A successful strategy also relies on creating a Single Source of Truth, allowing departments to build customized insights while ensuring that everyone works from consistent and accurate information. As artificial intelligence becomes increasingly common, organizations must also consider ethical concerns, cybersecurity risks, and responsible data management. Developing a balanced data strategy enables businesses to maximize the value of their information while protecting it from misuse, creating a strong foundation for long-term innovation, trust, and competitive success.

Research and Extensions

Recent research emphasizes that effective data governance has become increasingly important as organizations adopt artificial intelligence and advanced analytics. According to Janssen et al. (2020), organizations should establish governance frameworks that prioritize data quality, transparency, accountability, and ethical decision-making to ensure AI systems produce reliable and trustworthy outcomes. Strong governance practices also help businesses comply with evolving regulations while improving stakeholder confidence. In addition, Dwivedi et al. (2021) found that organizations achieve greater value from artificial intelligence when technology is supported by clear business strategies, skilled employees, and high-quality data. Rather than relying solely on AI capabilities, successful organizations integrate governance and leadership into their AI initiatives to improve decision-making and operational performance. Similarly, Wang and Strong (1996) argue that data quality is a critical factor in organizational success. Their research identifies dimensions such as accuracy, completeness, consistency, and timeliness as essential characteristics of useful data. High-quality data enables organizations to make informed decisions and reduces the risks associated with inaccurate information. Together, these studies reinforce DalleMule and Davenport’s argument that balancing innovation with strong data governance enables organizations to maximize the value of their data while reducing operational and regulatory risks.

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

Organizations should develop a balanced data strategy that supports both innovation and security. Businesses can use data analytics and artificial intelligence to improve customer experiences, increase efficiency, and make better decisions, but these efforts should be supported by strong data governance practices. Companies should establish a Single Source of Truth to ensure that data remains accurate, consistent, and accessible across departments while allowing teams to create customized insights for their specific needs. In addition, organizations should invest in cybersecurity, employee training, and AI governance to reduce risks related to privacy, bias, and data breaches. As AI becomes more widely available, competitive advantage will come less from the technology itself and more from how organizations use reliable data to solve business problems and serve customers. By balancing offensive and defensive data strategies, businesses can improve operational performance, maintain customer trust, and remain competitive in an increasingly data-driven marketplace.

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.