Case Study on "Common Customers" | Power BI Interview | Must Watch
Vložit
- čas přidán 29. 01. 2023
- Topmate Link to book session 1:1 - topmate.io/learnwidgiggs
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / shashank_nikumbh26
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs
it will really helpful if u attach the dataset to practice.
Sir in the total_cutomers DAX, why we have used the date filter like datesbetween as the slicer will automatically filter the date as per the selection of slicer nh. Instead we can go for countrows and it will have automatically filter the data as per the city and then the slicer will again work as a filter for that selected date.
This guy never fails to impress with his content! Hats off to your consistency of the quality content that you deliver via your videos !! 👍
Thanks Rajat 😊
If your bring data through Import Mode from SQL Data base. And you want to create a calculated column. Better to create at the database itself or in PQE . Also some Data Transformations better to do at SQL Data base or PQE . ( SQL data - Import Mode Only)
Very informative video!!
Thanks 😊
As always, Great content and very good explanation. Thank you☺
Welcome 😊
Can you please do a video on how to test the power bi report
Thanks for sharing great content always ☺️
Thanks for watching!
Practice easily
Bro can you make video on banking project domain it's need help for one
what if instead of countrows we want name then which dax function is suitable for this ??
Hi sir,
I am having a transcation table (Customer name, date ) and date table.
I want to see how many new customers came in a month when compared to previuos month in Column chart (y axis- count of new customers vs month) and who are those customers (customer names ) in table .
can you please help me ?
Sir in place of DATESBETWEEN() can we use SAMEPERIODLASTYEAR()
Ha, It should work.
For last year any other formula can we use apart from Datesbetween....for comparison if they ask 2 yrs...
For last yr Sameperiodlastyear ()..can be tested if it works right.
Hi ... In place hard coding -365 can we replace with dateadd(min(calendar [date],-1,year)) same goes with Max ??
I think this will make it complex.
Becoz I already made it dynamic only its not hard coded if you watch it properly. ( From the selected range which is dynamic subtract 365)
But what if last year is a leap year@@learnwidgiggs
Sir Can You Please Make A Video On End To End Project Explanation.
Next video will be on - "How to Explain yr project"
How to do the same when there is no direct relationship between customer table and date table?
Treatas() may be useful
Hello, can you please the dataset file for this lecture, i have to practice this scenario
I don't have it ready available to share.. sorry..you can create it on your own by just taking the ss from the video..will hardly take 5 mins
Thank you for the video. But, the hardcoding of 365 days will fail for leap years, right?
Good point. Didn't consider this scenario.
How to Check if the report or visual that u have generated is have exact Results? How You will answer this question? How you varify in your company sir?
Analyze it in excel and compare the data from the source
Sir please first make on video on those topic on which you said "Noted"
I hope you remember
Next video will be on - "How to Explain yr project"
@@learnwidgiggs thanks sir...and please make it like you are explaining in front of interviewer... include all points like team size...blabla.. thanks
Scenario : Donut chart is there that is region by volume. I want top 10 regions by volume. How can I achieve that?
✅ Scenario: Rolling 24 months. So, volume, net sales & gross profit is there. In that visual (from line & stacked bar chart) you don’t want bar chart. So, what other charts can you use?
✅ Scenario: Client having 2 categories i.e., potato & prepared potato products. So, there are volumes. Volume is a measure that we have which is derived from a table. If you see this measure, it is coming from a view, it has different values in sales volume & value. This is giving you the volume for this. Now, how do you calculate % of volume?
✅ Scenario: It’s January new year, for ranking which function will you be using? If you wanted to rank the month according to the volume. I want to rank the category or the month, I just want to rank it based on the volume i.e., potato should come as 1, prepared potato should come as 2. Which function will you be using to get it?
Scenario : If you are a stakeholder where you have normal amount of data, but you want direct query mode to use. What will you suggest? Can you convince me why should I go for import mode? What are the steps you will be telling them and what will be the dashboard performance? Will it be faster or slower?
koi solutions bata do.....
One question.... I watched your some interviews video's or some other videos where u explain how data loaded in PowerBI and create reports...how you perform etl in PowerBI query editor. So i want to ask in real time also you perform etl in power query editor or you clean data using SSIS and only create visual in PowerBI.....i want to ask in real time also all cleaning done in PowerBI itself without Using SSIS or other tool? It happened in real time ? It happened with you?
Yes most of the transformations or cleaning we do in Power Query...if in any particular project specific ETL tool has to be used then you don't have any other choice but to use it for transformation
@@learnwidgiggs Thanks for answer.....and can you tell something any scenario why they choose to use seperate ETL tool? Instead of power query? And in last can I get job with good SQL server, Excel and power BI... without SSIS? THANKS
@@xyz_1943 Because not all the transformations you can handle in power query in power bi so sometimes they prefer to use seperate ETl and one more reason to give less load on power bi if the data is huge.
Yes you can get the job.
@@learnwidgiggs thanks for replying sir....i am learning so much from your video's......Thank you so much and waiting for next video about explaining project. THANKS
@@learnwidgiggs can u tell me in short just in 1 sentence how to handle null or blanks? You just remove it or replace with other values
Send here dataset file
I don't have it ready available to share.. sorry..you can create it on your own by just taking the ss from the video..will hardly take 5 mins
Hi sir ,
I am a housewife and started learning power bi please help me with some videos and anything so that I can learn it please help me
Are u studying in Excel r institute
total_customers = COUNTROWS(VALUES('Sample Sales 5'[Customer Name]))
last_yr_customers = CALCULATE([total_customers],SAMEPERIODLASTYEAR('Practice Calendar'[Date]))
Common _customers =
COUNTROWS(
INTERSECT(
VALUES('Sample Sales 5'[Customer Name]),
CALCULATETABLE(
VALUES('Sample Sales 5'[Customer Name]),
SAMEPERIODLASTYEAR('Practice Calendar'[Date])
)
)
)