Audience
Analytical data engine for companies wanting help with decision support and business analytics
About SSAS
Installed as an on-premises server instance, SQL Server Analysis Services supports tabular models at all compatibility levels (depending on version), multidimensional models, data mining, and Power Pivot for SharePoint. A typical implementation workflow includes installing a SQL Server Analysis Services instance, creating a tabular or multidimensional data model, deploying the model as a database to a server instance, processing the database to load it with data, and then assigning permissions to allow data access. When ready to go, the data model can be accessed by any client application supporting Analysis Services as a data source. Models are populated with data from external data systems, usually data warehouses hosted on a SQL Server or Oracle relational database engine (Tabular models support additional data source types).
Popular Alternatives
VertiPaq Analyzer
VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular. Added measures for segments and partitions: pageable, resident, refresh date, last access. Analysis Services provides many Dynamic Management Views (DMV) to collect information about memory used by a data model. For example, DISCOVER_OBJECT_MEMORY_USAGE is a DMV that provides information about all the objects in memory. You can use such a DMV also to monitor a Multidimensional instance of Analysis Services. Kasper de Jonge created a sample model (BISM Memory Report) that organizes this data in a hierarchical way, making it easy to find the most expensive databases, tables, and columns on a server. If you want to analyze a particular database, you probably want to look at more detailed information, which are available in other DMVs.
Learn more
UnlimitedAnalytics
UnlimitedAnalytics® is an enterprise software for data analytics, business intelligence, capacity management, data warehousing, dashboard, and reporting solution that implements a fit-for-all data sources algorithm that creates a simplified, unified multi-data-sources and multi-dimensional data warehouse. Once data is uploaded for ingestion/analysis, users can compose detailed and executive graphic/tabular reports. This is achieved by the solution creating dynamic and on-the-fly multi-dimensional data cubes (OLAP, PIVOT, CROSSTAB, etc.) without any coding or scripting requirement. For an organization that is desirous of turning huge and massive data from multiple sources into business information for operational, tactical, and strategic decision-making assets.
Learn more
AnalyticDB
AnalyticDB for MySQL is a high-performance data warehousing service that is secure, stable, and easy to use. It allows you to easily create online statistical reports, multidimensional analysis solutions, and real-time data warehouses. AnalyticDB for MySQL uses a distributed computing architecture that enables it to use the elastic scaling capability of the cloud to compute tens of billions of data records in real time. AnalyticDB for MySQL stores data based on relational models and can use SQL to flexibly compute and analyze data. AnalyticDB for MySQL also allows you to easily manage databases, scale in or out nodes, and scale up or down instances. It provides various visualization and ETL tools to make enterprise data processing easier. Provides instant multidimensional analysis and can explore large amounts of data in milliseconds.
Learn more
Nucleon BizApp Studio
Nucleon BizApp Studio is a high-level application design and development software without or less coding. It supports data editor forms, user controls, reports, charts, tables, cross tables, scripting and other application components. Data Forms allow you to CRUD (create, edit, update, delete), search and view data using HTML-based editor forms. It provides a form designer and viewer where you can design data editor form with its data editor controls (textbox, datatime, numeric, image etc.) and edit the data using this form. It allows only RDBMS (MS Access, Oracle, MySQL, PostgreSQL, SQL-Server etc.) to create, read, update and delete data. NoSQL database systems currently are not supported. Nucleon BI provides OLAP Cross Table features for easy visual data mining and analysis: The Cross Table module provides MS Excel-like tables (Pivot Table), engineered for multi-dimensional data analysis and cross-tab report generation.
Learn more
Integrations
Company Information
Microsoft
Founded: 1975
United States
docs.microsoft.com/en-us/analysis-services/ssas-overview
Videos and Screen Captures
You Might Also Like
Free CRM Software With Something for Everyone
Think CRM software is just about contact management? Think again. HubSpot CRM has free tools for everyone on your team, and it’s 100% free. Here’s how our free CRM solution makes your job easier.
Product Details
Platforms Supported
SaaS
On-Premises
Training
Documentation
Support
Online