Skip to content

Mikael Ahonen

Inspiration | Attitude | Stories

  • Blog
  • Mikael
  • Business
    • Microsoft Excel
    • Pipedrive CRM
  • English
    • Suomi
    • English
    • Svenska
Koneoppimisen hyödyntäminen ennakoivassa huollossa. Kaksiosaisessa sarjassa asiaa kustannusäästöistä ja esimerkki Python-kielellä.

Machine learning in predictive maintenance

Posted 29.10.202027.10.2020 Mikael AhonenLeave a commentPosted in Information technology

Machine learning in predictive maintenance. The two-part blog series provides insights for cost savings and an example script in Python.

How to fool a web service about your actual location? In an experiment I pretended being in Ireland while traveling in Sweden.

Faking your geographical location to a web service – A hobby project

Posted 28.10.202027.10.2020 Mikael AhonenLeave a commentPosted in Information technology

How to fool a web service about your actual location? In an experiment I pretended being in Ireland while traveling in Sweden.

Difference between Data Science and Data Engineering 1. Data platform built by a Data Engineer 2. Predictions and recommendations developed by a Data Scientist

Difference between data scientist and data engineer roles

Posted 17.08.202017.08.2020 Mikael AhonenLeave a commentPosted in Information technology

In my opinion the big difference is that a data scientist focuses more on business problems while data engineer solves technical problems.

Review about DataCamp data science courses. Read the review about the online training and get familiar with pricing and service offering.

DataCamp – Learn data science online

Posted 13.08.202021.08.2020 Mikael AhonenLeave a commentPosted in Information technology

Experiences from DataCamp online training. Structured data science courses are easy to organize for yourself or a team.

Databox demo with an interactive report embedded on to an web page. Combine data from multiple sources and share easily with Databox.

Databox for enterprise reporting – Review and demo

Posted 13.08.202021.08.2020 Mikael AhonenLeave a commentPosted in Information technology

Databox enables elegant reports in a SaaS interface to be shared and published both internally and outside the organization.

The article goes through the PySpark execution logic and provides guidelines to optimize the speed and performance.

PySpark execution logic and code optimization

Posted 09.02.202009.02.2020 Mikael AhonenLeave a commentPosted in Information technology

The article goes through the PySpark execution logic and provides guidelines to optimize the speed and performance.

Pipedrive Essential and Advanced comparison of pricing and features. When to choose Pipedrive Advanced or Essential for your company.

Pipedrive Essential vs Advanced – Comparison of features and pricing on 2020

Posted 29.01.202029.01.2020 Mikael AhonenLeave a commentPosted in Information technology

Pipedrive Essential and Advanced are by far the most popular plans among my customers. A comparison of different subscriptions.

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

Posted 10.11.201910.11.2019 Mikael AhonenLeave a commentPosted in Information technology

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

Posted 07.10.201904.10.2019 Mikael AhonenLeave a commentPosted in Information technology

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

Posted 01.09.201901.09.2019 Mikael AhonenLeave a commentPosted in Information technology

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

Posted 15.07.201904.11.2019 adminLeave a commentPosted in Information technology

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

Posted 23.06.201913.08.2020 Mikael AhonenLeave a commentPosted in Information technology

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

Posted 02.06.201913.08.2020 Mikael Ahonen2 CommentsPosted in Information technology

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

Blogging about professional topics is an excellent way to increase visibility for yourself and your company. Read the tips and experiences!

Blogging about professional topics – Experiences and tips

Posted 09.05.201926.07.2019 Mikael AhonenLeave a commentPosted in Self improvement

Blogging about professional topics is an excellent way to increase visibility for yourself and your company. Read the tips and experiences!

Video blog series - Industrial Engineering and Management in career. Picture from Tampere, Pyynikki.

Industrial Engineering and Management in career – Video answers to questions from students

Posted 08.04.201924.04.2019 Mikael AhonenLeave a commentPosted in Self improvement

Video blog series – Industrial Engineering and Management in career See the answers in the Youtube playlist. There are English subtitles. Thanks Lassi Mäkinen for […]

4. Enter the Pipedrive promo code to redeem the extended trial period. Fill the rest of the sign up form and click "Next".

Extended free trial period for Pipedrive CRM

Posted 16.02.201902.02.2020 Mikael AhonenLeave a commentPosted in Information technology

Simple instructions to sign up and get started with Pipedrive CRM. Redeem the extended trial period for Pipedrive.

Experiences from funding application classification by text analytics

Experiences from funding application classification by text analytics

Posted 27.01.201927.01.2019 Mikael AhonenLeave a commentPosted in Information technology

