Interview Questions.

Q1. What Are The Applications Primarily Used By Business Analyst?

SAS bi dashboard

SAS Enterprise Guide

SAS Information Map Studio

SAS OLAP Cube Studio

SAS Stored Process

SAS Visual BI

Q2. How Will You Location Sas Platform Applications Available From Web Browser?

Start>> internet

View the hyperlinks stored as favorites in internet explorer

Q3. Explain The Concepts And Capabilities Of Business Object?

A business object may be used to represent entities of the business that are supported inside the design. A enterprise item can accommodate records and the behavior of the enterprise associated with the entity. A business object can be any entity of the development surroundings or a actual man or woman, place or technique. Business gadgets are most typically used and can be used in companies with volatile desires.

Q4. What Is Business Intelligence?

As name indicates it’s the Intelligence one gains from the commercial enterprise; approximately the enterprise. Typically, it's miles achieved by using diverse Data warehousing, Data mining and reporting gear and techniques.

These equipment and techniques assist the system to provide proper facts to right humans at right time and right format. So, decision makers can more deal with their business of creating choices in preference to losing time in digging plies of organization facts.

Q5. What Is Sas Business Intelligence?

SAS business intelligence has analytical competencies like information, reporting, records mining, predictions, forecasting and optimization. They help in getting facts in the format favored. It helps in enhancing exceptional of records.

Q6. What Are Sas Bi Dashboard Components?

Datamodel, dashboard, indicator, levels

Q7. Where To Use Sas Business Intelligence?

SAS BI provides the information about an company while wished. It provides this information in custom designed format. SAS BI integrates statistics throughout the organization and grants the self-provider reporting and analysis. This consumes much less time for responding requests and for business makes use of to view the facts. An integrated, flexible and robust presentation layer for SAS Analytics with full breadth is also offered by means of SAS BI. All those are incorporated within the context of business for higher and faster choice making.

Q8. What Is Broad Cast Agent?

A broadcast agent permits automation of emails to be disbursed. It allows reviews to be sent to different enterprise objects. It also customers to select the file layout and ship thru SMS, fax, pagers and so forth. Broadcast dealers lets in the power to the customers to receive reviews periodically or no longer. They assist to manage and time table the files.

Q9. Explain About Sas Business Intelligence?

SAS commercial enterprise intelligence has analytical abilties like information, reporting, records mining, predictions, forecasting and optimization. They help in getting statistics within the format preferred. It facilitates in improving great of facts.

SAS BI offers the information about an employer while needed. It affords this statistics in custom designed layout. SAS BI integrates statistics across the organisation and promises the self-service reporting and analysis. This consumes much less time for responding requests and for commercial enterprise makes use of to view the records. An included, bendy and sturdy presentation layer for SAS Analytics with full breadth is likewise supplied via SAS BI. All these are included inside the context of commercial enterprise for higher and faster decision making.

Q10. Where Are Dashboard Components Are Created And Maintained?

Sas BI dashboard web application

Q11. How Sas Deals With Business Intelligence?

SAS has developed stop to give up enterprise intelligence answer named as SAS Enterprise Intelligence Platform. It enables the customers to extract and transform business enterprise huge facts into completely incorporated reporting warehouse, leading to more usable business records and extra effective choice making.

With the manner; the platform is based and the manner metadata (The metadata is explored in details on the below sections) is dealt with; it turns into feasible to symbolize the single model of fact to the supposed customers.

SAS stores the facts handiest once which and shares its metadata across all the applications managing that facts which is probably ETL device trying to update that facts or information mining tool trying to dig out that data for a few advert-hoc queries or is probably reporting device generating monthly record for the commercial enterprise.

Q12. What Is Sas Metadata Repository?

It is the vicinity wherein all this metadata is stored in a few specific format. SAS stores its metadata in centralised repository; which in turn is managed by means of SAS Metadata Server. This metadata is then shared with all the packages below SAS Open Metadata Architecture. This allows SAS in attaining single garage of statistics and consistency of the facts amongst all of the applications the usage of it.

Q13. What Is The Limit Of The Number Of The Rows And Columns Available In The Worksheet?

1 million rows and 16000 columns

Q14. What Is The Primary Data Source For The Wrs?

Information maps

Q15. How Many Types Prompting Framework Can Be Broken Down To?

Design time: growing the framework to ask questions and have the outcomes surpassed to the software

Run time: Displaying the prompt in an software and processing the person enter

