Data Warehousing Trends, Best Practices, and Future Outlook with James Serra

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

Bio - James works at Microsoft as a big data and data warehousing solution architect where he has been for most of the last eight years He is a thought leader in the use and application of Big Data and advanced analytics, including data architectures such as the modern data warehouse, data lakehouse, data fabric, and data mesh. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. He started his career as a software developer, then was a DBA for 12 years, and for the last twelve years he has been working extensively with business intelligence and data warehousing using numerous Microsoft technologies and tools. He has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning have helped him to develop many successful data warehouse and BI projects. He is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of major events including SQLBits, PASS Summit, PASS Business Analytics conference and the Enterprise Data World conference. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He has numerous Microsoft certifications, and has a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas. More info is at http://www.linkedin.com/in/jamesserra