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
- Tim Roper (Dec 1, 2021)
Lays the foundations for designing models that will meet your expectations. When you meet a fork in the road, this course tells you the pros and cons of each path you could take. It won't actually tell which path to take (and rightly so), it merely enables the designer to make informed decisions. Do not overlook the private discussion area. If anything is unclear to you, simply ask your question and the course organisers will answer!
- SQL Down Under (Nov 29, 2021)
I was looking for a course that I could recommend to my customers, so I decided to review this one. What a great job you have both done with it. It is truly excellent. I know what sort of effort is involved in creating this, and can only thank you both for doing so. Well done !
- James Morton (Nov 12, 2021)
Excellent course - lots of great information. One point to note is that the speech to text for the lectures occasionally doesn't understand the lecturer and uses the incorrect word
- Dmytro Polishchuk (Nov 8, 2021)
I think that this is a great course. I don't even know how you can make it better.
- Pelle Bergkvist (Nov 6, 2021)
Excellent! I have worked with Power BI for 8 years, but still have a lot to learn. Since Alberto and Marco are so exceptional skilled in this topic I thought the course should be a little bit too advanced for me. But with excellent pedagogy and very good example step by step the course was just perfect for me. I can really recommend it.
- Iman Ef (Nov 3, 2021)
Incredibly useful course by the best experts in this area!
- Javier Mc Calla Vaz (Nov 1, 2021)
Perfect course!!!
- Kenneth Barber (Oct 16, 2021)
This is a very thorough course about programs that use Tabular and is well worth the price increase compared to its predecessor, and the free upgrade to this course for those that were taking the predecessor was very generous. I have no complaints about this course's content and I am very glad that this course exists. However, the delivery was unnecessarily long-winded and exhausting to watch, even when you watch at double speed. To avoid repetition and reduce the course time, there could have been better integration between Alberto's lectures and Marco's demos, and some of Marco's demos might have been better off being recorded without commentary, edited to speed up mouse movements and waiting time and to remove imperfections, and then commentated after the fact. In general, better planning and heavier use of video editing would have greatly improved the information density of this course and make it easier for students to make connections between the different topics and get a big-picture understanding of Tabular.
- Eduardo Dellepiane (Oct 10, 2021)
Excellent! The content, the explanations, the demos, the way you go deeper as we advance...just amazing. Thank you very much!
- Tyler Snyder (Oct 4, 2021)
Outstanding value. Undoubtedly, five stars. Pros: - Content. - Clear/detailed explanations of new concepts. - Improved video platform. - Tabular Editor 3 Enterprise license for three months ($300 itself). - Course will be useful as a reference guide post-completion. The one critique I have is the lack of practice material. A simple 'try and complete this objective' statement before some demos would have been enough to meet this need. Would I recommend this to a friend? - "As always, it depends. If you aren't sure, test it with the free trial. Will you utilize this information, or will you not utilize this information? You'll need to understand your unique circumstances to decide what's right for you." ^Some of you will understand why that's in quotes.
- Mark Bond (Sep 25, 2021)
Sorry, this is the worst course you’ve created for following. It is done at such a speed that you can’t follow it with ease. There have been too many times when, and I’ve done everything you’ve done, but it’s given a different result. It is incredibly frustrating compared to the other courses you’ve provided.
- – Hi Mark,
Thanks again for your honest opinion.
Just so my recommendations are available for everyone: the player is designed to allow students to set at what speed they want to watch. Some parts people may want to speed up, some parts people may want to slow down. In the bottom right corner of the player the little gear icon allows us to set the speed.
Students should also make full use of the private discussion area available inside the course in case they have questions about the results they're getting. The discussion section is closely monitored by Marco, Aberto and Sergio.
Thanks,
Claire
Reply by Claire Costa (Oct 6, 2021)
- – Hi Mark,
Thanks again for your honest opinion.
Just so my recommendations are available for everyone: the player is designed to allow students to set at what speed they want to watch. Some parts people may want to speed up, some parts people may want to slow down. In the bottom right corner of the player the little gear icon allows us to set the speed.
Students should also make full use of the private discussion area available inside the course in case they have questions about the results they're getting. The discussion section is closely monitored by Marco, Aberto and Sergio.
Thanks,
Claire
- Francisco J Montes (Sep 18, 2021)
Too much talking
- Sergio Murru (Aug 23, 2021)
The most complete course about the internals of SSAS Tabular seen as the core of the different products SSAS Analysis Services, Azure Analysis Services and Power BI. This course is amazing!