Your AI Coding Agent Can Now Build and Manage Dataverse — Here’s How

The way enterprise software gets built is changing fast. Rather than manually piecing together APIs, command-line tools, and custom scripts, developers are increasingly turning to AI agents — describing what they need and letting the agent figure out the execution. But for that shift to work with platforms like Microsoft Dataverse, the platform itself needs to be something agents can actually understand and operate.

That’s exactly what Dataverse Skills delivers. Released as an open-source plugin for GitHub Copilot and Claude Code, Dataverse Skills gives AI coding agents deep, practical knowledge of Dataverse — from connecting and authenticating to building schemas, loading data, and running analytical queries. All of it driven by natural language.

What Are Dataverse Skills, Really?

At its core, Dataverse Skills is a plugin that teaches your coding agent how to work with Dataverse. It doesn’t expose a menu of commands for you to choose from. Instead, you describe your goal in plain English, and the agent decides which skills to apply, in what sequence, using which underlying tools.

Think of it as giving your AI agent a domain expert’s knowledge of Dataverse — without you needing to be that expert yourself.

The underlying engine uses the Power Platform CLI (PAC CLI) for authentication, solution management, and automation tasks, paired with the Dataverse Web API and Python SDK for data operations. But you never have to think about any of that. Natural language is the only interface you need.

Three Phases, One Unified Experience

The plugin’s capabilities are organized around three core phases of any Dataverse project:

1. Connect

The agent discovers your Dataverse environments, authenticates using PAC CLI or Azure CLI, registers the Dataverse MCP server, and sets up a consistent project structure. You don’t configure anything manually — the agent handles the entire discovery and initialization process.

2. Build

Once connected, the agent can scaffold full data models from scratch: tables, columns, choice fields, lookup relationships, many-to-many relationships, forms, and views. It picks the right tool for each task — MCP for quick reads, the Python SDK for bulk operations, and the Web API as needed — and registers every component into your solution automatically.

3. Operate

With the schema in place, the agent can load data, run cross-table analytical queries, and bulk-import records from CSV files. Need 50 realistic sample records with domain-specific content generated on the fly? One prompt is all it takes.

Seeing It in Action

Here’s a real example of what this looks like in practice. You open your terminal, install the plugin with a single command, and type:

“I’m building a logistics and inventory management system for Veloce Apparel. I need tables for Warehouses, Products, Suppliers, Shipments, and Incidents — with lookups, a many-to-many between Products and Suppliers, and a self-referential shipment routing chain (tracking a package’s journey through hub transfers). Create everything in a VeloceLogistics solution, load sample data, and show me which shipments are currently delayed or stuck in transit.”

From that single prompt, the agent autonomously:

  1. Discovers your Dataverse environment and configures MCP
  2. Creates the solution using PAC CLI
  3. Builds five tables with choice columns, lookups, and a many-to-many relationship
  4. Generates and runs a Python script to bulk-load realistic sample data
  5. Queries across tables to answer the business question

No toggling between documentation tabs. No manual CLI commands. No context switching. The agent orchestrates everything from end to end.

Works With Both GitHub Copilot and Claude Code

Development teams rarely standardize on a single AI coding tool. Some developers prefer GitHub Copilot; others work with Claude Code. Dataverse Skills was built with this reality in mind. Since the skills are written as plain Markdown files with YAML frontmatter — not compiled binaries or proprietary formats — the same plugin works identically in both environments.

Install it from the plugin marketplace for either agent and you get the same knowledge, the same safety checks, and the same results. One investment, both tools covered.

Open Source and Built to Extend

The project is MIT-licensed and openly available on GitHub. Each skill is a standalone Markdown file — readable, editable, and extensible without any compiled code. Teams can add new skills for their own Dataverse customizations, improve existing ones, or contribute bug fixes back via pull request. The architecture is deliberately approachable for anyone who wants to tailor it to their environment.

A Broader Shift in How Platforms Get Used

