Power BI Notes

-

There are three type of relation between data : 

1. One to One 
2. One to Many 
3. Many to Many


Popular posts from this blog

What AI I use in Investment Banking ?

-
AI is no less than an extended arm to my daily work, although the sensitive information always need to be covered up and not disclosed.  My No. 1 AI is :  A. NoteBookLM  It's a Google Product and gives you very accurate answer by reading the Web Link and PDF as source to it. Even you can go and recheck the answer by sources and it specifically mark it for you.  It helps a lot specifically for Rules and Regulations that are 200-500 pgs long and it take a lot of effort to do it all together by yourself.  It almost cut short time by half.  B. ChatGPT  It is very common but very few of us understand how to use it ? The chatGPT works with very clear goals defined and the reason you need the result and then provide a good resource to it if  possible and it will give you really perfect answer.  My tip is that always make GPT remember your last conversation in the same context and it will give you more better result.  C. Perplexity  It is i...
Read more

Interview Question for Freshers in Finance / Investment Banking / Merchant Banking / Accounts

-
Finance Related  Question 1 : What are the common or basic Debt to Equity Ratio ? Answer 1 : 2:1 Questione 2 : What are the two source of funds for Company/Project which is showed in Balance Sheet in Liability Side. Answer 2 : Debt (Loans/Debentures) and Equity (Promoters Funds and Capital Raise through Investors) Research Related  Question 1 : If I have to take out the financial statements of a company of a listed and unlisted company, how will I do that ? Answer 1 : For the listed company, it is easy as we can take out the financial statement from it's website as, as per the law of the land India and others too a listed company have to disclose certain information publicly which includes Financials and the disclose it with the help of their wesbite.  While we can also take financial statements and other financial or legal information from NSE and BSE. If we change the location from India to France we can take it from EURONEXT.  For an unlisted company either we ca...
Read more

Basic Investment Banking Interview Questions and Answers : S1

-
Image
After introduction and all the interviewer would hoop you into technical or mathematical questions. Let me help you out in understanding the basics of the same so that you can understand the most difficult ones.  Let's start !! Question 1  How much you will pay for a company that generates ₹ 100 Crore of cash flow every single year into eternity ? Eternity means time that has no end  So basically they want to know that does you know the formulas or not ? So what formula will be used here ? The Perpetuity Formula Before answering the question keep in mind that whatever you answer or whatever you say in an interview the interviewer will use it as a content to question you against.  SO What is Perpetuity Formula ? Perpetuity Formula is what has been asked in the question, the question is the defination of the Formula. A Perpetuity Formula is used to calculate the present stream of cash flow that is expected to continue for indefinitely.  Answer of the question wil...
Read more

What is an Information Memorandum ?

-
An Information Memorandum is also Known as or the stages to Infomation Memorandum (IM) is :  1. Teaser  2. Preliminary Information Memorandum (PIM) 3. Confidential IM  OR  Placement Memorandum Meaning :  Basically an IM is a summarized document having comprehensive data or information about the company or project which requires fund or non fund based facilities.  It is specially made for a Lender and/or Investors. A start-up makes a Pitch Deck but at the end in documentation procedure an IM is filed.  We will learn in details about IM by understanding all the components of an Information Memorandum !! The Information Memorandum has following Heads/Sub-Heads/ Components : Basically the IM has the information which is specifically required by the Lenders/Investors to understand and execute the fund or non-fund based facilities (in simple language a Loan or Debt or Term Loan or Letter of Credit or Performance Guarantee) An IM which is also called as Place...
Read more

Most used formulas of Excel

-
Image
COUNT :  Counts the number of cells within a range that contains number .  COUNTA :  Counts the number of cells within a range that don't contains number .  COUNTIF :  Count things that satisfy one or more conditions . That is select the range, then write the criteria and we are good to go. COUNTIFS :  Count things that satisfy one or more conditions and criteria . That is select the range, then write the criteria, repeat then again as many times as you want and we are good to go. --------------------------------------------------------------------------------- Learn THE Most important excel tips to be a pro : Click Click !! ------------------------------------------------------------------------------------------- AVERAGE :  Simply having a average of the selected range of a row or coloumn.  AVERAGEIF :  It's a average of numbers which satisfy a certian criteria, select the range, write the criteria and then select the numbers whose range i...
Read more