Advanced Business Intelligence is divided into three types namely: SSAS, SSIS, and SSRS. Let’s discuss the interaction between SSAS and MSBI in detail
In fact SSAS stands for SQL Server Analyses Services which is a part of Microsoft Business Intelligence to develop online analytical processing Solution, In other words, it a technology for faster and deeper analysis of data in order to create cubes from data mart (or) data warehouses. A data Source view is an insulation data between actual data source and solutions where the schema can be modified as per our requirements. Moreover A star schema is used in the schema structure, where different dimension tables were directly connected to the fact table. It is the way of how does SSAS interact with MSBI.
Here dimensions classified into two types: Database dimensions which perceived as a master template and Cube dimensions which perceived as an instance of the master template. Cubes have multidimensional databases, dimension and facts to its basic constituents. These details generally stored in a pre-aggregated proportional format where the user can analyze the huge amount of data and slice the required data very easily. Here MDX is a query language table used to query a cube, similar to the T-SQL which is used to query the data in SQL Server. MDX is a part of OLD DB for OLAP specification of Microsoft. Some of the other OLAP providers support MDX are Micro strategy’s Intelligence server, and SAS’s Enterprise BI, Server Hyperion’s Essbase server
Adventure Works is the simple databases available from Microsoft for all purpose as well as different SQL versions. This database used for cube design and development, where it contains all the dimensions and prepopulated data to start an SSAS project.
At the same time, Data in OLTP suited that to support convenient data storage for user application. For data warehousing environments, data needs to required in the schema which supports the dimensional model. As a result For analyzing the data in the data warehouse, Using ETL Data needs to transformed from OLTP storage system to data warehouse, where the end user can align the data in a suitable format to create data from a data warehouse.
Know more on OLTP from OnlineITGuru through MSBI online training.
However Analysis services will have the capacity to recover information from Databases through DB interface (or).Net Provider interface. In particular a Data source contains one fact table, with some number of measurements connected by joins where an information source populated by an OLTP information base, called an Operational Data Base (ODS). For example an ODS is a single entity in putting away the information from different Source, which serves as a single source of data for your data warehouse.
Furthermore Analysis services use cartridge device which allows you to use an relevant SQL language. For example Extensions to talk to the different relational databases. And systems which include SQL server, IBM 2, Tera data, Oracle. Therefore a database wizard allows you to create data sources on an existing database collection. In addition that allows you to create data sources. Where a single connection shared by the analytics services for multiple data sources.
I finally conclude how SSAS interacts with MSBI through it supported types.
These data sources supported by two types:
.Net providers: Simultaneously the Microsoft created an a.Net framework and programming language. Where the framework used to run the Common Language Runtime (CLR) environment. For example this framework is itself is a huge class. Where it exposes tons of functionality which contains a managed code.
OLE DB Data providers:
Above all OLE DB an industry standard that defines a set of COM objects. That allows users to access the data from different sources. Consequently Where the data comes from various sources like Microsoft Access, Microsoft project and various database management systems
It’s better to have a fundamental knowledge of keeping up and examining them for implementation. No Programming abilities required to take in this course. It’s great to have knowledge of the utilization of Excel or the worksheets to understand the whole design of MSBI. Checkout in OnlineITGuru now for the best msbi online course