https://i123.fastpic.org/big/2024/0624/75/4faefd2e38db89009312a8f8a52cac75.jpg
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
https://images2.imgbox.com/84/2f/LUrAQyTh_o.jpg
https://t91.pixhost.to/thumbs/465/418437041_filestore.png
https://filestore.me/3t29y8bxytdy/.Introduction.to.Analyzing.Data.with.ChatGPT.2023-12.rar
Видео
