Patrick Maguire

Patrick has a background as a Business Analytics Consultant, where he meticulously gathered comprehensive business requirements and crafted user stories. His role involved bridging the gap between business operations and IT for clients.

Motivated by a passion for data, he joined the Data School to enhance his technical skills. Since then, Patrick has collaborated with a diverse range of clients, including Salesforce, major fashion retailers, sports governing bodies, and large manufacturing firms. Notably, he developed a Returns dashboard in Tableau for a global fashion retailer that garnered attention at the C-Suite level.

Patrick is a software certified data analyst in both Tableau and Power BI. He is also Alteryx Advanced accredited, and has strong data transformation skills in Tableau Prep and Power Query. Further, he has experience querying with SQL, and managing projects in an agile manner.

A graduate of King's College London with a First Class Honours Degree in Economics, Patrick is not only dedicated to his professional pursuits but also finds joy in his leisure activities. In his free time, he is an enthusiastic participant and spectator of various sports, with a specific focus on golf and football.

Blog Posts

Avatar
Wed 29 Nov 2023 | Patrick Maguire
Scaffolding in Tableau Prep
Scaffolding within Data Preparation refers to the process of filling in missing rows within a data set. Having complete rows within a data set greatly eases analysis when it comes to building charts, and is most prominently required when working with dates
Avatar
Wed 29 Nov 2023 | Patrick Maguire
Creating a Drill Down Bar Chart using Parameter Actions
Drill downs are extremely powerful. They can turn a simple bar chart into something that has potential for exploration. They are very effective in that they allow the user to explore the data further, whilst also saving space on the dashboard by effectively combining two bar charts into one
Avatar
Wed 29 Nov 2023 | Patrick Maguire
Nested LODs: When and How?
In simple terms a Nested LOD is an LOD inside another LOD. Double the LOD power. Let's see how they work. Here we have a simple table showing the Sales made within different Categories and Sub Categories
Avatar
Wed 29 Nov 2023 | Patrick Maguire
How to create a Dynamic Scatter Plot in Tableau
Scatter Plots are one of the most insightful chart type's in an analyst's arsenal. They allow us to directly plot the relationship between two measures. A simple example being to show the relationship between Profit and Sales, for different products, as shown below
Avatar
Fri 01 Dec 2023 | Patrick Maguire
Dashboard Week Day 5: All Good Things Must Come to an End
Today marks my final day in training at the Data School. It has been an absolute rollercoaster of an experience. There have been many highs, coupled with many lows
Avatar
Thu 30 Nov 2023 | Patrick Maguire
Dashboard Week Day 4: The Money of Movies
After a 1 day hiatus away from Dashboard Week due to illness, we are back again (not quite at 100%) and ready to go
Avatar
Tue 28 Nov 2023 | Patrick Maguire
Dashboard Week Day 2: Ireland Vs France
Day 2 - Let's get active. Today started a lot less than ideal. A defective train delayed my entry to the office by about 15 minutes so I'm slightly behind scheduele. We move nonetheless. Today's task focuses on data from the OECD, analysing the earnings and wages of different countries over time
Avatar
Mon 27 Nov 2023 | Patrick Maguire
Dashboard Week Day 1: Biscuits Biscuits, Biscuits
HERE WE GO! Hot off the heels of a restful week in Portgual, Dashboard Week has arrived! Today's task looked at data from the Office for National Statistics within the U.K
Avatar
Thu 16 Nov 2023 | Patrick Maguire
LOD Calculations in Tableau Prep
LOD Expressions allow us to control the granularity of calculations by fixing the Level of Detail for specific dimensions. Whilst many are familiar with the extensive use cases these calculations bring in Tableau Desktop, the value they can bring within Tableau Prep is less explored
Avatar
Tue 24 Oct 2023 | Patrick Maguire
Tackling the Tableau Data Analyst Exam: Part 3
Another blog, another Tableau Data Analyst Exam practice question for us to sink our teeth into. This question is a bit of a mouthful, and slightly more multi faceted than some of its predecessors
Avatar
Tue 24 Oct 2023 | Patrick Maguire
Tackling the Tableau Data Analyst Exam: Part 2
Welcome to blog #2 of my Tableau Data Analyst Exam mini-series. The question we will look into in today's blog focuses in on Moving Averages and how we can utilise them in Tableau Desktop
Avatar
Tue 24 Oct 2023 | Patrick Maguire
Tackling the Tableau Data Analyst Exam: Part 1
As my date with the Tableau Data Analyst Exam edges closer and closer, I've decided to document some interesting questions that come up in practice. Hopefully these blogs can help others prepare for the exam as well as consolidate some of my own learning
Avatar
Tue 17 Oct 2023 | Patrick Maguire
SQL 101
Today, DS41 and myself got our first introduction into Structured Query Language (SQL).  SQL is a coding language used to communicate and query relational databases
Avatar
Fri 29 Sep 2023 | Patrick Maguire
How to create a Dumbbell Chart in Power BI
I love Dumbbell charts. They are an extremely effective chart type. Making your first Dumbbell Chart in Power BI, however, takes a little bit of work. Within Power BI we have no default 'Dumbbell Chart' chart type. This does not mean we can't make one! By clicking the ..
Avatar
Mon 09 Oct 2023 | Patrick Maguire
How to Create a Customer Order frequency chart in Power BI
Getting acquainted with how to create different graphs across Tableau in Power BI has been challenging, but like anything, with time, it gets easier! Here is a quick tutorial on how to create a Customer Order Frequency Chart. Here is the end goal
Avatar
Sun 03 Sep 2023 | Patrick Maguire
Makeover Monday - Power BI edition
This week, DS41 were tasked with completing our first ever Power BI Makeover Monday (MM)
Avatar
Mon 28 Aug 2023 | Patrick Maguire
The Fundamental Characteristics of a GOOD Dashboard
When creating a Dashboard, it can be easy to get so caught up in the analysis such that some of the fundamentals of dashboard design go out the window (I have certainly been there!)
Avatar
Mon 28 Aug 2023 | Patrick Maguire
Logical Functions in Tableau: How can we utilise them?
A crucial technical skill required to proficiently harness the powers of Tableau is the skill to understand and effectively implement Calculations. Calculations within Tableau utilise existing fields in the data set, and Functions to create a new Data Field
Avatar
Tue 22 Aug 2023 | Patrick Maguire
Grouping and Aligning in Power BI: How Does it work?
Today marked the first day of Power BI training for DS41. Robbin Vernooij (whilst fighting through his jetlag) took us through the basics of Power Query, and building charts and pages
Avatar
Mon 07 Aug 2023 | Patrick Maguire
So, what actually is data?
As mine and DS41's first week at the Data School comes to a close, I'm beginning to reflect on everything I have learnt this week. From data structure, data sources, and data preparation to name just a few, its amazing how much can be covered in a short space of time
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab