Mastering Tabular Video Course
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.
Collapse allCurriculum
- Michael Mertens (Jul 10, 2023)
Excellent, especially the amount of details you find nowhere else
- Jarosław Choduń (Jul 5, 2023)
Very good and detailed course
- Marco A. Bajana B. (May 30, 2023)
Excellent Course some time ago I wanted to finish and reinforce it. Tabular models have helped me a lot in my career in conjunction with Power BI. Now with the launch of Fabric, how is Azure Analysis Services in the world Microsoft of data? Regards and Success Marco Bajana
- Simon Kennaugh (May 28, 2023)
Extremely well presented and thorough course.
- Rafael Santos (May 8, 2023)
very good
- Farlyn Akerboom (Apr 30, 2023)
Amazing, so extensive and complete. I've learned so much and there is alot more material to go deeper. It would have taken me years to figure out all the knowledge being shared. Can totally recommend this to anyone who is serious about tabular development.
- Ben Ferry (Mar 22, 2023)
Amazing course. A lot of work, and it took me a while to get through it, but absolutely worth it. Excellent value for money. 100% recommended!
- Bernat Agulló Roselló (Mar 19, 2023)
This is a truly comprehensive course on tabular models. I like that is so systematic and that you get first the theory and then the demo, also from both Alberto and Marco so you get both views, which is nice. Probably I should have taken this course a bit earlier as half of it was material that I already knew, but at the same time there was another half I did not know, and more importantly I did not know that I did not know that part. I think it's particularly useful for those that have to deal with AS and AAS, but still very useful for those dealing with Power BI premium. In Power BI Pro you have less control on just about anything. But then again, for small models you do not need that much control. Great course overall.
- rogers.mendonca (Mar 14, 2023)
Wonderful course! An excellent opportunity to know in detail the insides of the architecture behind Power BI and how to handle this architecture through different interfaces and tools. Thanks and congratulations to Alberto Ferrari and Marco Russo for the didactics and quality of the classes.
- Jan Maarten van den Boogaart (Mar 2, 2023)
Excellent course! Very thorough. And very time-consuming... (completed in 18 months 😅).
- Anton Kostov (Jan 16, 2023)
Thanks it was and extensive and well explained course. You two are great charismatic lectors. The only issue I have is that at 2x speed the stream output cannot catch up (no matter the quality setting). It not due to my internet speed also because it is quite high. Anyways, thanks again.
- Liz Bellinghoven (Dec 27, 2022)
Great course!
- Francesco Dalvit (Dec 17, 2022)
Siete di gran lunga i migliori
- Marco Antonio Augusto (Nov 2, 2022)
Excellent course! very complete and well explained.
- Paulo Rocha (Aug 16, 2022)
This is s very comprehensive course on Tabular Model, covering everything you possibly want to know about it. It is one more course with the trademark of SQLBI which means excellence in every detail. Maestros Marcos and Alberto are really the greatest contributors to the Business Intelligence community. Thanks again maestros for que excellent work.