Loading...
SAS Business Intelligence (BI) is a suite of applications that allows you to prepare and display data for statistics, predictive analytics, data mining, text mining, and forecasting. The tools provide interactive visualizations backed by analytics.
Overview of SAS Business Product
SAS Enterprise Business Intelligence (BI) is a collection of tools for preparing and presenting results. Here's a brief summary of the SAS BI product names and their functions.
Prepare Data
It's conceivable that your data is stored in a relational database (Oracle, Teradata, MySQL, etc). The data is then stored in OLAP cubes, information maps, or, in some cases, SAS datasets so that it can be displayed in BI software. Some users use SAS Data Integration (DI) Studio, which is another SAS product, to build their extract transform load (ETL) operation.
SAS OLAP Cube Studio
Create OLAP cubes that are based on MDX code. OLAP cubes allow users to easily display and drill down to desired details by summarising large datasets. SAS Information Map Studio.
DBMS (Oracle, Teradata, DB2), SAS datasets, and OLAP cubes are used to construct knowledge maps. Data can be joined, variables can be renamed, and the data can be presented in a business-friendly format using information maps.
Display and Use Data
Data can be joined, variables can be renamed, and the data can be presented in a business-friendly format using information maps.
SAS Web Report Studio
Reports can be generated using OLAP Cubes, Info Maps, or SAS datasets. End-users can easily review reports and drill down to other reports using a simple, easy-to-use interface.
SAS Add-In for Microsoft Office
In MS-Excel – OLAP Cubes, information maps, and SAS datasets can all be used to create reports. Combine SAS data with Excel spreadsheet data.
In MS Office/PowerPoint – Reports can be created using cubes, information maps, or datasets. While it lacks the flexibility of MS Excel, it is simple to build reports that can be shared with other applications.
It's possible to build data in MS Excel and save it to the cloud, which you can then use in other BI software. This will be a strong alternative for smaller datasets that are modified infrequently and aren't stored centralized, such as a branch organization framework.
SAS BI Dashboard
Build dials, maps, and even moving indicators with the summarised data.
SAS Information Delivery Portal
In one place, you can access all of your Web Report Studio reporting, archiving procedures, and publishing platforms, as well as external web pages.
Prerequisties
This course addresses SAS Web Report Studio, SAS OLAP Server, Platform for SAS Business Analytics, SAS Enterprise Guide, SAS Add-In for Microsoft Office software.