DUCAT is the most ideal place where for anyone aspiring to learn SAS BI. Our lesson offers the elaborate insight in such a method that anyone can learn the pros and cons and be a specialist. SAS BI is a complete, easy-to-use business intellect software resolution that integrates the power of SAS Analytics and SAS Data Management to offer insights that power better decisions. It includes interfaces that are role based for all types of users within a well-defined IT domination framework. This helps organizations simplify and speed business intelligence employment. We at DUCAT impart guidance in such a method that it is a step by step approach to SAS BI. The teaching is planned by many instances that can be done through SA BI and some generated workout which will help to appraise your level of perception. DUCAT training members are a batch of extremely educated professionals who have vast familiarity and coverage. They share their knowledge to make you also an expert in that field. So after the training you also have the same level of know-how and can communicate that in your own business or at your job place. The training makes you the first choice for employers. The guidance imparted not only makes them capable of taking proper carrier decision but also makes them more appropriate to run their own business more suitably.

SAS INTELLIGENCE PLATFORM SAS INTELLIGENCE PLATFORM – BI TOOLS 4.2 VERSIONS SAS BUSINESS INTELLIGENCE TOOLS - COURSE OUTLINE PRACTICAL

  • SAS Data Integration Studio 4.2
  • SAS Olap Cube Studio 4.2
  • SAS Management Console 9.2
  • SAS Enterprise Guide 4.2
  • SAS Information Map Studio 4.2
  • SAS Web Report Studio 4.2
  • SAS Dashboard 4.2
  • SAS Information Delivery Portal 4.2
  • SAS Web Olap Viewer for Java
  • SAS Stored Process 4.2
  • SAS Stored Process Web Application 4.2
  • SAS Add In for Ms Office 4.2
  • Introduction to DWH / BI Concepts

SAS DATA INTEGRATION STUDIO 4.2 INTRODUCTION TO SAS DIS STUDIO

  • Features of SAS DIS Studio
  • Tasks performed by SAS DIS Studio
  • Navigation to SAS DIS Studio
  • Registering Source Tables Metadata

REGISTER METADATA FOR EXISTING SAS DATA SETS

  • Register metadata for a relational database accessed through an ODBC Driver
  • Register metadata for an external flat file (.csv, .txt files)

REGISTERING TARGET TABLES METADATA

  • Register target metadata for dimensional and fact tables

CREATING A JOB TO LOAD TARGET TABLES

  • Dimensional Tables
  • Fact Table
  • Creating the Star Schema Design (Implementing Slowly Changing Dimension Concepts)
  • Applying Transformations
  • Slowly Changing Dimensions
  • SCD Type2 Loader
  • Fact Table Lookup
  • Surrogate Key Generator
  • Key Effective Date
  • Data Transformations
  • Data Transformations
  • Proc SQL
  • Lookup Table
  • Append
  • Extract
  • Validate
  • Return Code Check
  • Data Transfer
  • Sort
  • Rank
  • Control Table
  • User Written Code
  • Create Transformation Template
  • Transpose
  • Data Access Transformations
  • File Reader
  • File Writer
  • Table Loader
  • Analysis Transformations
  • Frequency Report
  • One-Way Frequency Report
  • Summary Report
  • Tabulate Report
  • Print Report
  • Standardize
  • Converting a report job to a Stored Process
  • Scheduling Jobs in DIS
  • Metadata Sharing
  • Metadata Synchronization
  • Creating Project and Custom Repositories
  • Setting up Change Management for Project Repository
  • Creating a Job that contains Jobs
  • Creating Status Handlers for the Jobs
  • Impact and Reverse Impact Analysis

SAS OLAP CUBE STUDIO 4.2

  • OLAP Introduction
  • OLAP Components / ArchitectureOLAP Models
  • ROLAP
  • MOLAP
  • HOLAP
  • Discuss Dimensions / Facts / Hierarchies / Levels / Measures / Ragged Hierarchies / Aggregation
  • Introduction to SAS OLAP Cube Studio Tool
  • Features of SAS OLAP Cube
  • Tasks performed by SAS OLAP Cube
  • SAS OLAP Server benefits
  • Navigation to SAS OLAP Cube Studio
  • Steps to create an OLAP Cube
  • Creating an OLAP Cube using the cube designer:
  • Create an OLAP Cube from Detail Table (ROLAP)
  • Create an OLAP Cube from Star Schema (ROLAP, HOLAP)
  • Create an OLAP Cube from Summarized Table
  • Create an OLAP Cube with the following features:
  • Dimensions
  • Levels
  • Hierarchies
  • Measures
  • Aggregates
  • Review the Cube design and structure
  • Exploring OLAP Cube with
  • SAS Enterprise Guide
  • SAS Information Map Studio
  • Microsoft Office Excel
  • SAS WRS
  • Performing Cube Updates
  • Incremental Update to OLAP Cube
  • In-Place Cube Update
  • Introduction to MDX queries

SAS MANAGEMENT CONSOLE 9.2

  • introduction to SAS Management Console
  • Navigation in SAS Management Console
  • SAS Open Metadata Architecture
  • variable
  • Introduction to Metadata
  • Centralized Metadata Management
  • SAS Metadata Server
  • Connecting to the Metadata Server
  • Introduction and Working With Metadata Repositories
  • Client / Server Interactions
  • Create a Custom and Project Repository
  • Replication and Promotion of Metadata
  • User Manager plug-in
  • Introduction to SAS Application Servers and defining the SAS Application Servers and various other servers from SAS Management Console
  • Security planning for the user and user groups
  • Access control planning
  • Data Library Manager plug-in
  • Defining a data library
  • Setting up Change Management
  • Creating a new metadata profile from SAS ETL Studio
  • Using Job Scheduler plug-in
  • Define a SAS Batch Server
  • Define a Scheduling Server
  • Create and Schedule a job
  • Introduction to Stored Process and creating Stored Process
  • Additional Topics (Database Server, Database Schema, Data Library)

