Excel and ChatGPT: Data Analysis Power Tips

Focused View

Chris Dutton

1:41:59

17 View

01 - Introduction

01 - The Future is now Intro to AI for data analytics.mp4

03:21

02 - Setting expectations.mp4

01:46

02 - 1. How AI is Revolutionizing Data Analysis

01 - Why AI is a game-changer for data analysis.mp4

03:58

02 - AI use cases for data analytics.mp4

01:32

03 - 2. A Crash Course in AI, LLMs, and ChatGPT

01 - The AI landscape.mp4

03:21

02 - Generative AI and large language models.mp4

04:35

03 - The road to ChatGPT.mp4

05:10

04 - Generative AI tools.mp4

01:58

05 - Warning Pitfalls of ChatGPT.mp4

02:56

06 - Accessing ChatGPT and Google Bard.mp4

01:21

04 - 3. Prompt Engineering Tips

01 - Intro to prompt engineering.mp4

01:53

02 - Prompt tip Be clear and specific.mp4

01:09

03 - Prompt tip Provide context.mp4

01:07

04 - Prompt tip Establish roles.mp4

00:54

05 - Prompt tip Set the tone.mp4

01:24

05 - 4. ChatGPT for Excel

01 - Intro to ChatGPT for Excel.mp4

01:43

02 - Explain fundamental Excel concepts.mp4

08:54

03 - Generate Excel formulas from descriptions.mp4

07:45

04 - Generate DAX and M Code.mp4

05:12

05 - Automate tasks with VBA macros.mp4

04:52

06 - Generate formulas from sample data.mp4

06:06

07 - Ask for Excel data visualization advice.mp4

04:53

08 - Produce step-by-step Excel tutorials.mp4

10:36

09 - Collaborate on data prep and EDA.mp4

06:40

10 - Generate sample datasets.mp4

05:14

06 - Conclusion

01 - Key takeaways and next steps.mp4

03:39

Description

Data analytics revolutionized the way we work, and now, with the rise of artificial intelligence, data professionals have access to tools that let them work smarter and faster than ever before. In this beginner-friendly course, instructor Chris Dutton shows you have to leverage tools like Excel and ChatGPT together to work more efficiently and make smarter, data-driven decisions. Chris and the Maven Analytics team discuss how AI is revolutionizing data analysis, introduce the art of prompt engineering, review tips and best practices for generating consistent accurate model outputs, and address common limitations and pitfalls. Throughout the course you’ll learn some of the most powerful ChatGPT use cases for data science and analytics, and get hands-on practice using ChatGPT to explain and interpret code, generate formulas, troubleshoot errors, optimize complex queries, and much more.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Artificial Intelligence

Data Analysis

Excel

Chris Dutton

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.