Get Hired at Accenture with These Power BI Interview Questions | Power Bi Round 2 Interview Question

[@praveenbhojan5022]

1st question - simple step change the number data type to text and then change the data type into date

[@madhusudhanreddyt2838]

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

[@KSRDatavizon]

Thank You for Your comment, Please subscribe our channel for regular updates and it Motivates us a lot 🙏🏼

[@SandipanSarkar-c8v]

Finished watching

[@KSRDatavizon]

Thank You

[@vishalgatla-i8t]

For Que-2

[@KSRDatavizon]

Need any more information ?

[@kiran8145]

Please create a video on how to write a Power BI resume for someone with 1-2 years of experience.

[@KSRDatavizon]

sure kiran, we will make a video on the same,

[@Nishikant_N]

Question 5, i had tried but could not have done. How you can help me?

[@KSRDatavizon]

could you please share us the errro pic and your querrey in Detailed

[@kancharanarajendra6185]

How how many years experience these questions are for..

[@KSRDatavizon]

it helps for 3-5 years experiance people.

[@Sureshsahu-o9l]

These questions are typically asked for candidates with how many years of experience

[@KSRDatavizon]

3-5 years experienced people

[@harikk-en1cd]

Where is round 1?

[@KSRDatavizon]

kzbin.info/www/bejne/lXWzinahis6prK8

[@OneNI83]

Question No 5 ,it should be ALLSELECTED not ALL

[@KSRDatavizon]

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

[@amala-d1f]

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

[@madhusudhanreddyt2838]

yes it should be ALLSELECTED to work perfectly..

[@namangarg7023]

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

[@KSRDatavizon]

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.