From the course: No-Code Data Analysis and Visualization with ChatGPT
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Identifying trends in data
From the course: No-Code Data Analysis and Visualization with ChatGPT
Identifying trends in data
- [Narrator] Climbing up to the fourth floor, we start the trend analysis. Detecting trends helps us understand how things change over time. Here we instruct our assistant, ChatGPT. Show me a line chart to visualize the weekly sales over time for stores 1, 2, and 5. Add a trend line for each store. Wonderful. Store 1 had a noticeable increase in weekly sales over time. Store 2 had a slight downward trend. This suggests that it may be facing challengings that affect the sales performance negatively. There is a slight upward trend in store 5, but the gross rate is less steep compared to store 1. Cool. Moving on, let's get curious about how holidays impact our customer traffic. Create a connected scatterplot to visualize the average daily customers over time for store 9. Use gray circles to represent non-holiday weeks and red squares to highlight holiday weeks. Awesome. Just as we suspected, the plot reveals spikes close to or during the holiday seasons. It's like everyone suddenly…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.