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
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
Are the above questions only for a Power BI developer or else useful for data analyst role as well please clarify
Bhai cracking interview is easy but getting the interview is tough
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.
Ur speech improved a lot.
Can u provide all the above Q's in a pdf link for us to download ?
This is simply fantastic one 👏
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
Great work man ❤
Please share Accenture interview recently q/a
Azure active directory and Microsoft 365 center is different?
Can someone help me with, What was that Update App feature. ( In reference to Q.16)
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
@@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 😔
Superb question set
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
WHat is composite model and tell us with scenario based
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
is this is enough for a business analyst fresher?
Hi sir , can we get hand written notes for preparation which will be helpful for us
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.
Please recommend laptop for data analyst field
is it freshers or experience levels questions sir
Aap interview dene gye the ?
ARE THESE QUESTIONS ASKED FOR FRESHER AS WELL!?
I don’t think so , the more you see these type video , uts become more difficult
i will use most of time in slicer
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
Thanks
Thank u so much sir
Thankyou sir
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 ??
Q26
ans :- I THINK THIS WILL WORK
CumulativeSales =
VAR SelectedMonth = MAX('Date'[Month])
RETURN
CALCULATE(
SUM(Sales[SalesAmount]),
FILTER(
ALL('Date'),
'Date'[Month]