دوره Microsoft SQL Server Analysis Services Tabular

دوره Microsoft SQL Server Analysis Services Tabular

مدت دوره :

16 ساعت

شرح دوره :

این دوره آموزشی به شما دانش و مهارت هایی را برای توسعه مدل های جدولی در SQL Server Analysis Services 2022 (یا قبل از آن) ارائه می دهد: بارگیری داده ها از منابع مختلف، غنی سازی داده ها با مفاهیم تجاری (به عنوان مثال سال به روز) با استفاده از DAX، تعریف KPI و سلسله مراتب،… این دوره همچنین نحوه مدیریت پایگاه های داده جدولی را شرح می دهد: پشتیبان گیری، امنیت، نظارت و خودکارسازی نگهداری از جدول خدمات تجزیه و تحلیل.

مخاطبان دوره :

این دوره هم برای توسعه دهندگان هوش تجاری که می خواهند مدل های جدولی خدمات تحلیلی را توسعه یا تقویت کنند و هم برای افرادی که نیاز به مدیریت سرورهای جدولی خدمات تجزیه و تحلیل دارند در نظر گرفته شده است. این دوره همچنین برای مدیران پروژه یا تحلیلگرانی مفید است که از معرفی عملی در دنیای جدول خدمات تجزیه و تحلیل ترسی ندارند.

شرکت کنندگان باید اصول اولیه پایگاه های داده رابطه ای را بدانند. تجربه قبلی با OLAP یا خدمات تحلیلی لازم نیست.

Introducing Analysis Services Tabular

In a world where self-service business intelligence becomes more and more important it becomes crucial to understand the power of Online Analytical Processing (OLAP). In this introduction we show the key importance of OLAP systems and discuss the key differences between two OLAP systems that Microsoft Analysis Services provides: Tabular and multi-dimensional.

• What is Online Analytical Processing?
• Microsoft Analysis Services
• Difference between multi-dimensional and tabular

Building Tabular models

Tabular models are developed in Visual Studio. We can start creating models from scratch or we can use models business people already made in Excel and import them in Visual Studio. Not only do you learn to build a basic model, this module also discuss how to extend the model with objects such as display folders, key performance indicators, meta-data translations and more!

• Creating SSAS Tabular projects in Visual Studio
• Importing PowerPivot databases
• Creating databases from scratch
• Linking tables
• Building hierarchies
• Extending the model with KPIs, translations, …
• Working with Direct Query
• LAB: Building a tabular model in Visual Studio

Enhancing Tabular models with DAX

A tabular model becomes more useful to the business if it already contains business concepts such as year-to-date calculations, percentage of parent calculations and similar pieces of derived data often used in reports and analysis. In tabular Analysis Services models we have to encode this derived calculations using the Data Analysis eXpression language: DAX. This module shows you how DAX can be used to encode many business concepts into your model.

• Why do we need DAX?
• Deriving columns with DAX
• Referencing columns and tables
• Related and RelatedTable
• Building DAX measures
• Row versus filter context
• Using CALCULATE
• Implementing Time intelligence
• LAB: Creating measures and calculated columns with DAX

Administering Analysis Services

For an enterprise solution it is crucial that what has been build by the developers is well maintained as well. This involves taking backups of the deployed models, applying row level security such that business users can only see the objects relevant to their job, refreshing the data in the models (also called processing) and monitoring the models using Extended events, profiler, performance counters and dynamic management views.

• Backup and restore
• Securing the tabular model
• Processing
• Monitoring
• LAB: SSAS Tabular administration