Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data

It’s been a while since the last post about Power BI REST API. I have written previously about how to get the REST API, and use it in your application, how the authentication works, and things such as embedding content, and data source management. In this post, I’m going to explain one of the functionalities ...

Read More

2017 Data Insights Summit – Key Note (Live)

Posted by on Jun 13, 2017 in Uncategorized | No Comments

Not just one but TWO live blogs from Radacad running so you won’t miss anything! Reza is also blogging here http://radacad.com/microsoft-data-insight-summit-2017-keynote-live-blog 5 mins to go. Sitting between Chris and Alberto. We are delayed due to the massive influx of attendees queuing to get in. James Phillips speaking now Summit sold out 5 weeks early 2500 ...

Read More

Optimising Power BI data models

Posted by on Jun 3, 2017 in ETL, Power BI, Uncategorized | 8 Comments

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

Azure ML Part 4: A Machine Learning Prediction scenario (1)

In previous Posts Part 1, Part 2 and Part3  I have explain some about the azure Ml environment, how to import data into it and finally how to do data transformation using Azure ML component. In this post and the next one I am going to show how to do a Machine Learning in Azure ...

Read More

Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2

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

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

Clustering Concepts , writing R codes inside Power BI: Part 5

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

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