11:30 – 11:45 – Networking & Lunch
11:50 – 11:55 – Announcements
11:55 – 12:55 – Data Vault on SQL Server Tabular Model and Power BI By Derek Wilson
In this session, you will learn the basics of building a data vault to organize and store your company’s disparate data on SQL Server. Learn how Hubs, Links, and Satellite tables create options for storing a variety of data from multiple systems. The data vault structures will then be used as the data source to create views designed for SQL Server Analysis Services Tabular models. Finally, Power BI will be used to visual the data for your end users.
About Derek: He has successfully designed, installed and deployed data management and predictive analytics projects in a variety of industries. I enjoy working on data mining and predictive solutions to take historical data and apply adaptive learning technology to predict future outcomes. We create project that provide the most value to the business through improving service, decreasing costs or increasing revenue through architecture, design, or technology solutions. Derek is also on of the co-leaders of the Houston Area SQL Server User Group.