Power BI

Power BI

7501 bookmarks
Newest
Asking the right data questions and asking the data questions right
Asking the right data questions and asking the data questions right
In my last post I lamented the fact that there is too little focus on data thinking in data science and data visualization, and I described how much of a struggle it’s been for me to figure out how to learn and teach these skills. When I teach my academic visualization course, the thing the most exemplifies this need is the way I struggle to teach how to formulate good
·filwd.substack.com·
Asking the right data questions and asking the data questions right
About that weird Georgia chart
About that weird Georgia chart
Visualization social media has been busy mocking the following char t by the Georgia Department of Public Health. Pay attention to its horiz...
·thefunctionalart.com·
About that weird Georgia chart
Beyond Precision: Expressiveness in Visualization
Beyond Precision: Expressiveness in Visualization
Using precision as guidance for visualization design is powerful and yet limited in many different ways. Expressiveness may help.
Visualization is about mapping data values to visual channels;
While precision is a useful factor to keep in mind, it’s neither sufficient nor necessary to create effective visualizations.
First, it’s not always true that visualizations that use position are “better” than those that do not. Second, position can be expressed in multiple ways, so the guidelines leave us unable  to discern between visualizations that use position differently.
The problem with guidelines based on precision is that visualization is not really about precision.
But visualization is less about precision, and much  more about what the visual representation expresses.
data contains information that we want to communicate, and that information is what we want to  “express” with visual representations
Good visualizations stem from a good matching between what we want to express and what the visual representation expresses (something highlighted in the foundational work of Jock Mackinlay, who I believe introduced the term in the first place).
Expressiveness is much more about finding a good match between visual properties and “concepts” than precision or accuracy.
diverging color scale is not a matter of precision or accuracy (in fact a diverging color scale may even be less precise!), it’s a matter of good semantic matching; a matter of expressiveness.
The book divides visual channels into two large groups, magnitude channels and identity channels, according to whether they are more appropriate for quantitative or categorical information. For example, if I want to express a quantity, I shouldn’t use color hue, because humans do not perceive hues as ordered). And if I want to express categories, I shouldn’t use symbol size, because we naturally associate sizes with quantities, not categories.
Let’s look at other things one may want to express. Without any pretense to be exhaustive, here are some examples off the top of my head: Directionality: can the values be positive or negative? Is there a zero value or a meaningful threshold? Part-to-whole: do the data objects represent the part of a whole? Order: are the objects organized in a meaningful order? Grouping: are the objects organized around a set of meaningful groups Space/time: do the objects represent space or time or space-time phenomena?
But position expresses information in so many other important ways! Think about position on a single axis versus an orthogonal pair of axes; position in polar coordinates; position on a map; position to express grouping and alignment; etc.
Pursuing expressiveness may ultimately lead to inelegant or irrelevant findings, who knows. But it may also open the doors to a much richer description of how visualization works and to much better guidance.
we have to keep in mind that expressiveness is not only useful in figuring out how to express the information and ideas we want to communicate, but it is equally useful in making sure we do NOT accidentally convey information we did not intend to express.
We can work towards having a better and more complete characterization of what information and concepts we typically want to communicate with data and, similarly, develop a better understanding of what visual properties exist and what they express.
The more granular we go, the harder it is to generalize. In addition to that, the impulse to be able to describe every possible situation may backfire by making things more complicated than they need be.
Once we have a better description of data concepts and visual features, how do we build guidelines that can help people think more productively about visualization design?
Finally, if we want to approach this problem scientifically, we will also need to verify that guidelines and models based on expressiveness have a measurable impact on visualization effectiveness. For instance, it would be useful to explore if, among two competing visual representations, the one having a better match in terms of expressiveness leads to a difference  in comprehension (which is not easy to measure, but that’s a different story).
We do not visualize data, we visualize ideas based on data, and we need a better mental model (and maybe even a theory) to design visualizations.
·filwd.substack.com·
Beyond Precision: Expressiveness in Visualization
Dynamic Comparison values using Field Parameters - Self-Service Business Intelligence
Dynamic Comparison values using Field Parameters - Self-Service Business Intelligence
I have been reading a lot of good feedback of the Power BI May 2022 update especially and the introduction of field parameters. Do not want to go into details what it is, because the official blog post and video gives a good explanation. I would like to highlight this post from Chris Webb's about
·selfservicebi.co.uk·
Dynamic Comparison values using Field Parameters - Self-Service Business Intelligence
New Percentiles Transformation in Power Query Online
New Percentiles Transformation in Power Query Online
This content applies to: Power Query online There’s a new operation available for the Group By transformation in Power Query Online: percentiles. To see how it works, let’s see a simple example.  Consider the following Excel table containing information about invoices from different countries:  If you connect to this table from a Power BI or […]
·powerquery.microsoft.com·
New Percentiles Transformation in Power Query Online
How Many Employees by Period
How Many Employees by Period
I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling this [...]Read More »
·exceleratorbi.com.au·
How Many Employees by Period
Dataflows with benefits
Dataflows with benefits
Power BI datamarts are like dataflows with benefits. In case you missed the announcements this week from Microsoft’s Build conference, datamarts are a new major new capability coming to Power…
·ssbipolar.com·
Dataflows with benefits
Field parameters in Power BI
Field parameters in Power BI
New amazing #PowerBI feature 😍 Field parameters 😍 It is now possible to compose a parameter from different columns, useful to create a dynamic axis in a visualization. #PowerBI has released the fields parameter, we can now build a slicer to choose any dimension and also measures we want to visualize
·amalbenrebai.substack.com·
Field parameters in Power BI
Understanding context transition - SQLBI
Understanding context transition - SQLBI
Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather than be scared of it.
·sqlbi.com·
Understanding context transition - SQLBI
Composite models on SQL Server Analysis Services
Composite models on SQL Server Analysis Services
SQL Server 2022 Analysis Services will support composite models and it is now ready for you to try out with the CTP2 that has just launched. After you install this CTP for SQL Server 2022 on a server, tabular models are hosted on that server can now be used to create a composite model with.
·powerbi.microsoft.com·
Composite models on SQL Server Analysis Services
Fix Visuals or Replace Measures in Power BI Reports using pbi-tools — DATA GOBLINS
Fix Visuals or Replace Measures in Power BI Reports using pbi-tools — DATA GOBLINS
It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports . Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple me
·data-goblins.com·
Fix Visuals or Replace Measures in Power BI Reports using pbi-tools — DATA GOBLINS
Sci to BI - Similarities between Science & Business Intelligence — DATA GOBLINS
Sci to BI - Similarities between Science & Business Intelligence — DATA GOBLINS
In this post, I write about the similarities between scientific research & business intelligence. This article was originally written in 2019; I re-published it to support an article I’m working on about Power BI in Academic Research.
·data-goblins.com·
Sci to BI - Similarities between Science & Business Intelligence — DATA GOBLINS
The value Power BI could bring to Academic Research — DATA GOBLINS
The value Power BI could bring to Academic Research — DATA GOBLINS
I believe that Power BI - if successfully adopted & supported in a scientific research department - has the potential to deliver tremendous value. In this article, I try to explain how, and why this benefits researchers & society as a whole.
·data-goblins.com·
The value Power BI could bring to Academic Research — DATA GOBLINS
Group your data according to dynamic measure results
Group your data according to dynamic measure results
To group some data in the report, it is very common to create a custom column or a calculated column based on specific conditions, and then put this column in a slicer to filter visuals. This would generate more data in the model and the group result is fixed. If the data used in the conditions is f...
·community.powerbi.com·
Group your data according to dynamic measure results
Using Power BI Field Parameters to translate Data and Values – Gerhard Brueckl on BI & Data
Using Power BI Field Parameters to translate Data and Values – Gerhard Brueckl on BI & Data
When building an enterprise reporting solution with Power BI, a question that always comes up is how to handle translations. Large enterprises operate in various countries where people also speak different languages. So a report should be available in all frequently used languages. Ideally, you just create a report once and then a user can…
·blog.gbrueckl.at·
Using Power BI Field Parameters to translate Data and Values – Gerhard Brueckl on BI & Data
Limit access to certain columns with OLS && the new Field parameters feature without having to create several report versions for different security roles.
Limit access to certain columns with OLS && the new Field parameters feature without having to create several report versions for different security roles.
When creating an #OLS role to limit access to certain columns, measures or tables for certain users, the visual containing the restricted fields will be interrupted. This is why we need to create multiple report versions for different security roles.
·amalbenrebai.substack.com·
Limit access to certain columns with OLS && the new Field parameters feature without having to create several report versions for different security roles.
Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint.
Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint.
We’re thrilled to be shipping Power BI Data storytelling that lets you add Power BI reports and bookmarks to your slides and enjoy the delightful interactive experience of Power BI inside your presentations. With data storytelling, data will always be up to date in your slides, whether you’re building a presentation or presenting it live to others.
·powerbi.microsoft.com·
Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint.