A Fine Slice Of SQL Server
Elizabeth Ricks asks and answers a question:
As the workplace shifts to more remote communication, a question we’ve been receiving frequently in our virtual workshops is “How many words should I put on my slides?”
The answer? It depends on how your audience is consuming the information.
Read on to get past the standard consultant’s answer of “It depends” and see upon what it depends.
Comments closedPetr Baranovskiy shares a few new themes:
This will be a very short post compared to the detailed stuff I usually write. Just what it says on the tin – I made some tweaks to my three favorite {ggplot2} themes – theme_bw(), theme_classic(), and theme_void() – to make the graphics more readable and generally look better when posted online, particularly in blog posts. Please feel free to borrow and use.
Also, I will be frequently using these themes in subsequent posts, and I’d like to be able to point readers here with a hyperlink instead of repeatedly posting the whole theme_web_…() code every time I am writing a post.
Click through for the definition of each theme. H/T R-Bloggers
Comments closedBen Richardson looks at a couple of Power BI visuals:
In this article, you will learn how to work with Treemaps and Tables, which are two of the most commonly used Power BI visuals. You will also see how slicers can be used in Power BI to dynamically update the data in Treemaps and Tables. Power BI Visuals are extremely easy to create and don’t require you to write any code.
I like treemaps more than I probably should. They have a very limited set of good uses but I just can’t quit them.
Comments closedGilbert Quevauvilliers shares some exciting news:
The Power BI team has been doing a lot of incredible work. The most recent update which I got wind of is Custom Formatting of measures is now supported for Visuals.
This has already been deployed to the Power BI Service and if you download the
latest version of Power BI Desktop (Version 2.83.5894.961 as at 03 Aug 2020) it has the new features. This means you can use this TODAY!Previously this was only supported for tables and matrixes.
Click through to see how it looks in Power BI. It’s easy, and that’s a good thing.
Comments closedAri Lamstein announces that Choroplethr version 3.6.4 is now on CRAN:
Choroplethr v3.6.4 is now on CRAN. This is the first update to the package in two years, and was necessary because of a recent change to the tigris package, which choroplethr uses to make Census Tract maps. I also took this opportunity to add new example demographic data for Census Tracts.
Read on for a listing of the updates, examples, and a request from Ari to help keep the project up to date by finding a suitable sponsor. H/T R-Bloggers
Comments closedMike Cisneros takes us through slopegraphs:
When we use slopegraphs, we are trying to show one specific thing: is the value in the first column higher, lower, or the same as the value in the second column? That change is easy to see when we connect those values with lines, because the lines will slope up or down, in the direction of the change.
The steeper the slope, the bigger the change; and, if one thing is going up more dramatically than its neighbors, a slopegraph will make that easier to see than a traditional line graph would.
Mike has some examples of where slopegraphs make sense as well as cases when they don’t.
Comments closedSteve Jones tries out some of the Azure Architecture Icons:
The icons are svg, so while they work in PowerPoint, adding them to something like this post in OpenLiveWriter doesn’t work. However, I could make a quick diagram and capture an image of it.
Not great, but it shows I can put icons on a page with arrows.
Going one step further, I’ve been digging into Diagrams by mingrammer lately. With it, you use Python to generate diagrams, and there are quite a few Azure icons in there, as well as AWS, on-prem, etc.
Here’s a quick example of what you can do, taken from an upcoming talk of mine:
There are some limitations based on the underlying library, such as how you can’t connect cluster to cluster—meaning I can’t draw a line from “Logging” to “Storage\Logs”; I have to draw it from a particular element (Loki) to a particular element (Elasticsearch). In a lot of traditional reference architecture diagrams, though, that isn’t a problem.
Comments closedChrissy LeMaire has a nice-looking Windows Terminal theme:
I was sooo excited when Microsoft first made the announcement but was disappointed when I found out I’d have to run a specific version of Windows and compile the app myself. Whaat? No way, too much work. Now, it’s more widely available, so I decided to jump in and try it out. I love it and even miss Windows Terminal when I develop PowerShell on my Mac.
So here’s the Theme I’m contributing, which is based off of my favorite VS Code Theme, 1984 Unbolded. I call it Retrowave.
I went with essentially a black-and-grey theme for cmd + PowerShell and a bit more color (but still grey background) for WSL, but that’s so I can create screenshots easily without having to worry about color contrast on the printed page.
Comments closedMartin Schoombee gives us a warning around relying upon free custom visuals:
Before you get the impression that I’m against custom visuals, let me say this: I love custom visuals! I myself have used many custom visuals in the past and have been very quick to look for a custom visual when I couldn’t get something to display or work the way I needed it to in Power BI.
Custom visuals fill an important gap where the base product is not yet where it needs to be, and what better way for Microsoft to see what people need and where they need to invest more time from a visualization standpoint? It’s an awesome concept and I like it.
Unfortunately there are a few BUT’s to follow, but let me first tell you my story…
Read the whole thing. I like custom visuals a lot, but there are risks in a corporate world, and I don’t necessarily mean security.
Comments closedArtyom Keydunov shows off drill-down tables in Cube.js:
Since the release of drill down support in version 0.19.23, you can build interfaces to let users dive deeper into visualizations and data tables. The common use case for this feature is to let users click on a spike on the chart to find out what caused it, or to inspect a particular step of the funnel — who has converted and who has not.
In this blog post, I’ll show you how to define drill downs in the data schema and build an interface to let users explore the underlying chart’s data. If you’re just starting with Cube.js, I highly recommend beginning with this Cube.js 101 tutorial and then coming back here. Also, if you have any questions, don’t hesitate to ask them in our Slack community.
Click through for the demo, as well as links to the source code and an online example.
Comments closed