Interactive spreadsheets help free up your time — If you are like me and run your own practice (business, freelancing, publishing, whatever you want to call it), you probably use some form of a spreadsheet. …

Show users what they want (even though they don’t even know what they want) — Personalized content proposals are now an established element of the Web. Most social media serve content to their users based on multiple touchpoints of the user’s interaction with the platform. (Some of them also track the user outside their pages, which has caused a whole discussion about privacy and blocking…

How to detect seasonality, forecast and fill gaps in time series using Fast Fourier Transform — In this article, I will show you the uses of the Fourier transform in time series analysis. We will use the Fast Fourier Transform algorithm, which is available in most statistical packages and libraries. Visualisations and code examples in Python supplements this article. All are available in this notebook (Google…

With the help of technology and science — Residents of my city (Iława, Poland) increasingly report that there is a growing problem of rubbish that ends up next to an overflowing bucket in the city or is thrown into the neighbourhood bins. During the tourist season, street bins overflow, despite daily emptying by municipal services. Iława is “drowning”…

Banners for All Your Markets — Depending on your industry, the language of communication with potential clients can be more or less important. Every content must be in the language with which your users feel most comfortable. Translating your banner advertisement into other languages can really impact the effectiveness of your marketing creatives. In my experience…

Create a Dashboard for Free with Google Sheets and C3.js — online visualization of spreadsheet data. — We often have some business data that we need to track. We collect, process and store it in spreadsheets to then create charts and diagrams. However, sometimes there is a need to go out to a non-technical audience. …

Google Sheets as database, Apps Script as backend — Sometimes we have some data stored in a spreadsheet that we would like to make available to other applications, such as dashboards that visualise it. Of course, the growing number of applications and functionalities most often leads to a transition to the use of a real database. But sometimes, we…

Email is an important channel for communicating with your audience. There are plenty of email marketing platforms on the market. Most platforms offer some free tier (usually 2000 recipients per month), but the majority adds their logos to every email you send. Costs with an increasing number of users can…

Translate GTK app using Gettext and Localazy — Typically, when you start developing a new app, its interface is in a specific language, perhaps English, if you want to reach an international audience. By translating your app into other human languages, you can increase the number of people who can install, use, and recommend it. A few weeks…