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.
In my opinion the big difference is that a data scientist focuses more on business problems while data engineer solves technical problems.
Experiences from DataCamp online training. Structured data science courses are easy to organize for yourself or a team.
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.
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 – Nice 3D visualization using simple logic. Python notebook example in GitHub with industrial data.
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. Read the full post from data.solita.fi.
Excel Power Map is designed to visualize spatial data. Watch the demo video about visualizing annual asylum seeker data.
I wrote to Solita’s blog about text analytics with the headline “Finnish stemming and lemmatization in python”. The post has code examples.
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!
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 […]
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
Investing when a depression is coming. Is it bad moment to start investing to stock index that are usually seen as sage bets?
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.
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.
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 […]
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.
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 […]
Personally, I use a note app to store ideas, observations, travel tickets and debts that should be quickly accessible.
The top attraction of Cape Town were beautiful Table Mountain and the Cape of Good Hope. The society has it problems, though.
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 is a mobile app for work hour recording and management. Toggl is not great because of the uniqueness but simplicity.
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.
Podcast about society. Examples of topics: climate change, crime, women in leading positions and how is it like being rich?
Christmas is the festival of joy but buying presents is not so easy. Purchasing presents has became a social compulsion.
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 […]
The whole country was like a painting. Let’s start with a mellow video of the jump to chilly mountain stream in New Zealand.
Power methods for knowledge workers to get your productivity to the next level: Technology, Ergonomy, Work habits and Task automation.
I didn’t have high expectations for this happiness video course based on my previous experiences. But this video course happily surprised me!
Newcastle, Australia. If I would be planning a torture chamber to a medieval castle I would contact Tiger Air company for sure.
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?
The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.
Workbook, worksheet, saving, opening and options in Excel.
Change font color, autofit column width, merge cells, use bold text and set borders.
A brief introduction how to compose your first Excel formula.
Copy and paste only values, formulas or formattings in Excel.
Learn different number formats as well as Excel’s date and time system.
How to do absolute and relative references and name ranges.
Sort, filter and summarize easily with Excel table objects.
Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().
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 […]
It is actually possible to make your living by doing sports betting. This blog is not sponsored – these are my own experiences. Betting – […]
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 […]