SQL Saturday descends upon Lincoln, Nebraska this weekend and it’s another good chance to get a day of free SQL Server training delivered by many of the top people in the business. A total of 6 tracks at SQL Saturday #165 covering every part of SQL Server will be enough to get you up to speed on whatever topic you’re interested in. It’s going to be held on the University of Nebraska campus and it’s one of the reasons I submitted to speak at this event. I’ve really enjoyed the SQL Saturday events on campuses such as the ones I’ve attended at Baton Rouge on the LSU campus and Portalnd on the University of Portland campus. The setting works really well for obvious reasons.
I’m presenting two sessions in Lincoln. The first is titled Data Modeling Best Practice for Tabular Models and the second is Real-time Data Warehouse and Reporting Solutions. What’s really cool is that both of these sessions are previews of the two sessions I’m doing at the PASS Summit next month in November. If your interested in learning more about one of the great new features of SQL Server 2012, then come to my Tabular Models session. It will show you how to effectively make use of existing data sources in Tabular Models for your Business Intelligence solutions. The Real-time DW session will show you how to use the rich feature set of SQL Server to get a real-time data warehouse running successfully.
Data Modeling Best Practices for Tabular Models
The new Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you’ll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you’ll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel and Power View.
Real-time Data Warehouse and Reporting Solutions
In this demo-rich session, we will explore database and ETL architectures that let you smoothly move data from your application databases across the enterprise in real-time to your data warehouse. You will see how to use SQL Server features such as replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load data fast and dependably. We will develop an actual sample system during the session and discuss and walk through alternative real-time architectures, including the use of Data Vault methodologies. We will then see how to use Reporting Services and Power View to present data with a minimum amount of latency.