Microsoft

Microsoft Data Analysis with SQL, Excel & Power BI 专项课程

Microsoft

Microsoft Data Analysis with SQL, Excel & Power BI 专项课程

Build Data Analysis Skills with Microsoft.

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

 Microsoft

位教师: Microsoft

包含在 Coursera Plus

深入学习学科知识
初级 等级

推荐体验

5 月 完成
在 7 小时 一周
灵活的计划
自行安排学习进度
深入学习学科知识
初级 等级

推荐体验

5 月 完成
在 7 小时 一周
灵活的计划
自行安排学习进度

您将学到什么

  • 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.

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言:英语(English)
最近已更新!

May 2026

91% of learners achieved a positive career outcome

了解顶级公司的员工如何掌握热门技能

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

精进特定领域的专业知识

  • 向大学和行业专家学习热门技能
  • 借助实践项目精通一门科目或一个工具
  • 培养对关键概念的深入理解
  • 通过 Microsoft 获得职业证书

专业化 - 5门课程系列

SQL Foundations

SQL Foundations

第 1 门课程, 小时

您将学到什么

  • 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

Data Manipulation and Transactions in SQL Server

Data Manipulation and Transactions in SQL Server

第 2 门课程, 小时

您将学到什么

  • 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

Data Cleaning & Processing with Copilot in Excel

Data Cleaning & Processing with Copilot in Excel

第 3 门课程, 小时

您将学到什么

  • 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.

Advanced Data Analysis & Visualization with Copilot in Excel

Advanced Data Analysis & Visualization with Copilot in Excel

第 4 门课程, 小时

您将学到什么

  • 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.

Data Analysis and Visualization with Power BI

Data Analysis and Visualization with Power BI

第 5 门课程, 小时

您将学到什么

  • How to add visualizations to reports and dashboards.

  • How to design accessible reports and dashboards.

  • How to use visualizations to perform data analysis.

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

 Microsoft
312 门课程2,549,932 名学生

提供方

Microsoft

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情,我就可以学习。'

Jennifer J.

自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程,Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好:它远不止于此。Coursera 让我无限制地学习。'

常见问题