Tag Archives: Fact

SQL Server Exercise for Data Warehouse Candidates

Background Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire competent and reliable people. We recently had to fill a data warehouse position in our team and I setup the following technical exercise that helps measure technical competencies of candidates. Candidates were required to do… Read More »

Dimensional Modelling in Lucidchart vs Visio: Part 1

Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model data. As a Certified Microsoft Professional, my default modelling tool has always been Microsoft (MS) Visio and sometimes, Visual Studio. However, I’ve recently been introduced to Lucidchart and it completely blew my… Read More »