课程: Excel with Copilot: AI-Driven Data Analysis

AI-powered data visualization with Copilot

课程: Excel with Copilot: AI-Driven Data Analysis

AI-powered data visualization with Copilot

“

- [Instructor] Data visualization is vital for simplifying complex data, uncovering patterns, and effectively conveying findings to others. However, beginning a data visualization can be daunting. With so many chart options available, it can be challenging to determine the best starting point. Fortunately, Copilot can provide assistance by offering suggestions that inspire deeper analysis and improve visual representation. Consider the exercise file 03_03_data_visualization, which again contains data on the fifteen largest cities in the United States. We'll begin by graphing the population of each city. Copilot suggests a bar chart, which seems like a solid choice. I'll add this to a new sheet and you'll see the results formatted here. I'm going to head back to Copilot, and let's continue prompting. We can continue the analysis by experimenting with different data aggregations. For instance, we might instruct Copilot to instruct the average city area by is capital versus not capital. Copilot gives us a summary of the data generated. We also get a chart here that again we can add into our workbook. Now you notice that Copilot frequently favors bar charts in these situations, demonstrating an important principle of data visualization that while the urge to innovate for novelty's sake is strong, it's not necessary to be overly elaborate without cause, so we'll stick with the basics as Copilot does with a bar chart. They're a standard choice because of their simplicity and effectiveness in various contexts. I'm going to go ahead and continue here. Let's examine a situation where the bar chart might not be the best choice. For example, this could be when illustrating the relationship between two quantitative variables, such as area and population, and I'll do that in Copilot now. In this case, a scatterplot is more appropriate, which Copilot promptly provides. I can add this to my sheet and confirm the results. Currently, Copilot has limited functionality for customizing these plots, but Excel gives users full control over the process. For example, I might want to add a trend line to the scatterplot to examine the correlation between city area and population. In summary, Copilot facilitates the data visualization by suggesting efficient and straightforward chart types like bar charts and scatterplots. It emphasizes that utility often trumps the need for novelty, leaving room for users to refine and personalize their visualizations.

内容