Data Modelling

This page is about the skill Data Modelling, which is one of more than 40 technical skills you can assess on Alooba. The Data Modelling skill is about the process of creating models for how data should be stored within a database. For example, showing an understanding of the core concepts of dimensional modelling like data types, dimensions, facts, grains etc. It also requires showing an ability to identify any issues with storing data in particular ways, including loss of information, inability to answer certain business questions etc.

Check out the other skills here.

What types of things are included in the Data Modelling skill?

The Data Modelling skill assesses knowledge of topics like Data Models, Data Types, Dimensions, Facts, Star Schema & Snowflake Schema.

Which types of roles require good Data Modelling skills?

Data Modelling is a commonly assessed skill for roles such as Data Engineer, SQL Developer, DBA and Data Governance Manager.

Why should we test someone’s Data Modelling skills?

A critical part of running an ethical hiring process that’s fair and meritocratic is having objective measures of someone’s skills. Why does ethical hiring matter? Simple - it helps you hire the best person for the job.

Robert Half reported that the cost of a bad hire is on average 15-21% of the employee’s salary.

What was the most common reason for mis-hires? A lack of the right technical skills. This a true hiring own-goal, as it’s so easily preventable through a valid, thorough skills assessment.

So, if your role requires a candidate to know Data Modelling well, you can validate that with Alooba Assess.

Can I test my current team’s Data Modelling skills too?

Yes you sure can. You can assess their skills using Alooba Growth.

Which tests can I find the Data Modelling skill in?

Data Modelling can be assessed through the Concepts & Knowledge test & Free Response test. The Free Response Test includes different answer options like written responses, video answers and diagram answers.

Can I add my own Data Modelling questions?

Yes, you can add your own Data Modelling questions via the question bank.

How do I get access to Alooba to test Data Modelling skills?

Feel free to reach out and book a quick discovery call here.

How difficult is the Data Modelling skill?

Each question on Alooba is categorized by difficulty - Easy, Medium & Hard. You can set the difficulty level to whatever you like by picking and choosing the questions that you want to include.

What else can I assess with Alooba?

You can also assess someone’s intelligence, their personality type and critical soft skills, like communication.

Discover How To Get Started Assessing Data Modelling Skills

Over 50,000 Candidates Can't Be Wrong

That was definitely my first time ever being interviewed for skill assessment with the Alooba platform. Great experience and the value bestowed through such means is utterly respected on my behalf! I believe such online assessments should become more and more ubiquitous.

Yoav

Senior strategy manager candidate at global travel giant

Very great initiative taken my alooba, It's complete fair for all candidate to test their skill and it's help us to improve our performance. I'm excited to see the results.

Sheetal

Data analyst candidate for travel company

This was a very eye-opening assessment. I loved using alooba and the way the assessment was formatted. It was also great to see how some of the knowledge I gained from university can be applied to real-life scenarios and business problems.

Carrie

Senior product analytics candidate for leading Australian tech company

The website itself was amazing, and I liked it more than any LinkedIn or other assessment I took before. It shows how seriously you are taking this and made me enter the test mode without being stressed.

Majed

Marketing analyst candidate at Asian travel giant

Our Customers Say

I was at WooliesX (Woolworths) and we used Alooba and it was a highly positive experience. We had a large number of candidates. At WooliesX, previously we were quite dependent on the designed test from the team leads. That was quite a manual process. We realised it would take too much time from us. The time saving is great. Even spending 15 minutes per candidate with a manual test would be huge - hours per week, but with Alooba we just see the numbers immediately.

Shen Liu, Logickube (Principal at Logickube)

We get a high flow of applicants, which leads to potentially longer lead times, causing delays in the pipelines which can lead to missing out on good candidates. Alooba supports both speed and quality. The speed to return to candidates gives us a competitive advantage. Alooba provides a higher level of confidence in the people coming through the pipeline with less time spent interviewing unqualified candidates.

Scott Crowe, Canva (Lead Recruiter - Data)

How can you accurately assess somebody's technical skills, like the same way across the board, right? We had devised a Tableau-based assessment. So it wasn't like a past/fail. It was kind of like, hey, what do they send us? Did they understand the data or the values that they're showing accurate? Where we'd say, hey, here's the credentials to access the data set. And it just wasn't really a scalable way to assess technical - just administering it, all of it was manual, but the whole process sucked!

Cole Brickley, Avicado (Director Data Science & Business Intelligence)

I wouldn't dream of hiring somebody in a technical role without doing that technical assessment because the number of times where I've had candidates either on paper on the CV, say, I'm a SQL expert or in an interview, saying, I'm brilliant at Excel, I'm brilliant at this. And you actually put them in front of a computer, say, do this task. And some people really struggle. So you have to have that technical assessment.

Mike Yates, The British Psychological Society (Head of Data & Analytics)

I was at WooliesX (Woolworths) and we used Alooba and it was a highly positive experience. We had a large number of candidates. At WooliesX, previously we were quite dependent on the designed test from the team leads. That was quite a manual process. We realised it would take too much time from us. The time saving is great. Even spending 15 minutes per candidate with a manual test would be huge - hours per week, but with Alooba we just see the numbers immediately.

Shen Liu, Logickube (Principal at Logickube)

We get a high flow of applicants, which leads to potentially longer lead times, causing delays in the pipelines which can lead to missing out on good candidates. Alooba supports both speed and quality. The speed to return to candidates gives us a competitive advantage. Alooba provides a higher level of confidence in the people coming through the pipeline with less time spent interviewing unqualified candidates.

Scott Crowe, Canva (Lead Recruiter - Data)

How can you accurately assess somebody's technical skills, like the same way across the board, right? We had devised a Tableau-based assessment. So it wasn't like a past/fail. It was kind of like, hey, what do they send us? Did they understand the data or the values that they're showing accurate? Where we'd say, hey, here's the credentials to access the data set. And it just wasn't really a scalable way to assess technical - just administering it, all of it was manual, but the whole process sucked!

Cole Brickley, Avicado (Director Data Science & Business Intelligence)

I wouldn't dream of hiring somebody in a technical role without doing that technical assessment because the number of times where I've had candidates either on paper on the CV, say, I'm a SQL expert or in an interview, saying, I'm brilliant at Excel, I'm brilliant at this. And you actually put them in front of a computer, say, do this task. And some people really struggle. So you have to have that technical assessment.

Mike Yates, The British Psychological Society (Head of Data & Analytics)

I was at WooliesX (Woolworths) and we used Alooba and it was a highly positive experience. We had a large number of candidates. At WooliesX, previously we were quite dependent on the designed test from the team leads. That was quite a manual process. We realised it would take too much time from us. The time saving is great. Even spending 15 minutes per candidate with a manual test would be huge - hours per week, but with Alooba we just see the numbers immediately.

Shen Liu, Logickube (Principal at Logickube)