Operations Strategy & Analytics in Excel
2 Operations Strategy and Data Quality

-
Explain the role of operations strategy in linking long-term vision to daily decision-making.
-
Identify and describe the four competing priorities of operations strategy (cost, quality, speed, flexibility).
-
Discuss the relationship between data quality and operational success.
-
Recognize the five dimensions of data quality and their operational implications.
-
Describe common causes of poor data quality and strategies to address them.
-
Apply a step-by-step data cleaning process to real-world datasets.
-
Integrate data quality management into an organization’s continuous improvement strategy.
-
Compare operational challenges between goods-producing and service-oriented businesses.
2.1 Understanding Operations Strategy
Operations strategy connects a company’s long-term vision to the everyday decisions that make that vision a reality. It is not just a theoretical framework; it shapes how resources are allocated, how processes are designed, and how performance is evaluated. When well executed, it aligns every operational choice with the organization’s competitive priorities—whether that priority is to be the fastest, the most cost-efficient, the highest quality, or the most flexible provider in the market.
Example: Retail vs. Wholesale Strategy
In Pemi’s cafés, operations strategy shapes menu variety, pricing, service speed, and the customer experience. In its wholesale roasting arm, it drives decisions on bean sourcing, production scheduling, inventory management, and distribution partnerships.
While manufacturing firms produce physical goods, service companies also rely heavily on operations strategy. In a consulting firm, for example, the “production” is the delivery of expertise. Timelines, staff utilization, and project workflows take the place of assembly lines and production schedules. In both goods and services, operations strategy determines how the organization responds to fluctuations in demand, how it ensures quality, and how it manages costs.
An effective strategy balances four dimensions: cost, quality, speed, and flexibility. These dimensions are interdependent. A focus on cost efficiency may limit flexibility. Prioritizing speed may require extra labor or technology investments. The trade-offs a company chooses must match its competitive positioning.
Example: Strategic Trade-offs
Pemi cannot compete on price with mass-market coffee brands, so it prioritizes quality and brand experience while keeping operations lean enough to remain profitable.
2.2 Linking Operations Strategy to Data Quality
Even the most well-crafted operations strategy depends on reliable, timely, and accurate information. Without quality data, managers cannot make informed decisions about scheduling, inventory, staffing, or resource allocation. Poor data quality can turn a sound strategy into an operational liability.
Example: Data Accuracy Impact
In Pemi’s wholesale operation, misrecorded orders or incorrect delivery addresses can delay shipments and damage customer relationships. In cafés, inaccurate sales data may cause stockouts and lost revenue during peak demand.
In a service industry example, consider a marketing agency tracking campaign performance. If the analytics tool misclassifies website visits, the agency might misinterpret the effectiveness of different channels and shift its budget in the wrong direction.
The connection is simple: strategy guides the “what” and “why” of operations, but data quality drives the “how” and “how well.”
2.3 Dimensions of Data Quality
There are five basic dimensions of data quality: accuracy, completeness, consistency, timeliness, and relevance. Each one matters for daily operations.
Accuracy ensures that the data reflects reality.
If Pemi’s point-of-sale (POS) system mis-records a cappuccino as a latte, sales reports misrepresent customer preferences, potentially skewing menu planning and inventory purchasing.
Completeness means that all necessary fields are filled in and no critical information is missing.
A wholesale order without a delivery date or customer contact information creates bottlenecks and extra administrative work.
Consistency ensures that data follows uniform formats and naming conventions.
Variations in recording state names (“NH” vs. “N.H.”) can create mismatches across systems.
Timeliness ensures data is available when needed. Outdated information can lead to misaligned staffing schedules or production runs.
Relevance keeps the focus on collecting only what is useful for the decision at hand. Storing unnecessary details adds clutter and distracts from key metrics.
2.4 Common Causes of Poor Data Quality
Poor data quality can come from human mistakes, flawed processes, or technical limitations. Manual entry errors are among the most common issues. At Pemi’s café, a barista might accidentally record a large coffee as a medium, throwing off inventory counts. In a consulting firm, employees might misclassify billable hours, leading to incorrect invoices.
System issues can also introduce errors. If a customer order management platform does not integrate with the inventory system, discrepancies can arise when orders are fulfilled. Outdated technology may lack validation checks, making it easier for mistakes to slip through.
Process flaws often go unnoticed until they cause recurring problems. If a business collects information on paper forms before transcribing it into a digital system, every transcription step becomes a potential error point.
Culture plays a role as well. When employees do not understand why data quality matters, they may view it as a low-priority administrative task rather than as part of delivering good service.
2.5 The Role of Data Cleaning in Operations
Data cleaning is the deliberate process of finding and fixing errors, filling in gaps, and standardizing information so that it is usable for decision-making. It is not just a technical chore—it is an operational safeguard. Without clean data, forecasts become unreliable, schedules inefficient, and quality control ineffective.
In Pemi’s wholesale operation, data cleaning takes place before production schedules are finalized. Orders are checked for missing quantities, incorrect addresses, or unverified delivery dates. Catching and correcting errors before the beans are roasted prevents costly waste.
In service industries, the stakes are similar. A law firm that sends invoices with incorrect billing hours risks client disputes and payment delays. Regular data cleaning ensures the accuracy of records and preserves professional credibility.
2.6 A Detailed Walkthrough of the Data Cleaning Process
The cleaning process is sequential, but in practice, steps may loop back as new issues are found. Here is how a typical cycle might look when preparing Pemi’s wholesale order data for a weekly roasting plan.
- Import the dataset into a tool that supports sorting, filtering, and validation—often Excel, Google Sheets, or a database platform.
- Scan for duplicate entries. At Pemi, a duplicate might occur if a wholesale customer calls and emails the same order, and both are entered separately. Duplicates can lead to double production and unnecessary shipping.
- Identify structural errors. This includes inconsistent date formats, misaligned columns, or misspelled product names. A typo turning “Dark Roast” into “Dak Roast” could prevent the order from being matched with inventory records.
- Address missing values. This may mean reaching out to the customer for confirmation, using historical averages to fill gaps, or removing incomplete entries if they cannot be verified.
- Cross-verify against a reliable source. For addresses, this could be a postal database; for order quantities, the original order confirmation. This step ensures accuracy before the data is acted upon.
- Standardize formats. All product names, abbreviations, and customer identifiers should follow the same conventions. Consistency helps prevent future mismatches between systems.
- Document the changes made. Keeping a log of adjustments builds an audit trail and supports training efforts, showing employees where errors occur most often and how they were resolved.
This same process applies in service industries. For example, a digital marketing agency cleaning campaign analytics would import raw reports, remove duplicates from multiple tracking platforms, ensure consistent date and campaign naming conventions, address missing conversion data, verify numbers against client systems, and record all adjustments before analysis.
2.7 Embedding Data Quality into Operations Strategy
For data quality to last, it has to be part of daily operations. It cannot be treated as a one-time project. Businesses need to build quality checks into routine workflows, train employees, and review results on a regular basis. This makes data quality part of the culture rather than an occasional fix.
At Pemi Coffee Roasters, data entry rules are included in new employee training. Baristas, sales staff, and managers are shown how mistakes at their step affect production, delivery, and customer satisfaction. A wrong entry may seem small, but it can lead to missing inventory, late orders, or unhappy customers.
In a service business, project managers may review data at specific checkpoints. This makes sure the information passed to the next stage is complete and accurate. A missing client approval or an incomplete project log can cause delays later in the process.
Monitoring is also important. Leaders can track error rates, correction times, and the costs linked to mistakes. These numbers show whether the business is making progress or if problems continue. Regular reviews help find repeating issues, adjust training, and improve processes over time.
2.8 Continuous Improvement and Data Quality
Data quality is not a one-time achievement. It requires constant attention. Many organizations use continuous improvement methods such as PDCA (Plan–Do–Check–Act) or Six Sigma to keep data quality connected to their overall goals for operational excellence.
At Pemi Coffee Roasters, this might include quarterly audits of both café and wholesale systems. These audits can show patterns in errors and point to areas where training or processes need to change. For example, if delivery address mistakes become common, the order form could be redesigned to include address checks.
In service businesses, improvement often means making data collection easier and reducing manual entry. A consulting firm, for instance, could switch to one integrated system for time tracking and billing. This step reduces the chance of differences between separate platforms and helps keep records consistent.
2.9 Case Integration: Service Operations and Pemi Coffee Roasters
Although Pemi produces a tangible product, many of its operational challenges mirror those of service organizations. Both must align strategy with quality data to manage resources effectively.
Consider a busy Saturday at Pemi’s café alongside a high-demand day for a spa. In both cases, reservations (or orders) need to be accurate, inventory (whether coffee beans or massage supplies) must be sufficient, and staffing must be aligned with customer flow. Data quality in booking systems ensures smooth execution.
By studying operations in both sectors, students can see how the same principles apply whether the “product” is a latte or a legal consultation. The skills learned here—especially around cleaning and validating data—transfer directly between goods and service industries.
2.10 Summary and Assignment
Operations strategy sets the framework for how a business delivers value, and data quality makes sure that framework rests on solid ground. If the data is not accurate, complete, consistent, timely, and relevant, even the strongest strategies are likely to fall apart during execution.
Pemi Coffee Roasters shows how these concepts come together in practice. From café sales to wholesale roasting, decisions rely on clean data. The same applies in service settings, where customer satisfaction and efficiency hinge on reliable information.
Assignment: For this week’s applied activity, you will receive a dataset with intentional errors. Your task is to clean the data using the step-by-step process outlined in this chapter. Document each change, explain why it was necessary, and ensure that the final dataset meets all five dimensions of data quality.
Key Takeaways
-
Ops strategy links vision to daily trade-offs (cost, quality, speed, flexibility).
-
Good data makes strategy executable; focus on accuracy, completeness, consistency, timeliness, relevance.
-
Most data issues come from people/process/systems—use validation, integration, and training.
-
Clean with a repeatable workflow (dedupe → fix structure/missing → verify → standardize → document).
-
Make data quality routine (checkpoints + PDCA) across goods and services.
Chapter Two References
CARL Open Education Working Group. (n.d.). Data cleaning. In OER data collection toolkit. Pressbooks. https://pressbooks.openedmb.ca/oerdata/chapter/data-cleaning/ pressbooks.openedmb.ca
OpenStax. (2018, September 19). Production and operations management. In Introduction to business. https://openstax.org/books/introduction-business/pages/10-introduction