SAS BI Online Training

SAS BI Course Content :

1. SAS supports business intelligence with the following:

  • a set of client applications
  • SAS server processes
  • a centralized metadata management facility

2. SAS BI Course Content

  • SAS Data Integration Studio
  • SAS Data Quality Solution
  • SAS Management Console
  • SAS Intelligence Platform
  • SAS Information Delivery Portal
  • SAS Web report Studio
  • SAS OLAP cube Studio
  • SAS enterprise Guide
  • Prerequisites
  • the SAS programming language
  • SQL Knowledge

Chapter-1

  • Overview of SAS 9 Business Intelligence Platforms and SAS Data Integration Study
  • Business Intelligence overview
  • Business Intelligence Information Consumers
  • navigating in SAS Data Integration Studio

Chapter-2

  • Working Under Change Management
  • What is change management?
  • repository types
  • using change management

Chapter-3

  • Designing the Data Mart
  • planning a data warehouse
  • course data for the Orion Star company
  • Orion Star data models

Chapter-4

  • Building a Data Mart
  • review of the case study
  • defining the source data
  • defining the target tables
  • loading the target tables

Chapter-5

  • Administering SAS Data Integration Studio
  • setup tasks for SAS Data Integration Studio
  • setting up change management
  • security planning and implementation (self-study)
  • Creating and Exploiting OLAP Using the SAS System

Chapter 6

  • introduction to Online Analytical Processing
  • overview of SAS OLAP Cube Studio
  • registering metadata

Chapter-7

  • Working with SAS OLAP Cubes Derived from Detail Tables
  • creating a SAS OLAP Cube from a detail table
  • generating aggregations using cross- dimensional tuning
  • setting permissions using SAS Management Console
  • viewing a SAS OLAP cube with SAS Enterprise Guide

Chapter-8

  • Working with SAS OLAP Cubes Derived from Star Sachems
  • creating a SAS OLAP cube from a star schema
  • viewing a SAS OLAP cube with SAS Web OLAP Viewer for JAVA

Chapter-9

  • Monitoring and Tuning a SAS OLAP Cube
  • using Application Response Measurement (ARM) for tuning
  • building an information map from a SAS OLAP cube
  • creating a report with SAS Web Report StudioIII. Accessing SAS from Microsoft Office Applications

Chapter-10

  • overview of the SAS Add-In for Microsoft Office
  • introduction to the course data
  • introduction to the course scenarios

Chapter-11

  • Exploring the SAS Add-In for Microsoft Office
  • using the SAS Add-In for Microsoft Excel
  • using the SAS Add-In for Microsoft Word and Microsoft PowerPoint
  • using the SAS Add-In to publish documents (self-study)

Chapter-12

  • Inserting SAS Data into Microsoft Excel
  • SAS data set concepts and terminology
  • using SAS data sources with Microsoft Excel
  • using SAS data sources in PivotTables

Chapter-13

  • Analyzing Data with SAS Tasks in Microsoft Office
  • overview of SAS tasks
  • list data task
  • one-way frequencies task
  • table analysis task
  • summary table task
  • bar chart task

Chapter-14

  • Using the SAS Information Delivery Portal
  • overview of the SAS Information Delivery Portal
  • navigating the SAS Information Delivery Portal
  • changing portal preferences

Chapter-15

  • Interacting with Reports
  • introduction to reports
  • using SAS reports
  • using SAS stored processes

Chapter16

  • Interacting with Data
  • accessing data in the SAS Information Delivery Portal
  • using relational SAS Information Maps
  • using Multidimensional SAS Information MapsIf you require any further information please do not hesitate to contact us

Course Reviews

No Reviews found for this course.

Drop us a query

Looking for a training for

 Myself My team/organization

captcha

 I agree to be contacted over email

top
Copyright © 2015 KEEN IT TECHNOLOGIES Pvt.Ltd, ALL RIGHTS RESERVED  |   PRIVACY POLICY   |   TERMS OF USE   |   REFUND AND RESCHEDULE POLICIES   |   SITEMAP  
Keen IT is not an affiliate of SAP AG or other products.