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

This post is part of a series about specifications, requirements, work items and test-cases in the field of Business Intelligence solutions. First part is about why I hate and I’d not recomme…

In this article, you will learn about the secret of creating good reports.

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 ...

Following data visualization design principles is key to making your dashboard easily consumable.

Identifying and removing chart clutter reduces visual “noise”, allowing the audience to focus on the information.

How do you make sense of a mass of data, to gain insights and inspire people to change? Learn how story techniques can help the data analysis process.

Learn to select best Excel Charts for Data Analysis, Presentation and Reporting within 15 minutes. Learn about the various excel charts types.

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. …

3 common reasons why data visualization dashboards fail, and 7 best practices to make sure they don’t

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…

Hello community   I would like to share with you a Power BI report, which can help you to choose the most suitable chart for your data. You must enter the properties of your data in the filter on the left, to obtain a list of graphics that put forward your data. You can also click on a chart to see ...