Microsoft

Microsoft Data Analysis with SQL, Excel & Power BI Specialization

Microsoft

Microsoft Data Analysis with SQL, Excel & Power BI Specialization

Build Data Analysis Skills with Microsoft.

Learn SQL, Excel, and Power BI to analyze data and create actionable insights.

 Microsoft

Instructor: Microsoft

Included with Coursera Plus

Get in-depth knowledge of a subject
Beginner level

Recommended experience

5 months to complete
at 7 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
Beginner level

Recommended experience

5 months to complete
at 7 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Write SQL queries to retrieve, filter, and transform data from relational databases.

  • Analyze and organize datasets in Excel using formulas, functions, and data analysis tools.

  • Create interactive dashboards and visual reports using Microsoft Power BI.

  • Combine SQL, Excel, and Power BI to analyze data and communicate insights effectively.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

May 2026

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Microsoft

Specialization - 5 course series

SQL Foundations

SQL Foundations

Course 1, 22 hours

What you'll learn

  • Write SQL queries using SELECT, WHERE, ORDER BY, and built-in SQL functions to retrieve and analyze data

  • Understand relational database concepts including schemas, tables, views, and structured data organization

  • Use Microsoft SQL Server Management Studio to create, filter, sort, and transform data efficiently

  • Apply generative AI tools to support SQL query writing, debugging, and data analysis workflows

Skills you'll gain

Category: SQL
Category: Data Transformation
Category: Relational Databases
Category: GitHub Copilot
Category: Database Management
Category: Microsoft SQL Servers
Category: Generative AI
Category: Database Design
Category: Databases
Category: Data Manipulation
Category: Query Languages
Category: Data Analysis
Category: Transact-SQL
Category: Database Management Systems
Data Manipulation and Transactions in SQL Server

Data Manipulation and Transactions in SQL Server

Course 2, 15 hours

What you'll learn

  • Use INSERT, UPDATE, and DELETE statements to modify and manage data in SQL Server databases

  • Implement transaction management techniques to maintain database consistency and integrity

  • Apply ACID principles, isolation levels, and error handling strategies to prevent concurrency issues

  • Use generative AI tools to optimize SQL operations and troubleshoot transaction-related problems

Skills you'll gain

Category: Transaction Processing
Category: Data Manipulation
Category: Data Integrity
Category: Database Management
Category: Generative AI
Category: SQL
Category: AI Integrations
Category: Microsoft SQL Servers
Category: Relational Databases
Category: Database Theory
Category: Data Access
Category: Performance Tuning
Data Cleaning & Processing with Copilot in Excel

Data Cleaning & Processing with Copilot in Excel

Course 3, 19 hours

What you'll learn

  • Identify and address common data errors using Copilot in Excel.

  • Apply comprehensive data cleaning techniques to prepare datasets for analysis.

  • Manipulate and transform data efficiently with Copilot.

  • Implement data organization strategies for improved analysis readiness.

Skills you'll gain

Category: Microsoft Copilot
Category: Data Cleansing
Category: Prompt Engineering
Category: Data Manipulation
Category: Microsoft Excel
Category: Data Analysis
Category: Data-Driven Decision-Making
Category: Data Integrity
Category: Data Transformation

What you'll learn

  • Perform comprehensive data analysis and integrate external data sources using Excel Copilot.

  • Apply advanced formulas, conditional formatting, and data visualization techniques, including PivotCharts, to uncover key insights.

  • Develop and optimize Copilot prompts to streamline data analysis workflows.

  • Create detailed reports that summarize findings and visualizations for effective data-driven decision-making.

Skills you'll gain

Category: Microsoft Copilot
Category: Data Visualization Software
Category: Pivot Tables And Charts
Category: Statistical Analysis
Category: Data Presentation
Category: Data Analysis
Category: Data Integration
Category: Data-Driven Decision-Making
Category: Microsoft Excel
Category: Excel Formulas
Category: Data Compilation
Category: Data Storytelling
Category: Statistics
Category: Statistical Visualization
Category: Data Visualization
Category: Prompt Engineering
Category: Statistical Methods
Category: Data Synthesis
Category: Spreadsheet Software
Data Analysis and Visualization with Power BI

Data Analysis and Visualization with Power BI

Course 5, 27 hours

What you'll learn

  • How to add visualizations to reports and dashboards.

  • How to design accessible reports and dashboards.

  • How to use visualizations to perform data analysis.

Skills you'll gain

Category: Power BI
Category: Data Visualization Software
Category: Dashboard Creation
Category: Interactive Data Visualization
Category: Data Analysis
Category: Dashboard
Category: Web Content Accessibility Guidelines
Category: Statistical Analysis
Category: Statistical Reporting
Category: Data-Driven Decision-Making
Category: Data Visualization
Category: Data Storytelling
Category: Database Design
Category: Analytics
Category: Microsoft Power Platform
Category: Advanced Analytics
Category: Analysis
Category: Data Presentation
Category: Descriptive Statistics
Category: Statistical Visualization

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

 Microsoft
326 Courses2,565,441 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions