Author - admin

16 Dec

SAS BI Online Course | What is SAS Data Integration Studio

What is Data Integration Studio in SAS ?

SAS Data Integration Studio (SAS DI) is a GUI (Graphical User Interface) for generating and managing SAS codes. SAS Data Integration Studio (SAS DI) is used in building, implementing and managing data,integration process as it is a most powerful tool with user friendly visual design, irrespective of the data sources. This also automates and supports integration and running of large enterprise projects in spite of the repeatable processes. Also the changes made across data integration process will change the impact analysis after creation and management of data and meta data. SAS Data
integration also helps users to fine tune data integration by editing and changing, this also helps users to capture and manage standardized metadata from any source and also to understand enterprise metadata and data integration process for easy display and visualization. One most advantageous feature with SAS DI is that it enables programmers to write and blend tailor made code into the process for reusable purposes as well.
Following are different versions of SAS DI: SAS DI studio was earlier called as SAS ETL studio. Being SAS 9.4 the recent version with compatibility
to Versions 4.7 & 4.9, there are versions from 3.3 that compatible with SAS 9.1.

Learn more about SAS DI here.

By Blog Updates 0 Comments
Read more...
16 Dec

SAS BI Certification Online Training India

What is SAS BI:
SAS BI – called Business Intelligence is a bundle of applications that helps in allowing and displaying data for the enterprises. An overview of what can be learned in SAS BI
– Prepare Data
– Display Data
– Helpers
– Administration
Prepare Data – Preparation of data to view it in Bi tool. This is usually done because raw data exists in relational databases like oracle, mysql etc. Then it is placed in OLAP cubes or information maps to view it. SAS OLAP cubes – This helps in summarization of huge data to make it easy for viewing and drilling down information. SAS information Map Studios – The original purpose of these information maps is to join data, rename variable and make it into a business friendly data.
Display Data – Once the data is prepared, there are many tools to display it, such as:
SAS Web report studio – Creates reports from OLAP cubes, Info maps, SAS datasets.
SAS Add-In for Microsoft Office
SAS BI Dashboard
SAS information delivery portal
Helpers – It involves the following:
SAS Enterprise guide
SAS prompt framework
SAS stored Processes
Administration – This will basically allow users to administrate system and control data access.
Understand more about this here by signing up for a free demo.

By Blog Updates 0 Comments
Read more...
15 Dec

SAS Business Intelligence Online Training Course Content

SAS BI Course Content
Introduction to DWH / BI Concepts

  • SAS Web Report Studio 4.2
  • SAS EG 4.2
  • SAS Information Delivery Portal 4.2
  • SAS Data Integration Studio 4.2
  • SAS BI Dashboard 4.2
  • SAS Management Console 9.2
  • SAS Stored Process 4.2
  • SAS OLAP Cube Studio 4.2
  • SAS Stored Process Web Application 4.2
  • SAS Web OLAP Viewer for Java 4.2
  • Course Notes (Case Studies/ Exercises)
  • SAS Add-In for Ms Office 4.2
  • SAS Information Map Studio
  • LFS
  • Platform flow Manager PFM
  • SAS Web OLAP Viewer
  • SAS BI Dashboard 4.2

Chapter 1

  • Introduction
  • Overview
  • Audience

Chapter 2

  • Getting Started: The SAS Information Delivery Portal
  • Overview
  • Open the Portal and Log On
  • Create a Page and Add It to Your Navigation Bar
  • Add a SAS BI Dashboard Portlet to a Page

Chapter 3

  •  Working with Lists
  • Overview
  • Scroll Through a List
  • Delete One or More Items in a List
  • PART 2 Information for Dashboard Users 11

Chapter 4

  • Working in the SAS BI Dashboard Portlet
  • Select a Dashboard
  • Personalize a Dashboard
  • Personalize an Indicator
  • Create or Edit a Personal Indicator Alert
  • PART 3 Information for Dashboard Administrators 19

Chapter 5

  • Getting Started: Create a Dashboard
  • Create a Collection Portlet
  • Starting the SAS BI Dashboard from the SAS Information Delivery Portal
  • Creating a Dashboard
  • Create a Dashboard from Sample Data

Chapter 6

  • Data Models
  • Overview
  • Data Model Rules
  • Manage Data Models
  • Create or Edit a Data Model
  • Defining a Data Source

