Copilot in Excel: Full Project Demo | Surprisingly SOLID Results (project files included!)
Maven Analytics Maven Analytics
40.5K subscribers
2,283 views
0

 Published On May 29, 2024

Can AI solve a real-world data challenge in Microsoft Excel? We’ll see!

In this demo, Copilot will take on the Maven Rail Challenge and play the role of a BI Developer for National Rail, a company that provides business services to passenger train operators in the UK.

By only using natural language prompts it’ll attempt to perform these 4 analyses for a dashboard:
1. Identify the most popular routes
2. Determine peak travel times
3. Analyze revenue from different ticket types & classes
4. Diagnose on-time performance and contributing factors

Will Copilot have what it takes, or will a human data analyst need to be involved?

You’ll be surprised at the results!

🔗 Helpful Links:

👉 Downloadable demo files:
https://maven-datasets.s3.amazonaws.c...

👉 Maven Rail Challenge:
https://mavenanalytics.io/challenges/...

👉 Excel Specialist Learning Path:
https://mavenanalytics.io/path/excel-...

👉 Follow Enrique:
linkedin.com/in/enrique-ruiz-tapia

👉 Follow Maven Analytics:
  / maven-analytics  

👀 Looking to learn (Excel/SQL) this summer? Join our upcoming Immersives and build job-ready skils in just 10 weeks!
https://bit.ly/3wPwoPw

⏱️ Timestamps ⏱️
00:00 - Intro
00:20 - Project Brief
00:42 - STEP 1: Identify the most popular routes
02:22 - STEP 2: Determine the peak travel times
04:50 - STEP 3: Analyze revenue from different ticket types and classes
05:36 - STEP 4: Diagnose on-time performance and contributing factors
07:40 - Project Recap & Free Resources


At Maven Analytics, we empower everyday people with life-changing data & AI skills.

Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE!

Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: https://mavenanalytics.io/guided-proj...

show more

Share/Embed