Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the best training institute for SAS in hyderabad.
- 112 Answers
- 230576 Views
- Stansys Software Solutions, I also Faced
- E-Mail Answers
Answer Posted / mahesh
Hi This is Mahesh. I work for MNC and will give exposure to
live environment . Call me @ 9985052355 for any queries.
Here is the Content which I cover
Datawarehousing Concepts
• The Compelling Need for Data Warehousing
• Data Warehouse: The Building Blocks
• Trends in Data Warehousing
• Planning and Project Management of a
Datawarehousing Project
• Defining the Business Requirements
• The Architectural Components
• The Significant Role of Metadata
• Principles of Dimensional Modeling ( Star Schema,
Snowflake Schema, Fact Constellation)
• Dimensional Modeling: Advanced Topics
• OLAP in the Data Warehouse
• Data Warehousing and the Web
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 (Data Integration Studio)
• 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
• Working with the extract transformation
• Working with summary statistics transformation
• Explore status handling for transformations and jobs
• Working with the data validation transformation
• Working with the sort transformation
• Working with the append transformation
• Working with the transpose transformation
• Working with the apply lookup standardization
transformation
• Iterating a job with Loop transformations
• Basics of the Table Loader transformation
• Load styles of the Table Loader transformation
• Table properties and load techniques of the Table
Loader transformation
• Introduction to change management and establishing
a change management environment.
• Defining slowly changing dimensions
• Using the SCD type 2 Loader and Change Data capture
transformations (Pre & Post Process).
• Analyzing metadata using impact analysis
• Deploying jobs for scheduling.
• Deploying jobs as Stored Process.
• Exporting and importing metadata
• Building an OLAP cube
• Building an information map
• Building the dimensions
• Building the fact tables.
• Creating and Exploiting OLAP Using the SAS System
SAS OLAP Cube Studio
• Introduction to Online Analytical Processing
• Overview of SAS OLAP Cube Studio
• Registering metadata
• 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
• 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
• Monitoring and Tuning a SAS 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 Management Console
• User Creation and Permissions
• Creating Libraries
• Creating connections with Data Bases and SAS
Applications
• Creating Repository and creating Folders levels at
Repository
• Checking (TEST) connections for Different SAS
Servers.
• Creating Flows For Scheduling ,Creating Jobs with
dependencies and without Dependencies.
• Migration from Test Servers to Production servers.
• What is Metadata Tree and its Uses.
• Configuring Different Servers @SAS Management
Console.
• Explain The Structure at SERVER LEVEL and SMC LEVEL
(like Where the log files, Config Files, Batch Files,
executable files are stored For running different servers
successfully.)
• Brief Explanation about LSF and Process Managers
• Brief Explanation about WEB Servers like the
purpose of XYTHOS ,TOMCAT,Websphere.
• START and STOP Servers, Take Backups
SAS Information Map Studio
• Overview of SAS Information Maps
• Creating a Metadata Profile
• Creating a SAS Information Map
• Create a Relationship
• Create Folders
• Creating Data Items
• Creating Filters
• Save the Information Map
• Test the Information Map
• Using Information Map in SAS Web Report Studio,
Information Delivery Portal, Enterprise Guide
• Creating Information Maps from SAS OLAP Cubes.
SAS Web OLAP Viewer
• Opening OLAP Cubes, Information Maps(both from OLAP
Cubes and Tables)
• Conditional Highlighting
• Filtering, drilling down, Rolling up, slice and
dice capabilities
| Is This Answer Correct ? | 1 Yes | 17 No |
Post New Answer View All Answers
What are the functions which are used for character handling functions?
Name validation tools used in SAS
what is the difference between unique key and primary key? : Sas-di
Give some examples where proc report’s defaults are different than proc print’s defaults?
How we can call macros with in data step? : sas-macro
what are sas/access and sas/connect? : Sas programming
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How do you add a number to a macro variable? : sas-macro
What are the table names in oracle database...?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
How to limit decimal places for the variable using proc means?
what is sas olap server? : Sas-di
how many display types available in sas bi dashboard? : Sas-bi
name some data transformation used in sas di? : Sas-di
how does sas handle missing values in procs? : Sas programming
