[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)”

[Et al.] Look After The BAs!

As a Developer in an Agile environment, I want to appreciate the Business Analysts (BA) so that we can continue working in a respectful and collaborative manner. Sounds like a user story right? Well maybe it should be so that we can persistently practise this principle. Often we are faced with feuds between colleagues inContinue reading “[Et al.] Look After The BAs!”

[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]: Auto-Format Code According to PEP 8

Level of Difficulty: Beginner to Senior. So you’ve written a Python Script, Kevin has just told your team that all code needs to be reviewed and part of the team’s Key Performance Indicators (KPIs) will be PEP 8 compliance. Now there’s a slight sense of chaos and stress because “What is PEP 8?! Can oneContinue reading “[Python]: Auto-Format Code According to PEP 8”

[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]: Using Python Through Command Line

Level of Difficulty: Beginner. Sandra has asked you if you can give her a crash course on how to use Python through the command line. So you decide to show her how to run a few Python commands and maybe install a library. Here’s what you can do. What are the steps? The steps thatContinue reading “[Python]: Using Python Through Command Line”