Power BI Desktop file stores many metadata information in it, one of the most important piece of information stored there is Power Query M scripts. It is always easy to open a PBIX file and realize the queries in Query Editor Window. However, if you have many queries and you want a way to get Read more about Exposing M Code and Query Metadata of Power BI (PBIX) File[…]
For this blog I thought I would share a handy trick for optimising Power BI using a data modelling solution that is often forgotten or overlooked. It involves focusing on certain columns based on the degree of uniqueness they contain and converting or removing all together from a data model. I will explain how and why this Read more about Optimising Power BI data models[…]
I read a quote somewhere along the lines of… If you are trying to solve a problem with regular expressions… you now have two problems This seems a little harsh for a useful tool that has been with us for what seems a very long time. Plenty of languages offer support for Read more about Power BI and Regular Expressions[…]
I recently encountered a question posed to the Power BI community forum I found interesting enough to kick-start my blogging on Power BI. The essence of the question was asking how to dynamically determine distances between two geographic points from user based selections. So I thought I would cover how this can be done in Power BI to Read more about Dynamic distances in Power BI[…]
In the Part 1 I have explained some of the main statistics measure such as Minimum, Maximum, Median, Mean, First Quantile, and Third Quantile. Also, I have show how to draw them in Power BI, using R codes. (we have Boxplot as a custom visual in power BI see :https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/ ). However, to see the data Read more about Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2[…]
In this post and next one, I am going to show how to see data distribution using some visuals like histogram, boxplot and normal distribution chart. It always important to have a holistic perspective regarding the minimum, maximum, middle, outliers of our data in one picture. One of the chart that helps us to have a Read more about Visualizing numeric variables in Power BI – boxplots -Part 1[…]
There were many announcements earlier this month about Power BI. One of them which was and still is the breaking news of all is Power BI Premium. Many of you already know that it is a new licensing plan, but how it works? Is this a licensing plan that works for you or not? What Read more about Power BI Premium. Is It For You or Not?[…]
In the previous post,I have explained the main concepts and process behind the K-mean clustering algorithm. Now I am going to use this algorithm for classifying my Fitbit data in power BI. as I have explained in part 5, I gathered theses data from Fitbit application and I am going to cluster them using Read more about K-mean clustering In R, writing R codes inside Power BI: Part 6[…]
Sometimes we just need to see the natural trend and behaviour of data without doing any predictions. we just want to check how our business data can be naturally grouped. According to the Wikipedia , Cluster analysis or clustering is the task of grouping a set of objects in such a way that objects in the same group (called a cluster) Read more about Clustering Concepts , writing R codes inside Power BI: Part 5[…]
In the part 1, I have explained how to use R visualization inside Power BI. In the second part the process of visualization of five dimension in a single chart has been presented in Part 2, and finally in the part 3 the map visualization with embedded chart has been presented. In current post and next ones I Read more about Variable Width Column Chart, writing R codes inside Power BI: Part 4[…]