Implementing Tabular Data Models

Looking for faster and easier access to data insights? Take a deep dive into in-memory databases, known as tabular models, supported by SQL Server Analysis Services (SSAS) tools in SQL Server 2012 and SQL Server 2014. Learn to enrich the data model to meet analytical requirements, get the details on DAX queries for custom reporting, and hear tips and techniques for near real-time solutions.

Join experts Julie Koesmarno (fresh from her speaking engagement at SQL PASS Summit 2014) and Patrick LeBlanc for some exciting demos, including a step-by-step build of an actual tabular data model, plus some common pitfalls to avoid. If you have tons of data and want to build successful self-service analysis and corporate BI solutions, don't miss this course!

Course Outline:

  • ​​Introduction to Developing Tabular Model in SQL Server Data Tools (SSDT)​
  • Designing the Data Model in Tabular
  • Enriching the Data Model with Calculated Measures and Data Analysis in DAX
  • Overview of Querying Data Model with DAX
  • Administering and Securing Tabular Model
  • Near Real-Time Strategy in Tabular Model
  • Gotchas, Tips, and Tricks in Tabular Model Development
Instructor Team
Julie Koesmarno | LobsterPot Solutions, SQL Server and BI Consultant | @MsSQLGirl

Julie Koesmarno, SQL Server MVP, MCSE Data Platform, and MCSE Business Intelligence, is a SQL Server and BI Consultant at LobsterPot Solutions, with a bachelor's degree in IT. She has more than 10 years of experience working with SQL Server for large-scale and multimillion-dollar OLTP and ETL projects as a SQL Server Developer and System Analyst/Designer. Her recent projects include delivering a SQL Server 2012 data warehouse and BI solutions for a leading finance company in the United States and Australia.

Patrick LeBlanc | Microsoft SQL Server and Business Intelligence Technical Solution Professional | @Patrickdba

Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He has written several blogs and articles on SQLServerCentral.com and Business Intelligence Developer Network, and he is the author and co-author of four SQL Server books. Along with his more than 10 years of experience, he holds a master's of science degree from Louisiana State University. His past work experiences include Senior Consultant at Pragmatic works and Database Architect at several companies. Prior to joining Microsoft, he was awarded the Microsoft MVP award for his contributions to the community.

Live Event Details
November 11, 2014
9:00am–5:00pm PST
What: Fast-paced live virtual session
Cost: Free
Audience: Anyone new to tabular modeling or new to BI​
Prerequisites:

No prior knowledge of the SSAS tabular model is required, but basic database programming experience would be helpful