How to Extract JSON Data using Excel vs SQL vs Python vs ChatGPT

Maven instructors Enrique Ruiz, Alice Zhao, and Chris Bruehl demonstrate how to flatten a column of nested JSON data into individual rows in a table using Excel, SQL, and Python. Then, we see how ChatGPT approaches the same task.

Try this Data Drill out yourself! 👉 bit.ly/3YZXb6f

🌷 Spring Savings - Up to 50% Off 🌷

Looking to take your data skills to the next level?

We’re offering a rare opportunity to save on a Maven membership!

And, because we know that e-learning isn’t one-size-fits-all, we’ve got some awesome options for you to choose from:
👉 30% off your first 3 months!
👉 40% off for a whole year!
👉 50% off for LIFE!

All Maven memberships include:
✓ Unlimited access to ALL courses & paths
✓ Customized learning plans
✓ Guided projects
✓ Skills assessments
✓ Showcase portfolio builder
✓ Free practice data sets
✓ Private student dashboard
✓ Live instructor chat support
If you're looking to build expert-level data skills, or if you've considered joining our Excel, SQL, Power BI, Tableau, or Python courses in the past, NOW is the time to get on board!

SIGN UP TODAY 👉 bit.ly/4kaKlun

The fine print:
Offer expires Thursday, May 8th
Valid for Individual accounts only (not for Teams)
Monthly deal is for new Subscribers only
Annual deal not valid for existing Annual Subscribers

🔗 Helpful Resources

👉 Build Data Skills with Maven Analytics: bit.ly/4jEPZot

👉 Follow us on LinkedIn:
Maven Analytics: www.linkedin.com/company/maven-analytics
Enrique: www.linkedin.com/in/enrique-ruiz-tapia/
Alice: www.linkedin.com/in/alicexzhao/
Chris: www.linkedin.com/in/chrisbruehl/

‌
⏱️ Timestamps:
00:00 - Intro
00:15 - Data Drill Objective
00:37 - Excel Solution Walkthrough
04:29 - SQL Solution Walkthrough
11:16 - Python Solution Walkthrough
18:47 - ChatGPT Solution Walkthrough
20:53 - Validation Question
21:30 - Outro/Resources
‌

Maven Analytics is an award-winning online platform for data professionals to learn new skills, showcase their work, and connect with peers around the world.

We've helped more than 1,000,000 students build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundations for successful careers.

Start learning and build your FREE portfolio at www.MavenAn