Microsoft Copilot for Data Analysis and Data Visualization

Explore cleaning a real-world csv dataset with Copilot, profile data by column, fix missing values and invalid formats, and generate a cleaned, analysis-ready dataset.

Explore a synthetic, Copilot-generated employee dataset to practice data visualization. The lecture highlights key columns, calculated fields, and how Copilot-generated formulas enable exploratory data analysis.

Perform exploratory data analysis with Copilot, cleansing and understanding your dataset before creating dashboards for executives. Upload structured files, uncover insights, and plan visuals like workforce composition and retention trends.

Create Python code with Copilot to load an Excel dataset, clean it, and generate 15 charts including demographics, performance, pay, and retention, saved as PNG files in charts.

Explore the M365 Copilot interface, licensing, and admin settings, then attach cloud files from OneDrive or SharePoint, and generate charts with Python in Excel while respecting enterprise data protection.

Explore how M365 Copilot analyzes a real-world CSV dataset, profiles data quality, detects anomalies, and guides data cleaning and validation for analytics.

Generate visuals from the orders file in the M365 Copilot chat using Python and pandas to plot the sales trend, category performance, and regional distribution, and explore dashboards.

Explore how the analyst agent in M365 Copilot analyzes a linked orders dataset, computes correlations, visualizes with heatmaps, and forecasts sales using exponential smoothing with monthly seasonality.

Leverage the analyst agent to automatically generate 10–15 visualizations from your data, using Python and pandas with plotting libraries, and deliver a ready-to-present PowerPoint deck.

Demonstrate how Copilot performs a data quality check inside Excel, identifying missing values, duplicates, data types, and validity of dates, with Python code and a summarized data frame.

Use Copilot in Excel to generate pivot tables from a formatted data table, showing department, job title, active status, location, and the average base salary, with filtering and basic visualizations.

Explore conditional formatting and data bars in Excel with Copilot, applying rules such as greater than, between, text contains, and color scales to highlight inactive status and visualize base salaries.

Generate visuals from pivot-powered data in Excel, including a histogram of base salary, a department bar chart, and a years-of-service versus bonus scatter plot, with data cleaned to numeric types.

Excel Copilot uses Python to analyze an HR dataset, producing statistics, visuals, and ML models (logistic regression, random forest, gradient boosting) to explore attrition and department trends.

Explore advanced visualizations with Python and Copilot in Excel, including gender distribution, department headcount, age distribution, salary distribution by department, and bonus versus engagement plots.

Explore Microsoft Fabric, an enterprise analytics platform that unifies data ingestion, data warehousing, lakehouses, real-time analytics, governance, and Copilot-assisted SQL and visualization in one environment.

Explore the Microsoft Fabric interface, from workspaces and lakehouses to notebooks and data pipelines, and see how Copilot assists with data analysis and visualization.

Explore how Microsoft Fabric pricing works, including 60-day trials, Copilot availability, and paid Fabric capacity setup via Azure portal, with tips to manage costs.

Explore ETL flows in fabric, from extracting data from databases, flat files, or Excel to loading into SQL databases, warehouses, or lake house, with semantic models feeding Power BI dashboards.

Prepare your data for AI in Power BI to improve Copilot responses with a grounded semantic data model. Use AI data schema, verified answers, and AI instructions to guide Copilot.

Prepare data for AI by simplifying the data schema in Power BI with Copilot. Deselect nonessential fields and name data elements clearly to boost Copilot's semantic model insights.

Set up verified answers in Power BI by linking common questions to saved visuals via the semantic model, so Copilot chat returns the appropriate visual and insights.

Publish your report to the Power BI service, access the semantic data model, and prep data for AI using verified answers to improve Copilot insights.

See how Copilot accelerates dax development in Power BI by generating and explaining dax measures, and updating the data model with total revenue, average sales, and ebitda.

Generate and refine DAX measures with Copilot to update your data model and create year-to-date revenue and sales amount per manufacturer.

Copilot helps generate descriptions for measures in the semantic model view, enabling metadata documentation and visible descriptions in Power BI service.

Mark the model as prepped for AI in Power BI service after creating DAX measures and descriptions to avoid friction warnings and ensure Copilot delivers quality answers within 24 hours.

Create dynamic visuals in Power BI Desktop with Copilot prompts, answer questions about your semantic data model, and auto-generate comprehensive report pages with DAX queries.

Learn to generate executive summaries in Power BI using Copilot and the narrative visual, auto-creating concise, bullet-point insights on revenue, EBITDA, and sales trends for senior leadership.

Use Copilot in Power BI service to ask questions about reports, generate executive summaries, and uncover insights by filtering visuals and exploring the semantic model.

Set up a Power BI service subscription to auto deliver a report with a Copilot summary at a chosen cadence, delivering as PDF or full report via email or OneDrive.

Leverage Copilot in Word to generate executive summaries from Excel data and Power BI dashboards, pulling insights from OneDrive or SharePoint files for a concise one-page briefing.

Learn to generate a PowerPoint deck with Copilot from Excel or Word files in your organization, choose a template, and tailor slides to deliver key insights for senior management.

Embed live Power BI dashboards in PowerPoint slides using the Power BI add-in to deliver interactive visuals with automatic refresh, replacing static images.