In the age of AI-powered productivity, Copilot Notebook stands out as a powerful tool that blends natural language understanding with code execution and data visualization.
Whether you’re a data analyst, student, researcher, or curious explorer, Copilot Notebook helps you turn ideas into insights—without needing to write complex code from scratch.
The following article takes you through Copilot Notebook feature which began rolling out on May 2025, with some hands-on examples.
What Is Copilot Notebook?

Copilot Notebook is an interactive environment where you can:
- Ask questions or give instructions in plain English.
- Automatically generate and run Python code.
- Analyse data, create visualizations, and explore trends.
- Iterate and refine your analysis with AI assistance.
Think of it as a smart assistant that understands both your words and your data.
How to Use Copilot Notebook?

Start with a Prompt
You don’t need to know programming. Just describe what you want:
- “Plot the average sales per category from this dataset.”
- “Find the month with the highest revenue.”
- “Compare sales trends for Electronics and Clothing.”
Upload Your Data
You can upload files like:
- CSV or Excel for data analysis.
- Images for processing.
- Text files for natural language tasks.
Let Copilot Do the Work
Copilot will:
- Interpret your prompt.
- Generate Python code.
- Execute the code and show results (charts, tables, summaries).
You can ask follow-up questions like:
- “Add labels to the chart.”
- “Export the results to a CSV file.”
- “Explain what this regression output means.”
Iterate and Explore
The real power of Copilot Notebook is in its interactivity. You can:
- Refine your analysis.
- Try different visualizations.
- Ask for explanations or summaries.
Try It Yourself
Example Use Case
Let’s say you want to analyse monthly sales data.
You could download the following csv file: copilot_notebook_monthly_sales_data.csv containing sample data.
Note: If you are using the sample file, make sure it is available in your one drive.
Create Copilot Notebook
Go to the Notebooks feature and click Create Copilot Notebook.

Specify the Notebook name, Add reference and click Create.

Prompt Examples
Now you are ready to perform various actions, for example:
📈 Basic Descriptive Analysis
- “Show the total sales per category.”
- “Calculate the average monthly sales for each category.”
- “Find the month with the highest total sales.”
- “Display the top 5 months with the highest sales overall.” “Show the distribution of sales values.”

📊 Visualizations
- “Plot a bar chart of average sales by category.”
- “Create a line chart showing monthly sales trends for each category.”
- “Generate a pie chart of total sales by category.”
- “Visualize sales trends over time for Electronics.”
- “Create a stacked bar chart comparing monthly sales across categories.”

📉 Comparative Analysis
- “Compare sales between Electronics and Clothing.”
- “Which category had the most consistent sales over the year?”
- “Show the percentage change in sales month-over-month for each category.”
- “Rank categories by average monthly sales.”

📅 Time Series Analysis
- “Plot monthly sales trends for all categories.”
- “Identify seasonal patterns in sales.”
- “Forecast next month’s sales using a simple model.”
- “Highlight months with above-average sales.”

📊 Statistical Analysis
- “Calculate the standard deviation of sales for each category.”
- “Find the correlation between sales of different categories.”
- “Perform a regression analysis to predict sales based on month.”
- “Test if the difference in average sales between categories is statistically significant.”

📦 Category-Specific Insights
- “Show sales trends for Home & Kitchen.”
- “Which category had the highest sales in June?”
- “Compare quarterly sales for Toys.”

📁 Data Cleaning & Transformation
- “Check for missing values in the dataset.”
- “Normalize the sales data.”
- “Convert month names to datetime format.”
- “Add a column for quarterly grouping.”

📤 Export & Sharing
- “Export the cleaned dataset to a new CSV file.”
- “Save the chart as a PNG image.”
- “Create a summary report of sales performance.”

—
So, Why Use Copilot Notebook?
- No coding required (but you can edit code if you want).
- Fast insights from raw data.
- Flexible and interactive—perfect for brainstorming, reporting, or learning.
- Visual storytelling with charts and summaries.
>> Enjoy Co-piloting…😊































































