Introduction There are a few ways you can use SQL in Polars. One option is to use other libraries such as DuckDB and pandas. And another option is to actually run SQL without using other libraries. I’ll be demonstrating the latter in this blog post. Please refer to this post on how to use DuckDB…
Author: Yuki
The Difference Between LASTNONBLANK and LASTNONBLANKVALUE in DAX
There are so many useful functions in DAX, however, there are also some functions that are not too intuitive to understand. I’ll cover such functions particularly LASTNONBLANK() and LASTNONBLANKVALUE() in the blog post. Note that the difference I explain in this blog post also applied to FIRSTNONBLANK() and FIRSTNONBLANKVALUE() I use Contoso dataset in DAX.do…
How To Create Views in BigQuery
In this post, I’ll introduce two easy ways to create views in BigQuery directly in Google Cloud console. Option 1 – Create and run your query. Then save it as view. 1. Create a query for your view & run the query 2. Just click save as view Option 2 – Use “Create View As”…
How to Create a Hex Map in Power BI
Learn how to create a hex map in Power BI
Format All DAX Measures at Once
There are tools that help you format your DAX code such as Tabular Editor and daxformatter.com. They can only format your DAX one by one. Have you ever found yourself doing that before? Then this blog post is for you. With C# scripting in Tabular Editor, you can format your DAX measures all at once!…
What are Power BI Dataflows?
The Simplest Guide for Power BI Dataflows There are resources out there explaining what dataflows are in Power BI. But they often include some jargon and are not straight to the point. I simplified as much as I can so that you spend less time in understanding what they are and when you should use…
Calculate the Max Sales Amount for Product
Setup I use the Contoso data model. You can access it dax.do or download pbix here. The data model looks like this: Code The result looks like this: Validating the output: Here’s the full code I used in dax.do: Explanation VALUES() gets unique products from product table. You could just reference the table, but I…
Convert DataFrame to Series in Polars
There are basically 2 ways to do this. Some may think that df.select(‘Your Column’) alone would work but nope. It doesn’t return a series object, it returns a dataframe object instead. Source code: Github repo
Pandas vs Polars – Speed Comparison
Pandas and Polars Pandas is probably the most popular library for data manipulation and analysis. If you work in data, I’m sure you have heard about it or you may use it on a daily basis. Pandas is very useful and versatile in various data tasks, however, the main issue that’s being talked about is…
Polars with DuckDB – Using SQL in Polars
Polars and DuckDB We see that Polars and DuckDB seem to be the same kind of tools, where we can use them for data analytics, data science, and data engineering tasks, with great performance. I’m not going into which one is better than the other, but I’d like to show you a good way to…