Microsoft Scenario Library Information Technology Build analytics within Fabric

Available with: Azure AI Foundry and Power BI

Information Technology scenario: Build analytics within Fabric

Back to Information Technology Scenarios Download scenario guide

Scenario

Simplify creation of database analytics

1. Building data pipeline

The admin plans to create a separate DataFlow Gen2 pipeline by modifying the M Query to include a loop for multi-day data ingestion, serving as a backfill when daily tasks fail.

Microsoft Fabric icon

Copilot in Microsoft Fabric

Sample Prompt: Rewrite this M query by changing the relative date ‘yesterday’ to accept the ‘startDate’ and ‘endDate’ parameters in the string format of “MM/dd/yyyy”. Make sure to process in loop one day at a time as the original.

As there are multiple tables in the Lakehouse, the admin needs help to create complex custom SQL query. They decided to use the AI Skill help building the query.

Microsoft Fabric icon

Copilot in Microsoft Fabric

Sample Prompt: How many users are there with the Action Level 2 of CreateNewPublication during the last 30 days and 31-60 days ago? Separate them into two different columns. Please break down them by Profession and rank them from the most to the least users.

The admin wants to simplify the report by reducing the number of rows through grouping similar records together.

Microsoft Fabric icon

Copilot in Microsoft Fabric

Sample Prompt: Under the Profession column, I want to combine Product Management and Program Management as Product Management. Then group them together by Profession and apply sum to the other two columns.

While building the report in Power BI, the admin wants to emphasize the area of the data showing the highest Month Over Month growth.

Power BI icon

Copilot in Power BI

Sample Prompt: Which profession had the highest increase in the product usage this month?

The admin determines which group saw the largest decline in publication activity and analyze how changes in the product usage might impact those users.

Power BI icon

Copilot in Power BI

Sample Prompt: Which profession saw the most significant decline in publication activity? And what could be the potential impact of the increase/decrease in the product usage for those with the most significant decline?

The admin wants to create interactive experience and allows anyone with access to the report to ask questions to the data within the report.

Power BI icon

Copilot in Power BI

Sample Prompt: Publication creator MOMs with profession Business Operations or Design & Creative

KPIs

Opportunity to impact key functional area KPIs

How Microsoft Copilot can help improve budget variance

Keep your budgets on track by improving employee and process efficiency.
Create internal feedback loop to identify cost saving areas:
  • Draft employee surveys focused on the value of resources utilized and ideas for cost savings
  • Analyze surveys to gain valuable insights into what makes employees happy or areas that need improvement within the organization

How Microsoft Copilot can help improve app usage rates

Create great onboarding experiences and collect and analyze feedback to improve user experiences
Create onboarding materials:
  • Use Copilot to draft training guides
  • Use Copilot to enhance employee handbooks
  • Generate news and announcements

How Microsoft Copilot can help improve the product adoption rate

Create great onboarding experiences and collect and analyze feedback to improve user experiences.
Create onboarding materials:
  • Use Copilot to draft training guides
  • Use Copilot to enhance employee handbooks
  • Generate news and announcements

How Microsoft Copilot can help improve NPS

Real-time AI assistance for faster issue resolution allows agents to focus on delivering high-quality service.
Incorporate feedback:
  • Rapidly analyze customer feedback
  • Quickly create recommendations
  • Swiftly update scripts and processes
  • Create communications to socialize the changes

How Microsoft Copilot can help reduce costs

Use the time savings gained from Copilot to bring activities in-house and reduce reliance on external resources.
Create internal feedback loop to identify cost saving areas:
  • Draft employee surveys focused value of resources utilized and ideas for cost savings
  • Analyze surveys to gain valuable insights into what makes employees happy or areas that need improvement within the organization

How Microsoft Copilot can help optimize service outage response

Copilot helps you work to get your services back up and running and maximize user satisfaction.
Respond to user complaint or inquiry:
  • Respond quickly to inbound emails
  • Access customer records for improved support
  • Gets answer fast by searching internal sites and documents

How Microsoft Copilot can help reduce average support ticket resolution time

Microsoft Copilot enhances customer support by integrating AI assistance into self-service and service desk workflows.
Increase support communications and follow up efficiency:
  • Have Copilot assist with emails inbound and outbound emails
  • Draft email comms and announcements with Copilot
  • Generate meeting notes and follow up items

The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.