SQL Server Analysis Services for beginners -SSAS
https://CourseBoat.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 35 lectures (2h 43m) | Size: 970.1 MB
Create and deploy a Tabular Data Model
What you'll learn:
Setup Analysis Services Environment
Create a Tabular Model
Connect to data source
Create Table Relationships
Create Calculated Columns
Create Measures
Create Key Performance Indicators
Create Perspectives
Create Partitions
Create Roles
Deploy Model
Transform and import data
Requirements
Basic knowledge of excel advised.
Description
Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms
Tabular models in Analysis Services are databases that run in-memory or in DirectQuery mode, connecting to data from back-end relational data sources. By using state-of-the-art compression algorithms and multi-threaded query processor, the Analysis Services VertiPaq analytics engine delivers fast access to tabular model objects and data by reporting client applications like Power BI and Excel.