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 ?
initially when you are going to get the data from the source (if 6k rows), it is going to take a snapshot of the data at that given time and then load the data into the power bi in-memory (all 6k rows will come into the power bi). after you create the report with 6k rows..and if there are any changes happening at the source side (like truncating the data to 1k rows)..the power bi will still show all the 6k rows..since its loaded into the memory..when you perform a REFRESH at the power bi desktop level or the power query level, then it going to again establish the connection to the on-premises data source and get the data..and this time u will be seeing only 1k rows in the report.. answer is, initially you will get all the 6k rows..and even if we truncate the table to 1k rows, still the power bi report will show 6k rows only..once you click on the refresh button, then it will show the 1k rows...
he was asking the storage space and not the model or the dataset size.. the maximum model or the dataset size for pro or free license is going to be 1gb and for ppu license, it is going to be 100gb and for premium capacity license it is going to be 400gb if you are talking about the storage space allocation for the workspace level, then for pro license , we will have 10gb and for ppu and premium capacity we will have 100tb
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.
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?
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.
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 ?
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.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
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 ?
Such a beautiful questiona..thanks for this ..🎉
initially when you are going to get the data from the source (if 6k rows), it is going to take a snapshot of the data at that given time and then load the data into the power bi in-memory (all 6k rows will come into the power bi). after you create the report with 6k rows..and if there are any changes happening at the source side (like truncating the data to 1k rows)..the power bi will still show all the 6k rows..since its loaded into the memory..when you perform a REFRESH at the power bi desktop level or the power query level, then it going to again establish the connection to the on-premises data source and get the data..and this time u will be seeing only 1k rows in the report..
answer is, initially you will get all the 6k rows..and even if we truncate the table to 1k rows, still the power bi report will show 6k rows only..once you click on the refresh button, then it will show the 1k rows...
he was asking the storage space and not the model or the dataset size..
the maximum model or the dataset size for pro or free license is going to be 1gb and for ppu license, it is going to be 100gb and for premium capacity license it is going to be 400gb
if you are talking about the storage space allocation for the workspace level, then for pro license , we will have 10gb and for ppu and premium capacity we will have 100tb
Good insightful can you please post more around workspaces, containers, RLS these are most frequently being asked in power bi interviews
Sure, noted
Thank you 🤝 for sharing us good information
My pleasure
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.
Can we have Visuals from multiple workspace reports in a Power BI Dashboard?
@@jainsonika No
Provide a sample dataset and ask the candidate to create a report --- how to give relevant answer of this question
How can we connect Jira and use that data to create power bi dashboards?
really helpful video sir . Sir can you make a dedicated video for fresher interview please
My presentation skill is not good so could you make a video that how can we give a perfect presentation.
Thanks for suggesting, noted.
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?
Is this interview questions for freshers?
Hi Shashank these insights are really helpfull
Glad to hear that.
Nicely explained.
Thank you very much Shashank Sir :)
Most welcome!
Thanks for such an informative video..
Glad it was helpful!
Very nice explanation
Also make the Advanced Excel and Python Interview questions. Because sometimes we used to ask in data analyst role.
Thanks for the suggestion
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.
Please work on your slang.
Are you applying as a fresher?
Superb video 🎉😊
Thank you 🙏
I came here only for English practice 😂😂
Relatable, what kind of problem you are facing?
sir Are these questions asked to a fresher ?
@learnwidgiggs Please tell me these are not freshers level questions?
2 years
@@learnwidgiggs You always reply dude.. this is what makes us to see your videos and ask doubts. Keep it up.. thanks 👍
Hi sir can u make tell me about ur project question, how to explain any project
Already uploaded a video on this channel in the past..plz check out the channel videos.
When will we get powerbi openings for 2 exp?
People are already getting the calls
no sir@@learnwidgiggs
This for fresher or experienced?
Experienced candidate
Fresher college passout
Data analytics people fresher jobs in 2024 for intern and job??
Create a fake experience, no company hiring freshers for data analytics role.
Finished watching
We u kindly correct this query: calculate([sales],[cost]>600)
Calculate( [Sales], Filter(Sales, [Cost] > 600))
Are these questions for the beginner level(0-2) years or senior level?
Yeah I believe it will be 0-2 yrs
super
pls share that pbix file we are requesting u since long
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.
Are you those questions for fresher or experience?
Experienced 2 years
How many years of experience he has? Can you say please
I think 2
@@learnwidgiggs thanks sir❤️
Power bi openings vunnaya present
no
Tq
Do we have recession in india for 2024
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.
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 ?
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.
Well explained.. Thank you
Thanks for the information. Could you please create a demo video with an interview question that would really help.
Sure thing!