Data Analysis and Data Visualization with Microsoft Copilot

Explore how Excel transforms with the power of Copilot.

Learn how to efficiently navigate Excel using Copilot’s AI-powered features.

Discover how Copilot transforms Excel into a smart, AI-powered assistant that helps you analyze, automate, and create with just a few words.

Learn how to write clear, effective prompts that tell Copilot exactly what you need—turning your ideas into actions inside Excel.

Understand when Copilot can save you time—and when it's better to stick with manual Excel tools for speed, control, or precision.

Explore the essential skills modern Excel users need to work confidently with AI tools like Copilot—and stay ahead in a rapidly changing workplace.

Students will develop a conceptual understanding of why Copilot sometimes produces incorrect, incomplete, or misleading results, including issues related to data quality, prompt ambiguity, model limitations, and context window constraints.

In this lesson, we'll show you how Copilot can help you with data search and collection.

Use Copilot to summarize long documents, identify key points, and extract important decisions quickly.

Students will learn the conceptual framework for creating "AI-ready" data, including the role of AI instructions, the importance of business context documentation, and how to structure data so that Copilot can deliver responses that are consistent, reliable, and aligned with organizational goals.

Discover techniques for quickly identifying the most important information from any text.

Learn how to write effective prompts that guide Copilot in cleaning, formatting, and standardizing your datasets for accurate analysis.

Discover how to use Copilot to automate advanced data preparation tasks like pivoting tables, parsing text, and generating calculated fields.

See how Copilot can help you write and customize Power Query M code to clean, transform, and prepare your data faster and with less manual effort.

Access all the materials and templates that support your learning journey.

This lesson explains how Power Query and the M language work behind Copilot, helping you understand, troubleshoot, and refine AI-generated data transformations in Power BI.

Explore how Copilot can assist in identifying outliers, validating data integrity, and maintaining high-quality datasets.

Learn how to prompt Copilot to quickly summarize your data using key descriptive statistics like mean, median, mode, and standard deviation.

Discover how to use natural language prompts to create correlation matrices and identify trends in your data with the help of Copilot.

Learn to analyze data and derive actionable marketing insights efficiently.

Harness AI to identify market opportunities and emerging trends.

Quickly generate comprehensive competitor overviews.

Transform user input into actionable insights.

This lesson demonstrates how to uncover the true root cause of business decline—not the symptoms—using AI for multilayered analysis.

Explore how Copilot can assist you in performing hypothesis tests and interpreting results to support data-driven decisions.

This lesson provides a simplified overview based on a comprehensive guide from DataCamp.

Discover practical techniques for fact-checking and verifying information to ensure accuracy and credibility in your work.

Learn how to generate charts and visuals in Excel using natural language prompts with Copilot.

Learn how to turn raw data into clear, insightful charts and dynamic dashboards that communicate your findings effectively.

Discover how Copilot enhances data storytelling through automatically generated, insightful, and interactive visuals.

Master how to customize, filter, and export your visuals for polished presentations and reports with Copilot’s help.

This lesson covers the core principles of storytelling with data and shows how Copilot can help you design clear, focused, and persuasive visualizations that communicate insights effectively.

Get started with dashboards in Power BI and learn how to visualize data for quick, interactive insights.

Learn how to integrate multiple visuals into a cohesive, interactive Power BI dashboard that tells a compelling data story.

Learn how to enhance your reports with layout design, colors, text, and visuals to create polished, presentation-ready dashboards.

Discover how to configure automatic data refresh and real-time streaming to keep your Power BI reports up to date.

Explore best practices for publishing your dashboards securely and sharing them efficiently with your team and stakeholders.

Practice creating a comprehensive analysis report by applying hands-on techniques to organize, interpret, and present data effectively.

Gain a full understanding of how to plan, execute, and deliver a complete market research project from start to finish.

Learn how to transform insights and notes into a polished internal report tailored for a professional company meeting.

This lesson shows how a BA evaluates whether implemented changes produced real impact using metrics, reports, and Copilot-based analysis.

In this lesson, we explore how AI tools like ChatGPT can enhance decision-making for businesses without existing data.

Students will learn the conceptual approaches to measuring AI adoption, productivity gains, and return on investment, as well as the theoretical considerations for interpreting usage metrics and connecting them to business outcomes.

