Build your Team
Enhancing your data team with ours
Our consultants come armed with both technical and soft skills to support you to make the most of your data.
The Data School has been paramount to our success at JLL. It has allowed us to bring in highly skilled Tableau and Alteryx consultants. It saves considerable time trying to recruit contractors as I know their skills and training are to the highest standard. Over the past 5 years my team has developed analytical insights which have generated multi million dollar savings of which a considerable amount can be attributed to the Data School consultants we have had working on projects.
Paul Chapman, Global Director of Performance Management, BI and Innovation at JLL
Alteryx
Partner of the Year
EMEA
Tableau
Community Impact 2024
EMEA ESMB
DataIQ
Data for Good Champion
Finalist
DataIQ
Best Data Academy or Skills Development
Finalist
Alteryx
Partner of the Year
Europe
DataIQ
Data for Good Champion
Champion
Tableau
Data for Good 2021
EMEA
What our consultants are working on
We believe that sharing knowledge and expertise is key to driving innovation and growth in the data community. That's why we're excited to share our latest insights, tutorials, and industry trends with you through this blog.
Written by our team of experienced data consultants, these posts aim to solidify their own learning while giving back to the community.
Fri 24 Jan 2025 | Myles Stevenson
dbt for dummies
In today's data-driven world, businesses rely on analytics to make informed decisions. However, the process of transforming raw data into actionable insights can be complex and time-consuming
Fri 24 Jan 2025 | Curtis Paterson
Organising a dbt Project: Best Practices
Organising a dbt Project: Best Practices
When working with dbt, effective project organisation is key to ensuring maintainability, scalability, and collaboration. A well-organised dbt project not only simplifies debugging but also enhances readability
Tue 21 Jan 2025 | Zoe Reed
Normalised Vs Denormalised Data
Normalising data is a way of structuring datasets that reduces redundancy (duplication of the same information across multiple rows). This is done by storing data in multiple tables and creating relationships between them, often with the purpose of reducing the amount of storage required
Fri 17 Jan 2025 | Trea McElhone
Loading Data from Cloud Platforms into Snowflake: Part 1 - Stages
In our last blog we covered loading local data files into Snowflake via the GUI, in this blog we're going to get a little more advanced and look at how to bring in data from external cloud storage services, of which Snowflake supports three; Amazon S3, Microsoft Azure, and Google Cloud Storage
Fri 24 Jan 2025 | Yoan Caboste
Exploring the Versatility of the ON Clause in SQL Joins
Master the power of SQL joins! Discover how the ON clause goes beyond simple equality to handle complex conditions, pre-filter data, and unlock advanced self-joins. Learn how to write efficient, dynamic queries that give you deeper insights into your data
Wed 22 Jan 2025 | Marcel Wiechmann
Power BI Data Models: The Basics You Need to Know
Creating impactful reports in Power BI requires a solid foundation: your data model. Sure, Power BI allows you start visualizing as soon as you connect your data. But taking the time to understand and structure your data model will make your analyses both more powerful and easier to maintain
Wed 22 Jan 2025 | Ahsen Polat
Vom Training zur Praxis: Die wöchentlichen Kundenprojekte
Nach den Freitagsprojekten ist die Kohorte bereit, sich an die Kundenprojekte (auch Labore genannt) zu wagen
Wed 22 Jan 2025 | Holly Jones
Adding A Help Overlay To Your Dashboards
Creating an intuitive Tableau dashboard is an art, but sometimes even the most user-friendly dashboards require additional guidance for users. Adding a help overlay can provide essential instructions or context, ensuring that your audience understands how to navigate and interpret the dashboard
Tue 21 Jan 2025 | Edward Hayter
Lost in the Source: A Guide to Sources in dbt
The following blog explains what dbt sources are, how they are configured including an exhaustive list of properties options with added notes on how they function and ending on why dbt sources are important and can provide value to a business.
Mon 13 Jan 2025 | Priya Kondola
Understanding APIs in Alteryx
API stands for Application Programming Interfaces and can be integrated into workflows to connect with external systems and pull or send data to services.
An API is a set of rules and protocols that allow different software applications to communicate with each other
Tue 21 Jan 2025 | Dominic Brady
Preppin Data with SQL (2024Wk4)
Here is the challenge: https://preppindata.blogspot.com/2024/01/2024-week-4-unpopular-seats
Tue 21 Jan 2025 | Dominic Brady
Preppin Data with SQL (2024Wk3)
Here is the challenge: https://preppindata.blogspot.com/2024/01/2024-week-3-performance-against-targets.html
The task is to link our original sales data with a new quarterly sales target data source an ascertain if Prep Air is meeting its targets
Want to know more?
Whether you're planning for the future or you have a project that needs to get started next week our team are more than happy to help.
Complete our contact form with your name, company email and a brief message and we will get back to you as soon as we can.