SQL Server Tutorials: Implementing Tabular Data Models

  • 2016-11-28
  • 423

SQL Server Tutorials: 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.

Watch experts Julie Koesmarno (fresh from her speaking engagement at SQL PASS Summit 2014 and Patrick LeBlanc, as they show 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, check out this course!

Instructors | Julie Koesmarno - LobsterPot Solutions, SQL Server and BI Consultant; Patrick LeBlanc - Microsoft SQL Server and Business Intelligence Senior Technical Specialist
Introduction to Developing a Tabular Model in SQL Server Data Tools (SSDT)

Get an introduction to tabular models from the Microsoft BI Stack point of view, with a focus on a basic overview of programming languages used in tabular models.
Designing the Data Model in Tabular

Take a deep dive into developing a tabular model in SQL Server Data Tools, including Workspaces and Tabular Instance, along with a look at basic configuration to allow better user experience.
Enriching the Data Model with Calculated Measures and Data Analysis in DAX

Explore techniques to enrich the data model in SSDT to meet analytical requirements and to enhance user experience. Hear about analytical calculations and data analysis configurations.
Overview of Querying Data Model with DAX

Learn about how, after a data model is built, users can build custom DAX queries, which can be essential for custom reporting in SSRS and custom actions via Excel.
Administering and Securing Tabular Model

Tabular model solutions need to be production-ready before users can access them. Learn how to administer and secure tabular models, from development and database administration perspectives.
Near Real-Time Strategy in Tabular Model

Meeting near real-time requirements can be an essential part of tabular model solutions. Hear more about techniques for implementing near real-time solutions using tabular modeling.
Gotchas, Tips, and Tricks in Tabular Model Development

Understanding limitations, additional tools, and tips around data visualization is essential to the success of tabular model solutions. Uncover the gotchas, tips, and tricks for successful tabular model projects.
Learn

Introduction to Developing a 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
Recommended Resources and Next Steps

Prerequisites
None

Suggest

Tableau 9 Advanced Training: Master Tableau for Data Science

Tableau 9 Interview Q&A: Tableau For Data Science Careers

Tableau 10 Advanced Training: Master Tableau in Data Science

Tableau 10 A-Z: Hands-On Tableau Training For Data Science!

Tableau for R Users - Explore Tableau 9 and Embed R Code

Building Interactive Dashboards with Tableau

Data Science using Tableau