Blog Feed

[Power BI] Creating a Hamburger Menu for Filters in Power BI

Level of Difficulty: Beginner – Senior. Often we create Power BI reports that require some sort of filtering mechanism but filters take up a lot of real-estate that could be used for other visuals instead. What if we could hide and show a filter pane using a “hamburger” menu mechanism? We can and here’s how.Continue reading “[Power BI] Creating a Hamburger Menu for Filters in Power BI”

[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams

Level of Difficulty: Intermediate to Senior So you’ve reached created a database, you’ve created schemas and tables. You’ve managed to create an automation Python script that communicates with the database, however, you’ve reached a crossroad where you need to validate your SQL tables. Some of the validation might include ensuring that the tables exist andContinue reading “[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams”

[Automation]: Using Power Automate with SQL Server (Primary keys that aren’t int)

Level of Difficulty: Beginner – Senior. Are you in a situation where you’re using a SQL database and you’ve already designed, created and gone through all 700 iterations of the review? Primary keys already created of type uniqueidentifier with default value of NEWID(). Then Fred comes with his clever idea of adding some sort ofContinue reading “[Automation]: Using Power Automate with SQL Server (Primary keys that aren’t int)”

[RPA]: Uploading Files to Azure Blob Storage in UiPath Processes

Level of Difficulty: Intermediate – Senior. This post will assist in using Azure Blob Storage to store files used in UiPath processes. A funny thing happened the other day… Jackson broke the news to the team that his laptop was stolen. After some panic, he lets everyone know that at least the latest solution wasContinue reading “[RPA]: Uploading Files to Azure Blob Storage in UiPath Processes”

[Python]: Setting up alerts on SQL Server Job Agent failures

Level of Difficulty: Beginner to Intermediate. So you’ve found yourself in a semi-ops situation where you need to do daily checks on SQL Server Agent Jobs because the client, Steve, has concerns that his data is not updating. Now you have to go through the manual process of opening SQL Server Management Studio then loggingContinue reading “[Python]: Setting up alerts on SQL Server Job Agent failures”

[Python]: Finding the Python Interpreter Path

Level of Difficulty: Beginner. Are you having issues pip installing libraries to the right place? Could it be because you have more than one interpreter installed? Well… How many Python interpreters do you have installed? The standard IDLE interpreter – the one that comes with the Python installation? The one that was installed when youContinue reading “[Python]: Finding the Python Interpreter Path”

[RPA]: Using The Microsoft Office 365 Activity For Sending Emails in UiPath

Level of Difficulty: Beginner. This post will assist in using the Microsoft Office 365 Activity, specifically for sending emails with attachments, in UiPath. What are the steps? The steps that we will be following are: Follow the link on how to create an App Registration on Azure Get the Application ID and Tenant ID fromContinue reading “[RPA]: Using The Microsoft Office 365 Activity For Sending Emails in UiPath”

Who is The JPanda

“This is fine.” – Wise People Across The World How Did The JPanda Come About? While working at CSIR, Jacqui was exposed to using the Pandas Python library extensively. Through this, her love for Pandas and Python alike, grew – thus earning her the nickname The Panda. This nickname followed her into Britehouse where herContinue reading “Who is The JPanda”


Follow My Blog

Get new content delivered directly to your inbox.

%d bloggers like this: