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

Presentation of Mastering Tabular
- Analysis Services Tabular overview
  FREE
- Links to external resources
Slides and demos
- Practice by repeating demos
- Demos download
- Slides of the video course
Introduction to Tabular models
- Introduction to Tabular models
  FREE
- Analysis Services architecture
- Introduction to TOM
- Architectural choices
Installing the prerequisites
- Installing the prerequisites
  FREE
- SQL Server
- Important notes about SQL Server 2019 and 2022
- SSMS and the demo database
- Important notes about Visual Studio 2019 and 2022
- Visual Studio
- Power BI Desktop and Excel
- Tabular development tools
Guided tour on Tabular
- Guided tour on Tabular
  FREE
- Introducing the workspace database
- Introducing the guided tour
- Creating a model with Power BI Desktop
- Improving the model in Power BI Desktop
- Getting started with Visual Studio
- Testing reports with Visual Studio
- Deploying models from Visual Studio
- Creating a model with Tabular Editor 2
- Different ways of working with Tabular Editor
- Working with Tabular Editor 3
- Conclusions
Understanding model types
- Understanding model types
  FREE
- Basic model types
- DirectQuery model types
- Conclusions
Formula engine and storage engine
- Formula engine and storage engine
  FREE
- Introduction to the AS engines
- Introducing data islands
- Using multiple data islands
- Final considerations and conclusions
Data sources for Tabular
- Data sources for Tabular
  FREE
- Introduction to data sources
- Power Query data sources
  FREE
- Authentication and impersonation
- Data gateway
- Final considerations
Tabular presentation layer
- Tabular presentation layer
  FREE
- Introducing the presentation layer
- Column names and display folders
- Hierarchies
- Using format strings
- Sorting options
- Summarize by
- Data category
- Object visibility and perspectives
- Grouping columns
- Grouping columns - additional notes
- Date table in Tabular and Power BI Desktop
- Featured tables
- Detail Rows expression
- KPI
  FREE
- Translations
- Q&A in Power BI
Understanding relationships
- Understanding relationships
  FREE
- Introducing relationships
- Types of relationships
- Special behaviors in relationships
- The blank row
- Limited relationships
  FREE
- Relationships and ambiguity
Handling security
- Handling security
  FREE
- Introducing security
- Introducing security architecture
- Understanding roles
- Static row-level security
- Table and column security
- Dynamic security
- DirectQuery security
Understanding data types
- Understanding data types
  FREE
- Introducing data types
- Data type conversion
- Floating point rounding errors
- DateTime
- Other data types
Understanding the VertiPaq engine
- Understanding the VertiPaq engine
  FREE
- Row stores and column stores
- VertiPaq encoding
- VertiPaq segmentation
- VertiPaq segmentation update (Power BI Premium)
- VertiPaq memory usage
- Best practices
Understanding DirectQuery
- Understanding DirectQuery
  FREE
- Introducing DirectQuery
- Using DirectQuery
  FREE
- DirectQuery and DAX
- Understanding query limits
- Real-time and DirectQuery
- Final considerations
Understanding DirectQuery over Analysis Services
- Understanding DirectQuery over Analysis Services
  FREE
- Introduction to DirectQuery over AS
- Architecture of DirectQuery over AS
- Query resolution in DirectQuery over AS
- Calculated columns
- Limitations
- Security and use cases
Aggregations
- Aggregations
  FREE
- Introducing aggregations
- Composite models
- Dual tables
  FREE
- Aggregation and granularity
- Aggregation with custom formulas
- Aggregation precedence
- Updating aggregations
- Conclusions
Push Datasets
- Push Datasets
  FREE
- Introducing push datasets
- Implementing real-time solutions with push datasets
Hardware considerations
- Hardware considerations
  FREE
- Basic hardware considerations
- NUMA and virtual machines
- Hardware in the cloud
Architectural choices
- Architectural choices
  FREE
- Introduction to architectural choices
- Data modeling constraints and requirements
- Performance and latency requirements
- Business logic requirements
- Conclusions
Managing Tabular
- Managing Tabular
  FREE
- What's next?
Interfacing with Tabular
- Interfacing with Tabular
  FREE
- Connections
- Libraries
- Tabular Model Scripting Language (TMSL)
- REST APIs for cloud services
- Choosing between TMSL and TOM
- Conclusions
Deploying Tabular models
- Deploying Tabular models
  FREE
- Deploying and processing in production
- Deploying from Visual Studio
- Deploying from Tabular Editor
  FREE
- Other deployment techniques
- Power BI deployment
Processing and partitioning Tabular models
- Processing and partitioning Tabular models
  FREE
- Processing and partitioning
- Partitions in Tabular models
  FREE
- Partitioning strategies
- Processing options
- Executing process commands
- Processing strategies
Monitoring Tabular
- Monitoring Tabular
  FREE
- Introduction to monitoring Tabular
- Memory configuration
- Diagnostic events and tools
Backup and restore strategies
- Backup and restore strategies
  FREE
- Database storage architecture
- Executing attach, detach, backup, and restore
Scaling out
- Scaling out
  FREE
- Scaling-out Analysis Services
Conclusion
- Conclusion

Student Rating

4.9

80 ratings

93%

4-star Reviews (3 of 48)

Nicolas Rojas (Jul 30, 2023)
Es completo, donde se aprende a profundidad el funcionamiento de tabular y tambien herramientas que ayudan a mejorar tanto el armado del modelo, como la mantencion y la escalabilidad. recomiendo este curso en todos los casos ya que se aprende a realizar modelos en visual estudio, tabular editor y power bi. por lo que es realmente util si trabajas con power bi o power pivot en excel.
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.

Hosted on Vimeo

$349

Enroll Now Or try for free Options for multiple students

Quote

Student Rating (80)

What is included

157 Video Lectures
Sample material
Expert
Trainers
Captions & Subtitles
Student
Certificate

This video course contains 35 hours of training, for a total of 157 lectures. Our training platform tracks your progress and resumes the course from where you left off.

The course is accessible on desktop and mobile browsers for 36 months after the purchase date.

The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.

You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.

In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.

Taught by

Marco Russo

Taught by

Alberto Ferrari

We provide subtitles in these languages:

English
Arabic*
Chinese (China)*
Chinese (Taiwan)*
French*
German*
Italian*
Japanese*
Korean*
Polish*
Portuguese (Brasil)*
Russian*
Spanish*
Ukrainian*

(*) Translated automatically from the original English captions.

After completing all the lectures in this video course, you will be able to download a certificate of completion in PDF format from your student dashboard.

Options

Volume
Discount
Group
Discount
Transferable
License
Manage
your Team

Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.

Amount	Discount
$400+	10%
$800+	15%
$1000+	20%
$4000+	25%

You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the Enroll Now button and add more students in the next step.

Students	Discount
10+	25%
25+	30%
50+	40%
100+	50%
200+	65%
300+	70%
350+	72%

This video course is also available with a transferable license, which is a convenient solution for teams.

License type	Price	Duration	Student(s)
Untransferable	$349	36 months	1
Transferable	$1390	36 months	Unlimited *

* The number of concurrent access reflects the number of licenses you have purchased. E.g. If you have a single transferable license, only one student can access the course at a time. To give another student access to the course, you must revoke the access and assign the license to the different student.