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

About the Blog : An Outline

-
Image
Investment Banking Nerd is a Knowledge Repository. Hi,  My name is Ishika Mishra and I'm a blogger by hobby. My journey of blogging started with an amazing theory, my English subject teacher always scolded me for my spelling and verbs usage mistakes, you will very easily find the same in this write up also.  To tell you about my current blog "Investment Banking Nerd", it's an amazing creation that I love to do everyday. This blog helps many people from a ' Student ' who wants to enter Investment Banking to those working in Investment Banking industry and wants to research about Investors and documentations tools and it's importance.  Investment Banking Nerd blog is a creation of Knowledge base and a Portfolio for me !! Isn't it's amazing the you are working anywhere in this world and you just type in on the net your very own website name and everything you know & had made repository of comes off in a second in front of your eyes. This is the i...
Read more

How to do Forecasting of Financials ?

-
Image
I'm learning this from youtube videos. Two methods of taking forecast :  1. Through Formula  In this we use =forecast(Xs,knownYs,knowYs) Eg : In this we will already had data till 2024, we had put in the formula =forecast(2025,Revenue (2019:2024), Year (2019:2024)) 2. Forecast on the Data Tab ! We have taken the same data as the 1st formula ! These are for one line data and provide very accurate answers, but for more and better data one need to understand the technicality of growth and it's rate. 
Read more

How to Research for Energy sector ?

-
Image
Unmapped  Energy Core Area of Work (28/02/25) India  National Power Portal :  It will Provide day to day, month to month and years of report on Installed Capacity and Generation, whether that state has achieved the target which was set or not.  Yes Solar is not very much highlighted and is difficult to find, but hydro, thermal and RES is well Defined.  Central Electricity Authority :  The Reports are old but it will help a lot for yearly data rather than the latest.  The Dashboard is yet another best thing to understand the data. Vidyut PRAVAH : For daily demand and price of electricity in different states of India, and it's per unit price.  Global Global Energy Monitor :  It's Google sheet and easy to track, it's basically a overview not detailed perpective. But it really helps when you are working on different countries. 
Read more