Is Excel AI Data Analysis Any Good?

Step 1: Article in Markdown Syntax

Introduction

Let's delve into how Excel AI functions when it comes to data analysis. In this exploration, we start by using the 'Analyze Data' feature. The goal is to perform some straightforward tasks:

Firstly, we ask the AI to filter data to show only records from Utah and then sort by sales. Unfortunately, the result isn’t what we anticipated.

In the next attempt, we include product and profit in our query. This returns a result that appears acceptable but still not quite what we're aiming for. Moreover, some of the formulas generated by the AI seem odd and not very useful.

Seeking a different approach, we decide to use a pivot table. However, initially, the pivot table does not function as intended. Despite specifying that we want to pivot by product, the outcome continues to look largely the same.

After adjusting our approach, we finally manage to pivot by product while including total sales and profit for Utah. This yields results that are more aligned with our expectations.

Despite achieving our goal eventually, the process feels cumbersome and outdated, especially considering we are in 2023. Hence, there’s much anticipation for the new GPT-powered Co-pilot, which promises to be significantly more intuitive and user-friendly.

Step 2: Keywords

Keywords

• Excel AI
• Data Analysis
• Filter
• Utah
• Sales
• Product
• Profit
• Pivot Table
• GPT-powered Co-pilot
• 2023

Step 3: FAQs

FAQ

1. What was the initial task in the Excel AI data analysis?

• The initial task was to filter data to show records from Utah and sort by sales.

2. Did Excel AI provide the correct results on the first attempt?

• No, it failed to provide the correct results initially.

3. What additional data did the user include to refine their query?

• The user included product and profit data in their query.

4. Did the AI formulas meet the user’s requirements?

• No, the AI-generated formulas seemed odd and weren't very useful.

5. How did pivot tables function initially?

• Pivot tables didn’t function as intended initially, even after specifying the pivot by product.

6. What was the final successful query outcome?

• The successful query outcome included pivoting by product while incorporating sales and profit data for Utah.

7. What was the user’s opinion on Excel AI after the experience?

• The user felt that the Excel AI process was cumbersome and outdated for 2023 and expressed anticipation for the more intuitive GPT-powered Co-pilot.

8. What feature is the user looking forward to in the future?

• The user is looking forward to the new GPT-powered Co-pilot.