Put your FAQ search on steroids with Elasticsearch and GPU — In a previous post we created a simple “string match search” to find German/English translations. In a figurative sense, we can also call this translation table a kind of FAQ. FAQ search is said to have the following positive characteristics: very fast at inference time gives good control over answers …

Tkinter vs Excel VBA — User-friendly search masks are almost indispensable in today’s flood of data. In this article we will see how to develop a responsive search for translation purposes using Tkinter and compare it with VBA.

Exhaustive Sudoku solving bot tutorial: Image and optical character recognition plus text to speech — In a previous article we created a bot called Isaac (inteligible solution for administrative and analytical communication). In this post we will teach Isaac how to play Sudoku. Isaac will receive eyes to see, hands to write and a mouth to speak. With those skills Isaac will be able to…

Applied statistical process control on financial write-downs — Depreciation refers to an accounting method used to allocate the cost of a tangible or physical asset over its useful life. In this post the value of an asset used is amounted monthly per profit and cost center. Accounting for depreciation can greatly affect one’s profits. That’s why it is…

Extracting SAP’s tables automatically with SQUIR — Are you frequently running SE16N transaction to extract tables out of SAP? If you want to automate this, here you’ll find the solution. Squir (SAP querying intelligent robot) is a standalone application. The programme is made of Python, an Excel template for parameter selection, and screenshots which the bot needs…

Are quality control charts an underestimated concept of sales analysis? — One sub field of statistics is statistical process control (SPC). SPC is hardly ever mentioned in any books about data science. Top of that SPC is scarcely used with sales data. I believe that SPC is misprized in this analytical conception. Actually SPC can be a much supportive supplement for…

Use RPA, PyAutoGui, and Pandas to avoid repetitive manual work in SAP and your data warehouse — Background: Do you frequently export data from SAP or other ERP systems? Do you then spend some time with data wrangling before you import into your data warehouse? Afterwards don’t you forget to conduct some data validation checks and send an email to a colleague if any of your plausibility…

Workrooms for immersive online Python trainings — While Facebook is making a big bet on the Metaverse, we have set up a Learniverse. We want you to get the best out of all worlds during your Python training journey. Medium articles, books, Youtube tutorials and (online) training are all well known. But with usual online meetings we…

Conveniently tinker with LSTM and Apriori parameters in Excel — Motivation: We already learned how to code market basket analysis, time series forecasting and recommending engines in Jupyter Notebook in previous posts. We also know how to Pyinstall these Python scripts into exe files and connect with Excel wings. …