Thank You, Please subscribe our channel for regular updates. this video was made by one of our student who cracked the interview, sorry if any mistakes as she was new for making sessions. our intension just to share her experiance with us. hope you cna understand
This is for freshers only..also most of the optimisation of queries can be done in SQL only... For two fact tables u can select required columns from two different tables and then union all. Select distinct customerid from table1 Union all Select distinct customerid from table2
Optimizing SQL Queries for Freshers: A Quick Tip! When working with two fact tables, remember that most of your query optimization can be done directly within SQL. 💡 Here’s a simple tip: If you need to retrieve distinct customer IDs from two different tables, you can select the required columns from both tables and use the UNION ALL operation to combine the results.
![[[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit](http://i.ytimg.com/vi/Ar6hSITP-w4/mqdefault.jpg)
1st question - simple step change the number data type to text and then change the data type into date
we can do it in DAX also using the combination of Date, LEFT, RIGHT and MID Functions..or we can use the Date.From function in the custom column
Thank You for Your comment, Please subscribe our channel for regular updates and it Motivates us a lot 🙏🏼
Finished watching
Thank You
These questions are typically asked for candidates with how many years of experience
3-5 years experienced people
How how many years experience these questions are for..
it helps for 3-5 years experiance people.
Question 5, i had tried but could not have done. How you can help me?
could you please share us the errro pic and your querrey in Detailed
For Que-2
Need any more information ?
Please create a video on how to write a Power BI resume for someone with 1-2 years of experience.
sure kiran, we will make a video on the same,
Question No 5 ,it should be ALLSELECTED not ALL
Thank You, Please subscribe our channel for regular updates. this video was made by one of our student who cracked the interview, sorry if any mistakes as she was new for making sessions.
our intension just to share her experiance with us. hope you cna understand
Yes u are right, we can use ALLSELECTED if we are using slicers but in Question 5 I have not used the slicer so we can use ALL DAX as well. Thank you
yes it should be ALLSELECTED to work perfectly..
This is for freshers only..also most of the optimisation of queries can be done in SQL only...
For two fact tables u can select required columns from two different tables and then union all.
Select distinct customerid from table1
Union all
Select distinct customerid from table2
Optimizing SQL Queries for Freshers: A Quick Tip!
When working with two fact tables, remember that most of your query optimization can be done directly within SQL.
💡 Here’s a simple tip: If you need to retrieve distinct customer IDs from two different tables, you can select the required columns from both tables and use the UNION ALL operation to combine the results.
Where is round 1?
ua-cam.com/video/_DPYCkUivvM/v-deo.html