Alberto Ferrari – Mastering Tabular Video Course

Description

Mastering Tabular Video Course , Alberto Ferrari – Mastering Tabular Video Course download

Alberto Ferrari – Mastering Tabular Video Course

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.

Curriculum

Presentation of Mastering Tabular

•  Analysis Services Tabular overview
•  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
•  Analysis Services architecture
•  Introduction to TOM
•  Architectural choices

Installing the prerequisites

•  Installing the prerequisites
•  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
•  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
•  Basic model types
•  DirectQuery model types
•  Conclusions

Formula engine and storage engine

•  Formula engine and storage engine
•  Introduction to the AS engines
•  Introducing data islands
•  Using multiple data islands
•  Final considerations and conclusions

Data sources for Tabular

•  Data sources for Tabular
•  Introduction to data sources
•  Power Query data sources
•  Authentication and impersonation
•  Data gateway
•  Final considerations
• Tabular presentation layer
•  Tabular presentation layer
•  Introducing the presentation layer
•  Column names and display folders
•  Hierarchies
•  Using format strings
•  Sorting options
•  Summarize by
•  Data category
•  Object visibility and perspectives
•  Date table in Tabular and Power BI Desktop
•  Featured tables
•  Detail Rows expression
•  KPI
•  Translations
•  Q&A in Power BI

Understanding relationships

•  Understanding relationships
•  Introducing relationships
•  Types of relationships
•  Special behaviors in relationships
•  The blank row
•  Limited relationships
•  Relationships and ambiguity

Handling security

•  Handling security
•  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
•  Introducing data types
•  Data type conversion
•  Floating point rounding errors
•  DateTime
•  Other data types

Understanding the VertiPaq engine

•  Understanding the VertiPaq engine
•  Row stores and column stores
•  VertiPaq encoding
•  VertiPaq segmentation
•  VertiPaq memory usage
•  Best practices

Understanding DirectQuery

•  Understanding DirectQuery
•  Introducing DirectQuery
•  Using DirectQuery
•  DirectQuery and DAX
•  Understanding query limits
•  Real-time and DirectQuery
•  Final considerations

Understanding DirectQuery over Analysis Services

•  Understanding DirectQuery over Analysis Services
•  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
•  Introducing aggregations
•  Composite models
•  Dual tables
•  Aggregation and granularity
•  Aggregation with custom formulas
•  Aggregation precedence
•  Conclusions

Push Datasets

•  Push Datasets
•  Introducing push datasets
•  Implementing real-time solutions with push datasets

Hardware considerations

•  Hardware considerations
•  Basic hardware considerations
•  NUMA and virtual machines
•  Hardware in the cloud

Architectural choices

•  Architectural choices
•  Introduction to architectural choices
•  Data modeling constraints and requirements
•  Performance and latency requirements
•  Business logic requirements
•  Conclusions

Managing Tabular

•  Managing Tabular
•  What’s next?

Interfacing with Tabular

•  Interfacing with Tabular
•  Connections
•  Libraries
•  Tabular Model Scripting Language (TMSL)
•  REST APIs for cloud services
•  Choosing between TMSL and TOM
•  Conclusions

Deploying Tabular models

•  Deploying Tabular models
•  Deploying and processing in production
•  Deploying from Visual Studio
•  Deploying from Tabular Editor
•  Other deployment techniques
•  Power BI deployment

Processing and partitioning Tabular models

•  Processing and partitioning Tabular models
•  Processing and partitioning
•  Partitions in Tabular models
•  Partitioning strategies
•  Processing options
•  Executing process commands
•  Processing strategies

Monitoring Tabular

•  Monitoring Tabular
•  Introduction to monitoring Tabular
•  Memory configuration
•  Diagnostic events and tools

Backup and restore strategies

•  Backup and restore strategies
•  Database storage architecture
•  Executing attach, detach, backup, and restore

Scaling out

•  Scaling out
•  Scaling-out Analysis Services

Conclusion

•  ConclusionCommonly Asked Questions:
  1. Business Model Innovation: Acknowledge the reality of a legitimate enterprise! Our approach involves the coordination of a collective purchase, in which the costs are shared among the participants. We utilize this cash to acquire renowned courses from sale pages and make them accessible to individuals with restricted financial resources. Our clients appreciate the affordability and accessibility we provide, despite the authors’ concerns.
  2. Mastering Tabular Video Course
  • There are no scheduled coaching calls or sessions with the author.
  • Access to the author’s private Facebook group or web portal is not permitted.
  • No access to the author’s private membership forum.
  • There is no direct email support available from the author or their team.