SQL Saturday Jax 2024

Hey guys, a couple weeks ago all of those at Patriot Consulting spoke at the SQL Saturday event in Jacksonville, Florida. At this Star Wars themed community event, we were able to both enjoy and learn while in attendance of the presentations of others and also impart some of our knowledge upon those who attended our session. At UNF, where the event was held, each room was named after another planet. We had people like

Read More »

Single Ticks & Strings

Hello everyone, I hope you are doing well today. Have you ever been writing out a string or a print statement in python and got stuck trying to put an apostrophe in there? If so, I have the answers for you. First, I am going to address our error… single tick hell… then I am going to give you the solutions to your problems and keep you out of single tick hell. Fear not citizen!

Read More »


Hello everyone, I hope you are having a great day today. Have you ever wanted to make a measure in Power BI but didn’t know where to start? Well look no further! Throughout today’s blog I am going to be going over some different DAX functions to show why this stuff is dope. Without further ado, let’s get into it. I am going to start basic and show you how to create a measure, but

Read More »

Adding A Python Script Dataset to Power BI

Hello everyone, today I am going to show you how you can use Python to create a dataset to use in Power BI. This will be a simple walkthrough of all the steps you need to do so. There are some prerequisites though. Let’s go ahead and get right into it. The First Prerequisite: You will need to have Pandas already installed on your computer. If it is not already installed it is super simple

Read More »

Unleashing Data Insights with AWS QuickSight: A Guide to Creating Datasets

In the vast landscape of data analytics, having the right tools to harness the power of your data is crucial. AWS QuickSight, a cloud-powered business intelligence service, stands out as a game-changer, enabling organizations to visualize and analyze their data effortlessly. In this first blog post as part of a four AWS QuickSight blog series, Ill guide you through the crucial steps, unlocking the power of AWS QuickSight to transform your data into valuable insights.

Read More »

Pass Parent Package Values to Child Packages via Parameter Binding

Introduction                I was working on a project that required passing of variable values obtained from a parent package query to the child packages and want to share with you how I was able to achieve this. For my project, I had to get the latest date from the Insert Date column and calculate the number of days lapsed from that value to the present date. That calculated value was set as a variable in

Read More »
Subscribe to our blogs via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers