Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the best training institute for SAS in hyderabad.
- 112 Answers
- 224257 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 is treatment emergent events and treatment emregent adverse event
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
What are the statements in proc sql?
explain the use of % includes a statement in sas? : Sas-administrator
What are the scrubbing procedures in sas?
How do you test for missing values?
What can be the size of largest dataset in SAS?
: and & modifiers.
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what is transformation in sas data integration? : Sas-di
is data integration and etl programming is same? : Sas-di
Mention sas system options to debug sas macros.
what is the use of sas management console? : Sas-di
what is sas olap server? : Sas-di
