Ques:- Why is SAS considered self-documenting?
Asked In :-
Edgematics, Sigma Computing Solutions, Idbi Bank Ltd, pwc canada, alliantgroup, enel x, truglobal, northeastern university mba, scry analytics,
Ques:- We have a crosstab report which is having product,region and Revenue information. Now the requirement is thatwe need to add a new column with the information 'High' and'Low' just beside the Revenue column. If Revenue is high isshould display as 'High' and if Revenue is low then itshould display as 'Low'.
Asked In :-
Learningmate Solutions, Niper, SpiceJet, Accucia, Petrofac Ltd, bny mellon, vitality uk, cheq systems, inc., eon energy, greyb,
Ques:- How could you generate test data with no input data?
Asked In :-
DataCore, I Logix infotech, Prodapt SA, Spoors Technology Solutions India, Vontobel, macquarie group, sap fieldglass, federal reserve bank of dallas, bairesdev, isilumko staffing,
Right Answer:
You can generate test data with no input data by using data generation tools or scripts that create random data based on predefined rules or patterns, such as using functions to generate random numbers, dates, or strings. Additionally, you can create sample datasets based on common scenarios or use existing datasets as templates to create variations.
You can generate test data with no input data by using data generation tools or scripts that create random data based on predefined rules or patterns, such as using functions to generate random numbers, dates, or strings. Additionally, you can create sample datasets based on common scenarios or use existing datasets as templates to create variations.
Ques:- When we r going for Short_cut join & It's Resolution???Plz provide one scenario??
Ques:- How many missing values are available? When might youuse them?
Asked In :-
E-Merge tech, Magnitude Software, Seeq, KOICA, Pendo, spss, columbia shipmanagement, scalable capital,
Right Answer:
The number of missing values can be determined using functions like `isnull()` or `isna()` in data analysis tools. Missing values might be used in data imputation, to identify patterns in data quality, or to analyze the impact of missing data on results.
The number of missing values can be determined using functions like `isnull()` or `isna()` in data analysis tools. Missing values might be used in data imputation, to identify patterns in data quality, or to analyze the impact of missing data on results.
Ques:- How are numeric and character missing values representedinternally?
Right Answer:
Numeric missing values are typically represented as a special value like NaN (Not a Number) or a specific sentinel value (e.g., -9999), while character missing values are often represented as an empty string or a specific placeholder like "NA" or "NULL".
Numeric missing values are typically represented as a special value like NaN (Not a Number) or a specific sentinel value (e.g., -9999), while character missing values are often represented as an empty string or a specific placeholder like "NA" or "NULL".
Ques:- What is difference between WEBi Report and Crystal Report?
Right Answer:
WEBi Report (Web Intelligence) is part of SAP BusinessObjects and is designed for ad-hoc reporting and data analysis with a user-friendly interface, allowing users to create and modify reports easily. Crystal Report, also part of SAP BusinessObjects, is more focused on highly formatted, pixel-perfect reports and is typically used for operational reporting. WEBi is more flexible for data exploration, while Crystal Report is better for detailed, structured reporting.
WEBi Report (Web Intelligence) is part of SAP BusinessObjects and is designed for ad-hoc reporting and data analysis with a user-friendly interface, allowing users to create and modify reports easily. Crystal Report, also part of SAP BusinessObjects, is more focused on highly formatted, pixel-perfect reports and is typically used for operational reporting. WEBi is more flexible for data exploration, while Crystal Report is better for detailed, structured reporting.
Ques:- What is the equivalent oracle operators for following BOOperators where we use in prompt:a. Different from pattern b.Match patternc. Both and d.Except
Asked In :-
Executive Ship Management, Umang, Fluentgrid, deloitte australia, vardhman textiles, datorama, finicity, j.d. edwards, trans maldivian airways, ontario teachers' pension plan,
Right Answer:
a. Different from pattern - `NOT LIKE`
b. Match pattern - `LIKE`
c. Both and - `AND`
d. Except - `MINUS`
a. Different from pattern - `NOT LIKE`
b. Match pattern - `LIKE`
c. Both and - `AND`
d. Except - `MINUS`
Ques:- What is the difference btween olap and oltp?
Asked In :-
Kardium, Aggregate Intelligence, Maharishi University of Information Technology, Global Data Management, bayshore healthcare, wealth-x, gaininsights solutions, bis research, ontario ombudsman, canada life group insurance,
Right Answer:
OLAP (Online Analytical Processing) is used for analyzing large volumes of data for reporting and decision-making, while OLTP (Online Transaction Processing) is used for managing day-to-day transactional data and operations.
OLAP (Online Analytical Processing) is used for analyzing large volumes of data for reporting and decision-making, while OLTP (Online Transaction Processing) is used for managing day-to-day transactional data and operations.
Ques:- How to schedule the report twice in a day?
Asked In :-
Auriga Research, Modulr, zoom video communications, eon energy, canada life group insurance, synergy,
Ques:- WHO ARE THE USERS OF THE REPOSITORY?
Asked In :-
SAS Institute, falkirk council, edf trading, bairesdev, digital asset, elsa, canada life group insurance, data matrix, herald logic, elinvar.de,
Ques:- What are the differences between web intelligence reports and crystal reports ?
Asked In :-
Innominds Software (P), STUP Consultants, Azuga, CoreCompete, Reflections Info Systems, ICPS, hft, analytix business solutions, gro intelligence, emv,
Ques:- What is LAG function?How is it used? can any one explain
Asked In :-
Ahana Systems & Solutions, ATYETI, London Stock Exchange Group, Qubix International, ubs, telia company, valuemomentum, karnataka bank, origami risk, ramco,
Ques:- What is diff between InfoView and Zero BOAdmin (ZABO)?
Right Answer:
InfoView is a web-based interface for users to access and interact with reports and dashboards in BusinessObjects, while Zero BOAdmin (ZABO) is a lightweight administration tool that allows administrators to manage BusinessObjects environments without the full complexity of the traditional Central Management Console (CMC).
InfoView is a web-based interface for users to access and interact with reports and dashboards in BusinessObjects, while Zero BOAdmin (ZABO) is a lightweight administration tool that allows administrators to manage BusinessObjects environments without the full complexity of the traditional Central Management Console (CMC).
Ques:- How to test reports in cognos ?
Asked In :-
Prospecta, codeMantra, Access Research, Bounteous, gruppo scai, consulenza aziendale informatica, fulton hogan, robins air base,
Right Answer:
To test reports in Cognos, follow these steps:
1. **Verify Data Accuracy**: Check that the data in the report matches the source data.
2. **Check Report Layout**: Ensure the report layout is as per the specifications (formatting, alignment, etc.).
3. **Validate Filters and Prompts**: Test all filters and prompts to ensure they return the correct data.
4. **Test Calculations**: Verify that any calculations or aggregations are correct.
5. **Check Performance**: Assess the report's loading time and performance under different conditions.
6. **Review Security**: Ensure that user permissions are correctly applied and sensitive data is protected.
7. **Conduct User Acceptance Testing (UAT)**: Have end-users review the report to confirm it meets their needs.
To test reports in Cognos, follow these steps:
1. **Verify Data Accuracy**: Check that the data in the report matches the source data.
2. **Check Report Layout**: Ensure the report layout is as per the specifications (formatting, alignment, etc.).
3. **Validate Filters and Prompts**: Test all filters and prompts to ensure they return the correct data.
4. **Test Calculations**: Verify that any calculations or aggregations are correct.
5. **Check Performance**: Assess the report's loading time and performance under different conditions.
6. **Review Security**: Ensure that user permissions are correctly applied and sensitive data is protected.
7. **Conduct User Acceptance Testing (UAT)**: Have end-users review the report to confirm it meets their needs.
Ques:- Can any one give the example for slicing and dicing of data ?(with simple query)
Asked In :-
E2E Research, Acturis, zafin, wmc, bc pension corporation, arden university, smarkets, axiom,
Ques:- Can you excute a macro within a macro? Describe.
Asked In :-
CIGNEX Datamatics Technologies, Creditsafe Technology, KBRA, Keyrus Group, Real Fruit Bubble Tea, TekFriday Processing Solutions, Bio-Reference Labs, webhelp, sirius computer solutions, mcap,
Right Answer:
Yes, you can execute a macro within another macro in most programming environments that support macros, such as VBA in Excel. This is done by simply calling the inner macro by its name within the outer macro's code.
Yes, you can execute a macro within another macro in most programming environments that support macros, such as VBA in Excel. This is done by simply calling the inner macro by its name within the outer macro's code.
Ques:- What are the implications?
Asked In :-
Bannari Amman Institute of Technology, Vontobel, intercontinental exchange, visionary rcm infotech, crunchbase,
Ques:- What are the steps involved in migrating CRN enviroment to Cognos 8?
Asked In :-
Shipmnts, Systematix Infotech, EY GDS, Groundswell Cloud Solution, Acturis, ubs, william hill, cmc markets, roivant sciences, bc pension corporation,
Right Answer:
1. Assess the current CRN environment and gather requirements.
2. Install Cognos 8 and configure the environment.
3. Migrate data sources and connections.
4. Transfer reports and content from CRN to Cognos 8.
5. Validate and test the migrated reports and data.
6. Train users on Cognos 8 features and functionalities.
7. Go live and monitor the new environment for issues.
1. Assess the current CRN environment and gather requirements.
2. Install Cognos 8 and configure the environment.
3. Migrate data sources and connections.
4. Transfer reports and content from CRN to Cognos 8.
5. Validate and test the migrated reports and data.
6. Train users on Cognos 8 features and functionalities.
7. Go live and monitor the new environment for issues.
Ques:- Please, anyone, let me know the style or an example of using'by='/'by' variable of a PDV(Program Data Vector)
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.
