Analysis Report One - What’s Your Data Strategy

Executive Summary

This report evaluates Northwind Traders’ data strategy using the offense-and-defense framework from “What’s Your Data Strategy?” The analysis shows that Northwind should strengthen defensive controls around inventory accuracy and data consistency while also using offensive analytics to identify pricing and sales opportunities. In healthcare, the same balance is essential because organizations must protect sensitive patient data while still using analytics to improve care and operations.

Introduction

Organizations today depend on data to make better decisions, improve operations, and remain competitive. In “What’s Your Data Strategy?”, Leandro DalleMule and Thomas H. Davenport explain that organizations need to balance two complementary approaches to data management: defensive and offensive data strategies.(DalleMule and Davenport 2017) Defensive strategies focus on protecting data through governance, quality, privacy, security, and regulatory compliance, while offensive strategies focus on using data to create business value through analytics, decision-making, and innovation.(DalleMule and Davenport 2017)

The article argues that successful organizations cannot focus on only one approach. Strong governance creates trustworthy data, while analytics transform that trusted data into better business decisions. The authors also introduce the concepts of a Single Source of Truth (SSOT), where critical organizational data is maintained consistently, and Multiple Versions of the Truth (MVOT), which allow different departments to analyze the same trusted data for their specific business needs.

The supporting MIT Sloan article expands on these ideas by arguing that artificial intelligence alone will not create a lasting competitive advantage. Instead, organizations that combine high-quality data, skilled employees, and thoughtful business strategies will gain the greatest long-term value from AI. (Brynjolfsson, Li, and Raymond 2023) Together, these readings demonstrate that successful organizations must invest in both reliable data management and effective data analysis.

Research and Extensions

Recent developments in artificial intelligence reinforce the importance of having a strong data strategy. As organizations increasingly adopt generative AI, the quality and security of their data become even more important. Researchers have warned that AI systems can be vulnerable to data poisoning, where false or manipulated information is introduced into training data, leading to inaccurate or potentially harmful outputs.(Goldblum, Fowl, and Goldstein 2024) This demonstrates why organizations must prioritize data governance, validation, and cybersecurity before relying heavily on AI-driven decision making.

In healthcare, these risks are especially significant because inaccurate data could influence patient care, treatment recommendations, or operational decisions. Healthcare organizations should establish clear data ownership, maintain accurate electronic health records, enforce strong access controls, and regularly audit data quality. These defensive practices create a trustworthy foundation that supports offensive uses of data such as predictive analytics, disease surveillance, and resource planning.

Together, the Harvard Business Review article, the MIT Sloan article, and current research on generative AI demonstrate that organizations achieve the greatest value when they combine strong data governance with thoughtful analytics and responsible technology adoption.

Data Visualizations

The following analyses use Northwind data to demonstrate one offensive and one defensive use of organizational information.

Warning

One note of caution. The code in this report focuses on the concepts introduced in Practice 1, including SELECT, FROM, WHERE, and basic ggplot visualizations.

Visualization One - Offensive

This visualization demonstrates an offensive data strategy by examining suppliers located in Germany, France, and the United Kingdom. Understanding supplier locations helps organizations identify sourcing opportunities and make strategic purchasing decisions.

SELECT CompanyName, Country
FROM Suppliers
WHERE Country IN ("Germany", "France", "UK")

Important

During the presentation, the WHERE statement will be changed and the visualization will be rerun as the required live edit.

ggplot(data = myquery1,
       aes(y = Country)) +
  geom_bar() +
  labs(
    title = "Suppliers in Germany, France, and the UK",
    x = "Number of Suppliers",
    y = "Country"
  )

The graph shows the number of suppliers located in Germany, France, and the United Kingdom. Management can use this information to evaluate supplier concentration and identify opportunities to diversify sourcing across different regions.

Visualization Two - Defensive

This visualization demonstrates a defensive data strategy by identifying products with fewer than 10 units remaining in stock. Monitoring inventory levels helps organizations avoid stockouts, maintain accurate records, and ensure products remain available for customers.

SELECT ProductName, UnitsInStock
FROM Products
WHERE UnitsInStock < 10

ggplot(data = myquery2,
       aes(x = reorder(ProductName, UnitsInStock),
           y = UnitsInStock)) +
  geom_col() +
  coord_flip() +
  labs(
    title = "Products with Low Inventory",
    x = "Product",
    y = "Units in Stock"
  )

The visualization identifies products that are running low on inventory. Managers can use this information to review replenishment needs before stockouts occur, improving customer satisfaction and reducing lost sales.

Recommendations for Industry

Northwind should strengthen its defensive data strategy by establishing routine inventory monitoring and maintaining standardized product and supplier records. Products with fewer than 10 units in stock should be reviewed alongside their reorder levels and units already on order before new purchasing decisions are made.

The company should also expand its offensive use of analytics. Supplier-location data can help management identify geographic concentration, evaluate sourcing relationships, and reduce dependence on a limited number of regions. Future analysis should connect supplier information with product pricing, order volume, and sales performance.

For healthcare organizations, the same framework requires a strong defensive foundation built around patient privacy, data accuracy, access controls, and regulatory compliance. Once those controls are established, hospitals can responsibly use analytics for staffing, readmission prevention, resource planning, and improved patient outcomes.

Conclusion

This report demonstrates that organizations need both defensive and offensive data strategies. Defensive practices ensure that information is accurate, secure, and reliable, while offensive analytics help leaders identify opportunities and make better decisions. The Northwind analysis shows how simple SQL queries and visualizations can support both goals. In healthcare, maintaining trustworthy data is especially important because poor data quality can affect privacy, compliance, operations, and patient care.

References

bibliography: references.bib

References

Brynjolfsson, Erik, Danielle Li, and Lindsey R. Raymond. 2023. “Generative AI at Work.” MIT Sloan Management Review.

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

Goldblum, Micah, Liam Fowl, and Tom Goldstein. 2024. “Data Poisoning Attacks on Machine Learning: A Survey.” IEEE Transactions on Pattern Analysis and Machine Intelligence.