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

Clustering data using SQL - An example with industrial IoT data

Clustering time series data with SQL. The purpose of this experiment was to prove that doing data science doesn’t always require fancy tools.

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

Excel Power Map - Spatial data visualization as a time series

Excel Power Map is designed to visualize spatial data. The tool is also known as Excel 3D Map. Watch my Power Map demo video from Solita’s blog here .

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

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

This is a summary from the original Finnish blog article. Data analysis result: Invest only the money you don’t need at the moment The purpose of the stock market analysis was to answer this question: Is it good idea time to start regular investing if a depression is coming?

Learn how formatting cells in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells.

Lecture 2 - Formatting Cells in Excel

Back to Excel course main page Formatting cells in Excel Learn how to formatting cell in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells to enhance the final result.

NaN

Visualization and clustering of earthquake dataset

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 unknown.

Excel Power BI lisäosien perheeseen kuuluvat Power Query, Power Pivot, Power Map ja Power View nopeassa esittelyssä.

Introduction to Excel Power tools

Next I will introduxe briefly how Power tools in Microsoft Excel Power BI family are related to each other. That way you quickly realize whether they fit in your needs or not.