Big SQL Energy Beginner Course: Lesson 30 Case Study: Visualizing Data
Got BDE?⚡️
Hi BDEs! Welcome to Lesson 30 of the free Big SQL Energy Beginner Course⚡️ Today we’re doing a CASE STUDY on visualizing data!
Return to Big SQL Energy Beginner homepage here to access the other lessons:
If you’re new here:
💁🏽♀️ Who Am I?
I’m Jess Ramos, the founder of Big Data Energy and the creator of the BEST SQL course and community: Big SQL Energy⚡️. Check me out on socials: 🔗LinkedIn, 🔗Instagram, 🔗YouTube, and 🔗TikTok. And of course subscribe to my 🔗newsletter here for all my upcoming lessons and updates— all for free!
⚡️ What is Big SQL Energy?
🔗Big SQL Energy Intermediate is an intermediate SQL course designed to solve real-world business problems hands-on using realistic data and a modern tech stack. You’ll walk away with 2 SQL portfolio projects, portfolio building guidance, access to the Big Data Energy Discord community, and lots of confidence for you upcoming coding interviews! You also get access to all monthly events including masterclasses, office hours, and guest speakers. This course is all of the most important things I’ve learned on the job as a Senior Data Analyst in tech who grew from a $72K salary to over a $150K salary. And now I’m sharing it with YOU! It’s more than just another course— it’s a challenging program designed to upskill your SQL to the intermediate level, get ready to ace your live coding interviews, and build connections in the data community through the Discord and events.
Lesson 30: Visualizing Data Case Study
We’re finally at the part where we’re using our skills to solve case studies and mini business problems— YAY! If you’re ready to learn even more skills & practice more advanced business problems to get ready for interviews and build a data analytics portfolio, you GOTTA check out my 🔗Big SQL Energy Intermediate course. I promise— it’s even better than the beginner course because it’s way more material and you get access to the community events and Discord 🔥
In this lesson, we explore order trends by product name and gender and visualize the data using this query:
select
gender,
product_name,
count(order_id) as orders
from
orders ord
join
customers cust
on ord.customer_id = cust.id
group by
1, 2Follow along in the video for the visualization portion!
If you’ve enjoyed the free BEGINNER Big SQL Energy course, grab my intermediate course. There are no deadlines or timelines for this course— you start and take as long as you want. It will take your beginner skills to the next level and get you ready to ace your interviews. DM me or email me at courses@bdeanalytics.com if you have questions on the intermediate course!
Return to Big SQL Energy Beginner homepage here to access the other lessons: