No-Code Data Analysis and Visualization with ChatGPT
36mIntermediate2024-08-14
Authors

Alina Zhang
Course details
Thousands of years ago, the mastery of fire reshaped humanity. Today, a similar divide exists: those who harness the power of large language models, and those who don't. Where do you stand?
Join Alina Zhang, a senior data scientist, and discover how to unlock the power of ChatGPT for data analysis and visualization without writing a single line of code. Introducing the "Leaning Tower of Data Analysis," you'll gain hands-on experience with a synthetic retail dataset, learning to handle missing values, summarize statistics, and design visuals. Dive into trend identification, deviation detection, correlation exploration, and part-to-whole analysis—all through plain English. By the end, you'll be equipped to apply these skills in your projects, telling compelling data stories like a skilled professional.
Learning objectives
Analyze data using ChatGPT, identifying trends, detecting outliers, and exploring correlations.
Handle missing values, summarize datasets, and perform part-to-whole analysis.
Build machine learning models for classification and assess performance.
Create visually appealing data visualizations with proper color, font, and caption design.
Apply the "Leaning Tower of Data Analysis" framework to real-world datasets.
Join Alina Zhang, a senior data scientist, and discover how to unlock the power of ChatGPT for data analysis and visualization without writing a single line of code. Introducing the "Leaning Tower of Data Analysis," you'll gain hands-on experience with a synthetic retail dataset, learning to handle missing values, summarize statistics, and design visuals. Dive into trend identification, deviation detection, correlation exploration, and part-to-whole analysis—all through plain English. By the end, you'll be equipped to apply these skills in your projects, telling compelling data stories like a skilled professional.
Learning objectives
Analyze data using ChatGPT, identifying trends, detecting outliers, and exploring correlations.
Handle missing values, summarize datasets, and perform part-to-whole analysis.
Build machine learning models for classification and assess performance.
Create visually appealing data visualizations with proper color, font, and caption design.
Apply the "Leaning Tower of Data Analysis" framework to real-world datasets.
Skills covered
DALL-EChatGPTData VisualizationOpenAIAI Productivity ToolsData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOne-Off
Concepts
0. Introduction
- 01 - Analyze data like a data scientist without coding
- 02 - Hire ChatGPT as your assistant for data analysis
1. Foundations of Data Analysis and Visualization
- 03 - Allan's challenge in retail chain sales data
- 04 - The leaning tower of data analysis framework
- 05 - Describing a dataset and handling missing values
- 06 - Statistical summary and value counts
- 07 - Distribution and comparison
- 08 - Color, font, and caption design for visualization
2. Advanced Data Analysis Technique
- 09 - Identifying trends in data
- 10 - Detecting deviations and outliers
- 11 - Exploring correlation without assuming causation
- 12 - Aggregation and part-to-whole analysis
3. Applying Machine Learning and Communication Skills
- 13 - Machine learning classification for store performance
- 14 - Speaking the retail dialect - Sales per square foot (SPF)
- 15 - Creating a slide deck for storytelling
Conclusion
- 16 - Tell the story of your data
Related courses
- Manager's Guide to Building a Data Dashboard with ChatGPT (No Code Required)
- Build an AI-Powered Customer Insights Dashboard (No Code Required)
- Build a No-Code ETL Pipeline with Google BigQuery
- Build with AI: LLM-Powered Data Analysis App with Python and Streamlit
- Build with AI: Create Data Analytics Dashboards with Lovable
- Microsoft Power Platform Foundations
- Learning Power Platform: Excel Integration
- Power Apps: Building Data-Driven Apps with Excel
Related learn paths
- Data Science Professional Certificate by KNIME
- Building Generative AI Skills for Web Developers
- Starting Your Career in Tech: Data Science
- Advance Your Data Engineering Skills
- Prepare for the Power Platform Fundamentals (PL-900) Certification from Microsoft Press
- Explore App Development with the MERN Stack
- Technical Program Management
- The Top Skills Engineering Professionals Have Right Now