Power BI

Learn how to use Datamarts in Power BI. They enables you to store and explore your data in a relational and fully managed Azure SQL DB.

I was listening to Cole Nussbaumer Knaflic interviewing Steven Franconeri a few days ago (excellent episode!) and I was struck by something they mentioned towards the end regarding the illusion of being neutral when visualizing data. Many seem reticent to editorialize their data visualizations for fear of being perceived as biased. Cole was mentioning strategies she advocates for that bring more clarity and focus but necessarily leads to more direct steering of the reader’s attention from the visualization designer’s side (highlighting, annotations, simplification, etc.)

Many managers are uncomfortable with interpreting the numbers in their reports and dashboards. If this common data literacy problem isn't addressed across management levels, companies will continue to struggle in their efforts to develop data-driven cultures. In this article, I cover four key areas of data interpretation that are essential for all managers who are striving to make data-informed decisions.

In May 2022 Desktop update, we recieved the Field parameters function into Power BI. This function lets us change dimensions in visuals with a simple click on the slicer.

A good way to think of data visualization (data viz) is that it can be the difference between utter confusion and really grasping an issue.

Data visualization is the practice of translating information into a visual context, such as a map or graph, to make data easier for the…

Which specialists are required to build a BI-based system and what scope of work falls on each of their shoulders? — read about it in our…

Download (PDF): Guidelines for Measuring Trust in Organizations (updated 2013)IntroductionIn 2003, a coalition of organizations representing 50,000 public relations and communications professional

Speed to value, speed to audience

TL;DR, you can incremental refresh PowerBI using Parquet files stored in an Azure Storage without using any Database in the middle, you can download sample pbix here I am using this blog post by Gi…

If you’re using the new Parquet connector in Power BI there’s a chance you will run into the following error: Parameter.Error: Parquet.Document cannot be used with streamed binary value…

Was chatting with David Eldersveld and he suggested that he wants to run a competition using the famous New York Taxi Dataset with Datamart, long story short, I did endup publishing my attempt befo…

An article on the new catch keyword added to the Power Query language for the try catch statement

In today's data economy, the word 'insight' is used frequently in business. However, in many cases, it is misused without a clear understanding what the word means. We need to enhance insight literacy, which starts with developing a clearer definition of what insights really are.

According to a NewVantage Partners survey, 99% of firms have invested in data initiatives and 92% reported the pace of investment is accelerating. However, only 24% reported having a data-driven organization. This article looks at 10 reasons why your company may not have achieved this goal yet.

To become an effective data storyteller, you must shift your mindset from being reporting centered to embracing a different storytelling approach. In this article, I introduce the Insight Funnel and how reports/dashboards complement data stories. Then I explore the six key approach differences between reports/dashboards and data stories.

The most common way of sharing data with employees has been through dashboards and reports, but they mainly focus on the 'what.' What executives really crave is the 'why'--interpreting the numbers to help inform decisions. A recent survey reveals how data stories can address this crucial need.

Data literacy is a key focus of many organizations as they seek to help their employees take full advantage of their data. While data storytelling is often included in data literacy training, the question is whether it is a required skill to be data literate. In this article, I explore the minimum viable skills someone needs to qualify as being data literate. I then share where data storytelling fits in the data literacy landscape.

Today, more and more people realize there is more to data storytelling than just data visualization. If you were to evaluate what makes a data story "good," you'd discover one crucial ingredient that's necessary--a meaningful insight. In this article, I review what insights are and the critical role they play in data stories. I also share thoughts from a recent journal article by Sorin Adam Matei and Lucas Hunter on the importance of insights to data storytelling in science communication and data journalism.

Projects on CodeSandbox can be configured via files in the .codesandbox directory at the root of your project. All configuration files are optional, but adding them is recommended to optimize your experience using the project editor.

Have you been working with Composite Models in Power BI? Did you run into challenges while you did? Then this blog is for you! In this blog I will further elaborate on what the composite models (in…

pbi-tools bring Power BI projects under source control, enabling professional development workflows and enhanced governance. Available for free and with ope

Power BI Architecture with separate layers: In a Power BI report development cycle, we can have separate layers since we can use many components to build report files which facilitates the re-usability of elements for better integration. we could have data preparation , data modeling and data visualization layers, such as:

Challenges to the data-driven culture and how changes in the delivery model can help to achieve it

As organizations automate processes, the great debate between low-code and pro-code inevitably arises. Follow these steps to make the right app dev choice.

Continuing on my exploration of field parameters, in this post I want to share how you can use field parameters and modelling to dynamically sort columns in a table with a slicer and also switch ro…

I show how using different Power BI DAX queries gives you the same result, one DAX measure uses a lot of resources and the other uses almost nothing.