Applying Tools and Techniques: Opportunities in Your Work

Part 1: Starting with the Business Question

The most effective data projects don't start with data; they start with a business problem. Before building any report, a manager should ask: "What question am I trying to answer?" or "What decision do I need to make?" The tools you've learned are the means to answer these questions.

This shift in mindset—from creating charts to solving problems—is the foundation for identifying valuable opportunities. The following video provides an excellent framework for thinking about this process.

The key takeaway for your workshop is that every good dashboard is a response to a question. Encouraging managers to articulate their questions first will naturally lead them to the metrics and data they need.

Part 2: Finding Opportunities in Everyday Work

Managers might think that "AI" is only for large, complex projects. It's important to demystify this. As AI expert Andrew Ng explains, some of the most significant value comes from a "long tail" of smaller, customized projects that solve unique business problems.

This concept of the "long tail" is a powerful message for your workshop. The tools you've taught—Power Query and Power BI—are exactly what enable these custom, high-value projects without needing a team of AI scientists.

Part 3: A Framework for Identifying and Prioritizing Opportunities

To make this process concrete for your managers, you need to provide them with a structured way to brainstorm and evaluate ideas. The "AI Opportunity Assessment" is a perfect tool for this. It guides users through a simple, logical process.

First, let's look at the overall process visually.

Now, let's dive into a practical template that your managers can use directly.

This template transforms a vague goal ("use AI") into a concrete action: find a repetitive, time-consuming task and see if a tool can do it better.

Part 4: Connecting Opportunities to Power BI's Capabilities

Once a manager identifies a potential opportunity, the next step is to connect it to a specific tool or feature they've learned about. This is where you bring the discussion back to Power BI.

The AI features built into Power BI are specifically designed to answer the types of business questions managers have.

By connecting the dots, you can frame the tools as follows:

• Problem: "I spend hours every week manually compiling a sales report."
  • Opportunity: Automate a high-volume, repetitive task.
  • Power BI Solution: Use Power Query to automate the cleaning and merging of data, then create a Power BI report that refreshes with one click.
• Problem: "Our customer churn rate went up last quarter, and I don't know why."
  • Opportunity: Perform a root cause analysis.
  • Power BI Solution: Use the Key Influencers or Decomposition Tree visual to analyze the factors contributing to churn.
• Problem: "I need to forecast our inventory needs for the next six months."
  • Opportunity: Predict future trends based on historical data.
  • Power BI Solution: Use the built-in Forecasting feature on a line chart.

Part 5: Your Workshop Activity: The Opportunity Brainstorm

As the instructor, your role is to facilitate this discovery process. Here is a plan for a 30-45 minute activity you can run during your workshop:

1. Introduce the Goal (5 mins): Explain that the objective is to find one or two real-world tasks in their own jobs that could be improved with data analysis or automation.
2. Individual Brainstorming (10 mins):
   • Distribute a simplified version of the "AI Opportunity Assessment Template".
   • Ask each manager to silently list 3-5 tasks they do regularly that are repetitive, time-consuming, or based on guesswork.
   • Have them use the scoring system (Manual Repetition + Time Impact + AI Suitability) to rank their own ideas.
3. Small Group Discussion (15 mins):
   • In groups of 3-4, have each person share their highest-scoring opportunity.
   • The group's task is to help each other refine the idea by asking:
     • "What business question are you trying to answer?"
     • "What metric would help you measure this?" (e.g., "late shipment rate," "employee turnover")
     • "Which Power BI visual or feature we've learned might help?" (e.g., a line chart for trends, a map for geographic data, Key Influencers for root cause).
4. Group Share-Out (5-10 mins):
   • Ask each group to share one compelling example with the room. This reinforces the concepts and shows the variety of applications.

Conclusion

You have now journeyed from the raw, messy beginnings of data to the strategic identification of business opportunities. This lesson provides the crucial link between the technical skills your managers have learned and the real-world value they can create.

Key Takeaways:

• Effective data analysis starts with a business question, not a tool.
• Valuable opportunities often lie in automating high-volume, repetitive tasks that managers perform every day.
• A simple framework (Identify, Evaluate, Prioritize) can help managers systematically find and vet potential projects.
• The AI features in Power BI are built to answer common business questions about root causes, trends, and key drivers.

Preview of the Next and Final Lesson:

With a list of potential opportunities in hand, the final step is to turn ideas into action. In our last lesson, we will focus on the final outcome of the capstone project: Create a personal action plan for implementing data-driven decision-making. You will learn how to guide your managers in selecting one opportunity and outlining the concrete steps needed to make it a reality.