Introduction To Analyzing Data With Chatgpt
Published 12/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.04 GB | Duration: 2h 35m

Learn the most powerful way to ANALYZE DATA with ChatGPT using simple questions–no complex formulas or coding

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video

Learn the incredible power of ChatGPT to analyze data and answer questions that are in a plain format

Learn to analyze and aggregate your data with simple questions

Calculate custom calculations, averages, median, max, min and count calculations

Calculate powerful date calculations - Aggregate into Year, Month, Quarters and Weekday

Create running totals, difference from, percentage and ranking calculations

Create relative date calculations - calculate last 7 days, last 3 month calculations

Ask direct questions of your data in simple instructions - no complex formulas and coding at all

Requirements

You must have a ChatGPT paid account

Have experience working with spreadsheets and data

Description

Learn the most POWERFUL way to ANALYZE and UNDERSTAND your Excel and spreadsheet data with ChatGPT using simple questions with no complex formulas or coding.In this course you will learn how to use simple and easy to create instructions that will analyze data and provide new insight and intelligence into your data.If you are new to ChatGPT, I will take you step by step to get up and running. We've focused on providing you with the fundamentals you need to work with data analysis and ChatGPT effectively!COURSE STRUCTUREIn this course you will learn the following:Setup and prepare ChatGPTAggregate and summarize data with simple easy to understand instructionsCreate column graphsLearn different methods of aggregations such as averages, medians, highest values, lowest values, counts and unique countsLearn to do text, numeric, date and top 10 filtersLearn to create powerful management reports such as summaries by year and monthCreate line and area graphsCreate year on year growth and calculations such as last 7 days or last 30 daysCreate powerful calculations such as running totals, running percentages, difference from and rankingsREQUIREMENTS:You will require a paid ChatGPT accountHave a working knowledge of using spreadsheet software and dataABOUT THE TRAINER:Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon QuickSight.Ian has over 250,000 students and over 80,000 reviews and an average course rating of over 4.5 out of 5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.You can see all of Ian's other Data Analysis courses by searching for his name on Udemy.WHY YOU SHOULD SIGN UP:Learners buying this course get:Full access to almost 3 hours of Full HD quality videoLifetime accessMoney-back guarantee (see Udemy terms and Conditions)Certificate of completion upon course conclusionWe look forward to having you on the course!COURSES ROADMAP:You can see all of Ian's other Data Analysis courses by searching for his name on Udemy.ExcelComplete Introduction to Excel Pivot Tables Complete Introduction to Excel Power PivotComplete Introduction to Excel Power QueryExcel Interactive Dashboards and Data AnalysisComplete Introduction to Business Data AnalysisTables and Formulas with ExcelPower BIComplete Introduction to Microsoft Power BIComplete Introduction to Query EditorPower BI Master Class-Data Models and DAX FormulasPower BI Master Class - Dashboards and Power BI Service Google Data StudioComplete Introduction to Google Sheets Pivot TablesComplete Introduction to Google Looker Data StudioAWS QuickSightComplete Introduction to AWS QuickSight

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Reasons for the Course

Lecture 3 About the Course

Lecture 4 Download the Data File

Section 2: Setup and Load Data

Lecture 5 Introduction to Setup and Load Data

Lecture 6 Setup ChatGPT

Lecture 7 Load Data

Lecture 8 Overview of ChatGPT

Section 3: Aggregating and Summarizing Data

Lecture 9 Introduction to Aggregating Data

Lecture 10 Aggregate Data

Lecture 11 Format and Sort

Lecture 12 Export and Calculation

Lecture 13 Practical Activity Aggregation

Lecture 14 Practical Activity Aggregation

Section 4: Methods of Aggregation

Lecture 15 Introduction to Methods of Aggregation

Lecture 16 Methods of Aggregation Part 1

Lecture 17 Methods of Aggregation Part 2

Lecture 18 Practical Activity Methods of Aggregations

Lecture 19 Practical Activity Methods of Aggregation

Section 5: Filters

Lecture 20 Introduction to Filters

Lecture 21 Text Filters

Lecture 22 Numeric Filters

Lecture 23 Top 10 Analysis

Lecture 24 Date Filters

Lecture 25 Practical Activity Filters

Lecture 26 Practical Activity Filters

Section 6: Trends and Date Analysis

Lecture 27 Introduction to Trends and Date Analysis

Lecture 28 Year and Month reports

Lecture 29 Weekday

Lecture 30 Trend Graphs

Lecture 31 Date Calculations

Lecture 32 Practical Activity Dates and Trends

Lecture 33 Practical Activity Dates and Trends

Section 7: Percentages

Lecture 34 Introduction to Percentages

Lecture 35 Percentages

Lecture 36 Pie Graphs

Lecture 37 Practical Activity Percentages

Lecture 38 Practical Activity Percentages

Section 8: Advanced Calculations

Lecture 39 Introduction to Advanced Calculations

Lecture 40 Running Totals, Difference From, Ranking

Lecture 41 Practical Activity Calculations

Lecture 42 Practical Activity Calculations

Section 9: Course Conclusion

Lecture 43 Course Conclusion

Spreadsheet and Business Intelligence users who want to learn how to use ChatGPT,Anybody who wants to learn how to ask questions of their data,Anybody who wants to learn the incredible power of ChatGPT to analyze data