Power BI Power BI Visual Padding using themes Jun 4, 2023 Jose CherianVisual 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…
Kaggle Machine Learning Kaggle API – The Missing Python Documentation Feb 19, 2020 Jose CherianOfficial 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 Tableau Prep Python Integration – Installing and Setting Up TabPy Sep 20, 2019 Jose CherianTableau 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…
Tableau Prep Tableau Prep – Aggregating Strings Aug 28, 2019 Jose CherianAggregating 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…
Tableau Prep Tableau Prep – Iterating Group And Replace Jul 30, 2019 Jose CherianWe 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?…
Tableau Prep How to connect to FTP with Tableau Prep Jun 24, 2019 Jose CherianIt 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…
Tableau Prep Tableau Prep Email Alerts May 4, 2019 Jose CherianIn 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…
Tableau Prep Tableau Prep – Future Proofing Group and Replace Apr 25, 2019 Jose CherianIn 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…
Tableau Prep Tableau Prep Tip – Getting Group And Replace Right At One Go For Enormous Data Sets Apr 20, 2019 Jose CherianGroup 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 Tableau Prep Tableau Prep – Connecting to REST API Apr 6, 2019 Jose CherianTableau 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…