Tag: Databases

28 Aug

Data Modeling Databases

Data Modeling for Mere Mortals – Part 4: Medallion Architecture Essentials

by Nikola

No Comments

Bronze, silver, gold...We are wrapping up our data modeling series by explaining how to set different layers for the lakehouse architecture

25 Jul

Data Modeling Databases Relational Databases

Data Modeling for Mere Mortals – Part 3: All we need is a Data Lakehouse?!

by Nikola

4 Comments

Is data lakehouse the concept to rule them all? Do we all need to implement it now? This article will provide you with the answers...

21 Jul

Data Modeling Databases Relational Databases SQL Server SSAS

Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals

by Nikola

4 Comments

Do you know what is PROBABLY the best data model in business intelligence world? Curious to learn 4-step dimensional design process? This article will provide...

01 Jul

Data Modeling Databases Relational Databases

Data Modeling for Mere Mortals – Part 1: What is Data Modeling?!

by Nikola

4 Comments

Why is data modeling sometimes intimidating? Maybe because you feel lost when you see all these diagrams that look so complex and complicated... But, data...

28 Dec

Databases SQL Server T-SQL

Secret life of CTEs

by Nikola

1 Comment

Common Table Expressions (CTEs for friends) is one of the most powerful, but still much underestimated, techniques in T-SQL.