Fun with DAX – A-Maze-ing DAX

Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1

For a month I am looking to create a Microsoft App that user able to take a picture from an invoice then able to see the items in Power BI or store it in storage such as SQL server, excel and so forth. In this posts, first I will show how to create a Power Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1[…]

Fun with DAX – Mission Impossible

Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman.  To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer Read more about Fun with DAX – Mission Impossible[…]

Microsoft Business Applications Summit – 2018 Keynote (Live Blog)

I have front row seats at the keynote that will begin shortly.  As features and announcements are made, I will update here. The room is massive and filling fast.  I’m sitting with some true legends in right by the stage and there is an electric buzz in the air. And we are underway. Power BI Read more about Microsoft Business Applications Summit – 2018 Keynote (Live Blog)[…]

Dynamic Date Range from Slicer

A recent post on a community.powerbi.com forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. the preceding  10 months of data. If a user Read more about Dynamic Date Range from Slicer[…]

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 about Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data[…]

2017 Data Insights Summit – Key Note (Live)

Not just one but TWO live blogs from Radacad running so you won’t miss anything! Reza is also blogging here https://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 about 2017 Data Insights Summit – Key Note (Live)[…]

Optimising Power BI data models

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

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 about Azure ML Part 4: A Machine Learning Prediction scenario (1)[…]

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 about Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2[…]