SAS Business Intelligence Online Training

Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI applications support the activities of decision support, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining. BI include a set of concepts and methods to improve business decision making byusing fact-based support systems.

SAS Business Intelligence Online Training Course Content
  • SAS Management Console
    • Introduction to SAS Management Console
    • Navigation in SAS Management Console
    • SAS Open Metadata Architecture
    • Introduction to Metadata
    • Centralized Metadata Management
    • SAS Metadata Server
    • Connecting to the Metadata Server
    • Introduction and Working With Metadata Repositories
    • Client / Server Interaction
    • Create a Custom and Project Repository
    • Setting up Change Management
    • User Creation and Permissions
    • Creating Libraries
    • Creating connections with Data Bases and SAS Applications
    • Creating Flows for Scheduling, Creating Jobs with dependencies and without dependencies.
    • Brief Explanation about LSF and Process Managers
  • SAS Enterprise Guide
    • Introduction on SAS EG Application
    • Customizing SAS Enterprise Guide options
    • Setting up and managing profiles
    • Importing files from sources other than SAS
    • Accessing data via SAS libraries
    • Grouping and summarizing data
    • Introduction to querying data
    • Filtering and sorting data
    • Creating new columns with an expression
    • Joining tables
    • Grouping and summarizing data in a query (self-study)
    • Creating new columns by recoding values (self-study)
    • Creating a frequency report
    • Generating HTML, PDF, and RTF output
    • Creating a listing report
    • Creating a graph
    • Creating Stored Process from SAS EG.
    • Creating OLAP cubes from SAS EG.
    • Working on different STATASTICAL Procedures.
  • SAS/DI Studio Or ETL Studio
    • Data ware housing Concept
    • Exploring SAS Data Integration Studio
    • Working on Change Management
    • Explaining how to define source, target data structures and designing jobs.
    • Introduction to jobs and the job editor
    • Working with propagation and mappings
    • Working with intermediate files
  • Data Transformations
    • Proc SQL
    • Lookup Table
    • Append
    • Extract
    • Validate
    • Return Code Check
    • Data Transfer
    • Sort
    • Rank
    • Splitter
    • 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
  • Deploying jobs for scheduling
  • SAS OLAP Cube Studio
    • OLAP Introduction
    • Discuss Dimensions / Facts / Hierarchies / Levels / Measures / Ragged Hierarchies / Aggregation
    • 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
    • Measuresv
    • Aggregates
  • Review the Cube design and structure
  • Exploring OLAP
    • Cube with
    • SAS Enterprise Guide
    • SAS Information Map Studio
    • Microsoft Office Excel
    • SAS Web Report Studio
  • SAS Information Map Studio
    • Introduction to SAS information Map Studio.
    • Updating an information map with filters, folders, and data items
    • Adding additional data sources to an information map
    • Overview of information map pre-filters
    • Building a general pre-filter
    • Building an authorization-based pre-filter
    • Information Maps and Stored Process.
    • Overview of stored processes
    • Associating stored processes with an information map
    • Using information maps in SAS Web Report Studio
    • Overview of surfacing data with information maps
    • Using information maps in the SAS Information Delivery Portal
    • Using information maps in SAS Enterprise Guide
    • Using information maps in the SAS Add-In For Microsoft Office
    • Overview of OLAP cubes
    • Building an information map for an OLAP cube
  • SAS Web Report Studio
    • Introduction on SAS Web Report Studio
    • Calling Information Maps into WRS.
    • Creating filters at WRS
    • Creating Layouts for Reports.
    • Creating Prompts.
    • Customizable roles to authorize capabilities(From SMC)
    • Working on Report Creation and Templates.
  • SAS Information Delivery Portal
    • Introduction to SAS IDP
    • Adding a Portal page
    • Adding Contents to Portlet.
    • Adding portlets to page
    • Utilize SAS EG to create content and publish packages to the framework
    • Viewing and managing portal content.
    • Portal Customization
    • Call Reports from WRS to IDP.
    • User level Authentication.
    • Designing Portal
    • Creating Dashboards.
    • Calling STP into IDP
    • Cubes in PORTAL
    • Sharing portal content.
  • SAS MICROSOFT ADD IN
  • SAS BI Dashboards

Please Register with us