Vanligvis vil CTRL + + tastene kunne brukes for å øke størrelsen, og CTRL + - for å redusere den.
Har du hjul på musen, kan du bruke CTRL sammen med hjulet for å justere størrelsen. På Mac kan du bruke CMD + + og CMD + -.
Dette kurset har ikke oppført noen dato for studiestart. Bruk skjemaet under for å kontakte leverandør for nærmere informasjon.
Module 1: SQL Server Analysis Services (SSAS) Tabular Introduction
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.
Module 2: Building Semantic Tabular models
Tabular models are developed in a Visual Studio add-in named SQL Server Data Tools (SSDT). We can start creating models from scratch or we can use models business people already made in Excel and import them in SSDT. 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!
Module 3: DAX Expressions in SSAS Tabular
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.
Module 4: SSAS Administration
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.
Azure Analysis Services
Running Analysis Services Tabular requires a server with a lot of fast memory, software licenses and some maintenance and administration. Unless you run it in the cloud, then you're up and running in minutes!