Chapter 7

  • Ranges
  • Manage Ranges
  • Create or Edit a Range

Chapter 8

  • Indicators
  • Overview
  • Manage Indicators
  • Create or Edit an Indicator
  • Indicator Displays
  • Indicator Alerts
  • Manage Dashboards
  • Create or Edit a Dashboard
  • Controlling the Appearance of a Dashboard
  • LSF
  • PFM

Data Warehousing Concepts (1week)

  • What is Data Warehousing
  • Why Use a Data Warehouse ?
  • Available Tools in the Market
  • Key Terms
  •  Architectural Concepts
  • Primary Components
  • What is ETL ?
  • Data Cleansing
  • Data Merging
  • Data Aggregation
  • Data Scrubbing
  • Historic Data
  • Current Data & Historical
  • Complete History
  • Limited/Unlimited Number of Histories
  • Load Types
  • First Time Load ( Initial Extraction )
  • Delta Load
  • Full Load
  • Incremental Loads
  • Schema Types
  • Star Schema
  • Snowflake Schema
  • Integrated Star Schema
  • Advantages of Each Schema
  • Dimensional Modeling Techniques
  • Conceptual Modeling
  • Logical Modeling
  • Physical Modeling
  • Named Input
  • Formatted Input
  • Data marts
  • Concept
  • Dependent vs Independent Data Mart
  • Enterprise Warehouse Schema
  • Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
  • Facts
  • Additive Facts
  • Semi Additive Facts
  • Non Additive Facts
  • Measures
  • Dimension Table Types
  • Slowly changing Dimensions
  • Type 1/2/3 Dimensions
  • Junk Dimensions
  • Confirmed Dimensions
  • Need of Time Dimension Comparison
  • Why is BI (Business Intelligence ) Required ?
  • OLTP
  • DSS
  • OLAP
  • Types of OLAP
  • ROLAP
  • MOLAP
  • HOLAP
  • DOLAP
  • DDE Triplet
  • Reporting Architecture
  • Database Layer
  • Interface Layer
  • Server Layer
  • Presentation layer
  • BI Server Systems
  • BI Client Systems and Functionalities
  • Hieracheis
  • Need of Hierarchies in Reporting
  • Need for ODS in Data Warehousing

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
  • Gntroduction 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 4.2 (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 4.2

  • 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 4.2

  • 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 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 Management Console 9.2

  • 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….

Register today to attend Free Instructor Led Online Demo 

By Blog Updates 0 Comments
Read more...
15 Dec

SAS BI Certification Question and Answers

1 Question What are the new features included in the new version of SAS i.e., SAS9.1.3?
Answer The main advantage of version 9 is faster execution of applications and centralized access of data and support.
2 Question What versions of SAS have you used (on which platforms)?
Answer SAS 9.1.3,9.0, 8.2 in Windows and UNIX, SAS 7 and 6.12
3 Question Approximately what date is represented by the SAS date value of 730?
Answer 31st December 1961
4 Question How do you debug and test your SAS programs?
Answer Using Obs=0 and systems options to trace the program execution in log.
5 Question How could you generate test data with no input data?
Answer Using Data Null and put statement
6 Question What is the purpose of error?
Answer It has only to values, which are 1 for error and 0 for no error.
7 Question What are some good SAS programming practices for processing very large data sets?
Answer Sort them once, can use firstobs = and obs = ,
8 Question How do you control the number of observations and/or variables read or written?
Answer FIRSTOBS and OBS option
9 Question How do you test for missing values?
Answer Using Subset functions like IF then Else, Where and Select.
10 Question How can you put a “trace” in your program?
Answer ODS Trace ON, ODS Trace OFF the trace records.
11 Question How to limit decimal places for variable using PROC MEANS?
Answer By using MAXDEC= option
12 Question Describe 5 ways to do a “table lookup” in SAS.
Answer Match Merging, Direct Access, Format Tables, Arrays, PROC SQL
13 Question What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data?
Answer In unsorted data you can’t use First or Last.
14 Question Identify statements whose placement in the DATA step is critical.
Answer INPUT, DATA and RUN…
15 Question What are _numeric_ and _character_ and what do they do?
Answer Will either read or writes all numeric and character variables in dataset.
16 Question What are the validation tools in SAS?
Answer For dataset: Data set name/debugData set: name/stmtchk
For macros: Options:mprint mlogic symbolgen.
17 Question What are the default statistics for means procedure?
Answer n-count, mean, standard deviation, minimum, and maximum
18 Question Where do you use PROC MEANS over PROC FREQ?
Answer We will use PROC MEANS for numeric variables whereas we use PROC FREQ for categorical variables.
19 Question Describe CROSSLIST option in TABLES statement?
Answer Adding the CROSSLIST option to TABLES statement displays crosstabulation tables in ODS column format.
20 Question How to specify variables to be processed by the FREQ procedure?
Answer By using TABLES Statement.
21 Question What is the one statement to set the criteria of data that can be coded in any step?
Answer OPTIONS Statement, Label statement, Keep / Drop statements.
22 Question What are the scrubbing procedures in SAS?
Answer Proc Sort with nodupkey option, because it will eliminate the duplicate values.
23 Question How do you debug and test your SAS programs?
Answer First thing is look into Log for errors or warning or NOTE in some cases or use the debugger in SAS data step.
24 Question What are some good SAS programming practices for processing very large data sets?
Answer Sampling method using OBS option or subsetting, commenting the Lines, Use Data Null
25 Question What areas of SAS are you most interested in?
Answer BASE, STAT, GRAPH, ETS.

SAS BI Business Intelligence Online Training Course 

By Blog Updates 0 Comments
Read more...
14 Dec

SAS Business Intelligence Online Training | SAS BI Online Course

What is SAS BI?
What is Data Integration Studio in SAS BI?

What is SAS DI?
Visual design tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications and technologies.Create process flows and perform – extract, transform, and load (ETL) data for use in data warehouses -cleanse, migrate, synchronize, replicate, and promote data for applications.

What does SAS DI Do?

Give business users at all levels the ability to explore data from the warehouse in a web browser, to perform simple query and reporting functions, and to view up-to-data results of complex analyses Centrally control the accuracy and consistency of enterprise data.

Successful candidates need to be skillful in Online SAS BI Course with topics like:

By Blog Updates , , , 0 Comments
Read more...
13 Dec

Azure Administrator Online Training India

What is Azure Active Directory  ?:

Windows Azure Active Directory is an identity management service which is basically a cloud based directory from Microsoft. Azure Active Directory is integrated with various advanced features such as application access management plus identity governance and core directory services.  Based on centralized rules and policies, this standard platform allows developers to access control to their applications, an intriguing feature Azure AD offers. This platform is more apt for IT admins as it gives single sign on access to all its users and for app developers this platform helps in building the application to make it faster and simple so that integration with other identity management systems becomes feasible.

Azure Active Directory is a consolidation of numerous features like multi factor authentication of identity management capability, self-service password management, privileged account management, application usage monitoring, device registration, self-service group management, access control according to the roles & rich auditing along with security monitoring. These are the most important and need of the day features as these will enable different capabilities of the system to secure and streamline cloud based applications. One unique advantage of Azure Active Directory is that its seamless integration with windows server in just few clicks giving companies to leverage identity investment and manage access.

Know more about the ease of implementing windows Azure Active Directory, here.

By Azure Administration Online Course , , 0 Comments
Read more...
11 Dec

SAP SF Compensation Certification Questions

 

1 Question Which of the following options reflects a best practice for configuring compensation plan guidelines?
Answer Please choose the correct answer.
2 Question You have created a route map and have entered information for all options in each step. You have also configured To Dos for the Home Page.
Question Which field appears in the planner’s To Do List on the Home Page when the worksheet is in their inbox?
Answer Step Name
3 Question Which of the following can a user do to export all of the compensation data from SuccessFactors to another system?
Answer Select the Aggregate Export option from Compensation Home.
Answer Create a Compensation Planning ad hoc report.
4 Question Which actions can you control using role-based permissions?
Answer Read and write compensation data via executive review.
Answer View budget rollup information.
Answer Change eligibility rules in a compensation plan template.
5 Question You have defined the eligibility rules as shown in the attached screenshot. Budgeting is done as a percent of the current salary.
Question What can you see on the compensation form for an employee in Salary Plan PRM? C_THR86_1605 dumps, C_THR86_1605 questions
Answer
The employee appears on the form and is included in the total budget basis but CANNOT receive an award amount in merit, adjustment or lump sum.
6 Question Your customer needs a budget that calculates a percentage of imported values for each employee on the compensation worksheet.
Question Which Based On option can you use to fulfill this requirement?
Answer User
7 Question Your client notices that data on compensation worksheets is incorrect. The attached screenshot shows the user data file (UDF) that was
Question uploaded. Which columns cause this problem?
Answer DATE_OF_CURRENT_POSITION
Answer SALARY_PRORATING
Answer SALARY
8 Question Your customer has different compensation plan templates for stock and compensation. This customer therefore wants to use
Question one combined compensation statement. What can you use to achieve this?
Answer The Secondary Plan option
9 Question You want to export user compensation data from your customer’s SuccessFactors system. Which option in the Employee Data
Question Export tool prevents any user compensation data from being downloaded?
Answer Short format: only system fields
10 Question You want to display the percentage of employees in each pay grade who are eligible to receive a stock grant.
Question Which of the following activities must you perform to do this?
Answer Upload a stock participation guideline table CSV file in the Admin Tools.

 

Register today to attend free Demo session – Click Here for More Details 

By Uncategorized , , 0 Comments
Read more...
08 Dec

Microsoft Azure and Machine Learning Online Training

Azure machine learning:

Azure machine learning was launched in 2015, Feb and has immediately changed the technology game of the industry to help solve the problems of big data processing. As this provides an independent work space, ML workspace (Machine Learning) workspace is a place where all the objective work is done like taking it live apart from general Azure dashboard. Workspace can be accessed at azure studio with UI being more clear and coherent even though the dependency of items is not always the same. Following are the items that are more used in this workspace:

  1. Datasets – Usually these are data containers
  2. Experiments – Used to create, test and train the models
  3. Tested models – these are trained and tested models which can be reused
  4. Web services – Used to gain new predictions.

In routine training terms, Machine Learning is used for predicting the day to day complex issues such as weather forecasts, traffic jam analysis and more, Azure ML helps create, deploy and maintain solutions to these kind of predictive problems.

Online training on Azure Machine Learning from Adithya e-learning involves real time training to make candidates understand different scenarios. Advantage with Azure machine learning is it involves very less or no coding and the entire process is a drag and drop model. To learn and understand more, click here.

By Blog Updates 0 Comments
Read more...
08 Dec

Microsoft Azure 8.1 Certification Online Training

Azure Cloud:

Cloud computing has become a mainstream technology in most of the companies and that has become a well-known fact all over but the new word of the day is all about harnessing the power of cloud computing and streamlining the performance of cloud to make its infrastructure more powerful which produces higher returns to the enterprises. In this scenario, more and more cloud computing technologies are evolving, out of which Azure cloud is a growing technology and the certification of Azure have immense implications in the real world job industry.

What is Azure Cloud:

It is an integrated technology blending with different dimensions such as computing, analytics, storage, database, networking & mobile for achieving better ROI’s within an optimised investment and implementation. Certification on Azure will help in gaining the professional recognition for expertise over entire architecting, developing and administering azure solutions, making them Azure specialist. Adithya e-learning offers the high standard industry level training program on Azure cloud which will help in clearing the certification as well. Online training involves work on scripting applications for azure, virtualization, deploying azure infrastructure solutions, managing IT solutions and a real time project.

Know more about Azure cloud here.

By Blog Updates 0 Comments
Read more...
08 Dec

Microsoft Azure 8.1 Certification Online Training

What is Virtual Machine in Azure ?

Azure windows virtual machine (VM) generally uses windows server to support on high level, secure & on-demand virtualized infrastructure. Virtual Machines are typically used to gain control over small or multi-tier applications running on another rack in your datacentres. This tutorial will help you understand how to create, manage and deploy virtual machines in Azure. Azure virtual machines can be created through azure portal and this process also assists in providing a browser based interface for understanding, creating and deploying virtual machines.

Let us now understand the creation of Azure virtual machine:

  • Start by logging into the azure portal and then by clicking on new project and selecting compute, windows 2017 data server can be opened where virtual machine information can be created.
  • Then, on entering the portal, the sizes of VM can be selected here and also the disk type filters can be changed. Once done, by not changing the defaults (will be there in settings) and clicking OK on the summary page will deploy the virtual machine. Once the deployment is done, VM will be pinned to the dashboard of Azure portal, so it opens automatically.

Understand more about the Virtual Machine in Azure, here.

By Uncategorized , , 0 Comments
Read more...