Topic
Both are powerful tools for analysing and presenting data. However, they have different strengths and capabilities, and choosing the right tool for your needs can be a challenging decision. Let's compare Excel and Power BI to help you decide which one is right for you.
Read the pieceReport options are a powerful way of adding customisability to your reports that means you don’t have to have a designer to put a report into design mode to change a parameter or filter. So let’s see how we create them.
Read the pieceIt’s safe to say that any opportunity to automate a report is an opportunity I always pounce on. The Jet Scheduler is a powerful tool that allows you to schedule reports to be automatically run by the Windows Task Scheduler.
Read the pieceWe see tutorials and instructions state that Jet Reports uses Column A and Row 1. But what can we use this row and column for? Let's find out!
Read the pieceWhen writing reports, you may find that you need to filter your data based on information stored in a separate table. Let's take a look at how to do this in Jet Reports.
Read the pieceImagine a scenario where you’re tasked with analysing sales data for the prior two years, but you’ve been given the information in 24 separate Excel documents. What do you do? This is where Power Query comes to the rescue.
Read the pieceIf too much reliance is put on volatile functions, it can make recalculation times slow in Excel alone - when you couple that with Jet reporting it can compound the issue further.
Read the pieceContinuing my learning journey of Python (and tools) in data analysis, there was a data set for the 2022 Commonwealth Games. I thought that since I had just done some EDA on the Olympics, it would be good to look at this data set.
Read the pieceSome reports can run in a matter of seconds, but if it is not built following ‘best practice’ guidelines, over time it can grow into an unoptimised mess that takes MUCH longer to run. This article will explore some of the most impactful ways to streamline a Jet report.
Read the piece
