ZhongTr0n

I'm a data consultant providing services in a broad range of data solutions. My specialities are mainly situated in Azure and Power BI and NLP for which I also write articles.

I built this VIM styled website to bundle all my articles, posts and social media accounts. Most of the articles are written on Medium, but this site uses the "friend-links" which provides free access.

Posts & Articles

Add a User-Friendly Disclaimer to Your Power BI Report

February 2023
POWER BI | DATA VISUALIZATION

Combine bookmarks and transparant buttons to add a clutter free disclaimer to your reports.

Build a Web-scraping API in Under 30 Minutes with ChatGPT and Azure Functions

December 2022
AZURE FUNCTIONS | PYTHON | ChatGPT

Azure Functions let's you build API's in minutes. Combining this with ChatGPT makes it possible to build useful tools in no time.

The Unrealistic Expectations of IT-Recruiters: A Data Analysis

January 2022
NLP | PYTHON | NETWORK ANALYSIS | DATA VISUALIZATION

Using a combination of NLTK, RegEx and NetworkX I analyzed a dataset of job descriptions. In the analysis I focus on the unrealistic expectations recruiters often set forward.

How It's Built Network Chart

Automating Instagram Comments Using Image Recognition

Create a Stacked Funnel Chart

April 2021
POWER BI | DAX | DATA VISUALIZATION

A junior colleague told me it was not possible to create a stacked funnel chart. Taking this is a challenge I tried to use some DAX creativity to create one anyway. The result came out great, so I decided to share the steps and the code with the community. This article covers the full tutorial on how to build on yourself.

Detecting Mumble Rap Using Data Science

October 2020
NLP | PYTHON | SPEECH-TO-TEXT | GOOGLE CLOUD | DATA VISIUALIZATION

Using a Google speech to text API and NLP, I built a model that can classify rap as mumble. My personal favorite :).

Safety Considerations For Working With Data

April 2020
INFOSEC

Looking at data from an infosec perspective. This article lists key considerations related to IT security when working with data.

Benchmarking Off-The-Shelf Sentiment Analysis

March 2020
PYTHON | SENTIMENT ANALYSIS | POWER BI

Power BI introduced multiple out of the box AI features to generate more advanced insights. One of these insights is a classic sentiment analysis. Being curious on how well this AI feature worked, I decided to do some benchmarking.

Add Category "Other" to Charts

February 2020
POWER BI | DAX | DATA VISUALIZATION

Categorical charts can often become cluttered with too many small partitions. For this reason, data analysts often resort to an aggregated "other" category, which groups all the small partitions. In Power BI it's not possible to create a dynamic "Other category". So I got my hands dirty on some DAX to provide a solution.

Implement AND/OR Selection<

December 2019
POWER BI | DAX | DATA VISUALIZATION

There are plenty of ways to filter your data in Power BI, using both slicers and filters. The default behaviour of Power BI filtering is "and filtering". Meaning, if you select two categories for example location and time, it will only show results that match both of these criteria at the same time. Sometimes you might prefer "or-filtering". And ideally, you might want to toggle in between both modes. I built a solution to help you provide the functionality to the end user.

What is Dax? And Why you Should (or Should Not) Learn It

October 2019
POWER BI | DAX

When working with Power BI, you might have heard of DAX or Data Analysis Expressions. But what is DAX? What can you do with it and is it worth it to invest time to learn it. In this article I try to answer all of those questions for you.

Power BI: How I Started Using Python To Automate Tasks

July 2019
PYTHON | POWER BI | FLASK | WEBDEV

Less data in your Power BI report means better performance. But after spending days building a report, you might have so many widgets that you lose track on which fields you actually used and which ones you could remove from your report. The only way to evaluate this is by going over each widget and writing down which data is used. As a developer I despise manual monkey work, so I wrote some Python to automate this task for me.

5 quick ways to speed up your Power BI dashboard

May 2019
POWER BI | DAX | POWER QUERY

One of the most frequently asked questions I am asked by Power BI developers is how they can speed up their reports. It doesn't take too many widgets or records to bring your report down to a crippling pace. Fortunately there are numerous ways to bring the speed back up. In this article, I share some quick wins you can implement right away to speed things up.

Create categorical choropleth with Python

May 2019
PYTHON | MATPLOTLIB | DATA VISIUALIZATION

My very first blog post. A client asked me for a categorical choropleth map in Python. Not being able to find a library to provide this (whith shapefiles) I tried to create a custom solution. As the result turned out great, I decided to share the steps and code with the community. To my surprise this was picked up by Towards Data Science.