What is it?
It is an in-memory database, managed by the Analysis Services Vertipaq engine.
Who uses it?
Power BI and Excel Power Pivot.
Why use it?
To provide fast and simple access to relational data.
When was it introduced?
2012 by Microsoft
How to create it?
Using SQL Server Data Tool.
Where is it stored?
in SQL Server Analysis Services server or Azure Analysis Services.
The data is compressed when stored.
What are the components?
– Tables
– Relationships
– Measures
– Hierarchies
– KPIs
– Partitions
Leave a Reply