Videos
dbt-excel, the revolutionary dbt adapter that turns spreadsheets into data warehouses
Welcome to dbt-excel, the revolutionary dbt adapter that combines the rigor of dbt with the flexibility and familiarity of Excel. Get ready to change the way you look at data analytics forever. ...
The Problem with Tableau & Power BI
I love how Tableau & Power BI are constantly pushing each other to become better tools. Both of these tools come with an army of shiny features. But I believe could still learn a lot from DevOps an...
The Problems with KPI's (Key Performance Indicators)
KPI's are an invaluable tool to track the progress of your organization. But they can be a double-edge sword and here are 3 reasons why.
The Problem with Open-Source Dashboarding Tools
As soon as programmer hear about the cost of a tool like Tableau or Power BI, their first instinct is to look for an open-source alternative. So far, I haven't found a good one. Open-source alterna...
Tableau Calculation Mastery: Unpivoting & Last Date with Data
In this tutorial I show you how to combine two advanced formulas. The first one is how to unpivot a column (turn one column into multiple) using LODs. The second I show you how to calculate the las...
Power BI Hacks: Evenly-Spaced Tables
Have you ever tried to evenly space the columns of a table or a matrix? You know, just like in Excel. Only to find out this is not possible out of the box? Well, today I share how to get it done. T...
Power Query Tips: SQL Script from Files (part 2)
In the last video, I showed you how to modify your query based on a SQL script. Now we are taking it one step forward and turn it into a function that bulk loads multiple SQL scripts. If you have...
Power Query Tips: SQL Script from Files (part 1)
In this video, I show you how to modify your query based on a SQL script. Normally, you would need to copy and paste the code any time you change the script. But with some M magic, we can point Pow...
Mastering Power Query: Part 5 (Jedi)
This is the fifth and final video in a series of Power Query tutorials. In this video, I show you how to turn an M script into a reusable function. True M mastery comes from making your work robust...
Mastering Power Query: Part 4 (Pro)
This is the fourth video in a series of Power Query tutorials. In this video, I show you how to use the Advanced Editor and some M language commands to make your Power Query work more robust. Watch...
SQL Tutorial: Using SQLFiddle
SQLFiddle is a great tool if you want to test your SQL scripts. It is 100% web-based, you can use multiple SQL dialects, and it is easy to use. I personally use it to test my scripts with values th...
SQL Tutorial: Working with NULL values in T-SQL
In this video, I walk you through a use case in which I had NULL values, empty strings, and a variable number of spaces. I show you my line of reasoning and walk you through the formulas I used, be...
Mastering Power Query: Part 3 (Advanced)
This is the third video in a series of Power Query tutorials. In this video, I show you how to use the Advanced Editor and some M language commands to make your Power Query work more robust.
Power Query: Using M to make your work reusable (Advanced)
Power Query allows us to clean data with just some clicks. But you need to get your hands dirty with the M language to make your work truly re-usable. In this tutorial I walk you through a real-wor...
How to build a Tableau portfolio?
Are you looking for a Tableau job at the moment? Here are is some inspiration on how to make a Tableau Portfolio using Tableau Public.
Mastering Power Query: Part 2 (Intermediate)
This is the second video in a series of Power Query tutorials. In this video, I show you some best practices and how to avoid some nasty habits like renaming columns or leaving the change types in ...
Mastering Power Query: Part 1 (Beginners)
This is the first video in a series of Power Query tutorials. In this video, I show you how to get the job done (even if it wasn't always the best way possible). Watch the next videos in the series...
Using R script visuals in Power BI
Power BI makes it possible to embed R and Python visuals inside of your reports. Using this feature can add different levels of complexity, but it can be a game changer for those visualizations tha...
Sentiment Analysis with Alteryx (Using the R tool)!
In this video, I show how to use the R tool in Alteryx to do sentiment analysis. Then, we turn it into a macro so that it can be further re-used. This is not an R tutorial and I don't explain sen...
5 Google Sheets Tricks you might not know!
I cannot make it personally to the XKE, so I have decided to make a video as a replacement for my talk. I hope you can learn one thing or two from this video.
Tableau Calculation Mastery: 3 Ways to Split Columns
In this video I show you how to split a column in Tableau using 3 methods: 1) The easy way with Split 2) The Excel way with Find, Len, Left, and Right 3) The hard way with Regular Expressions
Using Google Sheets to Scrape Web data
This video teaches you how to use the =IMPORTHTML() formula from Google Sheets to extract data from a website.
Tableau Fun: Using Unicode characters instead of Custom Shapes
If your two axes are occupied, you can also use Unicode characters in your calculations as if they were custom shapes.
Excel-like Absolute Reference in Tableau
When Excel users start learning Tableau, they are always curious about how to calculate an absolute reference. In Tableau and in SQL, this is a bit more difficult, but it is also possible. This tut...
Tableau Time Series: How many in a certain moment?
How many members did the club have at a certain moment in time? The answer to this question is not as straightforward as you might think. In this video, I show you a solution to this problem. In ...