Data Warehousing Trends, Best Practices, and Future Outlook
2022TL; DR
Gain insights into the current Data Warehousing trends, best practices, and future outlook
Session Details
Over the last decade, the 3Vs of data – Volume, Velocity & Variety has grown massively. The Big Data revolution has completely changed the way companies collect, analyze & store data. Advancements in cloud-based data warehousing technologies have empowered companies to fully leverage big data without heavy investments both in terms of time and resources. But, that doesn’t mean building and managing a cloud data warehouse isn’t accompanied by any challenges. From deciding on a service provider to the design architecture, deploying a data warehouse tailored to your business needs is a strenuous undertaking. Looking to deploy a data warehouse to scale your company’s data infrastructure or still on the fence? In this presentation you will gain insights into the current Data Warehousing trends, best practices, and future outlook. Learn how to build your data warehouse with the help of real-life use-cases and discussion on commonly faced challenges. In this session you will learn:
- Choosing the best solution – Data Lake vs. Data Warehouse vs. Data Mart
- Choosing the best Data Warehouse design methodologies: Data Vault vs. Kimball vs. Inmon
- Step by step approach to building an effective data warehouse architecture
- Common reasons for the failure of data warehouse implementations and how to avoid them
3 things you'll get out of this session
Speakers
James Serra's other proposed sessions for 2026
Data Architectures and Microsoft Fabric - 2026
Deciphering Data Architectures full-day workshop - 2026
Enhancing your career: Building your personal brand - 2026
How to build your career - 2026
Learning to present and becoming good at it - 2026
Using Generative AI on Structured and Semi-structured Data - 2026
James Serra's previous sessions
Data Lakehouse, Data Mesh, and Data Fabric (the alphabet soup of data architectures)
I'll explain the current popular data architectures: Data Lakehouse, Data Mesh, and Data Fabric
Power BI Overview, Deployment and Governance
I’ll discuss deployment strategies, common usage scenarios, how to store and refresh data, prototyping options, how to share externally, and then finish with how to administer and secure Power BI.
Azure Synapse Analytics
Learn all about Azure Synapse Analytics, including demos so you can see exactly how it works and how it can make your life easier.