Datalore tech review

 28 August 2023  6 min  Data science

Datalore is a collaborative data science platform. The notebook experience has been taken to the next level.

Wealth management web app - Technical implementation

 15 July 2023  5 min  Data science

Here is a presentation of the wealth management app I have developed.

Visualizing Finland's postal codes in a Filled map in Google Looker Studio

 3 May 2023  3 min  Data science

Visualize Finland’s postal code areas on a map in Google Looker Studio. The instructions requires a Google Cloud project and a BigQuery database.

Public report in Looker Studio requires login - Instructions to solve

 25 April 2023  3 min  Data science  2

Looker Studio is a free reporting and business intelligence tool in Google Cloud. Read this, if you are redirected to Google account login page after trying to share a Looker Studio report publicly.

Datalore - Introduction to the advanced analytics platform

 15 March 2023  1 min  Data science

Datalore is a fairly recent online platform for advanced data analytics.

Bodo is a faster alternative for Spark to run massive ETL jobs in Python

 14 March 2023  3 min  Data science

Bodo is a platform for data processing with Python and SQL. It is especially suitable for large datasets thanks to its unique parallel processing technology.

BigQuery for ML Engineers in Google Cloud

 1 December 2022  5 min  Data science

BigQuery is by far the most important storage and processing service in Google Cloud from ML perspective.

Machine learning products in Google Cloud

 27 November 2022  7 min  Data science

This is a summary of Google Cloud Platform (GCP) products relevant for Machine Learning Engineer role.

Clustering data using SQL - An example with industrial IoT data

 10 November 2019  2 min  Data science

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

Introduction to AWS Glue for big data ETL

 1 September 2019  1 min  Data science

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

Unpivot columns to rows with Excel PowerQuery

 1 October 2017  1 min  Excel

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

Lecture 7 - Tables, sorting and filtering in Excel

 1 November 2016  1 min  Excel

In Excel's table object you can sort, filter and summarize data effortlessly as well as select the formatting that fits your needs.