Dataverse Skills is more than a productivity tool — it signals a broader direction for enterprise platforms. As AI agents become a standard part of the developer workflow, the platforms they interact with need to be operable through intent, not just through traditional interfaces. Describing what you want and having it built, configured, and queryable in your environment is no longer a future concept. With Dataverse Skills, it’s available today.

Getting Started

Install the plugin with one command:

  • GitHub Copilot (VS Code): /plugin install dataverse@awesome-copilot
  • Claude Code: /plugin install dataverse@claude-plugins-official

Then describe your intent and let the agent do the rest.

Original article: Dataverse Skills: Your Coding Agent Now Speaks Dataverse by Suyash Kshirsagar, Microsoft.

Statistics and Data Analysis Terminnologies-I

Variance

Variance in mathematics is a measure of how spread out the values in a set of data are. It quantifies the average squared deviation of each data point from the mean (average) of the dataset. In simpler terms, it tells us how far individual data points are from the center of the data.

The formula for variance is:

Where:

Higher variance means the data points are more spread out, while lower variance indicates they are closer to the mean.

Standard Deviation

Standard deviation tells us how much data points tend to deviate from the mean on average. A small standard deviation indicates that the data points are clustered closely around the mean, whereas a large standard deviation shows that the data points are spread out.

Example

Alright, let’s walk through an example to make the concept of standard deviation clearer!

Imagine you have the test scores of five students in a math exam: 80, 85, 90, 95, and 100. Here’s how we calculate the standard deviation step by step:

Step 1: Find the Mean

The mean ((\mu)) is the average of the data:
$$\mu = \frac{80 + 85 + 90 + 95 + 100}{5} = 90$$

Step 2: Calculate Deviations from the Mean

Subtract the mean from each score to find the deviations:

  • (80 – 90 = -10)
  • (85 – 90 = -5)
  • (90 – 90 = 0)
  • (95 – 90 = 5)
  • (100 – 90 = 10)

Step 3: Square Each Deviation

Square the deviations to eliminate negative values:


Step 4: Find the Average of the Squared Deviations

Add up the squared deviations and divide by the total number of data points ((n = 5)):
$$\text{Variance} (\sigma^2) = \frac{100 + 25 + 0 + 25 + 100}{5} = 50$$

Step 5: Take the Square Root of the Variance

The square root of the variance gives us the standard deviation:
$$\sigma = \sqrt{50} \approx 7.07$$

Final Result:

The standard deviation is approximately 7.07. This means that, on average, the test scores deviate from the mean by about 7.07 points.

Now, with this example, you see how the standard deviation helps visualize the spread of scores

Moving Averages

The moving averages method is a statistical technique used to analyze time-series data by smoothing out short-term fluctuations and highlighting trends or patterns over time. It’s often applied in fields like finance, economics, and sales forecasting.

Here’s how it works:

  1. Determine the Window: Choose the number of data points (known as the “window”) you want to consider for calculating the average. For example, you might decide on a 3-month or 5-day moving average.
  2. Calculate the Average: For each period, calculate the average of the chosen number of data points. This average is the moving average for that period.
  3. Shift the Window: Move the window one period forward (e.g., from days 1–5 to days 2–6) and calculate the next average.
  4. Repeat: Continue shifting the window and calculating averages across the entire dataset.

The result is a new series of data (the moving averages), which smooths out random variations in the original data, allowing you to better understand trends.

There are different types of moving averages:

  • Simple Moving Average (SMA): Equal weight is given to all data points in the window.
  • Weighted Moving Average (WMA): More weight is given to recent data points.
  • Exponential Moving Average (EMA): Uses a formula to give progressively more weight to recent data points.
sample c# code for moving averages
// Simple moving average calculation 
double[] data = { 10, 12, 14, 16, 18, 20, 22, 24, 26, 28 }; 
int windowSize = 3; 
double[] movingAverages = new double[data.Length - windowSize + 1]; 
for (int i = 0; i < movingAverages.Length; i++) { 
              movingAverages[i] = data.Skip(i).Take(windowSize).Average(); 
} 
Console.WriteLine("Moving Averages: " + string.Join(", ", movingAverages));
Explanation

