Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #1270, Level: Medium) Table: Employees +—————+———+ | Column Name | […]
Category: Business Analytics Blog
Learn How To Write SQL Queries With Examples: #5
Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #1412, Level: Hard) Table: Student +———————+———+ | Column Name | […]
Learn How To Write SQL Queries With Examples: #4
Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #262, Level: Hard) Table: Trips +————-+———-+ | Column Name | […]
Learn How To Write SQL Queries With Examples: #3
Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #185, Level: Hard) Table: Employee +————–+———+ | Column Name | […]
Learn How To Write SQL Queries With Examples: #2
Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #177, Level: Medium) Write a SQL query to get […]
Learn How To Write SQL Queries With Examples: #1
Question Source: LeetCode Solution Language: MySQL This Q&A series will cover data questions from LeetCode and present my solutions to them. Please feel free to comment with your suggestions if you feel that these problems may be solved in a more optimized manner. Question (LeetCode Question #176, Level: Easy) Write a SQL query to get […]
Successful Product Ownership: What Does It Look Like?
I was looking through courses in LinkedIn Learning today when I came across a course on Foundations of an Agile Product Owner role. I absolutely loved going through this course for the following reasons: If you are someone, trying to understand what a Product Owner does on a day to day basis, or just trying […]
SQL Joins: A Guide That Makes It Stupid – Simple
Share This Post: Businesses across the globe have evolved over the past decade. With companies striving to Digitally Transform their value chains and become more Lean and Agile, Analysts and Program/Project/Product Managers of today need to become data-driven problem solvers. To solve problems using data, one needs to access, analyze and report on the business […]
A Simple Value-Based Problem-Solving Approach
The process of building a product, service, or process must be user-focused, and therefore should follow an incremental problem-solving approach. This ensures a robust feedback loop is set up with customers/strategic stakeholders, increasing the success odds.
My First Visualization Project on Tableau Public
Share This Post: I’d been thinking about trying out Tableau Public for quite some time. This weekend, I finally got to it. The first step was to select the dataset I wanted to use and determine the questions to be answered by analyzing this data. So, I decided to pick a topic that’s of interest […]