After a whirlwind 4 days in Seattle I finally have some time to think back over the Microsoft Data Insights Summit and digest what were probably some of the more interesting points to come out of the Summit. Most of these came from the keynote so if you would like more detail on any of Read more about 5 interesting points from MDIS 2017[…]
Power BI REST API has changed a lot recently, especially for embedding Power BI content. Through my session in Microsoft Data Insight Summit 2017, It was my pleasure to speak about changes and have a session full of demos working with the new REST API. Areas that I’ve focused for this session was embedding Power Read more about Power BI for Developers – Session Slides, Materials, and Recording – Microsoft Data Insight Summit 2017[…]
Thanks everyone to attend my session in Microsoft Data Insight Summit 2017 about Data Visualization. It was a pleasure to see you all. Here I put the session materials to download and links as reference to study more. Please feel free to ask your questions here. My session was over booked with 650 registrations, and Read more about Session Materials & Recording: Take Power BI Visualization to the Next Level – Data Insight Summit 2017[…]
Hello from Keynote of Microsoft Data Insight Summit 2017. I’m sitting at the blogger table (there is no table actually, just chairs 😉 ) and will be blogging live from here new announcements and live events from the keynote. Watch this blog and refresh your page 🙂 7:51am: Sitting in press chair. people are filling Read more about Microsoft Data Insight Summit 2017 – Keynote – Live Blog[…]
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[…]