SAS ENTERPRISE GUIDE 4.2 INTRODUCTION TO SAS ENTERPRISE GUIDE

  • SAS Enterprise Guide Framework
  • SAS EG Building Blocks
  • SAS EG Navigation
  • Create a Project
  • Add data to the Project:
  • Adding local SAS table
  • Accessing remote data (Self Study)
  • Adding spreadsheet to a project
  • Adding text file to a project as a SAS dataset
  • Creating various Report Tasks
  • List Report
  • Frequency Report
  • One-Way Frequency Report
  • Two-Way Frequency Report
  • Generating Summary Statistics
  • Create Tabular Summary Report
  • Creating a Graph
  • Create various Data Transformation
  • Filter
  • Sort
  • Rank
  • Transpose
  • Append
  • Introduction to Query Builder
  • Setting a filter and selecting columns
  • Creating new columns in a query
  • Replacing values in a query
  • Joining Tables
  • Inner Joins
  • Outer Joins
  • Creating and applying custom formats
  • Creating Advanced Queries
  • Controlling Query Output
  • Creating and applying parameterized queries
  • Grouping and Filtering data in a query
  • Additional Topics
  • Automating projects and processes
  • Creating customized Process Flow
  • Modifying SAS Code
  • Customizing Task Code
  • Exporting SAS Code
  • Customizing the Outputs
  • Style Manager
  • Document Builder
  • Project View
  • Viewing an OLAP Cube with SAS Enterprise Guide
  • Viewing an Information Map with SAS Enterprise Guide
  • Create and Register Stored Process from SAS Enterprise Guide

SAS INFORMATION MAP STUDIO 4.2

  • Introduction to SAS Information Map Studio
  • Navigating SAS Information Map Studio
  • Access and source data from SAS Information Map Studio
  • Updating an Information Map with filters, prompts, folders and new data items
  • Building an Information Map from:
  • SAS Datasets (Relational SAS Information Map)
  • OLAP Cube (Multi Dimensional Information Map)

SAS WEB REPORT STUDIO 4.2

  • Introduction and Navigation to SAS Web Report Studio Interface
  • Understanding the Tasks performed within SAS Web Report Studio
  • Creating Basic reports by using New Report and Report Wizard
  • Create a Web Report from Detail table and OLAP cubes Information Maps
  • Managing Existing Reports
  • Searching a report
  • Navigating report folders
  • View report definitions
  • Storage locations for reports
  • Report actions available (Edit/Rename/Move/Copy/Delete/Rename/Schedule)
  • Scheduling & Distributing Report

SAS STORED PROCESS 4.2

  • Introduction to SAS Stored Process
  • Building Registering and Testing Stored Process
  • SAS Enterprise Guide 4.2 (Create, Register and Test)
  • SAS Data Integration Studio (Create and Register)
  • SAS Management Console (Registration)
  • Access Stored Process from SAS Web Report Studio / SAS Information Map Studio / SAS Stored
  • Process Web Application
  • Create Stored Process with Prompts

SAS STORED PROCESS WEB APPLICATION 4.2

  • Introduction to SAS Stored Process Web Application
  • Viewing SAS Stored Process from Web Application
  • Managing Stored Process from Web Application

SAS ADD-IN FOR MICROSOFT OFFICE 4.2

  • Introduction and Navigation to SAS Add-In for Microsoft Office
  • Connecting to the SAS Metadata Server from Microsoft Excel
  • Inserting SAS Data into Microsoft Excel
  • Accessing SAS data
  • Filtering SAS data
  • Sorting SAS data
  • Selecting and Ordering columns
  • Analyzing with SAS Tasks in Microsoft Office
  • Access and Analyze SAS OLAP Cubes from Microsoft Office
  • Running Stored Process from Microsoft Excel
  • Customizing the Output Style

DATA WAREHOUSING AND BUSINESS INTELLIGENCE CONCEPTS DATA WAREHOUSING

  • Data Warehouse Introduction
  • Steps to Design Data Warehouse
  • Components of Data Warehouse
  • Approaches to Data Warehouse Designing
  • Data Modeling types:
  • Normalized Data Model (Databases)
  • Dimensional Data Model (Data Warehouses)

BUSINESS INTELLIGENCE

  • Business Intelligence Introduction
  • SAS Business Intelligence Architecture
  • Client Tier – Middle Tier – Server Tier
  • Introduction to Metadata
  • Types of Metadata
  • SAS Centralized Metadata Repository
  • Advantages of SAS Centralized Metadata Repository
  • About Metadata Profile
  • Data Model's
  • Normalized Relational Data Model (Entity-Relationship)
  • Dimensional Data Model
  • Star Schema Design
  • Snowflake Schema Design
  • Dimension Tables
  • Steps in designing Dimensional tables
  • Conformed Dimensions
  • Datatype
  • Junk Dimensions
  • Degenerate Dimension
  • Slowly Changing Dimension (Type1, Type2 & Type3)
  • Fact Table
  • Steps in designing Fact tables
  • Datatype
  • Types of Fact tables
  • Additive * Semi-Additive * Non-Additive.
COMMENCING NEW BATCHES
ENQUIRY FORM
FOLLOW US ON
SUBSCRIBE TO OUR NEWSLETTER

WE ACCEPT ONLINE PAYMENTS
PAY ONLINE