For me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I came across most talked Bullet Chart and Highlighting a…

Being an analyst with modern visualization technology is fun and enriching. Who doesn’t enjoy a stunning visual with useful and easily consumable insights? The reality is: even the most thoughtful authors have blind spots. Why? Because authors have significant amount of background knowledge that is ...

We have a very special new member to the custom visuals gallery: the Dual KPI. Dual KPI efficiently visualizes two measures over time. It shows their trend based on a joint timeline, while absolute values may use different scales. The reason this visualization is special is because we use it at Microsoft in executive dashboards to monitor usage and user satisfaction for each product, or when an executive wants to keep an eye on two KPIs at the same time (for example Profit and Market share or Sales and Profit).

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well placed search and replaces should fix

In this module you will learn how to use the Synoptic Panel Power BI Custom Visual.  The Synoptic Panel is really one of the more impressive visuals available. This visual allows you to take an ima…

In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between a source and destination. Module 28 – Sankey Do…

In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual.  This is the first of two Box and Whiskers visuals that we will cover. The Box and Whiskers chart …

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Every day the members of Microsoft’s Treasury group have to make smart decisions about how to manage the company’s $158 billion in assets. Their guide to these decisions can be found in data and information analysis, and one of their tools of choice to manage this process is Microsoft Power BI. One amazing example of this data in action is the US Consumer Personal Spending dashboard, created by Investment Analyst, Carlton Gossett. This dashboard displays publicly available information in a dynamic, interactive way, allowing Treasury to quickly get a feel for consumer spending in the US and ...

Summary   "How is my company doing?"   It's a question we hear often. It seems simple enough, but answering it is a complex process. This report is designed to answer the question in a clear and straightforward manner, while providing enough detail to take some action.   If we wanted to further dev...

Like the name suggests, a pyramid chart has a triangular structure. Lines run across it, dividing it into sections with thicknesses proportional to their values. A pyramid chart represents data in the form of percentages, with the whole chart representing 100%. A pyramid 3D chart built with Collabion helps you visualize the total data, as well as the hierarchical structure of it, in the form of a pyramid-like structure. A filtered pyramid chart, on the other hand, is represented in the form of a graduated glass pyramid filled by liquid, where the graduations indicate the values of different...

Vizion Solutions new and improved look and feel to the Sales Manager Scorecard eyJrIjoiNmI3NTYxYTgtMWYzNi00NGJhLTk5ZTgtNzcwN2ZhMjdjNzgzIiwidCI6ImU0OTdiODdkLTA2MmQtNDAzZS1iNWMxLTNlZGNhN2IzNTUwNyIsImMiOjN9

Dashboard for Messi´s worldrecord of 91 goals in one year (2012), with details like mode ('left/right foot'), opponent, competition etc. For more details, see my blog: http://worktimesheet2014.blogspot.com/2016/12/powerbi-dashboard-for-messis.html eyJrIjoiOWYxMTVkNTUtZjJjMy00NTcyLWJlMzctNmNlYzE5ZmQy...

Power BI Dashboard Filters sometimes cause confusion. In this article, I will show how you can filter a dashboard using live tiles.

Infographic visualizations are getting increasingly popular, and have been widely adopted in the real world. As research reveals, they can improve the effectiveness of visualizations by making data quickly understood and easily remembered. However, current data visualization systems lack supports for generating infographics. Infographic Designer (a.k.a. InfoNice), released as a Power BI custom visual, enables easy creation […]

Esri is a leader in the GIS industry and ArcGIS is a very popular product to build great maps. Now, you can use ArcGIS maps in Power BI (in preview). See the official information here: This is real…

Learn to visualise Google Analytics data via Microsoft Power BI. Power BI can be connected to various data sources including ‘Google Analytics’.

We’re excited to share at Microsoft Ignite that soon Power BI users can use ArcGIS Maps for Power BI (preview) created by Esri. This preview will bring new capabilities to all Power BI users. The ArcGIS Maps for Power BI visual is provided by Esri. ArcGIS Maps for Power BI visual goes a step beyond. Not only can you plot data points from Power BI, but you can also add reference layers. Layers include a selection of demographic layers provided by Esri and public web maps or those published into Esri’s Living Atlas. You will be able to create a compelling analysis that also provides reference...

PowerBI allows users to add measures to tooltips. Many users want to add text columns as well. Today if you drag a text column to the tooltips, a count measure is created which is not very useful. …

If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy footba…

You may think that Sentiment Analysis is the domain of data scientists and machine learning experts, and that its incorporation to your reporting solutions involves extensive IT projects done by advanced developers. Well, today this is going to change.   Today I will show you how to gain Sentiment A...

This is a collection of the entire, growing series of posts about the 'little of visualisation design', respecting the small decisions that make a big difference towards the good and bad of this discipline.

With the update of Power BI last week you can now add your own maps in any size or shape to Power BI so you can extend the set of out of the box shapes that come with Power BI. This is possible bec…