Online Excel Pivot Tables Tutorials

DATA ANALYSIS WITH CHATGPT

This series of 12 tutorials will show you how to use ChatGPT to quickly and easily analyze complex datasets. It allows you to conduct more data exploration and reduces the time it takes to reach valuable insights.

Please note that will need to have the appropriate licensing from OpenAI to use ChatGPT. This tutorial is suitable for users of most internet browsers like Safari, Chrome, and Edge.

DOWNLOAD

SalesData.xlxs

Tutorial 1

Welcome to the first tutorial in our series designed to empower you with the skills to use ChatGPT for analyzing Excel data efficiently.

This session covers the initial setup and basic instructions needed to start leveraging ChatGPT's capabilities, particularly focusing on the Plus plan features for enhanced data handling and analysis.

Loading Data: Demonstrating how to upload and analyze a dataset containing over 8,000 rows of sales data.
Analyzing Data: Simple commands to generate insights such as field names, types, and data range analysis.
Advanced Commands: Creating tables, formatting data, and exporting results to enhance data presentation.
Visual Data Representation: Steps to create and export graphical representations of data analysis results.

Tutorial 2

Delve into the fundamentals of exploratory data analytics using ChatGPT. This session is designed to teach you how to leverage ChatGPT to analyze and understand complex datasets, focusing on sales data. Whether you're a data scientist, a business analyst, or just curious about data analytics, this tutorial will provide you with a practical understanding of how to explore and interpret data effectively.

Data Preparation: Walkthrough on how to upload and configure your dataset in ChatGPT for analysis.
Initial Analysis: Demonstrating commands to list dataset fields and initiate basic exploratory analysis.
Deep Dive into Sales Data: Detailed exploration of sales data to identify distribution patterns and outliers, including graphical representations.
Advanced Analysis: Combining multiple fields to uncover complex insights and how to download these insights for presentations or further analysis.

Tutorial 3

Explore the powerful capabilities of descriptive analytics using ChatGPT in this comprehensive tutorial. This session is part of a series focused on leveraging ChatGPT for various data analysis techniques. In this tutorial, we'll focus specifically on descriptive analytics, which aims to summarize and describe different aspects of datasets comprehensively.

Data Preparation: Step-by-step guidance on how to upload and verify data in ChatGPT.
Performing Descriptive Analytics: Commands and prompts to analyze data and extract detailed statistical summaries.
Understanding Statistical Outputs: Explanation of key statistics like average, variability, percentiles, and their significance in data analysis.
Data Formatting and Export: Tips on formatting output tables and exporting them for use in reports or presentations.

Tutorial 4

This session focuses on how to effectively summarize and aggregate large datasets using ChatGPT. Whether you're looking to understand total sales by region or customer insights, this tutorial will guide you through the process of generating meaningful summary tables and reports using ChatGPT.

Data Preparation: Guidance on uploading data and ensuring it's properly formatted for analysis.
Basic Summaries: Learn to produce quick summary tables, such as total sales by region.
Advanced Aggregation: Dive into more complex data aggregations like sales by product subcategory and adjusting table formats.
Exporting Data: Instructions on how to export aggregated data for use in reports or presentations

Tutorial 5

This tutorial continues to explore the capabilities of ChatGPT in data analysis, focusing on advanced data aggregation methods. Building on previous tutorials where we summarized data, this session dives into how to perform complex calculations such as averages, maximum and minimum values, counts, and unique counts using ChatGPT. Perfect for users who want to deepen their data analysis skills using ChatGPT’s advanced features.

Starting Simple: Refresh on how to upload data and list fields using ChatGPT.
Complex Aggregations: Step-by-step guidance on adding sophisticated calculations to your data tables.
From Theory to Practice: Real-world examples including calculating average sales per region and exploring customer transaction data.
Troubleshooting Tips: Insights into common data formatting issues and how to resolve them in ChatGPT.

Tutorial 6

Continue exploring the powerful data analysis capabilities of ChatGPT, focusing on applying various filters to data. Whether you're dealing with text, numeric values, or specific categorizations, this session will guide you through the process of integrating filters to refine and tailor your data queries effectively.

Introduction to Filters: Learn the basics of applying filters to data sets in ChatGPT.
Applying Text and Numeric Filters: Detailed examples on filtering data based on specific criteria such as product names or sales thresholds.
Advanced Filtering Techniques: Explore complex filtering like top-ten lists within specific categories or regions.
Practical Examples and Tips: Real-world scenarios demonstrating the application of filters to sales data for enhanced analytical outputs.

Tutorial 7

In this comprehensive tutorial we shift from creating data tables to crafting engaging graphical visualizations using ChatGPT. Focused on transforming complex sales data into visual formats, this tutorial will cover the basics of creating column graphs, line graphs, and pie charts. Whether you're presenting sales results or analyzing trends, these skills will enhance your ability to communicate data effectively.

