Excel

Power BI

7 Dec 2022 · 2 min read

Excel vs. Power BI - which one you should use

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 more

jetreports

10 Nov 2022 · 4 min read

Jet Reports 101 - Creating User Defined Options

Report 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 more

jetreports

7 Nov 2022 · 6 min read

Jet Reports 101 - Scheduling Reports with Jet Scheduler

It’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 more

jetreports

3 Nov 2022 · 4 min read

Jet Reports 101 - Row 1 & Column A… what CAN you use it for?

We 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 more

jetreports

31 Oct 2022 · 3 min read

Jet Reports 101 - NL(Filter) vs. LINK=

When 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 more

Excel

29 Oct 2022 · 5 min read

Excel 101 - Combine Multiple Files From Folders Using Power Query

Imagine 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 more

Excel

25 Oct 2022 · 2 min read

Jet Reports 101 - Evaluating Formulas NP(Eval)

If 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 more

data-analysis

22 Oct 2022 · 4 min read

Exploratory Data Analysis (EDA) of the 2022 Commonwealth Games

Continuing 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 more

data-analysis

10 Oct 2022 · 4 min read

Jet Reports 101 - Improving Performance

Some 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 more