A Fine Slice Of SQL Server
Erik Svensen knows what day it is:
Last week I posted on LinkedIn an example on how we can utilize the matrix as a month calendar slicer.
It got a lot of attention so why not share an example file where you can see how I built it.
Erik has put the sample file in a GitHub repo, so click through to check that out.
Comments closedIn this video, I show how we can make a GPT-4 deployment aware of our own custom data, without needing to fine-tune the model. I talk about meta prompts and the Retrieval Augmented Generation (RAG) pattern, and then show how you can set this up using Azure AI Search and Azure OpenAI. Then, I bring it back to Streamlit and give users the option between chatting with a generic GPT-4 deployment and chatting over custom data.
I try to make my videos 10 minutes in length. They usually end up at 15-18 minutes. This one clocks in at more than 30 minutes and there’s very little fluff.
Comments closedIn this video, I show how we can integrate an Azure OpenAI GPT-4 model into our Streamlit dashboard. Along the way, I also show off how easy it is to create multiple pages and talk a bit about session state and secrets management as well.
The fun part about this is, there’s not even that much code involved. Streamlit handles most of the conversational aspects and you’re primarily responsible for saving history.
Comments closedElena Drakulevska builds a map:
Are you aiming for that WOW effect when your client opens your report? I’ve found that people often experience an immediate sense of awe when they see a map visual, especially when it’s conditionally formatted to highlight, for example, which country has the highest sales. So, I thought I’d share how you can achieve this and go beyond the built-in shape maps in Power BI. Let’s transform your global data into compelling visual stories!
Click through to learn more about the technique.
Comments closedIn this post I show how groupScatterPlot(), function of the rnatoolbox R package can be used for plotting the individual values in several groups together with their mean (or other statistics). I think this is a useful function for plotting grouped data when some groups (or all groups) have few data points ! You may be wondering why to include such function in the rnatoolbox package ?! Well ! I happen to use it quit a bit for plotting expression values of different groups of genes/transcripts in a sample or expression levels of a specific gene/transcript in several sample groups.
Click through for the sample code and output. H/T R-Bloggers.
Comments closedIn this video, I extend the Streamlit app that we’ve been working on even more. We’ll convert a set of drop-down lists into a form, change the behavior of these drop-down lists, and add date picker logic.
Click through for the video, the code to date, and links to additional resources. I’m pretty happy so far with this series, and we’re about to kick it up to another level with the next video.
Comments closedJerry Tuttle talks radar charts:
I was looking for an opportunity to practice with radar charts and I came across an article on five-tool baseball players, so this seemed like a perfect application for this kind of chart.
A radar chart is an alternative to a column chart to display three or more quantitative variables. The chart graphs the values in a circular manner around a center point.
I have an unhealthy love for radar charts in the right circumstances, and this love came from the way you did scouting in earlier versions of Madden NFL games, using the radar chart to estimate traits. The only problem was, the charts turned out to be a lie: they didn’t really correlate to player talents, but that was something I learned years and years later and probably explains why I’m so bitter all the time. H/T R-Bloggers.
Comments closedRita Fainshtein makes waffles:
Why is it more challenging to get an accurate answer from pie/donut charts and why do we feel less confident trying to read them?
The main reason is the difficulty in calculating the areas of the pie slices/lengths of the donut arcs.
This is much more challenging and less confident than comparing the areas of rectangular shapes.
Rita takes a look at the waffle chart custom visual available for Power BI and then builds something custom fit for the task.
Comments closedAllison Kennedy talks color in Power BI:
Being a good data storyteller means using all the tools at your disposal. This includes color. It is important to note that I’m not advocating the use of color only in your reports – you need to ensure that there is another method to discern what’s going on with the data for those in your audience who might be colorblind. But that doesn’t mean we can’t play around with color and use it to add meaning to our reports.
Most people I know would agree that GREEN means ‘Good’ and RED means ‘Bad’. But colors can be very personal. For example, my favorite color is BLUE and it was also the color I chose for my math notebooks throughout school. (Yes, math was my favorite subject – I guess it’s no surprise I ended up in a career that works so much with data.)
In addition to personal meaning of colors, there can also be cultural meanings around individual colors, and that can shape how individuals view a given color. Grace Fussell has one of my favorite articles on the topic.
Comments closedI continue a video series on Streamlit:
In this video, I extend a Streamlit app that I created in the prior video. This extension will include retrieving data from SQL Server, caching function results, operating a set of simple filters, and displaying visuals using tabs.
Click through for the video, as well as the code that I used.
Comments closed