Latest posts

Clustering time series data with SQL. The purpose is to prove that doing data science doesn't always require fancy tools. Examples in this repository might be helpful, if you must use SQL instead of proper data science tools such as python. Thus this repository is not a comprehensive guide for time series data clustering. Even though clustering is often connected to machine learning, this showcase relies only on logical decision making. I have focused on IoT related data in the field of predictive maintenance.

Clustering data using SQL – An example with industrial IoT data

Clustering time series data with SQL – Nice 3D visualization using simple logic. Python notebook example in GitHub with industrial data.

Spark and Python tutorial for data developers. The example has been ran on AWS cloud computing platform.

Spark + Python tutorial for data developers

A tutorial for parallel computation with Spark and Python. The example has been ran on AWS cloud computing platform.

AWS Glue service works especially well for big data batch processing.

Introduction to AWS Glue for big data ETL

AWS Glue service works especially well for big data batch processing. Read the full post from data.solita.fi.

Excel Power Map-ominaisuus on tarkoitettu paikkatietojen visualisointiin. Katso turvapaikanhakijadatasta tehty demo-video.

Excel Power Map – Spatial data visualization as a time series

Excel Power Map is designed to visualize spatial data. Watch the demo video about visualizing annual asylum seeker data.

Finnish language stemming and lemmatization in python.

Finnish stemming and lemmatization in python

I wrote to Solita’s blog about text analytics with the headline “Finnish stemming and lemmatization in python”. The post has code examples.

Pipedrive expert partner certificate. Experiences from Pipedrive. Image ratio 16/9.

Migrating CRM to Pipedrive – Experiences and tips

Experiences from Pipedrive CRM implementation. Pipedrive is simple for the sales people, but the migration from an old CRM requires planning.

Go to blog

mikaelahonen.com in numbers

All time users
117093
Most popular post readers
28323
Time spent on site in work days
551
Posts
287