Q26 ans :- I THINK THIS WILL WORK CumulativeSales = VAR SelectedMonth = MAX('Date'[Month]) RETURN CALCULATE( SUM(Sales[SalesAmount]), FILTER( ALL('Date'), 'Date'[Month]
About 20th question u said we can't utilize other data sources if we connected direct query with databases....I have tried it...we can connect with other data sources when we connected with databases in DQ
Q24.With my practical experience , I am letting you know , Direct Query does not work good if you have records in billions or crores . Report loading time increases and all the calculations get process at runtime . Do change you answer and make it relative
For a line and clustered column chart or line and stacked , need to have average line for each category while having all the subcategories and category in x axis and sales in y axis
In direct query mode, we can pull data from different source, which is also known as composite model, have tried it in practical also, please correct if i am wrong @learn with gigs.
@@learnwidgiggs thanks for your proactive reply, just wanted to know can we fetch the data also from different sources if the data of sql server is in direct query mode??, I think we can fetch it. I have watched almost all your videos on your channel. Your content is invaluable. Thanks for everything you provide to community.
You can then use this measure in a card to show the values, I have just given an idea write the dax acc to whatever name you have given to your column and table
@@prasadmekala258 taara bolalaa se hoi ? Hamar gadia faad dele rahe CAPCO me questions puchat puchat.. 40 minute mata chatle rasn sann . O sorry 😞 bro... Replied in bhojpuri...
Hi sir, I have one doubt n you please explain it. How to create dynamic serial numbers. like, for example 3 countries there India, China, USA if we select India the serial numbers need to show from 1 again I select USA it's won't to show from 1 only not like index. anyone can answer.
With sample Global superstore as dataset, Can we have top 5 returns by priority and city in a matrix or table table with year as first column with no repeats, second column as market. Product name Order Priority Country
Hello brother please tell me how to share questions list I have some que from MICHEAL INDIA those questions are very diff from my all the interview let me know how to share with you
Q26
ans :- I THINK THIS WILL WORK
CumulativeSales =
VAR SelectedMonth = MAX('Date'[Month])
RETURN
CALCULATE(
SUM(Sales[SalesAmount]),
FILTER(
ALL('Date'),
'Date'[Month]
Can u provide all the above Q's in a pdf link for us to download ?
About 20th question u said we can't utilize other data sources if we connected direct query with databases....I have tried it...we can connect with other data sources when we connected with databases in DQ
Bhai cracking interview is easy but getting the interview is tough
for me its opposite
Tell us how you are getting your resume shortlisted🙃
Me also
Very True sir
How do you get interviews?@@TusharGaikwad-m9p
Q24.With my practical experience , I am letting you know , Direct Query does not work good if you have records in billions or crores . Report loading time increases and all the calculations get process at runtime . Do change you answer and make it relative
Then in that case which one is better?
@@sudhashrinaik8374 I think We can do it in Power Query only.
Boss, Going forward could u please include the link for data
@@likinponnanna8990 Yes, I have already started doing that.
Ur speech improved a lot.
Azure active directory and Microsoft 365 center is different?
This is simply fantastic one 👏
Great work man ❤
Please share Accenture interview recently q/a
Thank u for making the video on these questions.
you too Sonali for sharing this Questions.
Superb question set
For a line and clustered column chart or line and stacked , need to have average line for each category while having all the subcategories and category in x axis and sales in y axis
Can we have it ? I tried it
Can someone help me with, What was that Update App feature. ( In reference to Q.16)
Are the above questions only for a Power BI developer or else useful for data analyst role as well please clarify
@@kannanamudan6152 Both..
WHat is composite model and tell us with scenario based
In direct query mode, we can pull data from different source, which is also known as composite model, have tried it in practical also, please correct if i am wrong @learn with gigs.
@@shruti7463 Plz read about composite model..that is different then what you have mentioned.
@@learnwidgiggs thanks for your proactive reply, just wanted to know can we fetch the data also from different sources if the data of sql server is in direct query mode??, I think we can fetch it.
I have watched almost all your videos on your channel. Your content is invaluable. Thanks for everything you provide to community.
Can you upload the video on the dax question (26) that was asked in the interview
You can achieve that by using datesytd function
Create a measure like = Calculate(sum(sales),datesytd(date))
You can then use this measure in a card to show the values, I have just given an idea write the dax acc to whatever name you have given to your column and table
Please recommend laptop for data analyst field
is this is enough for a business analyst fresher?
were these question asked for senior level role or entry level role ?
It seems to be 3+ yrs
Sir is your interview questions play list enough to justify ourselves in 3-4 years of experience?
No I think these interview questions are more than 5 years ..who has more than 5 years they may clear this questions
Offcourse these are fresher level questions
@@goldiegs2181 fresher level interview questions only they may ask 5 to 6 questions...
@@prasadmekala258 taara bolalaa se hoi ?
Hamar gadia faad dele rahe CAPCO me questions puchat puchat..
40 minute mata chatle rasn sann .
O sorry 😞 bro... Replied in bhojpuri...
@@goldiegs2181 i don't know bhojpuri sorry..even I didn't understand what you have written 😔
Aap interview dene gye the ?
i will use most of time in slicer
did they ask these level questions to freshers???
I don't think so
is it freshers or experience levels questions sir
Hi sir, I have one doubt n you please explain it. How to create dynamic serial numbers. like, for example 3 countries there India, China, USA if we select India the serial numbers need to show from 1 again I select USA it's won't to show from 1 only not like index. anyone can answer.
With sample Global superstore as dataset,
Can we have top 5 returns by priority and city in a matrix or table
table with year as first column with no repeats,
second column as market.
Product name
Order Priority
Country
ARE THESE QUESTIONS ASKED FOR FRESHER AS WELL!?
I don’t think so , the more you see these type video , uts become more difficult
Hi sir , can we get hand written notes for preparation which will be helpful for us
Thanks
Thank u so much sir
Thankyou sir
sir please invite a fresher business analyst
Sure, noted
Hello brother please tell me how to share questions list I have some que from MICHEAL INDIA those questions are very diff from my all the interview let me know how to share with you
u can share it with me , let me know i will pass on the details to you
DAX for 26th question, please correct me if I am wrong :
26rev = calculate(sum(revenue),datesinperiod(dimdate[date],max(dimdate[date]),-1,Month)
It will give you only last month as Jan not Selected Month Feb ..For this you have to hold both values in variable and merge
Dax for 26 th question ??