Ryan IyengarDesigning Card Decks and Board Games in Google Sheets and FigmaA common question I’ve seen in board game design groups is how to generate and manage large decks of cards with lots of unique attributes…Sep 9, 2022Sep 9, 2022
Ryan IyengarinRyan IyengarA/B Test Reporting and Visualization in SQLFor a lot of e-commerce, subscription, or internet companies, A/B testing is a way of life. There are many tools and software services out…Dec 1, 20171Dec 1, 20171
Ryan IyengarinRyan IyengarGenerating Sample SQL Data in Excel and Google SheetsFor a lot of analytical SQL blog posts, I find myself generating sample data in Excel or Google Sheets to mess around with. This means…Dec 1, 2017Dec 1, 2017
Ryan IyengarHow Are Job Titles Changing Over Time?Resumes are an interesting database of people’s previous job titles. They’re not a perfect record of history, since they’re living…May 23, 20162May 23, 20162
Ryan IyengarinRyan IyengarProjecting Customer Lifetime Value in SQL Using Exponential DecayCustomer lifetime value is a really useful metric to use across a business, but unfortunately (or fortunately!) for a new business, most of…May 16, 20162May 16, 20162
Ryan IyengarinRyan IyengarWhat Makes for an Effective Job Posting?Employers write lots of job postings, and either pay to sponsor them on a website like ZipRecruiter, pay directly for visitors to those job…May 9, 2016May 9, 2016
Ryan IyengarinRyan IyengarGenerate AdWords Keyword Permutations in SQLI’ve mostly seen marketers generate tons of keyword permutations in Excel. It works well for small projects, but in the past I’ve worked…May 2, 20161May 2, 20161
Ryan IyengarinRyan IyengarHow Far Do People Move For Work?In looking through job histories, it’s pretty clear that the vast majority of people don’t move around that much from job to job.Apr 25, 2016Apr 25, 2016
Ryan IyengarinRyan IyengarHow Long Do People Stay at Their Jobs?The conventional wisdom is that over the past few decades, people are moving jobs more frequently. I figured I could dig in further and try…Apr 18, 2016Apr 18, 2016
Ryan IyengarinRyan IyengarJob Odds — What Job Am I Likely to Get?This is a question that a lot of job seekers are likely to ask themselves. The answer is obviously hyper-specific to everyone’s individual…Apr 11, 2016Apr 11, 2016