Analysis Report One - What’s Your Data Strategy

Executive Summary

Data has become one of the most valuable resources for organizations, particularly in healthcare where accurate information supports patient care, operational efficiency, and regulatory compliance. This report examines the concepts presented in What’s Your Data Strategy? and applies them to a healthcare setting using the Northwind database as a simulated organizational database. The report also incorporates recent research on artificial intelligence and competitive advantage to provide a broader perspective on modern data strategy. Two SQL queries and accompanying visualizations were created to demonstrate both offensive and defensive uses of organizational data. The offensive analysis examines the geographic distribution of healthcare partners to support strategic planning and expansion opportunities. The defensive analysis identifies products with inventory levels below their reorder points, demonstrating how data can reduce operational risk by helping managers prevent shortages of essential supplies. Based on these findings, healthcare organizations should prioritize strong data governance, maintain a single source of truth for critical information, and use trusted data to support informed decision making.

Introduction

Organizations generate enormous amounts of data every day, but collecting data alone does not create value. Companies need a clear data strategy that defines how information will be collected, protected, analyzed, and used to achieve organizational goals. In What’s Your Data Strategy?, DalleMule and Davenport argue that successful organizations balance two complementary approaches to data management: data defense and data offense (dallemule2017?). A defensive data strategy focuses on protecting organizational information through strong governance, security, privacy, regulatory compliance, and data quality. These activities reduce operational risks and ensure that managers can trust the information they use to make decisions. In contrast, an offensive data strategy emphasizes using data to improve competitiveness through analytics, visualization, forecasting, and customer insights. Rather than viewing these approaches as competing priorities, organizations should determine the appropriate balance based on their industry, strategic goals, and regulatory environment. Healthcare organizations provide an excellent example of this balance. Because hospitals and healthcare providers manage sensitive patient information and operate under strict regulations, defensive data practices are essential. At the same time, healthcare organizations increasingly rely on analytics to improve patient outcomes, optimize staffing, manage inventories, and identify opportunities to expand services. Therefore, healthcare organizations must protect their data while also using it strategically to improve organizational performance.

Research and Extensions

Although the concepts presented by DalleMule and Davenport remain highly relevant, recent developments in artificial intelligence have expanded the discussion of data strategy. Wingate, Burns, and Barney argue that while artificial intelligence will significantly improve productivity and decision making, it is unlikely to provide organizations with a lasting competitive advantage because AI technologies are becoming increasingly accessible to everyone (wingate2025?). As AI tools become more standardized, organizations will increasingly compete based on how effectively they implement these technologies rather than simply possessing them. For healthcare organizations, this means that purchasing advanced AI systems alone will not guarantee better performance. Instead, success depends on combining high quality data with experienced employees, effective governance, and organizational creativity. Artificial intelligence can help hospitals forecast patient demand, identify supply shortages, support clinical decision making, and improve operational efficiency. However, these systems are only as effective as the quality of the underlying data and the people responsible for interpreting the results. Together, these articles emphasize that technology should support, rather than replace, sound data management practices. Organizations that maintain accurate, secure, and well governed data while encouraging responsible innovation will be better positioned to improve patient care, reduce operational risks, and remain competitive in an increasingly data driven healthcare environment.

Data Visualizations

Offensive The first visualization demonstrates an offensive use of organizational data by examining the geographic distribution of customers, which are interpreted in this report as healthcare partners or referral organizations. The SQL query uses the SELECT statement to retrieve company names and countries from the Customers table, the FROM clause identifies the data source, and the WHERE clause filters the results to organizations located in the United States, Canada, and Mexico. The resulting data is saved as myquery1 and visualized using ggplot2. The graph uses geom_bar() to count the number of partner organizations in each country. This visualization illustrates how healthcare administrators could analyze referral networks or service areas to identify opportunities for expansion, strengthen relationships with partner organizations, and allocate resources more effectively. By transforming raw transactional data into actionable insights, the visualization demonstrates how offensive data strategies support organizational growth and strategic decision making.

Defensive The second visualization demonstrates a defensive use of organizational data by identifying products whose inventory levels have fallen below their reorder points. In this healthcare scenario, the products represent medical supplies, equipment, or other operational resources required to provide patient care. The SQL query retrieves the product name, category, units currently in stock, and reorder level from the Products table while filtering only those products whose inventory has dropped below the required threshold. The query results are stored in myquery2 and visualized using ggplot2. The bar chart groups products by category, allowing managers to quickly identify areas where shortages are most common. This type of analysis supports defensive data strategy because it helps organizations monitor inventory, reduce operational risks, and ensure that critical supplies remain available. In healthcare environments, proactive inventory monitoring can improve patient safety, reduce emergency purchasing costs, and support uninterrupted clinical operations.

Visualization One - Offensive

SELECT CompanyName, Country
FROM Customers
WHERE Country In ("USA", "Canada", "Mexico", "Brazil")

ggplot(data = myquery1,
       aes(x = Country)) +
  geom_bar() +
  theme_minimal() +
  labs(
    title = "Distribution of North American Healthcare Partners",
    subtitle = "Customers are interpreted as clinics or referral partners",
    x = "Country",
    y = "Number of Partners",
    caption = "Source: Northwind SQLite Database"
  )

Visualization Two - Defensive

--Put your SQL code in this block
SELECT ProductName,
CategoryID,
UnitsInStock,
ReorderLevel
FROM Products
WHERE UnitsInStock < ReorderLevel

ggplot(data = myquery2,
       aes(x = factor(CategoryID))) +
  geom_bar() +
  theme_minimal() +
  labs(
    title = "Products Below Reorder Level",
    subtitle = "Potential inventory shortages by category",
    x = "Category ID",
    y = "Number of Products",
    caption = "Source: Northwind SQLite Database"
  )

Recommendations for Industry

Healthcare organizations should establish a single source of truth (SSOT) for critical operational data such as patient records, inventory, suppliers, and financial information. Maintaining one reliable source of data improves accuracy, reduces duplication, and supports regulatory compliance while allowing different departments to generate reports tailored to their needs. Organizations should also invest in defensive data strategies by continuously monitoring inventory levels and data quality. The inventory analysis in this report demonstrated how simple SQL queries can identify products that have fallen below their reorder levels before shortages become critical. In a healthcare environment, this type of monitoring can help ensure that medications, medical equipment, and other essential supplies remain available for patient care while reducing emergency purchasing costs. At the same time, healthcare leaders should continue developing offensive data strategies by using analytics to improve decision-making and identify opportunities for growth. The geographic analysis of customers demonstrated how organizations can better understand where their services are concentrated. Similar analyses could help hospitals identify underserved communities, improve outreach efforts, strengthen referral networks, and allocate resources more effectively. Finally, healthcare organizations should balance investments in technology with investments in people. While advanced analytics and artificial intelligence can improve efficiency, long-term success depends on high-quality data, strong governance, employee training, and responsible use of information. Organizations that combine secure data management with meaningful analytics will be better positioned to improve patient outcomes, increase operational efficiency, and remain competitive in an increasingly data-driven healthcare industry.

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.