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
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!
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
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
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.
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