Sure! Let me break down the code for you step by step:

Purpose

This code calculates the Simple Moving Average (SMA) of an array of numbers, given a specified window size.


Variables and Initialization

  1. double[] data:
    This array holds the input data (in this case, {10, 12, 14, 16, 18, 20, 22, 24, 26, 28}), which represents a time-series or sequential dataset.
  2. int windowSize:
    This is the size of the moving average window, set to 3. It determines how many consecutive numbers are used to calculate each average.
  3. double[] movingAverages:
    This array will store the computed moving averages. Its length is:
    $$\text{Length of data array} – \text{windowSize} + 1$$
    This ensures that the moving average calculation stops when the remaining data is insufficient to fill the window.

Loop Logic

The for loop iterates through the data array to calculate the moving averages:

  1. Iteration:
    The loop runs from i = 0 to i < movingAverages.Length. During each iteration, it computes the average of a specific slice (sub-array) of the input data.
  2. data.Skip(i).Take(windowSize):
  • Skip(i): Skips the first i elements of the data array.
  • Take(windowSize): Takes the next windowSize elements starting from the current position.
    For example:
  • At i = 0: Takes {10, 12, 14}
  • At i = 1: Takes {12, 14, 16}
  • At i = 2: Takes {14, 16, 18}, and so on.
  1. .Average():
    Computes the average of the selected windowSize elements and stores it in the movingAverages[i] array.

Output

After the loop finishes, all the calculated moving averages are stored in the movingAverages array. Finally, the code prints them using:

Console.WriteLine("Moving Averages: " + string.Join(", ", movingAverages));

This will output the moving averages as a comma-separated list.


Example

For the given data array and windowSize = 3:

  • Moving average for {10, 12, 14} = ((10 + 12 + 14) / 3 = 12)
  • Moving average for {12, 14, 16} = ((12 + 14 + 16) / 3 = 14)
  • Moving average for {14, 16, 18} = ((14 + 16 + 18) / 3 = 16)
  • And so on.

The final output will be:

Moving Averages: 12, 14, 16, 18, 20, 22, 24, 26

The Skip(i) function is used to shift the starting position of the window when calculating moving averages. Here’s why it’s necessary:

  • In the first iteration (i = 0), we want to start the window at the beginning of the data array, which includes the first three elements (e.g., {10, 12, 14}).
  • In the next iteration (i = 1), we want the window to move forward by one position, so it starts at the second element and includes the next three elements (e.g., {12, 14, 16}).
  • This shifting process continues for each subsequent iteration, ensuring that each moving average is calculated using the right set of consecutive numbers.

Without Skip(i), the function would always start from the beginning of the array, and you’d end up calculating the same average repeatedly instead of progressively shifting the window. By skipping i elements, the window moves forward as intended, covering all possible sets of data points.

In the first iteration ((i = 0)), nothing is skipped because (Skip(0)) means “skip zero elements”—essentially, it starts at the beginning of the array, so it includes 10, 12, and 14 as intended.

The confusion might stem from interpreting Skip(i) too literally. Here’s what happens step by step:

  • At (i = 0), data.Skip(0) takes the array as-is (no skipping), so it starts with {10, 12, 14}.
  • At (i = 1), data.Skip(1) skips the first element (10), resulting in {12, 14, 16} being taken.
  • At (i = 2), data.Skip(2) skips the first two elements (10, 12), resulting in {14, 16, 18} being taken.

The Skip(i) ensures the window shifts correctly as the loop progresses. But in the first iteration, nothing is skipped, and 10 is included in the moving average calculation.

Convolution

What is Convolution?

Convolution is a mathematical operation that combines two sequences (arrays) to produce a new sequence. It essentially slides one sequence (called the “kernel” or “filter”) across another sequence (the “input data”) and calculates weighted sums at each step.

