Loading…
Back To Schedule
Tuesday, October 30 • 2:15pm - 3:15pm
Processing Analysis Services Tabular Models

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

For large in-memory Analysis Services Tabular models, the design of table partitions and the scheduled refresh/processing operations has significant implications for query performance, resource utilization, processing duration, and database availability. This session will review the tabular model's processing operation types, design decisions such as parallelism and transactions, and provide examples of Tabular Model Scripting Language (TMSL) scripts and PowerShell scripts used to support the processing of Tabular models. Additionally, common Azure and on-premises job automation and orchestration tools used in the processing of Tabular models will be demonstrated including Azure Automation, SQL Server Agent, and SSIS.

Speakers
avatar for Brett Powell

Brett Powell

BI Consultant, Frontline Analytics
I'm a Microsoft BI consultant specializing in Power BI and Analysis Services. I've authored two books on Power BI and I actively publish blogs on Insight Quest. You can contact me regarding BI architecture and solution design and development topics.


Tuesday October 30, 2018 2:15pm - 3:15pm PDT
1210 Laurel

Attendees (5)