Hi Shashank, I just wanted to express my gratitude for creating such valuable content. Your videos provided me with invaluable interview QnAs that were instrumental in helping me bag 2 offers.🎊 Keep up the fantastic work!💫 Shruti
As a unemployment person i know how people are suffering without job, you people who all are teaching in you tube like a god's angel in human form... thank you so much, i have learned so much things from your youtube channel, keep on posting these kind of video, once i will learn something in my career surly i will also post this kind of videos.
One important difference b/t Calculated column & Measure is, calculated column can be used for slicer, where as measure can not used in slicer. if this can tell in the interview, it will be more valued.
Sir can u plz make video for this questions.... .Create a BI Dashboard/Report that would display the sale analysis; please make sure that below requirments are captured in the report • Load all the three tables and use data modelling to relate the tables • Calculate revenue contribution of producer (if there is a producer X with 10,000 revenue out of total 100,000; when I select producer X result should show 10%; in the same way with revenue) • Group the accounts based on revenue as Tier1 (having revenue > 10000), Tier 2(5000 to 10000), Teir 3 (
After , watching this Video. I'm really glad that almost every Answer , I Know while giving Mock and practicing. Really our Content is Top Noutch , compare to others.
Hey shashank i am your constant viewer of your channel, Good evening, I am a power bi developer recently I stuck with a situation in which I have a table with sales date now I want to show data such that when user will select any date it gets the option of selecting data range like. 7-15 days 15-30 days 30-60 days and many more and all have multi select option Eg: User selected 1/1/2024 Now user show have filter in which it has option to see data of 7-15 days means 24/12/2023 to 16/12/2023 and same other filter of 15-30 days from 15/12/2023 to 01/12/2023 With multi select option
Hi Shashank, Thanks for sharing the valuable Interview Questions & tips to crack the Interview. It is really helpful for me and others as well. Request you to share some more videos. Regards, Amitabh
Dataflow is live query from your source database in power bi Service. It’s independent and not coming with your power bi report and dataset. Suppose you need a table that will use in different reports all together then you can create dataflow in power bi service.
Very informative ....i have one question...you said business analyst connect with client then gather req and share brd document with dev....then as pbi dev when we connect with client..please tell all scenarios...
Hi Shashank I completed my degree in 2008 And I have a three years sales experience from 2019 to 2022, Will this career gap affect on the job, How can I get a job as data analyst, Could you please tell me, So that I can plan accordingly ,
Hi Everyone. I have a topic; can you guys help me understand it? (I faced this question in one of my interviews.). I have an employee table, another table fct_Attendance_time, This employee has some columns, such as ID, name, and department name. The fct_Attendance_time table has every day in and out data (in: 8.30 out: 9.00 again, same employee comes in at 10.00 and out at 11.00). This is just a sample. for ex 1 employee went outside 10 or 20 also possible. Now they want to know: 1. For each department, how many employees present and absent need to be shown in visual form, not a table or matrix? 2. The number of visits per employee and how much time is spent in the office. 3. employee time spending percentage per day and previous day, Thanks in advance. @LearnWidGiggs bro, If possible, Please make a video for us.
Hi Sir, there is one scenario two table engine and product and in both we have calculated some columns like ActiveEngine in engine and Total Committed, Current Exposure in products and in both we have mode name so i want to built matrix which have all calculated columns from both vs model name , i have used related functions but values i ma not getting correct
Hi Shasanka,I watched all the video on RUclips for learning new things on power bi..so my question is that I have from BPO back ground and I dnt have any prior knowledge on power bi..but recently I took course for 3 months and I complete the course and I make so.w dashboard and report also..but in resume do I mention any project ??
Hi Shashank I have done work multiple domain but from two year I am working as support some process data also I have use power bi but not for development only review data flow I have total 10 year It's are different domain so now I am struggling to find a good job that suit my situation I need your help I want to explore this data analysis area can you help me
Hi Thank you for all valuable content. I have also given a interview in tcs where interview asked ne this question, he was trying to check my sql and data model ability through this question. If you have 2 tables with these columns sales_table=orderid, orderdate,deliverydate,salesamount Product_table=orderid,productid,productname,prod_category How are you going to build a visual of ordervalue and salesvalue comparison .... Give me e2e approach
Hi shashank, can you share this notepad file (.pbix file) ...it would be very helpful along with written ques and answer of all companies to get in a consolidated manner. Thank you Waiting for your response.... U are great person helping lot of people. Your videos are always helpful for me.
@@learnwidgiggs yes screenshot is possible, but if it's possible to share it would be helpful as it would be in a consolidated manner(pbix or notepad file) Thanks
Hi Shashank,
I just wanted to express my gratitude for creating such valuable content. Your videos provided me with invaluable interview QnAs that were instrumental in helping me bag 2 offers.🎊
Keep up the fantastic work!💫
Shruti
Many many congratulations 👏
And best wishes 🎉
congratulations 🎉
Congratulations!
Which platform you used for applying the job?
As a unemployment person i know how people are suffering without job, you people who all are teaching in you tube like a god's angel in human form...
thank you so much, i have learned so much things from your youtube channel, keep on posting these kind of video, once i will learn something in my career surly i will also post this kind of videos.
I could answer almost 95 % of the questions by watching all your playlist. thanks.
Which company you interviewed?
That's great, congratulations 🎉
One important difference b/t Calculated column & Measure is, calculated column can be used for slicer, where as measure can not used in slicer. if this can tell in the interview, it will be more valued.
Sir can u plz make video for this questions....
.Create a BI Dashboard/Report that would display the sale analysis; please make sure that below requirments are captured in the report
• Load all the three tables and use data modelling to relate the tables
• Calculate revenue contribution of producer (if there is a producer X with 10,000 revenue out of total 100,000; when I select producer X result should show 10%; in the same way with revenue)
• Group the accounts based on revenue as Tier1 (having revenue > 10000), Tier 2(5000 to 10000), Teir 3 (
actually, very helpful for people like me who struggling to find a job.🙂
After , watching this Video.
I'm really glad that almost every Answer , I Know while giving Mock and practicing.
Really our Content is Top Noutch , compare to others.
Glad to hear this 🙏
This video is incredibly helpful for those who are preparing for job interviews.
Awesome! Really Great! Thanks for sharing.
Hey shashank i am your constant viewer of your channel,
Good evening,
I am a power bi developer recently I stuck with a situation in which
I have a table with sales date now I want to show data such that when user will select any date it gets the option of selecting data range like. 7-15 days 15-30 days 30-60 days and many more and all have multi select option
Eg:
User selected 1/1/2024
Now user show have filter in which it has option to see data of 7-15 days means 24/12/2023 to 16/12/2023 and same other filter of 15-30 days from 15/12/2023 to 01/12/2023
With multi select option
I was just looking for it ! Thank you 😊
13 th answer is dataflow
Hi Shashank, Thanks for sharing the valuable Interview Questions & tips to crack the Interview. It is really helpful for me and others as well. Request you to share some more videos. Regards, Amitabh
Most welcome! I will.
what is dataflow in power BI can you explain it. Please create a video with use case.
Dataflow is live query from your source database in power bi Service.
It’s independent and not coming with your power bi report and dataset.
Suppose you need a table that will use in different reports all together then you can create dataflow in power bi service.
I watched the entire video and noted down both questions and answers, however, these questions for experienced people of freshers??
Thank you so much for sharing such a valuable and important content.
Glad you found it useful
hi can you start a playlist from begginer levelto advance
very informative video thanks
Are repetitive data and duplicated data are same?
please share your views?
Very helpfull Shashank, one day will share my interview question to u once i got oppertunity.😇
Sure 😊
Hi Shashank,
Are these questions asked for fresher or less than 3 years?
Regards,
Mani.
Very informative ....i have one question...you said business analyst connect with client then gather req and share brd document with dev....then as pbi dev when we connect with client..please tell all scenarios...
will you please tell me the interview process of data analyst from starting to landing of the job.
Very much helpful 🎉
You got a new subscriber ❤️
Hi Shashank
I completed my degree in 2008
And I have a three years sales experience from 2019 to 2022,
Will this career gap affect on the job,
How can I get a job as data analyst,
Could you please tell me,
So that I can plan accordingly ,
Hi Everyone.
I have a topic; can you guys help me understand it? (I faced this question in one of my interviews.).
I have an employee table, another table fct_Attendance_time,
This employee has some columns, such as ID, name, and department name.
The fct_Attendance_time table has every day in and out data (in: 8.30 out: 9.00 again, same employee comes in at 10.00 and out at 11.00). This is just a sample.
for ex 1 employee went outside 10 or 20 also possible.
Now they want to know:
1. For each department, how many employees present and absent need to be shown in visual form, not a table or matrix?
2. The number of visits per employee and how much time is spent in the office.
3. employee time spending percentage per day and previous day,
Thanks in advance.
@LearnWidGiggs bro,
If possible, Please make a video for us.
Which interviews these questions are asked
I am getting dynamic questions not so easy questions they are asking
Hi Sir,
there is one scenario two table engine and product and in both we have calculated some columns like ActiveEngine in engine and Total Committed, Current Exposure in products and in both we have mode name so i want to built matrix which have all calculated columns from both vs model name , i have used related functions but values i ma not getting correct
Can you make video on version control in Power BI?
Hi, could you please tell us this interview for how many years of experience?
2.8 yrs
sir, are these questions for freshers or experienced?
Hi Shasanka,I watched all the video on RUclips for learning new things on power bi..so my question is that I have from BPO back ground and I dnt have any prior knowledge on power bi..but recently I took course for 3 months and I complete the course and I make so.w dashboard and report also..but in resume do I mention any project ??
As a fresher you should put 5 projects covering Excel, sql and Power BI under 'Projects' section
Could you please share the job link of tcs as have the 2.8 years of experience ,It would be helpful if you share the link
Thank you soo much sir
Ur contents are gud but questions are not visible properly bro please share questions
If you are watching this video skip 2 minuits and watch in his every video 2 munuits are just waste of time
thanks for questions
Plj provide dataset in all video
Hi Shashank I have done work multiple domain but from two year I am working as support some process data also I have use power bi but not for development only review data flow I have total 10 year It's are different domain so now I am struggling to find a good job that suit my situation I need your help I want to explore this data analysis area can you help me
current status of calls on POWER BI
0
Please provide pdf link
Hello sir, I am preparing for data analyst I wanted to ask some questions regarding this where I can connect? Can you please help me in this sir.
Helpful
Hi sir plz tell me from when calls will be resumed
Hi
Thank you for all valuable content. I have also given a interview in tcs where interview asked ne this question, he was trying to check my sql and data model ability through this question.
If you have 2 tables with these columns sales_table=orderid, orderdate,deliverydate,salesamount
Product_table=orderid,productid,productname,prod_category
How are you going to build a visual of ordervalue and salesvalue comparison ....
Give me e2e approach
Thanks for sharing 👍
It will be best if you could send me on mail properly. (Mail id in about section of the channel)
Hi sir can u pls tell me exactly for this question how many dashboard created till date ??? Give this answer as per ur experience sir😊
Great
how many years exp this interview?
2.8 yrs
Hi sir
When start hiring for a power bi developer from Feb not getting any call
same problem.
Not getting calls for interviews even after updating my naukri profile everyday
Plz work on your resume.
And be active on LinkedIn
@@learnwidgiggs thanks fr advise brother 🤝
Please make a video on resume and template .
Very helpful 👍 Thank you so much for sharing.
Welcome!
April hiring will be good?
yes
Hi shashank, can you share this notepad file (.pbix file) ...it would be very helpful along with written ques and answer of all companies to get in a consolidated manner.
Thank you
Waiting for your response.... U are great person helping lot of people. Your videos are always helpful for me.
You can take the screenshot of the questions here, it's clearly visible 🙏
@@learnwidgiggs yes screenshot is possible, but if it's possible to share it would be helpful as it would be in a consolidated manner(pbix or notepad file)
Thanks
Can we get job after learining power bi.
I am new to this field please suggest.
What is your educational background
Is the certification is important to get power bi job?
Vanshu Same Question here But I'm little confuse Lemme know once you'll got know
Sir can u plz tell me what is job market for power BI ?
Zero
❤
Sir i am preparing for bank exams since 4 years but i didn't crack and now i want job but i am not from it sector please help me sir
Railway me vacancy hai waha bhi apply karo
Prepare for data analyst job
Sir waiting for 75days series n Tqsm for this session ❤
It has already started. Check out 'Shorts'
Your explanation is not clear...try to elaborate and give the best answers
Sir how can i talk with you because i follow you on LinkedIn but how should i massage you? Plz tell me
very informative video thanks