Sign up
Sign in
Sign up
Sign in
Member-only story
Riley Predum
Follow
Towards Data Science
--
1
Share
As a Data Analyst, I work a lot in SQL, and I thought I’d share a walk through on how to use it to solve business problems. I’m self-taught and worked my way from Marketing into a Data Analyst role at an edtech startup specializing in Data Science and UX Design education.
I wanted to pay it forward with my learnings and share some of the things I’ve found helpful in developing analytical skills. Without further ado, I’m going to jump in to the meat and potatoes: an end-to-end example of a few business/product analyst style problems you can solve with SQL.
This article is for those of you looking to develop your SQL/analytical thinking skills, and those trying to break into and start their careers as a Business Analyst, Data Analyst, Product Analyst, or Data Scientist. Whatever the path you choose, I guarantee you that SQL is a crucial skill to have in your toolbox!
As such, my goals for this article are for you to:
In a future part to this article series, I’ll dive deeper into more advanced SQL, and using it to solve business problems.
To get started, you’re going to want to go ahead and go to mode.com and sign up for a free account. It’s a super quick and basic sign-up process. After you’ve verified your account you can log in.
Once in the platform, go to SQL Training2019 and click Write a Query. As someone with experience in product and business analytics I’m going to walk you through SQL queries in the yammer_experiments table, which corresponds to product experiments and their results.
With that, we’ve achieved goal #1! Look at us go!
Let’s run the first query to figure out how many rows we’re dealing with:
--
--
1
Towards Data Science
Focused on teaching you the ins and outs of data analytics through detailed tutorials.
Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams

source