Visualizing numeric variables in Power BI – boxplots -Part 1

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[…]

Power BI Premium. Is It For You or Not?

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?[…]

K-mean clustering In R, writing R codes inside Power BI: Part 6

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[…]

Variable Width Column  Chart, writing R codes inside Power BI: Part 4

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[…]

ArcGIS Map in Power BI; Simple, But Insightful

I have written about 4 other types of map visual with Power BI before. In this post I want to explain how ArcGIS visual work as a map visual. There are some specific features in this visual which is simple to use, but will give you a lot of insight. With this type of map Read more about ArcGIS Map in Power BI; Simple, But Insightful[…]

One Data Set, Multiple Reports; Power BI Next Big Step Forward

You can use an existing data set with LiveQuery or DirectQuery connection as the shared data source for multiple Power BI reports. You can also create multiple reports from Power BI Service (website) connecting to the same data set. However, this new feature in Power BI Desktop version April 2017 is a big step forward; Read more about One Data Set, Multiple Reports; Power BI Next Big Step Forward[…]

Have more Charts by writing R codes inside Power BI: Part 1

Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia,  R is an open source programming language and software environment for statistical computing and graphics that is supported Read more about Have more Charts by writing R codes inside Power BI: Part 1[…]

Edition 2 of Free Book: Power BI from Rookie to Rock Star

As promised, here is the second edition (March 2017) of Power BI book; from Rookie to Rock Star as PDF. We are still working on other methods of sharing this book (Kindle, paperback…). In this new version March’s posts are added which are; M or DAX? Content Packs, Shape Map, and IF or Filter in Read more about Edition 2 of Free Book: Power BI from Rookie to Rock Star[…]

Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3

K Nearest Neighbour (KNN ) is one of those algorithms that are very easy to understand and it has a good level of accuracy in practice. In Part One of this series, I have explained the KNN concepts. In Part 2 I have explained the R code for KNN, how to write R code and how Read more about Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3[…]

Make Business Decisions: Market Basket Analysis Part 2

In the Part one I have explained the main concepts of Market basket analysis (associative Rules) and how to write the code in R studio. In this post I will explained the process of doing market basket analysis in Power BI. for doing this post I have used the data set from [1]. Power BI Desktop, is Read more about Make Business Decisions: Market Basket Analysis Part 2[…]