Loading...

shape shape shape shape

SAS BI

SAS BI Online Training | SAS BI Training Course Details

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.

SAS BI Online Training Course Content

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.

  • Introduction
  • exploring the platform for SAS Business Analytics
  • introducing the course environment and scenario
  • Introducing the Business User Reporting Applications
  • defining the business user role and reporting applications
  • exploring the SAS Add-In for Microsoft Office
  • exploring SAS Web Report Studio
  • exploring the SAS Information Delivery Portal
  • defining the interaction between the business user and the business analyst
  • Introducing Advanced Reporting Techniques and Roles
  • defining the business analyst role and applications
  • modifying an existing information map
  • creating a new SAS BI Dashboard indicator
  • creating data sources for reporting and analysis
  • defining the interaction between the business analyst and the platform administrator
  • understanding SAS Data Integration capabilities
  • Creating an Information Map
  • understanding SAS information maps
  • utilizing different data sources
  • exploiting dynamic subsetting of data
  • creating prefilters to subset the information map
  • using the Information Map LIBNAME Engine
  • creating information maps programmatically (self-study)
  • Building a SAS BI Dashboard Application
  • understanding SAS BI Dashboard
  • building the SAS BI Dashboard components
  • building advanced SAS BI Dashboard components
  • Building Stored Processes
  • understanding SAS Stored Process concepts
  • creating a stored process from a SAS Enterprise Guide project
  • creating a stored process from a SAS program
  • creating stored process parameters
  • creating a stored process to provide a dynamic data source
  • Utilizing Advanced Techniques with SAS Reports
  • building advanced reports with SAS Web Report Studio
  • creating and using SAS report templates
  • linking reports in SAS Web Report Studio
  • scheduling and distributing SAS Reports
  • building SAS Reports with SAS Enterprise Guide
  • creating shared prompts
  • Consolidating Information into a Business Reporting Application
  • creating the business reporting application
  • Introducing Multidimensional Data Sources
  • understanding online analytical processing concepts
  • building an OLAP cube with SAS OLAP Cube Studio
  • building an information map from a SAS OLAP cube
  • Introducing SAS Visual BI
  • introduction to SAS Visual BI
  • exploring the SAS integration with JMP
  • Examining the Environment Metadata
  • reviewing the platform for SAS Business Analytics
  • reviewing the course environment

Request For a Free Demo

bg

Start Your Best Online Classes With Us