Techno Whisp

Visual padding was a long awaited feature in Power BI and Microsoft added support for it  in 2023-March release of Power BI. In the past, users had to use dirty…

Official Kaggle API is a command line utility written in Python3, but the documentation only covers command line usage and not Python usage. This post will explain how you can…

Tableau Prep Python integration was added in  2019.3 and this post shows how to install and setup TabPy for Tableau Prep. Tableau recommends to run TabPy in a virtual environment…

Aggregating strings is a common task in data cleaning, but it is not yet supported in Tableau Prep out of the box.  This post is inspired by a Tableau community…

We can setup up a trigger to receive email alerts when ungrouped categories are detected in the flow, but how do we modify the flow to group the ungrouped categories?…

It is common to use FTP as a file transfer mechanism between businesses. Tableau Prep cant connect to FTP out of the box, but we can make it work with…

In  future proofing group and replace post, I promised to write about generating an email alert when ungrouped data is detected by the flow. We will use that scenario for…

In the last post, I shared a tip to to ensure  guaranteed grouping on all existing data in a data set. But what if your flow is scheduled to run…

Group and Replace feature in Tableau Prep is  one of my favorite as it can standardize fields using many of the built-in algorithms.  But it has its caveats; Algorithms are…

Tableau Prep or Tableau does not have A built in rest API connector, but we can download data from rest API using  Power Shell and pass it to  Tableau Prep…