Learn about the key differences between multi-dimensional modeling and relational modeling in analytical systems. Understand if multi-dimensional is a relational concept or not.
Read MoreThanks for reading. Here you will find a huge range of information in text, audio and video on topics such as Data Science, Data Engineering, Machine Learning Engineering, DataOps and much more. The show notes for “Data Science in Production” are also collated here.
Archive
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- January 2023
- December 2022
- November 2022
- October 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- May 2021
- April 2021
- March 2021
- November 2020
- October 2020
- September 2020
- July 2020
- June 2020
- May 2020
- April 2020
- February 2020
- November 2019
- October 2019
- September 2019
- July 2019
- June 2019
- May 2019
- April 2019
- March 2019
- January 2019
- December 2018
- November 2018
The Lakehouse approach is gaining momentum, but there are still areas where Lake-based systems need to catch up. Databricks have just launched Databricks SQL Analytics, which provides a rich, interactive workspace for SQL users to query data, build visualisations and interact with the Lakehouse platform.
Read More
Everyone’s talking about Azure Synapse Analytics, but does it sometimes feel like they’re talking about different things? Are you having trouble following where Azure SQL Datawarehouse is these days? In this post, Simon attempts to clarify the marketing message and talk about what’s actually coming and where we should be thinking about using it.
Read More
Dake Lakehouse? Another bit of meaningless hype or a new term for a future generation of analytics platforms? I’ll explain the concept and where it’s coming from, and you can decide
Read More
With the term Data Engineer growing exponentially, it can be difficult to pin down what exactly the role is, and where did it come from? This post dissects the history of the data engineer, how it relates to data science and business intelligence and asks the question… is it more than just ETL?
Read More
The ETL window is part and parcel of how BI developers build their solutions - but is it an outdated concept? With event-driven processes, it’s fairly straight forward to move past this as a concept!
Read More
Kimball warehouses have been around for an age, but technology has changed massively since they were designed. So why are people still using it? Does it have a purpose? This blog discusses some of the background behind the questioning of Kimball
Read More
Datawarehousing is a slow, unreactive thing, and it’s missing out on many opportunities because of it. How do you structure your modern data warehouse to react quickly and unlock value within your data, faster?
Read More