Power BI

Power BI

9059 bookmarks
Newest
Start skilling on Azure with these helpful guides
Start skilling on Azure with these helpful guides
We are excited to introduce Azure Skills Navigator, a new learning resource designed especially for those that are new to Azure and want to learn more. Azure Skills Navigator is our very own ramp-up guide intended to help you develop a strong foundation on cloud technologies as you begin to ex...
tommypuglia·azure.microsoft.com·
Start skilling on Azure with these helpful guides
Learning Azure Synapse Analytics – Early Release
Learning Azure Synapse Analytics – Early Release
Just a quick post friends. As you may already be aware, with my friend and now Avanade colleague Richard Swinbank (@RichardSwinbank), we are at it again. Following the success and enjoyment of coll…
tommypuglia·mrpaulandrew.com·
Learning Azure Synapse Analytics – Early Release
Cluster Analysis in Power BI - Iteration Insights
Cluster Analysis in Power BI - Iteration Insights
In this blog, we learn Power BI's clustering ability that provides a variety of cluster types that can add additional insights and information to your data.
·iterationinsights.com·
Cluster Analysis in Power BI - Iteration Insights
Contoso Data Generator - SQLBI
Contoso Data Generator - SQLBI
Contoso Data Generator is a free open source tool to generate sample Contoso databases on SQL Server based on a star schema. You can customize the database
·sqlbi.com·
Contoso Data Generator - SQLBI
Why Datamart is a Big Deal
Why Datamart is a Big Deal
My previous blog about Datamart was based on my daily work, but with the official release of the preview, Microsoft made datamart available in Premium per user License, it happen I have my personal…
·datamonkeysite.com·
Why Datamart is a Big Deal
Creating your own Contoso star schema database - SQLBI
Creating your own Contoso star schema database - SQLBI
When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases
·sqlbi.com·
Creating your own Contoso star schema database - SQLBI
The End of Agile
The End of Agile
I knew the end of Agile was coming when we started using hockey sticks.
·www-forbes-com.cdn.ampproject.org·
The End of Agile
Announcing the general availability of canvas components and component libraries
Announcing the general availability of canvas components and component libraries
Canvas components and components libraries empower low-code/no-code citizen developers to build reusable UX components which can be used across screens in an app or across apps in an environment. Canvas libraries along with the apps can be packaged and moved to other environments using standard Dataverse solutions and you can push component updates through solutions.
tommypuglia·powerapps.microsoft.com·
Announcing the general availability of canvas components and component libraries
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
Why Shouldn't All Charts Be Scatter Plots? Beyond...
Why Shouldn't All Charts Be Scatter Plots? Beyond...
A central concept in information visualization research and practice is the notion of visual variable effectiveness, or the perceptual precision at which values are decoded given visual channels...
·arxiv.org·
Why Shouldn't All Charts Be Scatter Plots? Beyond...
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
Microsoft Viva Goals brings purpose and alignment to the employee experience - Microsoft 365 Blog
Microsoft Viva Goals brings purpose and alignment to the employee experience - Microsoft 365 Blog
Today, we are excited to announce Microsoft Viva Goals, a new module for business goal setting and management, is now available in private preview. Viva Goals brings purpose and alignment to Viva customers—alongside culture and communications, wellbeing and engagement, growth and development, as well as knowledge and expertise.
·microsoft.com·
Microsoft Viva Goals brings purpose and alignment to the employee experience - Microsoft 365 Blog
Automation Maturity Model: Power Up your RPA and hyper-automation adoption journey!
Automation Maturity Model: Power Up your RPA and hyper-automation adoption journey!
The goal of the Power CAT Adoption Maturity Model for hyper-automation scenarios is to help organizations and their partners to think through how they can improve their capabilities and aligning them to improve business outcomes. A successful automation implementation requires technology, process and people to be aligned. The Power Automate maturity model is inspired by HEAT – Holistic Enterprise Automation Techniques and the Capability Maturity Model.
tommypuglia·powerautomate.microsoft.com·
Automation Maturity Model: Power Up your RPA and hyper-automation adoption journey!
Discover exciting new experiences and capabilities in process advisor
Discover exciting new experiences and capabilities in process advisor
We are announcing many exciting new experiences and capabilities in process advisor to empower you to visualize your process and get deeper insights to identify bottlenecks and optimization and automation opportunities. You can now gain insights on and improve your cloud flows with the help of process mining. With a few easy clicks, you can visualize your flow’s performance, identify bottlenecks and optimization opportunities, and monitor for business drifts.
tommypuglia·powerautomate.microsoft.com·
Discover exciting new experiences and capabilities in process advisor
First Look at Microsoft Power Pages - Carl de Souza
First Look at Microsoft Power Pages - Carl de Souza
In this video, I take a first look at the newly announced Microsoft Power Pages. This new additional to the Power Platform is an evolution of Power Apps Portals. Check out the video below, Episode 49 of Power Platform TV.   THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.   I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM. … Continue reading First Look at Microsoft Power Pages
tommypuglia·carldesouza.com·
First Look at Microsoft Power Pages - Carl de Souza
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