Capgemini- 10 Interview questions you must know | Power BI😲

[@sivakrishna_preneur]

Hi Sashank, I got these Qn's from one of my friend will you explain in detail ? Power BI fresher Interview ------------------------------------------------------ 1. What are the Transformations or what is data cleaning activites you have done to till now? 2. What is the major difference between custom column and condition column ? 3. How to combine two Columns and column will not be effected? 4. What is page navigation and why it is used ? 5. What is static tables ? 6. what is query folding ? 7. What is merge Query ? 8. What are the relationships that you've used to till now ? 9. How can you resolve Many to Many cardinolity ? 10. Why don't we take duplicates ? 11. What is Implicit and Explicit functions ? 12. What are the visual that we have in Power BI Desktop level ? 13. What is the use of Bar chart and column chart ? 14. Which chart is used for Trend Analysis ? 15. Differece b/n Area & Line chart ? 16. What is the use of Pie chart ? 17. Diff b/n Pie chart & Donur chart ? 18. What is the use of Edit Interactions ? 19.What is the major difference b/n Drill through and Drill down ? 20. What is BookMarks ?

[@Indizsek]

Such a beautiful questiona..thanks for this ..🎉

[@anshulsingh430]

Good insightful can you please post more around workspaces, containers, RLS these are most frequently being asked in power bi interviews

[@learnwidgiggs]

Sure, noted

[@deepaktibhe3077]

Your video's are really helpful. Can you please also make the video on migrating power bi report from one environment to other. Changing connectistion strings in power bi (DEv --> UAT--> Prod databases.) Version controlling in power bi. Handling multiple landuages in power bi. deployment in power bi report using CI CD pipelines.

[@ShivangiChauhan-je8ku]

really helpful video sir . Sir can you make a dedicated video for fresher interview please

[@randeepsinghrandeepsingh5692]

I came here only for English practice 😂😂

[@LearningNeverEndz]

Relatable, what kind of problem you are facing?

[@aryavlogs4532]

My presentation skill is not good so could you make a video that how can we give a perfect presentation.

[@learnwidgiggs]

Thanks for suggesting, noted.

[@jainsonika]

Can we have Visuals from multiple workspace reports in a Power BI Dashboard?

[@learnwidgiggs]

@@jainsonika No

[@tanyasrivastava6921]

Also make the Advanced Excel and Python Interview questions. Because sometimes we used to ask in data analyst role.

[@learnwidgiggs]

Thanks for the suggestion

[@JyotiSinha-no3zn]

Is this interview questions for freshers?

[@thulasikamana8135]

Thank you 🤝 for sharing us good information

[@learnwidgiggs]

My pleasure

[@shwaripawar8222]

Thank you very much Shashank Sir :)

[@learnwidgiggs]

Most welcome!

[@kanchannatekar5798]

Very nice explanation

[@Vinod-yb2ix]

Nicely explained.

[@APlantWoman]

How can we connect Jira and use that data to create power bi dashboards?

[@sparshgoyal3159]

@learnwidgiggs Please tell me these are not freshers level questions?

[@learnwidgiggs]

2 years

[@sparshgoyal3159]

@@learnwidgiggs You always reply dude.. this is what makes us to see your videos and ask doubts. Keep it up.. thanks 👍

[@8bitsql]

can you tell more about que 4 why relationship may break if constraint are applied. i have tried and it wont break in my case. then when it may be break?

[@AncientKTV]

Hi sir can u make tell me about ur project question, how to explain any project

[@learnwidgiggs]

Already uploaded a video on this channel in the past..plz check out the channel videos.

[@tanyasrivastava6921]

In my last interview I have not cleared that round because of my communication skills and i cleared the technical round. They I have work on my slang.I speak good English but my slang is not good to talk to US client as I get the feedback.

[@learnwidgiggs]

Please work on your slang.

[@LearningNeverEndz]

Are you applying as a fresher?

[@nautiyal6391]

Provide a sample dataset and ask the candidate to create a report --- how to give relevant answer of this question

[@surajkumarpachipulusu2217]

Hi Shashank these insights are really helpfull

[@learnwidgiggs]

Glad to hear that.

[@chetanshinde1992]

Thanks for such an informative video..

[@learnwidgiggs]

Glad it was helpful!

[@aishwaryasandra6773]

We u kindly correct this query: calculate([sales],[cost]>600)

[@learnwidgiggs]

Calculate( [Sales], Filter(Sales, [Cost] > 600))

[@tony_montana9122]

This for fresher or experienced?

[@Ram6669]

Experienced candidate

[@Live-nm8lx]

Fresher college passout

[@bipinjoshi2265]

Are these questions for the beginner level(0-2) years or senior level?

[@learnwidgiggs]

Yeah I believe it will be 0-2 yrs

[@SandipanSarkar-c8v]

Finished watching

[@Sirigineedi_Navann]

Superb video 🎉😊

[@learnwidgiggs]

Thank you 🙏

[@sandhyah6089]

Are you those questions for fresher or experience?

[@learnwidgiggs]

Experienced 2 years

[@neelimaneelu4604]

When will we get powerbi openings for 2 exp?

[@learnwidgiggs]

People are already getting the calls

[@mahidhar6247]

no sir​@@learnwidgiggs

[@chaitanyainamdar3478]

Thanks for the information. Could you please create a demo video with an interview question that would really help.

[@learnwidgiggs]

Sure thing!

[@prasadmekala258]

How many years of experience he has? Can you say please

[@learnwidgiggs]

I think 2

[@prasadmekala258]

@@learnwidgiggs thanks sir❤️

[@anupam5028]

Data analytics people fresher jobs in 2024 for intern and job??

[@rohitchowhan37]

Create a fake experience, no company hiring freshers for data analytics role.

[@VamsiKrishna-nv8wr]

super

[@neelimaneelu4604]

Power bi openings vunnaya present

[@sarihaddu]

no

[@subbaraoballipale890]

today in exl cmpy power bi dev role interview question i got this power bi question can u pls mention in ur video if I give you 1000gb data base & I have to use all tables & cols for my dashboard report what will be ur approach ?

[@sarihaddu]

My approach will be to use DirectQuery mode to import data into Power Query and then Power Pivot. It is because PowerPivot has dataset size limitation of 1 GB for pro user and 10 GB for premium user and so we cannot use import mode because it will bring all the data and metadata into the model. By using Direct Query, only meta data will be loaded into power query and I will do all the required ETL activities and load the data into power pivot, establish relationships, write dax according to the client requirements and then create reports and dashboards. When the client opens the dashboard, the data will be loaded directly from the database instead of the PowerPivot. DirectQuery mode removes dataset size limitations and can handle huge volumes of data. Please correct me if I am wrong. I am also learning power BI.

[@poojamali9506]

Well explained.. Thank you

[@ushavelagala6175]

Do we have recession in india for 2024

[@atharwaborkar6778]

No , recession as such. If you are good in the skills and learn new things then it is easy for you to grab any opportunities.

[@subbaraoballipale890]

pls share that pbix file we are requesting u since long

[@learnwidgiggs]

Google drive link.. didn't work for me for text and pbix files. I have tried many times in the past. So I couldn't share the link.

[@stylishboy2319]

Tq