This video course covers tools and techniques to create enterprise-grade Tabular models with Power BI and Analysis Services.
The Tabular semantic model is the core technology that runs Power BI, Azure Analysis Services, and SQL Server Analysis Services. Knowing the features available, understanding their capabilities, and being aware of the limitations is crucial to planning, implementing, and deploying a complete solution in an enterprise environment.
Power BI authors can bring their models to the next level, by understanding the details of the model features available in Power BI Desktop and by knowing the additional features available in external tools like Tabular Editor.
Business Intelligence developers can learn how to create a model for Analysis Services or Power BI Premium using Visual Studio or Tabular Editor, how to deploy and automate the processing, and how to implement security requirements.
Solution architects can understand how the Tabular engine running in Power BI and Analysis Services works. They will better understand all the details needed to choose the right model type depending on latency requirements and on the budget available: Import, DirectQuery, aggregations, composite models, or push datasets.
System administrators can learn how to monitor the Tabular engine, how to manage partitions, and how to implement and schedule incremental refresh.
This course is useful to different professionals working with Power BI and Analysis Services. After a first initial review of all the modules, you can use the content as a reference while creating your model. We recommend you review specific modules in depth when working on particular areas of the model, such as security, partitioning, aggregations, deployment, scaling out, and more.
Basic knowledge of DAX is useful to create simple Tabular models. You can follow the free Introducing DAX video course to get acquainted with DAX.
In order to complete your training on Tabular, after the Mastering Tabular video course you should study the Mastering DAX video course. In the Mastering DAX video course, you will learn how to write complex measures and queries using the DAX language, which is not included in the Mastering Tabular video course.
Students have access to a private discussion area where they can interact with the instructors by asking questions related to the lectures and the exercises.
Tabular Editor 3 Enterprise License
Included in your purchase of the Mastering Tabular video course is a license for Tabular Editor 3 Enterprise that is valid for 90 days. This is to ensure you have time to practice with the more advanced features required in enterprise-level solutions.
