Can AI solve a realworld 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 ontime 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://mavendatasets.s3.amazonaws.c...

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

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

Follow Enrique:
linkedin.com/in/enriqueruiztapia

Follow Maven Analytics:
  / mavenanalytics  

Looking to learn (Excel/SQL) this summer? Join our upcoming Immersives and build jobready 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 ontime performance and contributing factors
07:40 Project Recap & Free Resources


At Maven Analytics, we empower everyday people with lifechanging data & AI skills.

Head to http://mavenanalytics.io and master indemand 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, expertled guided projects: https://mavenanalytics.io/guidedproj...