Learn how to transform ideas into clear visual storyboards and compelling presentation concepts using PowerPoint’s creative tools and structured workflows.

Generate executive summaries and presentations effortlessly using Copilot.

Turn insights into persuasive presentations for informed decision-making.

Discover how to create complete project plans in Word with Copilot’s assistance.

In this lesson, we’ll introduce predictive analytics and models, covering how they use historical data and AI to forecast future outcomes and guide business decisions.

Discover how to use Copilot to model project outcomes under different scenarios (e.g., delays, resource changes) and generate actionable insights.

Discover how to quickly turn project goals into actionable step-by-step checklists and task breakdowns using Copilot.

Learn how to prompt Copilot to generate concise and structured project briefs that capture objectives, scope, deliverables, and key success criteria.

Discover how Copilot summarizes meetings and generates follow-up action items directly in Outlook.

Explore how Copilot can draft clear, professional progress updates for your team or stakeholders in seconds, saving you time on repetitive reporting.

Discover how Copilot helps you track overdue tasks and send effective follow-ups to keep projects on track.

See how Copilot can help you track performance indicators, spot bottlenecks, and provide clear summaries of project health.

Learn how Copilot helps you draft clear, professional project emails in Outlook with ease.

See how AI can streamline collaboration and improve communication across different teams.

Discover how Copilot helps you monitor project expenses and keep budgets on track in Excel.

Use Copilot to instantly create structured, professional project status reports in Word.

Here, we'll explore how to write prompts for text AI like ChatGPT, Claude, Copilot, etc.

Here, we'll explore how to write prompts for image-generating AI.

Learn how to structure digital marketing strategies using the RACE Framework: Reach, Act, Convert, and Engage.

Discover how the ReAct prompting framework enables AI to reason and act step-by-step for more accurate and contextual responses.

Explore the Tree of Thought method, which guides AI through branching decisions to improve problem-solving and planning.

This lesson explains how Chain-of-Thought prompting improves AI reasoning by encouraging step-by-step thinking, leading to more accurate results on complex tasks.

Understand how Self-Ask prompting encourages AI to generate and answer its own sub-questions for complex queries.

Learn the top reasons prompts fall short and get practical tips to craft more effective, agent-friendly instructions.

Understand how to assess AI responses using clear evaluation criteria like relevance, accuracy, and usefulness.

Learn the foundational language and key concepts that power generative AI technologies like ChatGPT.

Master advanced strategies to craft effective prompts that drive accurate, context-aware AI responses.

Explore powerful prompting frameworks like ReAct and Self-Ask to enhance reasoning and multi-step thinking in AI.

Deepen your prompt engineering skills with techniques for refining outputs and guiding complex AI behavior.

Discover and apply tools that let you test, compare, and optimize AI prompts for consistent results.

Learn specialized prompt techniques tailored for different industries, tasks, or creative use cases.

Explore the benefits of AI automation and understand how it can streamline business processes and boost efficiency.

Get an introductory tour of Microsoft Foundry, familiarizing yourself with its interface, key features, and navigation.

Task-based agents, conversational agents, data-driven agents, and workflow agents.

Foundry’s role in Microsoft’s AI ecosystem and how it differs from other AI platforms.

No-code approach vs custom development: benefits and limitations.

Models, agents, tools, data sources, workflows, and governance.

Conceptual explanation of visual builders, configuration panels, and prompts.

Step-by-step: create an agent that answers a set of FAQ questions. Configure the model and prompt using the UI, then save the agent.

In this lesson, we'll cover testing and iterating your agent.

In this lesson, we'll look through the templates that Microsoft Foundry provides.

Understand the difference between a single agent and a workflow of agents. Learn when to use multi-agent orchestration for complex tasks (e.g. separate agents for research, strategy, and execution).

Step-by-step: create a sequential workflow where Agent A’s output feeds into Agent B, then Agent C. For example, Agent 1 gathers data, Agent 2 summarizes it, Agent 3 generates a final report.

Learn how to add approval steps: the workflow pauses to ask the user a question or confirmation before proceeding (useful for quality checks or manual overrides).

Overview of advanced flows: you can route to different agents based on conditions or let agents collaborate in a group chat format. (This is useful for fallback or expert routing scenarios.)

Explore example applications (non-industry-specific): e.g. a support chatbot, an internal knowledge bot, or a scheduling assistant. See how Foundry’s features fit these scenarios.