Data Mechanics
Hello there and welcome, I’m Klaus a Power BI and Python Developer. Here I share my projects and articles on Python, business intelligence, and practical machine learning.
Projects
PyDAX
PyDAX is a python package designed to analyze DAX, it can extract comments, remove comments, and identify columns and measures referenced in DAX expressions.
Measure Killer
An external tool for Power BI and Microsoft Fabric developed by the Brunner BI Team. Its main goal is to detect unused columns and measures from a Power BI model.
World Data Report
The World Data Report is a Power BI project that offers a detailed overview of global data, covering weather, geographical, demographic, and socio-economic aspects.
Stock Intelligence
A Power BI report for analyzing stock market data using Yahoo Finance APIs. It can be refreshed anywhere and does not require an API key.
Eletric Motors Anomaly Detector
An investigation of machine learning strategies for electric motor anomaly detection using vibration and audio signals. Article published on Engineering Computations (ISSN: 0264-4401) on 10 December 2024.
Youtube downloader
An easy to use Python GUI based application. The YouTube Downloader allows you to download videos or audio from YouTube by simply pasting the URL.
Latest posts
-
Avoiding RecursionError in Qt Tree UIs with Iterative DFS
Today I want to share a Python trickt hat has been very useful in our UI code for Measure Killer. Credit for this suggestion to Pedro Smiderle, my college at Brunner BI and an absolute python legend. The problem is simple to describe: when a user checks or unchecks an item in a tree (basically…
-
Quick fix for outdated Usage Metrics Report in the Power BI Service
A while back I wanted to check the usage metrics for one of my reports in the Power BI Service, to see the page views and report opens. So I used the good old ‘View usage metrics report’ under the ‘More options’ of the report. It opened the Usage Metrics Report, but to my surprise…
-
An Easy Way to Handle Chained Discounts in Power Query
Introduction In a recent Power BI sales project, I needed to calculate the final price for each order after applying multiple discounts. At first, I tried a “row-by-row” approach, but I quickly realized it was complicated and had poor performance. After looking into other options, I found a simple and efficient way to calculate a…
Power BI Reports
About the Author
Hello there, I’m Klaus Jürgen Folz, a Microsoft-certified Power BI Data Analyst (PL-300) and a Mechanical Engineer. I work as Python and Power BI developer in Austria. I’m also the lead developer of Measure Killer, a Power BI external tool with more than 100k downloads. My goal with this site is to share my knowledge and the small wins to help developers like me.