Experiences from funding application classification by text analytics

MSCI World index history between 1969-2018.

Should you start investing if a depression is coming? – Data analysis

Posted 09.12.201819.08.2020 Mikael AhonenLeave a commentPosted in Business

Investing when a depression is coming. Is it bad moment to start investing to stock index that are usually seen as sage bets?

Example: How to combine machine learning and business?

Combining machine learning and business – Practical example

Posted 15.05.201830.05.2019 Mikael AhonenLeave a commentPosted in Information technology

You can find the article from Solita’s data related blog site data.solita.fi. Finally I managed to publish my blog post with the topic A Machine […]

Read about Solita team's solution in a hackathon organized by Hiab. The task was to take advantage of data to maximize machine uptime.

Maximizing uptime in Hiab hackathon

Posted 01.11.201730.05.2019 Mikael AhonenLeave a commentPosted in Information technology

Read about Solita team’s solution in a hackathon organized by Hiab. The task was to take advantage of data to maximize machine uptime.

Sarakkeiden muuttaminen riveiksi Excel PowerQuery työkalulla.

Unpivot columns to rows with Excel PowerQuery

Posted 01.10.201728.09.2017 Mikael AhonenLeave a commentPosted in Information technology

Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.

Python code to automatically list header fields of multiple CSV files. The original use case was related to data warehouse documentation.

Csv headers to list using Python

Posted 01.09.201725.04.2019 Mikael AhonenLeave a commentPosted in Information technology

Python code to automatically list header fields of multiple CSV files. The original use case was related to data warehouse documentation.

Parsing first name, last name and company from email in Excel - Download Excel template.

Parsing first name, last name and company from email in Excel – Download Excel template

Posted 22.02.201704.11.2019 Mikael AhonenLeave a commentPosted in Information technology

Parsing first name, last name and company from email in Excel Do you have a list of emails that you want to split by first […]

Landscape in Lesotho.

A nation that seized the time – Lesotho – Around the world trip days 23.1.2017 – 29.1.2017

Posted 26.01.201729.01.2017 Mikael Ahonen2 CommentsPosted in Around the world trip, Free time

Lesotho is a nation that time feels to be seized in. As the Grande finale of my trip I did a real grand old man of all hikes.

I was able to walk to grocery store along closed railway from my hostel. So don't try this at home!

Robberies in South Africa – Around the World Trip Days 9.1.2017 – 21.1.2016

Posted 23.01.201729.01.2017 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

This article is part of the series about around the world trip. Click to see all blogs from the around the world trip. You can […]

Note app - Google Keep vs Evernote

Google Keep vs Evernote – Requirements for your note app

Posted 10.01.201729.01.2017 Mikael Ahonen2 CommentsPosted in Information technology

Personally, I use a note app to store ideas, observations, travel tickets and debts that should be quickly accessible.

Cape of Good Hope, Cape Peninsula, South Africa

Cape Town – Around the World Trip Days 31.12.2016 – 8.1.2017

Posted 08.01.201729.01.2017 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

The top attraction of Cape Town were beautiful Table Mountain and the Cape of Good Hope. The society has it problems, though.

Selfie, Iguazu falls, Brazil. At this stage falling water and wind made conditions very wet.

From the Edge of the World to the Devil’s throat – South America – Around the World Trip Days 14.12.2016 – 29.12.2016

Posted 06.01.201729.01.2017 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

Second part from South America. The nature pics are worth seeing! I also made a bus ticket seller so angry that I got in trouble.

Toggl - Work hour logging

Toggl – Recording work hours to log has never been such enjoyable

Posted 04.01.201729.01.2017 Mikael AhonenLeave a commentPosted in Information technology

Toggl is a mobile app for work hour recording and management. Toggl is not great because of the uniqueness but simplicity.

Bariloche, Scenery from Circuito Chico lookout

Traveling through Patagonia – Around the world trip days 30.11.2016 – 14.12.2016

Posted 29.12.201629.01.2017 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

This time I was totally alone. Once again I had no plans prepared and the plane would land in a few hours to Buenos Aires, Argentina.

Hidden Brain - Podcast Review

Hidden brain – Shankar Vedantam, NPR – When you want to know how the world works

Posted 27.12.201625.12.2016 Mikael AhonenLeave a commentPosted in Society

Podcast about society. Examples of topics: climate change, crime, women in leading positions and how is it like being rich?

Does it make sense anymore to buy Christmas presents? We took this kind of trailer loads to landfill eight times.

Does it make sense anymore to buy Christmas presents?

Posted 18.12.201618.12.2016 Mikael AhonenPosted in Society

