Same issue i has been facing in my organization. so i have 5 years of experience in power bi simple way to optimize latency in report take some necessary action 1. remove all calculated columns, create a dataflow level or in query editor 2. remove all icons/images from outside if you are using in your report. 3. follow always star schema model. 4. remove all unnecessary columns from dataset which are not useful 5. if any column is taking large string, then try to avoid that column in use report 6. aggregate your data if it's possible 7.less use of slicer
Question from startup PFB scenario and the data file to be used: 1.Allow users to select measures of their choice. Sales , Quantity and GP need to be used for this. Users should be able to select the time period for the above selected measures For. for example MTD sales or QTD Quantity etc. 2.Need to display Top N/Bottom N products and regions based on the selected measure and time period. No. of items to be shown also need to be dynamic (5,10,15). =Q1. solved during the interview but for Q2. i have taken time please explain how to do it fast in 5 min and how to come up with solution in interview for 2nd ques with less time . please thank you
we have a requirement from 1 specific dept saying that yow know they wanted to have a sales data having various kpis lke units sold, sold value , margin so many other kpis also there so all these kpis coming from 1 source and then you have that direct connectivity and you prepared a dataset but visualization of the business requirement gonna be different may be that dataset or the same dataset can be used by different people or different divisions of the same dept in such cases you have to create different visualization for each division so are you maintaining a single dataset over there in pbi or you create a multiple dataset
Very useful & informative as always like all videos. Is it possible you to create video on how to add group of emails or users in dynamic row level security?
funning thing will come when you select state before country, it will not filter out country. because fact table doesn't have any bidirectional with country.
Hi Sir Recently I got a job for the position of Financial Analyst. Thank you for making interview videos it has really helped me to crack the interview.
Same issue i has been facing in my organization.
so i have 5 years of experience in power bi
simple way to optimize latency in report take some necessary action
1. remove all calculated columns, create a dataflow level or in query editor
2. remove all icons/images from outside if you are using in your report.
3. follow always star schema model.
4. remove all unnecessary columns from dataset which are not useful
5. if any column is taking large string, then try to avoid that column in use report
6. aggregate your data if it's possible
7.less use of slicer
Another important past is to avoid MANY TO MANY RELATIONSHIP which would help to retain and optimize report performance.
Question from startup
PFB scenario and the data file to be used:
1.Allow users to select measures of their choice. Sales , Quantity and GP need to be used for this.
Users should be able to select the time period for the above selected measures For. for example MTD sales or QTD Quantity etc.
2.Need to display Top N/Bottom N products and regions based on the selected measure and time period. No. of items to be shown also need to be dynamic (5,10,15).
=Q1. solved during the interview but for Q2. i have taken time please explain how to do it fast in 5 min and how to come up with solution in interview for 2nd ques with less time .
please
thank you
Useful information share thank you so much,
we have a requirement from 1 specific dept saying that yow know they wanted to have a sales data having various kpis lke units sold, sold value , margin so many other kpis also there so all these kpis coming from 1 source and then you have that direct connectivity and you prepared a dataset but visualization of the business requirement gonna be different may be that dataset or the same dataset can be used by different people or different divisions of the same dept in such cases you have to create different visualization for each division so are you maintaining a single dataset over there in pbi or you create a multiple dataset
Thanks for this Videos very much useful
Very helpful video 👏👏, thank you
Please explain CLS ( Column level security) concept
Very useful & informative as always like all videos. Is it possible you to create video on how to add group of emails or users in dynamic row level security?
Useful content. Thanks for sharing!
Very helpful bhaiya ❤
Thanks for this video
thanks for sharing it is freshers or experience candidates interview
Perfect bhai!
Thank you for sharing
Very helpful
sir if we select United kingdom then state list doesn't work
Sir, which documents are required for interview
Hi sir ,I have one scenario, rank change when rls is applied! Is there any solution
you mean say that, you are using rank formula, it doesn't give proper result while using RLS?
if it's can u send me pbix, i can check
bhai I visited your website and there were mock interviews for power BI. So do u take only power bi mock interviews or SQL mock interviews also?
@@sparshgoyal3414 both
@@learnwidgiggs Thanks for responding..
I want to book only for SQL interview but there were no option for SQL interview and how much do u charge?
I have graduated bsc 2013 so 11 year gap so can i enter it feild without coading so plz guide me any person
bhai dukaan khol le, apna business apna hota hai
Hi bro Goa is also part of India right but after bidirectional filtered apply and when we select India ..then Goa is went out from state table how ?
@@GP_MoralStories because Goa doesn't have any transactions in the fact table
@learnwidgiggs Thank you sir for reply ...all videos are just amazing and good 👍 keep doing
funning thing will come when you select state before country, it will not filter out country. because fact table doesn't have any bidirectional with country.
are power bi jobs still in demand in 2025?
No not for beginners market is too complicated for fresher or even 1-2 experience.
@@rahulmishra1523 not really i am working as a junior data analyst 3 months experience
Hi Sir
Recently I got a job for the position of Financial Analyst.
Thank you for making interview videos it has really helped me to crack the interview.
@@aditjain6580 Many many congratulations ❤️
What is your linkdin profile ?