[Top 150 ] Business Analyst Interview Questions and Answers| business analyst interview tips
In this video, we put together essential Business Analyst interview questions with answers over six important categories like Tableau, R, SQL These questions are for quick browsing before the interview or to act as a detailed guide on different topics in Business Analyst interviewers look for General 1. Name the five basic elements' categories in BPMN. They are Flow Objects, Data, Connecting Objects, Swimlanes, and Artifacts. 2. How can you say that a requirement is good or perfect? The features and standards of a good requirement can be pointed out using a rule called SMART rule. Specific – The description of a requirement should be perfect and specific enough to understand it.
Measurable – There are various parameters through which the requirement’s success can be measured. Attainable – Resources should be able to achieve success with the requirement. Relevant – States that what results are realistically achieved. Timely – Requirements of a project should be revealed in time. 3.
How does CATWOE help in business analysis and decision-making? Customers, Actors, Transformation process, Worldview, Owners, and Environmental constraints (CATWOE) helps in making decisions ahead of time. It includes analyzing how those decisions will affect customers (C); who are involved as actors (A); what different transformation (T) processes are which might affect the system, global picture, and worldwide (W) issues; who is responsible/has ownership (O) for the business; and what the environmental (E) impacts will be of the project/business. 4. Why do we use Activity diagram? Activity diagram is a graphical depiction/flowchart of actions, representing a stepwise listing of activities. We use activity diagrams for the description of those business processes that describe the functionality of the business system. 5.
What all various diagrams that a BA should have knowledge about? Activity Diagram – This represents the flow from one activity to the other activity. Activity refers to the operation of the system. Below shown is an example of activity diagram. Data Flow Diagram – Graphical representation of the flow of data into and out of the system. This diagram represents how data is shared between organizations. How a DFD looks like is shown below Use case Diagram – This diagram describes the set of actions that systems perform with one or more actors (users) of the systems.
Use case diagram is also called as a Behavioral diagram. Sample use case diagram is shown below Class Diagram – This is the structural diagram that represents the structure of the system by showing its classes, objects, methods or operations, attributes etc. A class diagram is the main building block for detailed modeling which is used for programming. Below shown is an example of a class diagram. Entity Relationship Diagram – ER Diagram is the graphical representation of entities and the relationships between them. This is a data modeling technique.
The example of an ER diagram is as below Sequence Diagram – Sequence diagram describes the interaction between the objects like how they operate and in what time sequence the messages flow from one object to the other. Example for sequence diagram Collaboration Diagram – Collaboration diagram represents the communication that occurs between the objects by showing the messages flow among them. 6. What is a feasibility study? Feasibility study is identifying the possibility (success rate) of the proposed idea for a business problem.
It helps identify new opportunities and focus on the project. 7. How can you avoid scope creep? Documenting the scope of the project. By following proper change management. Informing the effects of the change to the affected parties before making a change. Documenting the new requirements in the project log.
8. What is Pugh Matrix? Pugh Matrix is used to decide about the most optimal and alternate solutions. This technique is now a standard part of Six Sigma technique.
It is also known as a problem or design matrix. 9. What are the important areas in a Kano Analysis? Important areas in a Kano analysis are: Unexpected Delighters Performance Attributes Must Have Attributes 10. How do you define Personas? Personas are used instead of real users that assist developers and technical team in judging the user behavior in different scenarios. Personas are social roles, performed by any actor or character. It is derived from a Latin word meaning "character."
In marketing terminology, it represents a group of customers/end users. 11. What is Pareto Analysis? Pareto Analysis is a decision-making technique, also known as the 80/20 rule. It is used for quality control and defect resolution. It explains a few factors that can be responsible for big problems.
It is named as 80/20 rule, because as per this rule, 80 % effects in the system, arises from 20 % causes. 12. What is a requirement elicitation technique? Requirement elicitation is a technique of requirements gathering from users, stakeholders, users, clients by conducting interviews, sessions, brainstorming, etc.
13. List the business analysis process flow. Information gathering Identify the key stakeholders Identify the business objective Determine the available options Scope definition Define the delivery plan Define the requirements for a project Implementation and evaluation 14. What is meant by Benchmarking? The process of measuring the quality of policies, programs, products, rules and other measures of an organization against the standard measures or against the other companies is termed as Benchmarking. This is used to the measure the performance of a company to compete in the industry.
15. What is the major difference between risk and issue? A risk is a future event which negatively impacts business objective, while the issue is a result of events currently happening. 16. What is Risk mitigation? Risk mitigation is what to do when a risk occurs.It reduces the probability of risk occurrence. It checks whether any impact occurs for the project/business.
Cost is high in case any risk occurs. 17. Name the two documents related to a use case.
FRD (Functional Requirement document) SDD (System Design document) 18. What does PEST stand for? It means Political, Economic, Social, and Technological. It is used to analyze the business environment, in which it has to be operated. 19. What is business process modeling? Business process modeling is a part of business process management, which is used to improve the business process.
It is the representation of an organization’s business process. 20. Define Pair-Choice Technique. The pair-Choice Technique is used to give priority to various items in a process. It is mainly used when distinctive stakeholders are involved in the project.
This technique asks the group to compare each item with others and select the one having the highest priority. 21. What is 8-omega? It is a business framework that is mainly being adopted by firms and organizations for the betterment of their business. Its key factors are Strategy, People, Process, and Technology. 22.
What are the initial steps involved in product development? Market analysis SWOT analysis Personas Competitor analysis Identifying the strategic vision 23. Define use-case points. Use-case points are used to evaluate the cost of work done to develop the system.
24. How do you analyze performance metrics? Make sure that your key deliverables are met. The budget and time for the project should not be extended. Quality deliverables are maintained. 25.
What is a misuse case? It is a term derived from use-case. Unlike use case, a misuse case is something that shows -what kind of malicious activities can be performed by an actor that may result in system failure. 26. List various components of strategy analysis.
Vision Mission Objectives Strategies Action plan 27. What is the purpose of the Requirement Traceability Matrix? Requirement Traceability Matrix (RTM) is used to record all the requirements given by a client, so the purpose of RTM is to ensure that all of the mentioned requirements are met. 28. How do you define a requirement? A requirement is a capability possessed by a solution to solve a problem or achieve an objective.
Requirements are input to various stages of SDLC and must be properly documented and validated by the business users/stakeholders. 29. What does BPMN stand for? BPMN is the Business Process Model and Notation. It is a graphical representation of business processes. 30.
What does FMEA stand for? It means Failure Mode and Effects Analysis. It is a failure analysis, that is used mainly in product development, system engineering, and operations management. This analysis is performed to figure out various failure modes and their severity in any system. 31. List the core competencies of a Business Analyst Analytical thinking and decision-making Business and industry knowledge Business process management Technical and soft skills Problem solving and negotiation skills 32. What is the Kano Analysis? Kano Analysis helps you to analyze a system.
It helps to identify its impact on customers' satisfaction. 33. What is business modeling? Business modeling is identifying the value proposition for a business and then building a step-by-step approach for operating the business.
This step-by-step approach is known as business modeling. It includes vision, mission, and strategies to achieve the goals. 34.
List the importance of a flow chart. It displays information graphically which is both clearer and easy to grasp. Helps in process documentation. Helps programmers to write the logic. Aids testing and troubleshooting. 35.
Define SaaS. SaaS means Software as a Service. It is related to cloud computing. It is different from other software bundles as you don't need this type of software to be installed on your machine.
All you need is the Internet connection and a Web Browser to use it. 36. What are project deliverables? Project deliverables are a set of measurable goods and services that are delivered to the end customer at the completion of a project.
It is the outcome of the project. 37. What are the types of gaps that can occur during a Gap Analysis? Profit Gap – It is the gap between the estimated and actual profit of a company. Manpower Gap – It denotes the gap between the required number and quality of workforce and actual workforce strength in a company. Performance Gap – It is the difference between the actual performance and the expected performance. Product/Market Gap – It is the gap between estimated sales and actual sales.
38. Define BCG Matrix. The Boston Consulting Group (BCG) matrix is developed to analyze several business processes and new product offerings from companies. It is a useful tool that can be used in portfolio analysis, strategic management, product management, and brand marketing. 39. What is Risk avoidance? Risk avoidance is what to do to avoid the risk.
It avoids the risk by eliminating the cause. Impact of the threat occurrence is reduced to 0%. Cost is eliminated in risk avoidance. 40. What is BRD? A Business Requirement document is a formal contract between the client and the organization for the development of the specific product.
41. What are the different tools used in Business Analytics? MS Office and SQL Blueprint Python and R QlikView and Tableau Axure 42. What do you mean by critical path analysis? A critical path is the set of activities which includes the longest path in the whole project. So, a critical path analysis is a key component in reducing project timelines and controlling cost. 43.
Define BPMN Gateway BPMN Gateway is a processing modeling component that is used to control the flow of interaction, the sequence of processes. 44. How many types of an actor can be depicted in a use-case? Two types of actors can be depicted in a use-case, viz. primary and secondary actors. Primary actors start the process, and secondary actors assist them. Moreover, actors can be of four types such as Human, System, Hardware, and Timer.
45. What is a 100-point method? This method is used to assign priority to different steps in a process. Each group member is supposed to assign points to different steps. In the end, all the points for each step are calculated.
The step having the highest points has the highest priority. 46. What do you know about GAP Analysis? It is a process of comparing and determining the difference between two things or processes. 47. What is meant by scope creep? Scope creep is defined as the uncontrolled or sudden changes or deviations in the project’s scope without changes in other resources of the project.
It is due to the failure in proper monitoring, miscommunication, etc. 48. What does SQUARE stand for? SQUARE stands for Security Quality Requirements Engineering. It is one of the software engineering steps that mainly focus on documenting the security requirements of the system.
49. Tell us the difference between an alternate flow and an exception flow of a use case? Alternate flow are the alternative actions that can be performed apart for the basic flow and might be considered as an optional flow whereas Exception flow is the path traversed in case of the error or an exception being thrown. 50. Define the Use Case Model.
Use case model shows a sequence of events and a stream of actions regarding any process performed by an actor. 51. When do you need to use the Kano analysis? In order to understand the impact of customer satisfaction, a Kano analysis must be used.
It consists 5 requirements: An attractive requirement. Performance requirement. An obligatory requirement. Indifferent requirement.
Reverse requirements. 52. What is the basic difference between a requirement and need from a business analysis perspective? Needs are high-level descriptions of the upcoming goals of a business. Whereas, Requirements are the representation of the complete explanation of that business needs.
Software Development 1. What is the use of UML? Reason the system behavior. Detect and eliminate errors. Propose design plans to stakeholders. 2.
What is RAD methodology? Rapid Application Development (RAD) model is a kind of incremental model. The phases of a project are produced in parallel as individual projects. The developments in the project are timeboxed, delivered, and afterward assembled into a working model.
3. What Is OOAD? Object-oriented analysis and designing. It is used in object-oriented coding languages like Java, c++, etc. 4.
Define Agile. Agile is a technique that uses several light-weight methodologies such as Rapid Application Development (RAD), Extreme Programming (XP) and SCRUM. All these methodologies focus on the development of iterative solutions. 5. What does JAD stand for? It means Joint Application Development. 6.
Name important agile metrics which should be considered by business analysts The spring burndown matric Work category allocation The priority of the work Business value delivery Defect resolution time Work category allocation 7. What do you know about the term ‘Spike’ in relation to scrum? A spike is a time bound activity to conduct analysis or answer question rather than producing shippable product. Spikes are usually planned to take place in between sprints. 8. What is UAT? UAT is User acceptance testing.
If the UAR fails, BA did not understand the requirement properly. 9. What is Acceptance Testing? A BA along with the client, does the acceptance testing to validate that the system is performing as per the business requirements and the product’s acceptance criteria. 10.
What does SRS denote? SRS stands for System Requirements Specification/Software Requirements Specification. It is a document/set of documents that describe the features of a system or software application. 11. Why do we use a sprint burndown chart? A sprint burndown chart is graphic visualization of the rate of progress of the current sprint.
This chart is updated daily over the course of a sprint. 12. Define Scrum method It is one of the agile methods, which is used to develop iterative information systems. In this method, a small team works on the assigned tasks for 30 days, usually. 13.
What are the members of the Scrum Team? Scrum Team consists of 1) Product Owner, 2) Scrum Master, and 3) Development Team. 14. What is Beta Testing? A BA along with the testing team, does the beta testing and it is done on a pre-production version of the product. This testing is done to make sure that the functional and non-functional requirements of the system are met.
15. List the different phases of an IT project Project initiation Project planning Project execution Project monitoring and control Project closure 16. What is Functional Testing? A BA is expected to conduct functional testing to validate that the system is achieving the functionality specified in the use case/functional requirement specification document (FRS). 17. What are the different types of SDLC models? Waterfall Model Iterative Model V-Model Spiral Model Prototype model, etc. 18. What is a Sprint? It’s the basic unit of Scrum development and is restricted to a specific duration 19.
Explain the velocity of a sprint. Velocity of a sprint is the total work done by the development team is capable of doing over the duration of the sprint. It is agreed upon based on the historical data available about the previous sprint of the project. 20.
Explain Black Box Testing Black box testing is a kind of testing where the entire unit is tested as a whole without considering the contents or how the inner components and units are tested. This testing method only focuses on the known input signal and check whether the output behavior is according to expectation or not. 21. What are the 5 phases of SDLC? Planning Analysis Design Implementation Maintenance 22. Explain the term INVEST.
INVEST means Independent, Negotiable, Valuable, Estimable, Sized Appropriately, Testable. It can assist project managers and technical team in delivering quality products/services. 23. What do you think is the scope of Business Analysts in the Agile methodology perspective? With Agile methodology, Business Analysts act as a bridge between the development team and stakeholders. They act on key deliverables to prioritize and deliver the project in the stipulated time and budget. 24.
What is a modeling language? A modeling language is any artificial language that can be used to express information or knowledge or systems in a structure that is defined by a consistent set of rules. 25. What is SDLC? SDLC is an acronym stands for Software Development Life Cycle. Sometimes, it is also called System Development Life Cycle or Application Development Life Cycle. It is used to describe the process of planning, creating, testing and deploying an information system. 26.
What is UML modeling? UML (Unified Modeling Language) is a general-purpose modeling language, which is designed to provide a standard way to visualize the design of a system. 27. What is RUP methodology? Rational Unified Process (RUP) is a product application improvement method with numerous devices to help with coding the last product and assignments identified with this objective. RUP is an object-oriented approach that guarantees successful project management and top-notch software production. 28.
What is SDD? SDD stands for System Design document. It is a middle step dividing between business users and developers. 29. What are the core elements of SRS? Scope of Work Functional and Non-Functional Requirements Dependencies Data Model Assumptions Constraints Acceptance Criteria 30. Name the different types of Agile methodologies.
Scrum Kanban Crystal Extreme Programming (XP) Lean Software Development Feature Driven Development (FDD) Dynamic Systems Development Method (DSDM) 31. What is a must for White Box Testing? Scrum Kanban Crystal Extreme Programming (XP) Lean Software Development Feature Driven Development (FDD) Dynamic Systems Development Method (DSDM) 32. What are Test cases? A test case is a document which contains listing of all the possible scenarios that could happen based on a respective use case.
Thus, every test case is developed with a use case as a base. 33. List various software engineering processes. Gathering of requirements Analyzing Designing Implementing Testing Deploying in the business environment SQL Basics 1. What is ETL? Extraction, Transformation, and load is a data processing method mainly used in data warehousing.
2. What is self JOIN? Self JOIN is a query that joins a table with itself. This is used to compare the values of a particular column with other values in the same column of the same table.
Self JOIN uses aliases to name the original and duplicate tables. 3. What is SQL? SQL is short for Structured Query Language and is used to communicate with relational databases. It is the standard language used to retrieve, update, insert, and delete data when working with relational databases. 4. In what situations should you use WHERE and HAVING in a statement? Though both WHERE and HAVING are used to filter records, there is a subtle difference between the two.
The WHERE clause is used to filter records from a result, whereas HAVING is used to filter groups. If the two are used together, the WHERE clause is applied first to filter rows; only after grouping finishes is the HAVING clause applied. 5. What is CROSS JOIN? CROSS JOIN defines a Cartesian product on the sets of records from two or more joined tables, where the number of rows in the first table is multiplied by the number of rows in the second table. 6.
What are aggregate functions? Aggregate functions perform calculations on a set of values and return a single value. The common aggregate functions are: COUNT (counts the number of rows in the table) SUM (returns the sum of all values of a numeric column) AVG (returns the average of all values of a numeric column) MIN (returns the lowest value of a numeric column) MAX (returns the highest value of a numeric column) Aggregate functions are frequently used in combination with the GROUP BY statement. 7. What is a subquery? A subquery is, as the name suggests, a query within another query.
The outer query is called the main query, while the inner query is the subquery. You can think of this in terms of composition of functions. A subquery is always executed first, and its result is then passed on to the main query. 8. What is a database transaction? When we perform any activity in a database, such as addition, deletion, modification, searching, etc. is said to be a database transaction. 9.
What is the difference between LEFT JOIN and RIGHT JOIN? A LEFT JOIN returns all records from the left table, even when they do not match in the right table. Missing values become NULL. In a similar manner, a RIGHT JOIN returns all records from the right table, even when they do not match those in the left table. Missing values become NULL. 10.
What are the different parts of an SQL Statement? An SQL statement has three parts. There is the Data Definition Language or DDL, the Data Manipulation Language or DML, and the Data Control Language or DCL. 11.
What is OLTP? OLTP stands for On-Line Transaction Processing. Such systems are capable of performing database transactions and are meant to provide good speed for database transactions. These systems are mainly used for data entry and retrieving data from the database. 12.
What is the GROUP BY statement used for? GROUP BY is a statement that divides the result for a particular query into groups of rows. It is often used with aggregate functions such as SUM, AVG, MAX, MIN, and COUNT, which calculate information about each group. The SELECT statement returns one row for each group. 13. What Is INNER JOIN? INNER JOIN is the most common type of join.
It returns all rows that are shared by two tables. Visually, it’s analogous to identifying the overlap, or intersection, between two sets of data. 14. What is the difference between UNION and UNION ALL? UNION will omit duplicate records, whereas UNION ALL will include duplicate records. UNION requires the server to do the additional work of removing any duplicates.
15. What is a primary key? A primary key is a unique identifier for a particular record in a table. The primary key can’t be NULL. A primary key can be a single column or a combination of columns in a table. Each table can contain only one primary key.
R Basics 1. What are vectors in R? R operates on named data structures. The simplest such structure is the numeric vector, which is a single entity consisting of an ordered collection of numbers. 2. What are logical vectors in R? As well as numerical vectors, R allows manipulation of logical quantities.
The elements of a logical vector can have the values TRUE, FALSE, and NA 3. What are the concatenation functions in R? cbind() and rbind() are concatenation functions in R. 4. What is the plot(object)? Produce four plots, showing residuals, fitted values, and some diagnostics. 5.
What is R? R is a language and environment for statistical computing and graphics. It is a GNU project which is similar to the S language and environment which was developed at Bell Laboratories. R can be considered as a different implementation of S. There are some important differences,
but much code written for S runs unaltered under R. 6. What are Data frames in R? A data frame is a list with class "data.frame".
7. What is a formula(object)? formula() function extract the model formula. 8.
What is coef(object)? Coefficient() function extract the regression coefficient (matrix). 9. What is anova(object_1, object_2)? anova() function compare a submodel with an outer model and produce an analysis of variance table. 10. What is the read.table() function in R? To read an entire data frame directly, the external file will normally have a special form.
The first line of the file should have a name for each variable in the data frame. Each additional line of the file has as its first item a row label and the values for each variable. 11. What are residuals(object)? residuals() function extract the (matrix of) residuals, weighted as appropriate. 12. What is deviance(object)? deviance() function finds the residual sum of squares, weighted if appropriate.
13. What is print(object)? print() function print a concise version of the object. Most often used implicitly. Tableau Basics 1. What are measures and dimensions in Tableau? Measures: The measure values are the quantifiable values which we use in calculations.
Thus, all the measure values are predominantly numeric values as it is only them that are processed and calculated to give results that can be analyzed. Dimensions: The dimension values are the values of specific characteristics or attributes. The fields having dimension values known as the dimensions fields.
We do not use them in calculations. They only assign specific attributes to fields such as date, product, area, category, city, etc. 2. What do you understand by Data Extracts in Tableau? Data extracts are portions of data that we take from the data source. The data extracts are also called the subsets of data that we extract from the main data source. 3.
What is data blending in Tableau? The data blending brings data from two different data sources together in a single view or in a single Tableau worksheet. 4. What are data extract files in Tableau? The data extract files are the ones that contain a local copy of the entire dataset or in other words, we take a subset of data from the source.
The Tableau Data Extract files have a “.tde” extension. 5. Can we create custom territories on a map in Tableau? Yes, we can create custom territories on Tableau maps. 6. What are hierarchical fields in Tableau? The hierarchical fields are those which have data arranged in hierarchies.
Hierarchies organize relevant data on different levels. 7. What is Quick Sorting in Tableau? Tableau gives us the option to Quick Sort data present in our visualizations. We can instantly sort data from the visualization by simply clicking on the sort button present on the axes of a graph or chart.
An ascending sort is performed upon one click, the descending sort is performed on two clicks and an applied sort is cleared on three clicks on the Quick Sort icon. 8. What are the different kinds of filters in Tableau? Extract filters Data Source filters Context filters Dimension filters Measure filters 9. What are shelves in Tableau? The Shelves on a Tableau worksheet are demarcated areas used for specific purposes.
There are several shelves on a Tableau sheet like, Page shelf, Filter shelf, Marks shelf, Rows and Column shelf. 10. What are user functions in Tableau? The user functions in Tableau are unique functions that we use to perform operations on the registered users on Tableau Server or Tableau Online. 11.
What do you understand by context filters? Context filters are used to apply context on the data under analysis. By applying a context we set a perspective according to which we can see the charts and graphs. 12.
What is the maximum number of tables you can join in Tableau? The maximum number of tables that we can join in Tableau is 32. Qlikview Basics 1. What are CAL? CAL stands for Client Access License that offers different licenses depending on the user type.
2. What is interval match? Interval match is one of the functions that are useful for the tables containing numeric values because it is used to match a numeric value from one table to another table. 3. What is buffer load, and why is it significant? A buffer load is used to create a file using a buffer prefix in Qlikview's memory for future use. 4.
What are Sheets in QlikView? A Sheet divides a QlikView document into multiple sections. Every document will have at least one sheet in it, if needed, we can add more from the Sheet Properties option. 5.
What type of data connections are used in QlikView? OLEDB, ODBC, and SAP connectors. 6. What is the difference between Pick and Match? The Match() function checks whether the value of a string on expression is matching with data value present in a column. The Pick() function is used to return the nth expression along with string in the list.
7. What are delimited files and why are they called CSV files? Delimited files are text files in which data fields and data values are separated by commas, semicolons and tabs, and that is why they are also called Comma Separated Values files. These files are saved with .csv extension. 8. What is a Dashboard? A dashboard is a QlikView document which displays values from many fields simultaneously and makes the analysis process easier. 9.
What does the Auto-Generated function do in QlikView? Auto-Generated function automatically generates the numbers between the given range 10. How many types of charts are used in QlikView? Bar chart, Mekko Chart, Grid chart, Funnel chart, Line chart, Gauge chart, Combo Chart, Scatter Chart, Radar chart, Block chart, Straight table chart, Pie chart, and Pivot table chart. 11. What are the types of CAL? Named CAL document CAl Session CAL Usage CAL 12. What is Inline data? How can we load Inline into QlikView? Inline data is created on the spot and to load inline data in QlikView we need to open the Script Editor and then select the Insert option. After that, select Load Statement followed by Load from Inline.
13. How can you bring data into QV and handle early arriving facts? y using ODBC, OLEDB or SAP connectors as a data connection, we can load data using Select statement. 14.
What is Incremental load and Resident load? Qlikview Incremental load is used for loading new or changed records from the database, whereas resident load is a part of loading data which already present in the Qlikview application. 15. In Qlikview, what is the use of an optimized load? QVD files can be read in two modes- the standard and the optimized mode. The optimized load is a faster process and is preferable for large sets of data.
16. Is it possible to load web files into QlikView? If so, how? Yes, it is possible to load web files into QlikView. It is done through the Script Editor. 17. What is the difference between the Let and Set options in QlikView? Let: It assigns a variable to a value after assessing the expression. Set: It assigns a variable to a value without assessing the expression.
18. What is the use of Comparative Analysis in Qlikview Developer Platform? By using the Comparative Analysis option, users can quickly gain new insights to analyze their information in Qlikview. 19.
What is Fact Constellation Schema? Fact Constellation Schema is a collection of multiple facts tables sharing common dimension tables. It is made up of several star schemas and hence also called galaxy schema. 20. In how many ways can the Script Editor be invoked? Script Editor can be invoked in two ways- either by the shortcut keys Ctrl+E or by the icon for Edit Script. 21.
What is a synthetic key, and what is its importance? The synthetic key is created to avoid confusion when two rows of the table are the same. In QlikView, automatically, this scenario is detected, and a synthetic key is created to make the process faster. 22.
Difference between QVD and QVW? QVW: It is a QlikView file saved in binary format with default expression QVW containing tables, charts script etc. QVD: It is a binary CSV file that contains one data table, no layout and no security. 23. What P() and E() in the Set analysis? In QlikView Set Analysis, a P() function is used to return all possible values while an E() function is used for returning a set of all excluded values. 24. What is the difference between RDBMS and Associative Data Model? RDBMS stands for Relational Database Management System, and it stores data into rows and columns of tables and data is retrieved through SQL queries.
An associative database model is comprised of two tables: one for items and one for links.