How to add text to images using Python
March 13th, 2023 in Blog, Just For Fun, Python, UncategorisedIn this blog post, I will be showing how to add text to an image in Python. I used this code to generate hundreds of images with different text for one of our clients. The full script is downloadable at the bottom with the required extras. Firstly, install the Python library Pillow. Pillow is a PIL fork, install Pillow using pip and import PIL into the Python script. In Python, select the image that you would…
» Read moreSQL Server Agent Gantt Chart in Power BI
December 22nd, 2022 in Blog, Power BI, PowerBI, SQL ServerIn this blog post, I walk-through how to use a Power BI template file I have created that displays a Gantt chart which shows which SQL Server Agent Jobs have run and when. The purpose of the chart is to identify when jobs are overlapping and taking server resource off each other. If two or more resource intensive jobs overlap, it’s a good idea to schedule them at different times if possible. To use the template file, input the server name.…
» Read moreUpload Power BI Reports using PowerShell
July 8th, 2022 in Azure, Blog, UncategorizedIn this blog post, I will be sharing a PowerShell script that allows multiple Power BI reports to be uploaded at once. In a previous blogpost, I shared a PowerShell script that allowed users to downloaded multiple Power BI reports. Combined you could move several reports from one workspace to another in a few seconds. The script is downloadable at the bottom of the page as a txt file. To use the script there are three steps to take. The first…
» Read moreDownload Power BI Reports using PowerShell
April 14th, 2022 in Blog, Power BI, PowerShell, UncategorizedIn this blog post I will be sharing a PowerShell script that allows multiple Power BI reports to be downloaded at once. In the Power BI service, there is no way of downloading multiple Power BI reports at once. Therefore, users must download files one by one which is slow, time consuming and inefficient. Thankfully, there are ways around this, one of which is using PowerShell. The script is downloadable at the bottom of the page as a txt file.…
» Read moreCreating a quadratic solver in Python
February 3rd, 2022 in Blog, Python, UncategorizedIn this blog post, I will be showing you how to create a python function that will solve any quadratic equation. Firstly, what is a quadratic equation? A quadratic is an algebraic equation that can be arranged as ax2 + bx + c = 0 where a, b, c are known and a ≠ 0. If a = 0 then the equation becomes linear as there isn’t a x2 term. Secondly, how to solve this equation? There are different ways to solves quadratic equations including: By…
» Read moreHow to create a toggle button in Power BI
November 8th, 2021 in Blog, UncategorizedIn this blog post I will be showing you how to use a toggle button in Power BI. A toggle button in Power BI allows users to quickly switch between two options. Our first step is to create a toggle button as Power BI doesn’t have one by default. You can import one but by creating it yourself, it gives you more control. Our toggle button is created by having two images of identical size over the top of each other and using bookmarks to flip…
» Read moreHow to create the Fibonacci Sequence in Python
August 26th, 2021 in Blog, Python, UncategorizedThis blog post will go through how to create the famous Fibonacci sequence in Python. Each number in the Fibonacci sequence is the sum of the previous two terms. The sequence starts: 0, 1, 1, 2, 3, 5, 8, 13, … and carries on infinitely. The Python code I used is: The first two terms are entered into our list, then we specify the number of terms wanted in our sequence. Next, we loop through from 2 to the number of terms we wanted appending…
» Read moreJoin 2 Python lists together using nested loops
June 25th, 2021 in Blog, Python, UncategorizedIn this blog post I will show you how to join two 2D Python lists together. The code is in the screenshot below. Lines 1 – 2 are two lists that are going to be joined, line 3 is an empty list where the output will be appended to. Lines 4 – 5 are two loops (one nested inside the other) which cycle through the records in both lists, line 6 checks whether the first items (index 0) in the two records from each list that are currently i…
» Read morePower BI – Enable Load
April 16th, 2021 in Blog, Business Intelligence, Power BI, UncategorizedIn Power BI Power Query there is an option to enable or disable whether a table is loaded into the report. The option ‘Enable load’ can be found by right clicking on the table. Typically, by default, the load is already enabled. There is also an option ‘Include in report refresh’ which lets a user stop a table from refreshing when they refresh the entire report. This maybe useful for static tables or tables that are large which take a…
» Read moreTabular Cube Processing Report
December 9th, 2020 in Analysis Services, Blog, Business Intelligence, Power BI, Tabular, UncategorizedI have created a Power BI report which provides detail on the state of processing in a Tabular Cube.The report uses the cube’s dynamic management views to provide information about the cube’s partitions. To use the tabular cube processing report, you need to insert the following information: Server Database (Cube Name) Once entered and assuming the connection is fine you need to accept some native queries. These statements are select…
» Read more
Call today 0845 643 6463
