Coding and Automation for Data Analysis with Generative AI

本课程是 Microsoft Generative AI for Data Analysis 专业证书的一部分

位教师： Microsoft

2,196 人已注册

包含在中

了解更多

5个模块

深入了解一个主题并学习基础知识。

11 条评论

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

5个模块

深入了解一个主题并学习基础知识。

11 条评论

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

23 项作业

授课语言：英语（English）

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

了解关于 Coursera for Business 的更多信息

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

积累 Data Analysis 领域的专业知识

本课程是 Microsoft Generative AI for Data Analysis 专业证书专项课程的一部分

在注册此课程时，您还会同时注册此专业证书。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 Microsoft 获得可共享的职业证书

该课程共有5个模块

This course teaches you to harness AI-powered tools for code generation, focusing on SQL, Python, and R for data analysis tasks. The target learner for this course is a seasoned data professional or an aspiring analyst. This comprehensive program empowers. The course covers the design and implementation of automated data processing pipelines, enabling you to streamline your entire data analysis workflow.

Lays the foundation for using generative AI in coding by introducing key concepts, tools, and techniques for effective code generation and prompt engineering.

涵盖的内容

11个视频8篇阅读材料4个作业

11个视频总计50分钟

The code whisperer: A data analyst's new best friend 2分钟
Demo: Code generation unveiled 5分钟
Real-world code generation: Use cases and lessons learned 6分钟
A day in the life of AI-powered data analysis 6分钟
The prompt whisperer's secret 2分钟
Explore the art of prompt engineering 5分钟
The data cleaning dynamo: AI to the rescue 2分钟
Simplifying data transformations with AI 5分钟
The human-AI tag team: Together, we code better 3分钟
Collaborating with AI: The key to code generation success 6分钟
Code comparison: Human vs. AI 6分钟

8篇阅读材料总计80分钟

Coding and Automation for Data Analysis with Generative AI syllabus 10分钟
GenAI Tools for Data Analysis: A Practical Guide 10分钟
The rise of generative AI in data analysis 10分钟
Code generation tools: A comparative guide 10分钟
Prompt engineering best practices: Your visual guide to communicating with AI 10分钟
The power of automation in data analysis 10分钟
Automation beyond the basics: Advanced applications of generative AI 10分钟
Evaluating generative AI: A visual guide to metrics and benchmarks 10分钟

4个作业总计75分钟

Introduction to code generation 15分钟
Prompt engineering for code generation 15分钟
Automating data tasks with generative AI 15分钟
Code generation fundamentals 30分钟

Explores the use of generative AI to automate and streamline the creation, customization, and implementation of formulas within various data analysis tools, focusing on enhancing efficiency and accuracy.

涵盖的内容

13个视频6篇阅读材料4个作业

13个视频总计64分钟

The case of the missing data: How formulas save the day 3分钟
Excel formula refresher: Your essential toolkit 7分钟
Everyday heroes: Excel formulas in action 3分钟
The AI formula whisperer: Your coding companion 3分钟
Generating formulas with AI 6分钟
The prompt is mightier than the formula 6分钟
Fine-tuning your AI formulas 6分钟
Generative AI and formula creation 6分钟
Supercharge your analysis: AI formulas in action 3分钟
How to use AI to create powerful Excel dashboards 6分钟
Unleashing AI's creative spark 3分钟
Beyond basic formulas: Unleashing AI's creative potential 6分钟
Building complex formulas with AI 6分钟

6篇阅读材料总计60分钟

Essential formulas for data analysis 10分钟
Level up your analysis: Advanced Excel formula techniques 10分钟
The future of formulas: AI's expanding role 10分钟
Optimizing tool performance with AI formulas 10分钟
The art of formula creation with AI 10分钟
Case studies: Complex formulas made easy with AI 10分钟

4个作业总计90分钟

Activity: Excel formula challenge 30分钟
Generative AI and formula creation 15分钟
Implementing AI-generated formulas 15分钟
Building formulas 30分钟

Expand your coding capabilities by leveraging generative AI for complex code snippets, debugging, and customization, addressing specific data analysis challenges.

涵盖的内容

12个视频6篇阅读材料4个作业1个讨论话题

12个视频总计52分钟