Q16. How Will You Locate The Sas Platform Applications?

Go to

SAS >> All Programs>>SAS

Q17. What Are The Types Of Interactive Display Types?

Interactive precis chart and detail chart

interactive precis chart and element plot

Q18. How Many Types Of Prompts Are There?

Dynamic activates

Cascading activates

Relative date/Time activates

Range activates

Q19. What Are The Softwares And Applications That Are Used Most Frequently Used By Sas Bi Applications Developers?

SAS AppDev Studio

SAS A/F

SAS/Internet

Q20. What Are Several Options For Creating Reports In Web Report Studio?

There are 3 options:

Report wizard which consist of 5 steps

Templates that contain file layout data

Edit mode, which offer complete control over all components of file advent

Q21. What Is Metadata?

Metadata is regularly referred as “facts about facts”; but I would love to mention it as it's far nothing however additional statistics of your facts.

Usually many programs which deal with the DATA need a few fundamental information about it from their angle; for example, a database gadget in which you are going to save the statistics desires to recognise how consumer desires the facts to be saved? So, whilst you hearth a create table command on the database is nothing however you supply that information to the database gadget. In extra particular time period you outline the desk shape which is gets recognized as tables Metadata.

In some other instance when a few reporting application wishes to produce the weekly record it wishes the information about the fields at the report, format of these fields which are going to be represented to the consumer; what all database tables it’s going to deal with; in which library or schema they're positioned and many others. And so forth. All those terms are referring not anything apart from metadata.

So, it is equal with SAS as nicely; In the context of SAS; metadata is the statistics approximately all of the assets used in the provision of BI. The call of the column in place of the actual values stored inside it. Information about How to examine in information from non-SAS location. Description of document content in preference to the actual document itself. Details of the access rights of all users. A description of the source and goal tables utilized in information integration jobs; in addition to details of all of the transformations.

Q22. What Is Sas Enterprise Intelligence Architecture?

It is platform designed for Business intelligence answer. It has got extraordinary parts or ranges. The metadata sits along these levels and works as glue to stick these types of layers collectively.

There are 4 one-of-a-kind tiers; Data tier, Server tier, Client and Web tier.

All degrees can have been established on the equal machine or is probably on different machines; however, it's miles not unusual preparation to have server tier and internet tier on one machine and data tier and client tier on distinctive machines.

Data tier – Is nothing however in which the all Enterprise level facts is living.

It includes SAS Datasets, OLAP cubes, SAS SPDS (Special Performance Data Server), SAS SPDE, Other RDBMS tables like oracle, ERP structures and so forth. Using SAS/ACCESS we are able to connect with outside databases like Oracle; DB2 and so on.

Server Tier – This consists of all one-of-a-kind varieties of SAS Servers. SAS Servers are just like windows servers; which run within the heritage to serve the requests rose from patron.

SAS servers are commonly installed on specific machines. Various SAS servers all indexed as under;

SAS Workspace Server – The SAS Code generated by using various patron programs is sent to this server for execution. SAS Workspace server then access diverse datasets and libraries protected inside the code and executes them providing the output lower back to the quit customers. Each user has man or woman process allocated on the server.

SAS Stored Process Server – This is region in which all SAS Stored Process are done. SAS saved tactics are centrally saved SAS applications that can be accessed from extraordinary SAS client and web packages.

Object Spawner – Its a part of Server tier that's responsible for start up of SAS Work space server and join them with the Metadata Server.

SAS OLAP Server – This is used to get entry to formerly created OLAP cubes. It can read the cubes which have been created with other non-SAS applications. Process MDX queries. It is thrilling to understand that constructing the OLAP cubes is done by way of the usage of SAS Workspace server even as OLAP server may be used just for analyzing reason.

SAS/Connect Server – It used to submit SAS code from one device to be performed on every other. Provides Remote Library Services, Data transfer offerings and many others.

SAS/SHARE – Gives get right of entry to to SAS files for more than one customers at a time; and avoid connecting to the documents via one of a kind SAS/Connect far off logins.

Apart from this there are some extra SAS servers like Batch Server, Grid Server, Platform in shape for SAS and many others. However maximum crucial of all are SAS Workspace Server, SAS Stored Process Server, SAS OLAP server and Object Spwaner.

Q23. What Are The Component Of Range?

Code c language,c language, label, color

Q24. How Many Display Types Available In Sas Bi Dashboard?

8