An undocumented product_id parameter in Pipedrive API to attach products to deals
I found an undocumented product_id parameter in Pipedrive API to attach products to deals. The issue is reported to Pipedrive dev team.
My Pipedrive partner SaaShop nominated as the EMEA Partner of 2021
SaaShop nominated as the Pipedrive EMEA Partner of 2021. I announced my co-operation with SaaShop recently.
My Pipedrive business has been aquired by saashop.com
My part-time company has signed a contract with Finnish SaaShop to move all my existing Pipedrive customers under their business.
Free data science workspaces
Google Colab, Databricks Community Edition, Visual Studio Code and Dcoker are some options to create a free data science workspace.
Comparison of machine learning platforms in major clouds
Comparing the major machine learning platforms AWS SageMaker, Azure Machine Learning, Google Vertex AI and Databricks.
What is a machine learning platform?
What is a machine learning platform? Introducing different components such as workbench, MLOps tools and cloud computation.
Machine learning in predictive maintenance
Machine learning in predictive maintenance. The two-part blog series provides insights for cost savings and an example script in Python.
Faking your geographical location to a web service – A hobby project
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 scientist and data engineer roles
In my opinion the big difference is that a data scientist focuses more on business problems while data engineer solves technical problems.
DataCamp – Learn data science online
Experiences from DataCamp online training. Structured data science courses are easy to organize for yourself or a team.
Databox for enterprise reporting – Review and demo
Databox enables elegant reports in a SaaS interface to be shared and published both internally and outside the organization.
PySpark execution logic and code optimization
The article goes through the PySpark execution logic and provides guidelines to optimize the speed and performance.
Pipedrive Essential vs Advanced – Comparison of features and pricing on 2020
Pipedrive Essential and Advanced are by far the most popular plans among my customers. A comparison of different subscriptions.
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 + Python tutorial for data developers
A tutorial for parallel computation with Spark and Python. The example has been ran on AWS cloud computing platform.
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 – 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 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.
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.
Blogging about professional topics – Experiences and tips
Blogging about professional topics is an excellent way to increase visibility for yourself and your company. Read the tips and experiences!
Industrial Engineering and Management in career – Video answers to questions from students
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 […]
Extended free trial period for Pipedrive CRM
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
Should you start investing if a depression is coming? – Data analysis
Investing when a depression is coming. Is it bad moment to start investing to stock index that are usually seen as sage bets?
Combining machine learning and business – Practical example
I give an example about machine learning use case in a format that should be understandable also for less technical people.
Maximizing uptime in Hiab hackathon
Read about Solita team’s solution in a hackathon organized by Hiab. The task was to take advantage of data to maximize machine uptime.
Unpivot columns to rows with Excel PowerQuery
Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.
Csv headers to list using Python
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 Do you have a list of emails that you want to split by first […]
A nation that seized the time – Lesotho
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.
Robberies in South Africa
9.1.2017 – 21.1.2016 I had bought a bus ticket from Cape Town to Johannesburg from BazBus bus company. With the ticket I was able to […]
Google Keep vs Evernote – Requirements for your note app
Personally, I use a note app to store ideas, observations, travel tickets and debts that should be quickly accessible.
Cape Town
The top attraction of Cape Town were beautiful Table Mountain and the Cape of Good Hope. The society has it problems, though.
From the Edge of the World to the Devil’s throat – South America
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 – Recording work hours to log has never been such enjoyable
Toggl is a mobile app for work hour recording and management. Toggl is not great because of the uniqueness but simplicity.
Traveling through Patagonia
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 – Shankar Vedantam, NPR – When you want to know how the world works
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?
Christmas is the festival of joy but buying presents is not so easy. Purchasing presents has became a social compulsion.
Freakonomics Radio, Stephen Dubner – Exploring the hidden side of everything
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 […]
A place like a story book – New Zealand
The whole country was like a painting. Let’s start with a mellow video of the jump to chilly mountain stream in New Zealand.
This is how I make my every second productive
Power methods for knowledge workers to get your productivity to the next level: Technology, Ergonomy, Work habits and Task automation.
Happiness Tips, Chris Croft, LinkedIn Learning
I didn’t have high expectations for this happiness video course based on my previous experiences. But this video course happily surprised me!
Work stress that shouldn’t exist – Newcastle, Australia
Newcastle, Australia. If I would be planning a torture chamber to a medieval castle I would contact Tiger Air company for sure.
Hated by everybody Trump got the second highest number of votes and became the President of USA – This is out of the box thinking
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 Online
The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.
Lecture 1 – Introduction to Excel
Introduction to Microsoft Excel. What is workbook and worksheet? How to add and delete worksheets? Where to save and open Excel files?
Lecture 2 – Formatting Cells in Excel
Learn how formatting cells in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells.
Lecture 3 – The Basics of Excel Formulas
In the Excel formula basics lecture we’ll first mix numbers and text to create generic sentences and then we use SUM and IF.
Lecture 4 – Copy and paste in Excel
It’s possible to paste only specific components of you data such as formulas, values or formattings. Make you workbook great again.
Lecture 5 – Number formats, dates and time in Excel
Number formats allow you to preserve the original cell value while displaying it as percentage, currency, date or time format.