Finvest India Interview Questions and Answers

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Questions related to django and python.
Add your answer

One python coding(easy) and django ORM queries

Q1. Some technical and about company.
Add your answer

Q1. About company and some technical.
Add your answer

Q1. How can you leverage your previous experience to enhance collaboration in your current role?
Add your answer

Q1. What do you know about time decay in options and derivatives?
Ans. 
Time decay in options and derivatives refers to the decrease in the value of an option as it approaches its expiration date.
• Time decay is also known as theta decay, as it is represented by the Greek letter theta in options pricing models.

• Options lose value over time due to the diminishing likelihood of the option being profitable for the holder.

• Time decay accelerates as the expiration date approaches, especially for op...read more
Answered by AI
Add your answer

Q1. Can you discuss your strengths and weaknesses?
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. What is your skills?
Add your answer

Q1. Tell me about selenium
Ans. 
Selenium is a popular open-source automation testing tool used for web application testing.
• Selenium supports multiple programming languages such as Java, Python, C#, etc.

• It allows testers to write test scripts in a variety of formats like HTML, Java, C#, etc.

• Selenium can automate web browsers across different platforms like Windows, Mac, Linux, etc.
Answered by AI
Add your answer
Q2. Expalin java inheritance ana polymorphism
Add your answer
Q3. WHich tool you have used
Ans. 
I have used various tools such as Microsoft Excel, Google Analytics, and Adobe Photoshop.
• Microsoft Excel for data analysis and reporting

• Google Analytics for website traffic analysis

• Adobe Photoshop for graphic design
Answered by AI
Add your answer

Q1. Estimate number of burgers sold by one burger Outlet in your city.
Ans. 
The number of burgers sold by a burger outlet in a city can vary based on factors like location, menu offerings, pricing, and customer demand.
• Consider the population of the city and the popularity of the outlet.

• Analyze the outlet's menu offerings and pricing compared to competitors.

• Take into account any special promotions or events that may impact sales.

• Look at historical sales data if available.

• Interview employees or
Answered by AI
Add your answer

Q1. Estimate transportation cost for raw materials.
Ans. 
Transportation cost for raw materials can be estimated based on distance, mode of transportation, quantity, and current market rates.
• Consider the distance between the supplier and the manufacturing facility

• Take into account the mode of transportation (road, rail, sea, air)

• Calculate the quantity of raw materials being transported

• Research current market rates for transportation services

• Factor in any additional costs such
Answered by AI
Add your answer

Q1. Asked about past experience
Add your answer
Q2. Some guesstimate question
Add your answer

Q1. WAY OF QUESTION TREND
Ans. 
Question trends in customer service are constantly evolving based on customer needs and technological advancements.
• Stay updated on industry trends through research and training

• Adapt communication style to match current trends (e.g. chatbots, social media)

• Utilize data analytics to understand customer preferences and behavior

• Provide personalized and efficient service to meet evolving customer expectations
Answered by AI
Add your answer
Q2. REPLY MY WAY OF PERFECT ENGLISH
Add your answer
Q3. ALL BESED ON COMPUTER WORKS IN NON VOICE PROCESS
Add your answer
Q4. I FLEXIBLE IN DAY SHIFT
Add your answer
Q5. MY EXPECT 25K SALARY
Add your answer

Q1. How to run linear regression model in R
Ans. 
To run a linear regression model in R, use the lm() function with the formula specifying the relationship between variables.
• Use the lm() function to fit a linear regression model, specifying the formula with the dependent and independent variables.

• For example, to predict sales based on advertising spend, use lm(sales ~ advertising, data = dataset).

• Use summary() to view the results of the linear regression model, includ...read more
Answered by AI
Add your answer
Q2. How to run linear regression model without intercept in R
Ans. 
To run linear regression model without intercept in R, set the intercept parameter to 0
• Set the intercept parameter to 0 in the lm() function in R

• Example: lm(y ~ x - 1, data = dataset) will fit a linear regression model without intercept
Answered by AI
Add your answer

Q1. Securitisation and how it works.
Ans. 
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based...read more
Answered by AI
View 1 more amswer
Q2. Financial Ratios and how they work and what is a good number to have.
Ans. 
Financial ratios are tools used to evaluate a company's financial performance and health.
• Financial ratios are calculated using data from a company's financial statements.

• They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.

• A good number for a financial ratio can vary depending on the industry and company size.

• For example, a current ratio of 2 or higher is generally cons...read more
Answered by AI
Add your answer
Q3. Random number crunching based on some scenario that needs you to make assumptions and get an answer
Add your answer
Q4. How an Excel function works. (Vlookup, Hlookup, Xlookup, IF/AND/OR)
Ans. 
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
• Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup: Similar to Vlookup but searches for a value in the first row of a table.

• Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.

• IF: Retu...read more
Answered by AI
Add your answer

Q1. Personal Questions.
Add your answer
Q2. My expertise and proficiency of excel
Add your answer

Q1. No questions. Was confirmed my job
Add your answer

Q1. How much brokerage you used to generate a day
Ans. 
I used to generate an average of $X in brokerage per day
• On average, I used to generate $X in brokerage per day

• The amount of brokerage generated per day varied based on market conditions and client activity

• For example, on a busy trading day, I could generate $Y in brokerage, while on a slow day it could be lower at $Z
Answered by AI
Add your answer
Q2. Total brokerage generationin a day
Ans. 
The total brokerage generation in a day is the sum of all the brokerage fees earned by the equity dealer from executing trades.
• Calculate the brokerage earned from each trade executed during the day

• Add up all the brokerage fees to get the total brokerage generation for the day

• Consider different types of trades and their respective brokerage rates

• Example: If a dealer earns $10 from Trade A, $15 from Trade B, and $20 from...read more
Answered by AI
Add your answer