Blog

When you hear ETL (Extract, Transform, Load), most people imagine specialized tools like Keboola, Talend, Informatica, Pentaho, Microsoft SQL Server Integration Services, or dbt. But sometimes there are moments when you have data in a SQL database and for various reasons you cannot deploy ETL tools. How do I solve this for some clients?

Creating a quick RFM (recency, frequency, monetary) analysis isn't difficult. Visualizing it for end users is more challenging. And that's where another free "toy" of mine, which I've been using for years, will help you. It's a file with all achievable score values (1-5), segments, and recommended follow-up activity. Numerical RFM segments alone don't tell report readers anything; this way you can easily display segment names and sort them appropriately.

Do men or women shop with us more? And who is actually who? Figuring this out isn't exactly easy. Unless, of course, you have a handy database...

Visualizing addresses on maps isn't always easy. You often end up needing to display various metrics at the region and district level, but you don't have that information in your source data. However, if you have Czech or Slovak ZIP codes in your data, you can easily convert them to districts and regions using a free tool I've prepared for you.