Christmas is the festival of joy but buying presents is not so easy. Purchasing presents has became a social compulsion.

Freakonomics Radio Podcast

Freakonomics Radio, Stephen Dubner – Exploring the hidden side of everything

Posted 10.12.201620.12.2016 Mikael AhonenLeave a commentPosted in Society

The best podcast series on my opinion. The podcasts last typically from 30 to 60 minutes and during that time they try to find an […]

Queenstown, New Zealand

A place like a story book – New Zealand – Days 19.11.2016 – 30.11.2016

Posted 06.12.201629.01.2017 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

The whole country was like a painting. Let’s start with a mellow video of the jump to chilly mountain stream in New Zealand.

Knowledge worker's tips for better productivity

This is how I make my every second productive

Posted 15.11.201620.01.2019 Mikael AhonenLeave a commentPosted in Self improvement

Power methods for knowledge workers to get your productivity to the next level: Technology, Ergonomy, Work habits and Task automation.

Sustainable happiness - Pie Chart. How much genetic makes from happiness? A LinkedIn video course "Happiness Tips" by Chris Croft.

Happiness Tips, Chris Croft, LinkedIn Learning

Posted 13.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Self improvement

I didn’t have high expectations for this happiness video course based on my previous experiences. But this video course happily surprised me!

Newcastle obelisk view - Australia, NSW

Work stress that shouldn’t exist – Newcastle, Australia – Around the World Trip Days 11.10.2016 – 18.11.2016

Posted 11.11.201619.08.2020 Mikael AhonenLeave a commentPosted in Around the world trip, Free time

Newcastle, Australia. If I would be planning a torture chamber to a medieval castle I would contact Tiger Air company for sure.

Out of the box thinking - Sometimes pure logic leads to better results than the actual ideology.

Hated by everybody Trump got the second highest number of votes and became the President of USA – This is out of the box thinking

Posted 10.11.201610.11.2016 Mikael AhonenLeave a commentPosted in Society

Sometimes pure logic leads to better results than the actual ideology. What is out of the box thinking and how does it relate to Donald Trump’s victory?

Free Excel course.

The Free Excel Course Online

Posted 04.11.201606.11.2019 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.

Introduction to Excel for Excel beginners.

Lecture 1 – Introduction to Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Workbook, worksheet, saving, opening and options in Excel.

Formatting cells in Excel.

Lecture 2 – Formatting Cells in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Change font color, autofit column width, merge cells, use bold text and set borders.

The basics of Excel formulas.

Lecture 3 – The Basics of Excel Formulas

Posted 01.11.201629.01.2017 Mikael Ahonen1 CommentPosted in Free Excel course, Information technology

A brief introduction how to compose your first Excel formula.

Copy and paste in Excel.

Lecture 4 – Copy and paste in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Copy and paste only values, formulas or formattings in Excel.

Number formats, dates and time in Excel.

Lecture 5 – Number formats, dates and time in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Learn different number formats as well as Excel’s date and time system.

Cell references - Absolute and Relative - Defined names.

Lecture 6 – Cell references and named ranges in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

How to do absolute and relative references and name ranges.

Tables, sort and filter in Excel

Lecture 7 – Tables, sorting and filtering in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Sort, filter and summarize easily with Excel table objects.

Text formulas and advanced functions in Excel.

Lecture 8 – String functions and advanced formulas in Excel

Posted 01.11.201629.01.2017 Mikael AhonenLeave a commentPosted in Free Excel course, Information technology

Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().

Android vs Mikael. Yes. It's me in the picture. It was Halloween.

Creating my first Android app – How long it takes?

Posted 31.10.201629.01.2017 Mikael AhonenLeave a commentPosted in Information technology

Yes. It’s me in the picture. It was Halloween. Creating and Android app has been in my task list a good while but now I […]

Sports betting tutorial - Can you make living with it?

Sports betting tutorial – Can you make the living?

Posted 26.10.201619.08.2020 Mikael AhonenLeave a commentPosted in Information technology

It is actually possible to make your living by doing sports betting. This blog is not sponsored – these are my own experiences. Betting – […]

Visualization of earthquake data

Visualization and clustering of eartquake dataset

Posted 25.10.201604.11.2019 Mikael AhonenLeave a commentPosted in Information technology

The built-in dataset quakes in RStudio had 1000 records of earthquakes nearby Fiji. The first year of observations is 1964 but the last year remains […]

Posts navigation

1 2 Next

Search from site

 
Mikael Ahonen | mikaelahonen.com
Klikkaa OK hyväksyäksesi evästeet OK
Tietosuojaseloste
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.