In this tutorial, we’re going to dive into frequency tables in Excel as well as proportion tables. We’ll look at what they are and when to use them. You can watch the full video of this tutorial at the bottom of this blog. Categorical variables measure “what kind of something” whether it’s a customer’s buying
Tag: Pivot Query Editor
I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen, but don’t really know what they do. In this tutorial, I’d like to highlight the Power BI Modulo and
There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature in the Query Editor within your data queries. One thing to bear in mind early