Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where is SSAS headed?

Tags:

ssas

I was just wondering if I am one of the few people in the world actually using SSAS, or is it prevalent in IT? There are so few people posting SSAS questions and answers here. Right now I'm running into an issue creating a Data Mining Dimension (model name dropdown is blank) and when I Google the problem I get 4 results. MS did not include it in SQL Server 2010, so is it going away? Are people using PowerPivot instead?

like image 991
Dave Avatar asked Oct 27 '11 17:10

Dave


People also ask

Is SSAS deprecated?

Deprecated features in SSAS 2022There are no deprecated features announced with this version.

Is SSAS a data warehouse?

SSAS is Microsoft SQL Server's Analysis Services which is an online analytical processing (OLAP), data mining, and reporting tool used in Business Intelligence to make data work for end-users. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing.

Why do we need SSAS?

SSAS Tabular gives you the possibility to define very precise and granular security rules on the consumable data. With row-level security rules, data rows can be shielded from target audiences like external users or employees from other departments depending on your business requirements.

Is SSAS hard to learn?

Depending on your programming background and your awareness of SSAS, it could take you anywhere from 14 hours to 14 months to learn. If you have zero programming and data skills, it could take longer.


1 Answers

SSAS is there to stay. Microsoft have a 3 tier strategy for BI :

  • Personnal BI
  • Team BI
  • Organizational BI

PowerPivot is both for Personnal and Team, but SSAS is clearly in the Organizationnal slot. You can read all about it there :

http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx

like image 53
Dominic Goulet Avatar answered Oct 18 '22 02:10

Dominic Goulet