Unravel the mystery: Debugging AI-generated code 3分钟
Navigate common pitfalls in AI-generated code 6分钟
Demo: Error detection in practice: Using code editors and debugging tools 5分钟
The debugging toolkit: Equipping you for code success 2分钟
Demo: Debugging tools in action 5分钟
Debugging strategies for data analysts 5分钟
The quest for efficiency: Factors impacting AI-generated code performance 5分钟
Unlocking hidden performance boosts in AI models 5分钟
The AI coding dilemma: A debate 3分钟
Demo: Scale and accelerate coding tasks with generative AI 6分钟
Evaluating generative AI for coding 5分钟
The limitations of AI coding: Navigating the pitfalls 3分钟

6篇阅读材料总计60分钟

Troubleshooting AI-generated code 10分钟
Tackling complex errors in AI-generated code 10分钟
Debugging resources and communities: Your support network 10分钟
Prompt optimization techniques 10分钟
Measuring code efficiency: Key metrics and tools 10分钟
When to use (and not use) AI for coding 10分钟

4个作业总计75分钟

Troubleshooting AI-generated code 15分钟
Debugging strategies and tools 15分钟
Optimizing AI-generated code 15分钟
Advanced coding techniques 30分钟

1个讨论话题总计10分钟

Troubleshooting AI-generated code 10分钟

Guides learners in streamlining their data analysis workflows by identifying automation opportunities, integrating generative AI tools into coding environments, and automating key tasks like data cleaning, transformation, and visualization.

涵盖的内容

10个视频5篇阅读材料5个作业

10个视频总计43分钟

A data analysis journey from chaos to clarity 3分钟
Explore the data analysis life cycle 5分钟
The coder's unexpected ally 2分钟
Achieve seamless integration: Connect AI tools to your coding environment 5分钟
Integration adventures: Choosing the best path for your workflow 2分钟
The AI data cleanup crew 2分钟
Transform data with AI: Uncover hidden insights 6分钟
AI-powered visualization: From data to insights 5分钟
Measuring the impact of automation 6分钟
The automation skeptic 6分钟

5篇阅读材料总计50分钟

The automation mindset: Embracing AI for efficiency 10分钟
Choosing the right integration method 10分钟
Automation in action: Real-world success stories 10分钟
The return on investment with AI automation 10分钟
The future of data analysis automation: Trends and prediction 10分钟

5个作业总计105分钟

The data analysis life cycle and automation opportunities 15分钟
Integrating generative AI into coding environments 15分钟
Activity: Integrating GenAI into your coding environment 30分钟
Automating data processing tasks 15分钟
Automation and integration 30分钟

Solidify coding skills and enhance practical experience by applying generative AI in real-world data analysis projects, fostering collaboration and receiving valuable feedback to improve code quality and problem-solving abilities.

涵盖的内容

9个视频7篇阅读材料6个作业

9个视频总计45分钟

GenAI's data adventure: A journey through the AI landscape 3分钟
Demystifying generative AI: A glossary for data analysts 5分钟
Project walkthrough: Data cleaning and exploration with GenAI 5分钟
Project showcase: Predicting customer churn with generative AI 5分钟
Real-world applications of generative AI in data analysis 6分钟
The power of feedback: Excelling at code review 5分钟
Workflow design workshop: Crafting custom solutions with AI 5分钟
Demo: Building a workflow from scratch 5分钟
GenAI and the future of work 5分钟

7篇阅读材料总计70分钟

Generative AI for data analysts: A comprehensive guide 10分钟
The GenAI ecosystem: A vibrant network of models, tools, and platforms 10分钟
Generative AI case studies: Data analysis across industries 10分钟
Code review best practices: A guide to effective collaboration 10分钟
The ethics of AI-generated code 10分钟
Workflow optimization tips: A guide to efficiency 10分钟
Real-world workflow examples: Inspiration from industry leaders 10分钟

6个作业总计150分钟

Key concepts and terminology in generative AI for data analysis 15分钟
Practical applications of generative AI in data analysis 15分钟
Analyzing and improving AI-generated code 15分钟
Activity: Enhancing AI-generated code 30分钟
Project: Beyond the build: Critical reflection on workflow design 45分钟
Designing and automating workflows with GenAI 30分钟

获得职业证书

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

位教师

Microsoft

287 门课程 2,368,381 名学生

提供方

Microsoft

从 Data Analysis 浏览更多内容

Simplilearn
Data Analytics Course with Generative AI
课程
Microsoft
Microsoft Generative AI for Data Analysis
专业证书
IBM
Generative AI: Enhance your Data Analytics Career
课程
Microsoft
Data Processing and Optimization with Generative AI
课程

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

Felipe M.

自 2018开始学习的学生

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

Jennifer J.

自 2020开始学习的学生

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

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

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

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.