Business Intelligence Interview Questions and Answers in 2025 (100+ Q&A)

Business Intelligence Data Warehouse Developer

Ques:- In my report contain Product name, Amount, Country, Sales person.I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.if u select the Asia in prompt page-?ll Asian country results

Asked In :- Fortunesoft IT Innovations, Savantis, ITRS Group, Simplify Healthcare, ASSURANCE IQ, avanade, aml rightsource, metriqe solutions,

Right Answer:
To achieve this, you can create a calculated field or a mapping table that associates each country with its corresponding sales territory. Then, use this mapping to filter the report results based on the selected territory in the prompt. When "Asia" is selected, the report should filter to show only the countries that belong to the Asian territory.

Business Intelligence Database Administrator (dba)

Ques:- Name some of the standard Business Intelligence tools in the

Asked In :- Gleacher Shacklock, Trigyn Technologies Ltd, kotak mahindra bank, florida blue, data domain, frisco independent school district,

Right Answer:
Some standard Business Intelligence tools include Tableau, Power BI, QlikView, Looker, and SAP BusinessObjects.

Business Intelligence Database Administrator (dba)

Ques:- Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007i need to restrect this query to current date and current year[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosale

Asked In :- SAP Concur, Human Cloud Business Solutions, ClearBank, carl zeiss vision, william blair, metricstream, oil spill response ltd,

Right Answer:
```sql
SELECT *
FROM [gosales_goretailers].[Orders]
WHERE [Order month] BETWEEN 1 AND EXTRACT(MONTH FROM CURRENT_DATE)
AND EXTRACT(YEAR FROM CURRENT_DATE) = 2023; -- Replace 2023 with the current year if needed
```

Business Intelligence Database Administrator (dba)

Ques:- What are the limitations of cognos reportnet?What are the enhancements in reportnet ?

Asked In :- Solix Technologies, Inc, Valuefy Solutions, Nihilent Analytics, SFH Nigeria, qBotica, global payments, metricstream, vardhman textiles, kyriba, ccil,

Right Answer:
Limitations of Cognos ReportNet include:

1. Limited support for complex data transformations.
2. Lack of real-time data access.
3. Performance issues with large datasets.
4. Limited visualization options compared to newer tools.
5. Difficulty in managing security and user access.

Enhancements in ReportNet include:

1. Improved user interface for report creation.
2. Enhanced scheduling and distribution features.
3. Better integration with other IBM products.
4. Support for more data sources.
5. Advanced analytics capabilities.

Business Intelligence Data Warehouse Developer

Ques:- What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

Asked In :- Quantile, WFP, TAO Solutions, Seeq, fis,

Right Answer:
IQD stands for "Intelligent Query Data." It is a file format used in IBM Cognos ReportNet that contains metadata about the data source, including query definitions, filters, and data relationships.

To create an IQD in the ReportNet Framework, you typically use the Framework Manager to define a model, then publish the model, which generates the IQD files automatically.

Business Intelligence Database Architect/ Designer

Ques:- Tell me about intnx, intcx functions?

Asked In :- Insync Tech-Fin Solutions, Fusionex, Visier, elanco, tata chemicals, envestnet, inc, version 1, innoeye technologies, mindcrest, jedox,

Right Answer:
The `INTNX` function is used to increment a date by a specified interval, returning the new date. For example, it can add months, days, or years to a given date. The `INTCK` function, on the other hand, calculates the number of intervals (like days, months, or years) between two dates.

Business Intelligence Database Architect/ Designer

Ques:- Briefly describe 5 ways to do a “table lookup” in SAS.

Asked In :- Energytech Global, InfoObjects, pwc canada, annalect, collective health, molecular connections, kore.ai, commercetools gmbh, pcf bank, statistics center abu dhabi,

Right Answer:
1. **MERGE Statement**: Combine two datasets based on a common key using the MERGE statement in a DATA step.

2. **PROC SQL**: Use SQL queries to join tables and retrieve data based on specified conditions.

3. **DATA Step with SET Statement**: Use the SET statement to read in a lookup table and match records based on a key variable.

4. **PROC FORMAT**: Create a format using PROC FORMAT to map values from a lookup table to another dataset.

5. **ARRAYs**: Use arrays in a DATA step to perform lookups by referencing values from a lookup table.

Business Intelligence Database Analyst/ Programmer

Ques:- What are all the ways to define macro variable??

Asked In :- DataCore, kotak mahindra bank, ivy mobility, intellicus technologies, stefanini philippines, upstart lab,

Right Answer:
Macro variables can be defined in the following ways:

1. **%LET Statement**: Using the %LET statement to assign a value to a macro variable.
2. **Macro Definition**: Defining a macro using the %MACRO and %MEND statements, which can include parameters.
3. **CALL SYMPUT**: Using the CALL SYMPUT function in a DATA step to create a macro variable from a dataset value.
4. **%SYSCALL**: Using the %SYSCALL statement to create macro variables from data step variables.
5. **%GLOBAL and %LOCAL Statements**: Declaring macro variables as global or local within a macro.

Business Intelligence Database Architect/ Designer

Ques:- For what purpose would you use the RETAIN statement?

Asked In :- Blackcoffer, Acrotrend Solutions, Reflections Info Systems, NISM, Golden Moments, Auriga Research, Aggregate Intelligence, NUKG Business Solutions, gartner, ccil,

Right Answer:
The RETAIN statement is used to keep the value of a variable from one iteration of a data step to the next in SAS programming.

Business Intelligence Database Analyst/ Programmer

Ques:- What is a method for assigning first.VAR and last.VAR tothe BY group variable on unsorted data?

Asked In :- Protege Solutions, Proziod Analytics, ABN AMRO, Tower Hamlets Council, Alberta Health, chick-fil-a-franchise, 3edge solutions,

Right Answer:
You can use the `SORT` procedure to sort the data by the BY group variable first, and then use the `FIRST.VAR` and `LAST.VAR` automatic variables in a `DATA` step to identify the first and last observations in each BY group. If sorting is not an option, you can use a combination of `retain` statements and conditional logic to manually track the first and last occurrences within the BY group.

Business Intelligence Database Architect/ Designer

Ques:- Can u explain me banking domain projects ? and in bankingdomain projects how many dimension tables and how many facttables and how to load source and targets in mapping levelplese expain give me one example?

Asked In :- Aranca (Mumbai), Smart Cube India, VECV, amd, ipl, ccil, fis, bxb digital, a brambles company, mactay consulting,

Right Answer:
In banking domain projects, you typically deal with various dimensions and facts related to transactions, customers, accounts, and branches.

**Example Structure:**
- **Fact Tables:**
- Transaction Fact Table (stores transaction details like amount, date, type, etc.)
- Account Balance Fact Table (stores balance details for accounts over time)

- **Dimension Tables:**
- Customer Dimension (stores customer details like name, address, etc.)
- Account Dimension (stores account details like account type, opening date, etc.)
- Time Dimension (stores time-related data like year, month, day, etc.)
- Branch Dimension (stores branch details like branch name, location, etc.)

**Loading Process:**
1. **Source Extraction:** Extract data from operational databases (like transaction logs, customer databases).
2. **Transformation:** Cleanse and transform the data to fit the dimensional model (e.g., aggregating transaction amounts, deriving account balances).
3. **Loading:** Load

Business Intelligence Database Analyst/ Programmer

Ques:- I have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

Asked In :- Finacus Solutions, SAS Institute, Valuefy Solutions, Allocator, bank of england, metricstream, phonepe, rx savings solutions, metriqe solutions,

Right Answer:
You can use the following code in SAS:

```sas
data _null_;
array vars{*} _all_;
do i = 1 to dim(vars);
put vname(vars{i});
end;
run;
```

This will print the names of the variables in the log window. To print them in the output window, you can use:

```sas
proc print data=_null_;
var _all_;
run;
```

However, since the dataset is null, you may need to create a dummy dataset to see the output in the output window.

Business Intelligence Database Architect/ Designer

Ques:- What?s the difference between VAR A1 – A4 and VAR A1 ? A4?

Asked In :- Magnitude Software, Vontobel, AXA XL, macquarie group, corelogic, hertfordshire county council, innoeye technologies, syncron, deskera, nrsp inc.,

Right Answer:
The difference is that "VAR A1 - A4" represents a range of variables from A1 to A4, while "VAR A1 ? A4" typically indicates a conditional or logical operation involving A1 and A4, depending on the context.

Business Intelligence Database Analyst/ Programmer

Ques:- What can you learn from the SAS log when debugging?

Asked In :- saks fifth avenue off 5th, balbix,

Right Answer:
From the SAS log, you can learn about errors, warnings, and notes related to your code execution, including syntax issues, data processing results, and the steps completed during the execution.

Business Intelligence Database Architect/ Designer

Ques:- What areas of SAS are you most interested in?

Asked In :- VALUEWING CONSULTANCY SERVICES (P), Paperchase Accountancy India, Innoppl Technologies, Grand View Research, Coriolis Technologies, s&p global, ausgrid, london stock exchange group (lseg), mordor intelligence, metron, inc.,

Right Answer:
I am most interested in SAS data manipulation, data analysis, and reporting, particularly using SAS SQL and SAS macros for efficient data processing and automation.

Business Intelligence Database Architect/ Designer

Ques:- If you were told to create many records from one record,show how you would do this using arrays and with PROCTRANSPOSE?

Asked In :- Proziod Analytics, FACTENTRY DATA SOLUTIONS, Citco, docusign, hpl, hiqa - health information and quality authority, nmb bank limited,

Right Answer:
To create many records from one record using arrays and `PROC TRANSPOSE` in SAS, you can follow these steps:

1. Create an array to hold the values you want to expand.
2. Use `PROC TRANSPOSE` to convert the array into multiple records.

Here’s an example code snippet:

```sas
data original;
input id value1 value2;
datalines;
1 10 20
;
run;

data expanded;
set original;
array values[2] value1 value2; /* Adjust size based on number of values */
do i = 1 to dim(values);
value = values[i];
output;
end;
drop value1 value2 i;
run;

proc transpose data=expanded out=transposed;
by id;
var value;
run;
```

This code will take the original record and create multiple records for each value in the array.

Business Intelligence Project Leader/ Project Manager

Ques:- What is Bex?

Asked In :- DET, TFT, Gaian Solutions India, RSA Group, Hywel Dda Health Board, RCT, Jp Morgan Chase, Syniti, singapore economic development board, dse,

Right Answer:
BEx, or Business Explorer, is a tool in SAP BW (Business Warehouse) that allows users to analyze and report on data through various interfaces, including BEx Analyzer for Excel, BEx Query Designer, and BEx Web Analyzer.

Business Intelligence Database Analyst/ Programmer

Ques:- Have you ever used the SAS Debugger?

Asked In :- Khoj Information Technology, Mtree Software, NUKG Business Solutions, Mangalore Infotech Solutions, US General Services Administration, trident group india, latentview analytics, i&m bank, teg analytics, modak analytics,

Right Answer:
Yes, I have used the SAS Debugger to troubleshoot and optimize my SAS programs by stepping through the code, examining variables, and identifying errors.

Business Intelligence Database Architect/ Designer

Ques:- What r the names of the reports that u prepared???

Asked In :- Lumentum Operations, Global Data Management, macquarie group, equifax, loughborough university, hugh james, enel x, ultimate performance, applied data finance, payreto,

Right Answer:
The names of the reports I prepared include Sales Performance Report, Monthly Financial Summary, Customer Satisfaction Analysis, Inventory Management Report, and Marketing Campaign Effectiveness Report.

Business Intelligence Database Analyst/ Programmer

Ques:- Which stats created by proc means that are not created by proc summary or vice versa?

Asked In :- william hill, london stock exchange group (lseg), thoughtspot, applied data finance, upsa,

Right Answer:
PROC MEANS creates the N (number of non-missing values) and NMISS (number of missing values) statistics, which are not created by PROC SUMMARY. Conversely, PROC SUMMARY does not create the standard deviation (STD) and variance (VAR) statistics if the output dataset is specified, while PROC MEANS does.

The Business Intelligence category on takluu.com is crafted for professionals and aspirants preparing for roles that involve transforming raw data into meaningful insights. BI plays a crucial role in helping businesses analyze historical data, identify trends, and make data-driven decisions to improve performance.

This section covers key BI concepts such as data warehousing, ETL (Extract, Transform, Load) processes, data mining, OLAP (Online Analytical Processing), and dashboard development. It also explores popular BI tools like Power BI, Tableau, QlikView, and Microsoft SSRS, along with their applications in reporting and analytics.

Interview questions often test your knowledge of data modeling, KPI (Key Performance Indicators) definition, report creation, and real-time data processing. Candidates should be familiar with database querying using SQL and have an understanding of data governance and quality.

Preparing for roles such as BI Analyst, BI Developer, Data Analyst, or Data Engineer, this category offers comprehensive study materials, practical case studies, and scenario-based questions to enhance your problem-solving abilities and technical expertise.

At Takluu, we focus on combining theoretical knowledge with practical examples, enabling you to confidently tackle technical interviews and demonstrate your proficiency in BI concepts and tools.

Whether you are starting your BI career or looking to upskill, this category equips you with the necessary skills to turn data into actionable business insights.

Questions in: Business Intelligence

What makes Takluu valuable for interview preparation?

Get Our Mobile App

Programming

Reasoning

Network & Telecom

Management

What makes Takluu valuable for interview preparation?