A Fine Slice Of SQL Server
When you’re visualizing categorical data, sorting the bars in your chart is usually a straightforward task. Or is it?
In most cases, you probably take the category with the largest value and stick that in the prime spot, the leftmost slot on the horizontal axis. Then, you proceed from left to right in descending order of value. Easy peasy.
But it’s not always that simple, as Mike points out.
Comments closedSteven Sanderson builds a plot:
In the realm of machine learning, visualizing model predictions is essential for understanding the performance and behavior of our algorithms. When it comes to regression tasks, plotting predictions alongside actual values provides valuable insights into how well our model is capturing the underlying patterns in the data. With the
plot_regression_predictions()function in tidyAML, this process becomes seamless and informative.
Read on to see how the function works and the kind of result you can expect from it.
Comments closedKurt Buhler has some new digs:
Format strings greatly improve the usefulness of your model, particularly when you apply custom and dynamic format strings creatively. However, there are considerations to keep in mind.
It is important that the values in a report display for users as they expect. Effective formatting of DAX measures and table columns improves your model, as values are easier to read and interpret. While formatting may seem simple at first glance, the flexibility of DAX and format strings in Power BI can create many opportunities for more creative and efficient tables or visuals.
Click through to understand why proper formatting of measures is so important on dashboards, and also congratulate Kurt on becoming an Italian. At least, I assume citizenship conveys when you do work for Marco & Alberto.
Comments closedSebastian Sauer shows off some code. There’s pretty much nothing to excerpt here, as it’s all code and images, so the gist of what Sebastian shows off is how to use the vjust parameter on ggplot2 labels to force where those labels show up.
Benedict Ampea-Badu shares some tips:
In this last segment of the series, we’ll delve into the crucial elements of navigation and flow, exploring further the part of web accessibility that ensures users can effortlessly navigate online content. Additionally, we’ll shine a spotlight on the indispensable practice of regular testing, an ongoing commitment that goes beyond compliance, providing invaluable insights into real user experiences and fostering continuous improvement.
Ensuring a seamless online experience for everyone and facilitating smooth navigation boils down to adhering to the fundamentals of web accessibility. It boils down to carefully planning how websites are laid out, making it easy for users to explore different things effortlessly. When developers grasp how users interact and tackle possible issues, they go beyond just ticking boxes on a checklist. Instead, they create websites that truly put users first, considering how people actually use and prefer to browse.
This is particularly about accessibility in web applications but many of the same principles apply to things like Power BI reports.
Comments closedSteven Sanderson changes the script:
Before we dive into the code, let’s quickly review what superscripts and subscripts are.
- Superscripts: These are smaller-sized characters or numbers that appear above the baseline of the text. They are often used to denote exponents or indices.
- Subscripts: On the other hand, subscripts are smaller-sized characters or numbers that appear below the baseline of the text. They are commonly used in mathematical expressions or chemical formulas.
Read on to see how you can generate these in R visuals.
Comments closedGood User Experience (UX) design is crucial in enabling stakeholders to maximise the insights that they are able to derive from Power BI reports. One common challenge of report design is effectively managing and displaying large datasets in bar charts without overwhelming the user. This article will describe the process behind a method that can mitigate this issue: adding pagination to bar chart visuals. This visual will provide the following functionality:
- A number of categories filter: users can specify how many categories they would like to see per bar chart page
- A page filter: users can navigate to different pages to see more categories
Click through to see how. I tend to prefer Power BI dashboards be glanceable, so pagination defeat that purpose to some extent. But so does having to scroll through a large list.
Comments closedWelcome to today’s tutorial where we’ll explore the Power BI Tips+ Theme Generator and its incredible features designed to streamline your Power BI report building experience. In this walkthrough, we’ll guide you through the process of getting started with the Power BI Tips+ Gallery, focusing on the Sunset theme. By the end of this tutorial, you’ll be able to effortlessly integrate our pre-configured Gallery Projects into your Power BI reports. It doesn’t get easier than this!
Click through for the process, including a video on how to do it.
Comments closedMeagan Longoria looks at contrast:
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient colors (maybe you just used the default colors), you will end up with poor color contrast. Luckily there are a couple of quick (less than 30 seconds for most people to implement) fixes that can improve your color contrast.
Click through for a video demonstration and two tips from Meagan.
Comments closedBenedict Ampea-Badu shares some guidelines:
We live in the height of the digital age, where the digital space has become a thriving community, with every person craving a great yet personalized experience. In this era, there is one centralized truth with undeniable clarity: Accessibility is no longer a mere option; it is the cornerstone that will lead to the creation of a truly welcoming community.
In this second part of our series on accessibility design, we will discuss essential topics that lie at the heart of crafting accessible digital environments. We’ll begin by throwing more light on three of the five fundamental visual patterns vital to your designs:
- Color Contrasting
- Font Sizing
- Labelling and Iconography
Read on for good information and plenty of examples.
Comments closed