• LOGIN
  • No products in the cart.

SAS BI Interview Questions

What is SAS Business Intelligence?

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

What is Business Intelligence?

As name suggests it’s the Intelligence one gains from the business; about the business. Typically it is achieved by various Data warehousing, Data mining and reporting tools and techniques.

Where to Use SAS Business Intelligence?

SAS BI provides the information about an enterprise when needed. It provides this information in customized format. SAS BI integrates data across the enterprise and delivers the self-service reporting and analysis. This consumes less time for responding requests and for business uses to view the information. An integrated, flexible and robust presentation layer for SAS Analytics with full breadth is also offered by SAS BI. All these are integrated within the context of business for better and faster decision making.

SAS BI Online Training

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

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

What is METADATA?

Metadata is often referred as “data about data”; but I would like to say it as it is nothing but additional information of your data.

Usually many applications which deal with the DATA need some basic information about it from their perspective; for example a database system where you are going to save the data needs to know how user wants the data to be saved? So when you fire a create table command on the database is nothing but you give that information to the database system. In more specific term you define the table structure which is gets recognized as tables Metadata.

How many types of prompt are there?

The four types of prompt are:

  • Dynamic prompts
  • Cascading prompts
  • Relative date/Time prompts
  • Range prompts
  • What is BAS? What is the function?

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft. Applications and consultation to customers with their computer-related tasks.

What is the purpose of reporting?

That is more self-explanatory than previous questions. Ability to view or create report by users is the short answer but usually reporting tools like SSRS are much more powerful and they allow to set up subscriptions, provider reports in different usable for users format, secure reports and so on.

How do we Tune the BO Reports for Performance Improvement?

We can tune the report by using index awareness in universe

What are several options for creating reports in Web Report Studio?

There are three options

  • Report wizard which consist of five steps
  • Templates that contain report layout information
  • Edit mode, which provide full control over all aspects of report creation

What are SAS BI dashboard components? 
Data model, dashboard, indicator, ranges

How do we enhance the functionality of the reports in BO?

You can format the BO Reports by using various features available. You can turn the table reports into 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format, based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

What is the mean of BOMain.Key in business intelligence?

BOMain.key file contains all relevant information about the repository. It contains the address of the repository security domain.

What are the component of range
code interval,interval, label, color

What is broad cast agent in business intelligence?

A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast agents allows the flexibility to the users to receive reports periodically or not. They help to manage and schedule the documents.

Why we cannot create an aggregate on an ODS Object?

  • Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.
  • ODS is closer to OLTP system. We don’t normally prefer to store aggregated data in OLTP. So it is with ODS.
  • Unlike data warehouse where data is HISTORICAL, ODS is near real time (NRT). So data aggregation is less important is ODS as data keeps changing.

What is slicing in business objects?

Slicing and dicing of business objects is used for a detailed analysis of the data. It allows changing the position of data by interchanging rows and columns.

How to connect GDE to Co Operating system in Abinitio?

We can connect Ab Initio GDE with Co>operating system using Run->Settings.In there u can specify the host IP address and the connection type .Refer Ab Initio help for further details.

SAS BI Corporate Training

What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?

OLAP – On-Line Analytical Processing.

Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

MOLAP – Multidimensional OLAP.

This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.

Targeted at groups of users because it’s a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

DOLAP – Desktop OLAP.

Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).

Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It’s like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

ROLAP – Relational OLAP.

Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases. Used for large departments or groups because it supports large amounts of data and users.

HOLAP:

Hybridization of OLAP, which can include any of the above.

November 26, 2019
GoLogica Technologies Private Limited  © 2019. All rights reserved.