Simple Example

Let’s use a very basic case:

Input Data:

Imagine you have the sequence:

Kernel (Filter):

The kernel is a smaller sequence:

How Convolution Works:

The kernel slides across the input data. At each position, we multiply the kernel values by the corresponding input values and sum them up.


Step-by-Step Calculation

Step 1: First Position

Align the kernel with the first three values of the input:
[ [1, 2, 3] ]
Multiply each input value by the corresponding kernel value:

So, the first result is -2.


Step 2: Second Position

Move the kernel one step to the right:
[ [2, 3, 4] ]
Multiply and sum:

The second result is -2.


Step 3: Third Position

Move the kernel again:
[ [3, 4, 5] ]
Multiply and sum:

The third result is -2.


Final Result:

The output of the convolution is:
[ [-2, -2, -2] ]


Why Is This Useful?

Convolution is used in many fields:

  • Moving Averages: To smooth data or detect trends.
  • Image Processing: To apply filters like blurring or edge detection.
  • Machine Learning: In convolutional neural networks for feature extraction.

Basics of Machine Learning

What is a scalar ?

A scalar is also called a zero Dimensional Array . any single number or value is a scalar
example:

Weight: 70 kg

Temperature: 36.6°C

what is a vector ?

A vector is a 1-D array or an array which in most progrmming languages is written as [1,3,4,5]
For example:

A 3D point in space: [2, 5, 7] (x, y, z coordinates)

what is a matrix ?

A matrix is a 2-D array . i.e for e.g a table with rows and columns is a 2D array . It is also called an array inside an array i.e [ [ 1,2,3,4],[7,8,4,3] ]
A matrix is organized in rows and columns. It’s like a grid where each entry corresponds to a specific row and column. For instance:

3D Array..NDarray

A 3D array adds another dimension to the grid. Imagine stacking multiple 2D arrays like slices in a cube. .The same concept applies to higher order arrays like 4D , 5 D arrays . i.e a 4D array is nothing but stacked 3D arrays . Refer to the other blog also about array indexing How elements are indexed in a 3Dimensional array
For instance: the following is the example of a 3D array.
import numpy as np

# Create a 3D array
array = np.array([[[1, 2, 3],
[4, 5, 6]],
[[7, 8, 9],
[10, 11, 12]]])

# Access element at index (1, 0, 2)
element = array[1, 0, 2] # Result: 9
print(element)
# prints 9

How elements are indexed in a 3Dimensional array

In a 3D array, elements are organized in three dimensions, and their positions are specified using three indices, typically written as [i][j][k] or (i, j, k). Here’s a breakdown:

How Indexing Works:

This hierarchy lets you pinpoint any element in the 3D array.

How Indexing Works:

  1. First Dimension (i):
  • Determines which “block” or “layer” of the array you’re accessing.
  • Think of it as choosing a specific 2D “sheet” within the 3D array.
  1. Second Dimension (j):
  • Specifies the “row” within the selected 2D sheet.
  1. Third Dimension (k):
  • Points to the “column” within the chosen row.

This hierarchy lets you pinpoint any element in the 3D array.

Example:

Imagine a 3D array as a stack of 2D grids:

Layer 0:
[[1, 2, 3],
 [4, 5, 6]]

Layer 1:
[[7, 8, 9],
 [10, 11, 12]]
  • To access the number 9, you’d use indices [1][0][2]:
  • 1: Select the second layer (index 1 because indexing starts at 0).
  • 0: Within that layer, pick the first row.
  • 2: Then, take the third element in that row.

In Code (Using NumPy):

import numpy as np

# Create a 3D array
array = np.array([[[1, 2, 3], [4, 5, 6]],
                  [[7, 8, 9], [10, 11, 12]]])

# Access element 9
element = array[1, 0, 2]
print(element)  # Output: 9

This structure makes it easy to navigate, slice, and manipulate data in three-dimensional space.