Does Power Query requires training or reading a book, or even reading an article? I get this question a lot from those who started Power BI not long ago. Many users think that Power Query is just the get data from the source, and that’s it. Considering the many data source connectors in the Power Read more about Why data preparation and transformation? Why Power Query?[…]
A few weeks ago, my new book was published and is now available. As the Amazon web page for the book won’t allow me to put some more details about what it is, I thought it better to share some more information about it here. This book is available in all possible Amazon markets as Read more about Book Overview: Power BI DAX Simplified[…]
Small multiple is a relatively recent feature on some of the Power BI visuals. This feature enables you to have a much better visualization instead of trying to fit everything in one visual (over-complicate it) or create copies of the same visual (maintenance issue in the future). This is a simple feature to use, which Read more about Take Your Power BI Visualization to the Next Level using Small Multiples[…]
Have you ever tried to connect to a Power BI dataset from Excel using Analyze in Excel? if yes, you might have had this experience that your values don’t show in Excel’s Pivot table as values. This is because those values are not explicit measures, they are implicit measures in Power BI. In this article Read more about Explicit Vs Implicit DAX Measures in Power BI[…]
Bookmark is a helpful feature in Power BI. It enables you to have a good story to tell and also have a dynamic visualization. I have explained how bookmarks work in Power BI and how to use them with buttons to have a next-level visualization. An important attribute of the bookmark is the Data. You Read more about Power BI Bookmark: With or Without Data[…]
I have written two articles about fuzzy operations in Power BI and Power Query so far; fuzzy matching in Power BI, and fuzzy grouping. the methods above involve transforming the data with a fuzzy operation. However, sometimes you just want to know the similarity of values, or let’s say in other words; find the clusters. Read more about Fuzzy Clustering in Power BI using Power Query: Finding similar values[…]
An essential step towards a better analytics solution is to know your data. You have to know your data to be able to determine key columns, to learn what transformations need to be done, and etc. Power Query provides a very useful way of knowing your data in Power BI. Power BI has features for Read more about Know Your Data Better by Column Profiling In Power BI using Power Query[…]
I have explained previously what fuzzy matching in Power BI is and how to use it. In this article and video, I’ll explain Fuzzy grouping. Fuzzy grouping in short means grouping text values by their similarity based on a threshold, rather than exact equal values. This option at the moment is available in Power Query Read more about Fuzzy Grouping in Power BI using Power Query[…]
Age banding is a common scenario in analytics, and I have explained how it is possible in many different ways. One of the methods I have explained was using DAX measures and the TREATAS function. Sometimes, however, the age banding can be static, and Power Query can be used for the calculation, which would make Read more about Age Banding in Power BI using Power Query – Merge Queries Based on Between[…]
I have previously written an article with the full script of how to generate a date dimension in Power BI using the Power Query script, and I would always recommend that as the first choice. However, sometimes, you just want this to be in DAX way, so here in this blog and video, I explained Read more about All in One: Script to Create Calendar Table or Date Dimension using DAX in Power BI[…]