Creating a Column Graph: Learn to visualize total sales by region with a detailed column graph.
Designing a Line Graph: See how to trace sales trends over time and add forecast data to your visualizations.
Building a Pie Chart: Discover how to represent sales data as percentages in a pie chart and ensure it's easy to read.
Enhancing Visuals: Instructions on customizing graphs with data labels, legends, and adjusting color schemes for better clarity.

Tutorial 8

Dive deeper into the world of data visualization using ChatGPT. Building on basic graphs like column, line, and pie charts, this tutorial explores more sophisticated visualizations, including histograms, box plots, violin plots, scatter plots, and hex bins. Perfect for anyone looking to enhance their data presentation skills with more complex graphical representations.

Exploring Histograms: Learn to visualize the frequency distribution of data points within your dataset.
Understanding Box Plots: Gain insights into the quartiles and outliers of your data with box plots.
Utilizing Violin Plots: See how violin plots can offer both box plot and density plot features for detailed data analysis.
Creating Scatter and Hex Bin Plots: Discover how these plots can help you visualize complex relationships and density of data points effectively.

Tutorial 9

Continue exploring the advanced capabilities of ChatGPT in the realm of data analysis. This tutorial delves into trend analysis and dynamic date calculations, showing you how to manipulate and analyze temporal data effortlessly. Whether you're interested in understanding sales trends over time or performing complex date-related calculations, this session is designed to enhance your analytical skills using simple English queries with ChatGPT.

Trend Analysis Setup: Learn how to prepare your data and generate trend lines to understand upward or downward movements.
Date Calculations: Discover how to ask ChatGPT to calculate sales for the last week, the previous month, or custom date ranges.
Visualizing Trends: Instructions on creating line charts to visualize sales trends within a specific year and comparing data across different periods.
Practical Application: Apply these techniques to real-world data, enhancing your ability to make decisions based on time-based trends.

Tutorial 10

In this detailed tutorial we explore how to use ChatGPT for complex data calculations, such as calculating percentages, differences between months, running totals, and rankings. These calculations, often challenging in traditional data analysis tools, are simplified using ChatGPT's powerful language capabilities. This session is ideal for analysts looking to deepen their understanding of dynamic data manipulation without complex formulae.

Complex Calculations Simplified: Learn percentage calculations, detect changes between periods, and accumulate totals over time.
Dynamic Data Formatting: Instructions on how to format tables dynamically, correct order issues, and enhance data readability.
Visualizing Changes and Trends: Create visual representations such as line charts and column graphs to understand trends and variations.
Practical Examples: Real-world applications demonstrating how to use these techniques to analyze sales data effectively.

Tutorial 11

Complex Calculations Simplified: Learn percentage calculations, detect changes between periods, and accumulate totals over time.
Dynamic Data Formatting: Instructions on how to format tables dynamically, correct order issues, and enhance data readability.
Visualizing Changes and Trends: Create visual representations such as line charts and column graphs to understand trends and variations.
Practical Examples: Real-world applications demonstrating how to use these techniques to analyze sales data effectively.

Tutorial 12

Explore sophisticated data grouping techniques to enhance human resource data analysis using ChatGPT. This tutorial will focus on creating meaningful groupings or "bins" for employee data, such as age ranges and salary bands, which can provide insightful visualizations and reports.

Perfect for HR professionals and data analysts looking to leverage AI for more efficient data processing and decision-making.

Data Grouping Basics: Learn the fundamentals of creating bins for age and salary to segment HR data effectively.
Visualizing Grouped Data: Instructions on how to visualize these groupings through tables and charts, enhancing data presentation.
Practical Applications: See real-life applications of these techniques to analyze trends and distributions within a company’s workforce.
Dynamic Analysis Enhancements: Tips on refining data visualizations and adding calculations such as percentages and totals to your reports.

Connecting to Cloud Services: How to seamlessly connect to Google Drive and Microsoft OneDrive to access your files.
Interactive Tables: Discover how to utilize the new interactive tables to view, select, and manipulate data more efficiently.
Interactive Graphs: Understand how to create and work with interactive graphs, enhancing your data visualization capabilities.
Data Manipulation: Explore various features for cleaning and manipulating data directly within the interactive tables.

Tutorial 13

In this tutorial, we'll explore the new features introduced in the latest ChatGPT release, Omni Update, specifically focusing on data analysis enhancements.

This tutorial will guide you through connecting to Google Drive and Microsoft OneDrive, working with interactive tables, and utilizing new graphing capabilities.

Connecting to Cloud Services: Effortlessly integrate your Google and Microsoft services for easier file management.
Enhanced Interactive Tables: A more dynamic way to work, including selecting columns, filtering records, and generating customized tables.
New Graphing Features: Switch between static and interactive graphs, add tooltips, and customize graph colors for better data presentation.
Data Cleaning Tools: Learn how to remove unwanted columns, rename headers, adjust date formats, and standardize values in your dataset.