Posts by : Terence Shin

Best Practices
Time series analysis + simple exponential smoothing in Python
Terence Shin
24 May 2022
Are you optimizing your business predictions? With time series and exponential smoothing, you can place emphasis on more recent observations.
Tutorials
How to Conduct Time Series Forecasting with SQL (with Example)
Terence Shin
11 April 2022
Harness the power of SQL for time series forecasting. Learn how to predict future trends and make data-driven decisions with this step-by-step guide.
Tutorials
Quick guide: SQL aggregate functions | Census
Terence Shin
21 December 2021
Looking to do more with your data? Just need a refresher on how SQL aggregate functions work? We got you.
Tutorials
The 5 SQL date functions biz ops teams need to know | Census
Terence Shin
7 September 2021
Trying to figure out all the different SQL date functions out there? Follow a fictional company to learn 5 functions to help your business ops.
Best Practices
Guide to fraud prediction models | Census
Terence Shin
6 August 2021
In this primer on fraud prediction models, we'll look at the different types, features, and evaluation methods you can use for your use case.
Tutorials
Marketing mix modeling: Python tutorial with example dataset | Census
Terence Shin
12 July 2021
Data can help turn your marketing from art into measured science. Here's a primer on how you can harness marketing mix modeling in Python to level up your efforts and insights.