Power BI

A big data visualization solution in Microsoft Power BI summarizes and tracks performance against business objectives while Microsoft Core Services Engineering and Operations drives results. This solution refines large amounts of data into accurate and actionable insights for the entire organization. It improves satisfaction, enables growth, and drives operational effectiveness on Microsoft’s road to digital transformation.

The importance of empathy in stimulating a data culture, one where others want to participate.

Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop . Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. He

If you have a set of goals that you want to rollover into a new scorecard, or just want to bulk copy goals across scorecards, this utility script can save you some time by automating the copy process. What gets copied:    - Scorecard name, contact, and description (when duplicating scorecards)    -...

Inforiver launches the Premium Edition in Microsoft Appsource. Read more for the use cases on Premium edition's powerful capabilities.

A step by step guide to implement the Poisson Distribution in Power BI using DAX

In this post, I will describe what is the Pearson correlation coefficient and how to implement it in Power BI using DAX. What is Correlation Coefficient The correlation coefficient is a statistical measure of the relationship between two variables; the values range between -1 and 1. A correlation of -1 shows a perfect negative correlation, a correlation of 1 shows a perfect positive correlation. A correlation of 0.0 shows no linear relationship between the movement of the two variables. How to interpret...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2021/10/29/correlation-coefficient-in-power-bi-using-dax/" Read Morespan class="screen-reader-text" Read More/span/a/p

List of the most comon Univariate Statistics DAX Cheatsheet available in Power BI with their DAX code

Hybrid Tables: Hybrid tables are large tables that have one or more partitions in Import mode and another partition in DirectQuery mode. This will make the refresh of huge tables faster with incremental refresh. Plus get the latest data in real time with DirectQuery.

I just tested the technique shared by Ruth from Curbal, using the smart narrative to do storytelling in Power BI in order to to catch the user's attention and deliver insights more effectively. The goal is to highlight the selected categories. In a bar chart it's easy since it includes conditional formatting allowing to do it flexibly.

This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual.  As good as Power BI is, it will take Microsoft many more years to make it fully featured.  Microsoft Excel is 37 years old, and I can assure [...]Read More »

Azure Maps is a Microsoft technology that has a lot of cool features. Somewhat unexpectedly I discovered that along with purely mapping stuff it also provides functionality to acquire weather forec…

This blog post shows you how to change the filtering options from two items to multiple items in your Power BI reports.

A step by step guide to implement a paired t-test in Power BI using DAX only

Data Masking for Sensitive values

Transforming multiple columns at once with reference to existing columns can leave you with very slow queries. Learn how to do this fast.

Azure Data Explorer has a data type called dynamic which can be used to hold scalar values as well as arrays and property bags; you can read about it in the docs here. For example (following on fro…

In this short video blog we walk through how to create custom basemaps in MapBox and integrate them into your Icon Map in Power BI! We then take it to the next level by configuring dynamic basemaps which we can change using slicers. A big shoutout and thanks to James Dales for creating this awesome

With Power Query we can get the Date and Time of the last refresh, or the date modified. This post will show you how.

Let's see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it's done in Power Query.

Turn ON and OFF tooltips with a button in Power BI Reports

At a recent training course, one of the students asked if it was possible to add two different columns on the legend of a line chart, so that when a selection is made on a second slicer the chart splits to reveal multiple lines. Given others in the class showed [...]Read More »

OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create that in multiple ways.

Do you think Microsoft's files always follow best practices? In this episode, I'm dissecting a DAX formula from an automatically generated Power BI file.

Basically for every data model, but in particular for large and enterprise-grade data models, it might be wishful to perform backups. Power BI Premium offers a way to perform backup and restore ope…

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure …

Part of the the series: Doing Power BI the Right Way When you sign-up for the Power BI service at PowerBI.com (this address redirects to App.PowerBI.com), use establish a tenant for your organ…