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[…]
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[…]
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[…]
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[…]
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[…]
DAX has many functions to write conditional expressions. For example you might want to calculate sum of sales amount for all “Red” products. you can achieve it by using SUMX or Calculate, and functions such as IF or Filter to write a conditional expression for product color to be equal to “Red”. At the first Read more about IF and Filter are Different! Be Careful (DAX)[…]
In previous posts, I have showed the process of creating a live weather data streaming with Cortana. In Part 1 the process of setting up Raspberry PI3 and weather station sensor has been explained. Following, in Part 2, the process of setting up the Event Hub as a median to digest the data from Raspberry PI Read more about Part 4 – Live Streaming Weather Station with Cortana Analytics (Online Data Analytics with Azure ML)[…]
In previous posts (part 1 and part 2), I have explained the process of data live streaming. In the first post, I have explained the process of setting up the Raspberry PI 3 and Weather station. In the second one, I have explained the process of setting up the Event Hub that helps us to. In Read more about Live Streaming Weather Station with Cortana Analytics – Part 3[…]
I have previously written some blog posts about Map visuals in Power BI. One of them was specifically about Filled Map, titled as Filled Map; the Good, the Bad, the Ugly! Why? you need to read that post to find the reason. In this post I want to explain the power of Shape Map which Read more about Shape Map Better than the Filled Map[…]
There are many ways to share Power BI content with others. I have previously written about some of these methods, including Workspaces (or groups) in Power BI, Publish to Web, and Power BI Embedded. In this post, you will learn about organizational content pack which is another method of sharing. This method is a recommended Read more about Content Pack; Sharing, Self-Service and Governance Together[…]