Top 10 Power BI Interview Questions (based on what I usually ask)

Ғылым және технология

💥 FULL Power BI Course - chandoo.org/wp/power-bi-course/
~
Got a Power BI interview coming up. Make sure you know answers to these 10 questions.
0:00 - Top 10 Power BI Interview Questions
0:46 - Explain the difference between a measure and a calculated column.
2:05 - Describe the process of publishing a Power BI report to the service?
3:21 - How would you handle missing data?
5:30 - What is DAX and give us an example of recent DAX formula you've used?
7:22 - How do you connect multiple data sources to a Power BI Report?
8:12 - What are the main differences b/w Power BI Desktop and Power BI Service?
9:13 - How do you optimize the performance of a Power BI report?
12:09 - Explain RLS (Row Level Security) in Power BI and how do you implement it?
13:03 - What do the 1, * and arrow mean in the data model diagram?
14:47 - What is a Slowly Changing Dimension (SCD) and how do you handle it in Power BI?
16:52 - Power BI Weekend is happening again!!!
~
See the questions & answers here -
chandoo.org/wp/power-bi-inter...
💻 LEARN Power BI:
=================
📚 Full length Power BI Course - chandoo.org/wp/power-bi-course
📺 Power BI Playlist on my channel - • FREE Power BI Course 🎁
~
All the best with your interview.
#Powerbi #interview

Пікірлер: 65

  • @TheLuky28
    @TheLuky288 ай бұрын

    Thanks

  • @chandoo_

    @chandoo_

    8 ай бұрын

    You are welcome @TheLuky28. Thanks for the super :)

  • @vaindamtulasi8018
    @vaindamtulasi80187 ай бұрын

    row level security is used to hide certain data (eg: confidential data ) from other users in power BI service. This can be done after creating the dash board in the report view and in model section, go to manage roles, create a role with some name, go to tables and selecting the table which you want to hide , go to table permissions then add filter to define filters , now go to home ,then view ,then roles, assign user by entering their mail id Now publish the dashboard on power BI service

  • @laraberciyah7542

    @laraberciyah7542

    4 ай бұрын

    good

  • @kolavamshi4952

    @kolavamshi4952

    Ай бұрын

    Hi Bro..I am trying to learn Power Bi. But I am not finding any Power Bi working professional.Kindly suggest any one.

  • @vinaypatil8009
    @vinaypatil80098 ай бұрын

    Pls 🙏🏽 sir Continue this series with Excel , SQL, powerbi cover all interview questions with answers

  • @balajim3318
    @balajim33188 ай бұрын

    Amazing. Please continue this series till I get my job on Power BI😂

  • @english_speaking

    @english_speaking

    4 ай бұрын

    Bhai reference lgaade

  • @shayariworld2851

    @shayariworld2851

    Ай бұрын

    Did u got the job

  • @balajim3318

    @balajim3318

    Ай бұрын

    @@shayariworld2851 yeah. After so much. My joining date is June 3

  • @ashish90702
    @ashish907028 ай бұрын

    THANK YOU SO MUCH PLEASE UPLOAD MORE SUCH TYPE OF POWER BI INTERVIEW RELATED QUESTIONS 👍👍

  • @harikrishnannair7653
    @harikrishnannair76538 ай бұрын

    Row level security is like an access control method through which the end users access to report can be restricted based on certain parameters ( for eg- geography)

  • @charanreddys7190
    @charanreddys71907 ай бұрын

    I really appreciate your efforts for putting to explain in detail 🙏

  • @Koushik_1996
    @Koushik_1996Ай бұрын

    RLS is a feature of Power BI it basically help us to restrict user to view report or visual. It will help us to restrict the report based on some given rules and filter based on user credentials. RLS is basically two types one is Satatic RLS and another one is Dynamic RLS. Static RLS is basically apply on particular rules and filter after creating static rls it could not be changed by user specific but on the other hand the Dynamic RLS will change based on user credentials specific based on user credentials it will show whatever access he or she have on report. That is Dynamic RLS. After creating a report in power bi desktop then go to modeling tab and managed roles then create roles based on dax and apply filter and go to Power BI service your report dataset ellipse then select security and add member to role you created in Power bi desktop assign those roles into the members.

  • @user-cj6il3et4z
    @user-cj6il3et4z8 ай бұрын

    Thank you so much for these kind of videos. 👍

  • @jupitervibe3825
    @jupitervibe38256 ай бұрын

    Thanks for wishing for interview. Will get back to you once I clear the interview. 🎉

  • @aadildilse5022
    @aadildilse50228 ай бұрын

    Tq sir,more vedios on scenario based DAX question &answers

  • @rachanajm2831
    @rachanajm28312 ай бұрын

    You are a great tutor... thank you

  • @balamira297
    @balamira2978 ай бұрын

    Thanks Chandoo!

  • @yourbuddy4344
    @yourbuddy43448 ай бұрын

    Very much helpful... Thank you 😊

  • @bp2807
    @bp28078 ай бұрын

    Very Nice sir. What is Dataverse? Please do a video on the same. Please🙏🙏🙏

  • @faribayari8187
    @faribayari81877 ай бұрын

    Thanks, Plz make such video for data analysise position.

  • @brianligat9493
    @brianligat94936 ай бұрын

    A slowly changing dimension is a dimension that changes slowly. Brilliant!

  • @joyotiegbe1549
    @joyotiegbe15498 ай бұрын

    Thanks for sharing.

  • @dbamentorparag
    @dbamentorparag17 күн бұрын

    Thanks for your time

  • @ashaarun527
    @ashaarun5275 ай бұрын

    Thanks for the video. pls do more videos like this.

  • @AncientKTV
    @AncientKTV6 ай бұрын

    Besides teaching you have a ❤heart Anna

  • @Jessica-ii5rd
    @Jessica-ii5rd4 ай бұрын

    This is a life saver thank you so much 💕

  • @sagardhatrak9247
    @sagardhatrak92478 ай бұрын

    Please make the same for SQL as well as Power BI service

  • @fredyharsha4081
    @fredyharsha4081Ай бұрын

    Measure is used for aggregations functions Calculation column : derived columns

  • @rehanashaik5497
    @rehanashaik54977 ай бұрын

    Rls means it is restricting the data access to the particular user and by using the manage role will be creating

  • @aadyalakshmi1634
    @aadyalakshmi16347 ай бұрын

    Hi sir, wil you be able to provide certificate for these webinar or event which will add value in CV

  • @Nicole-if8gg
    @Nicole-if8gg6 ай бұрын

    RLS using PBI For organizational access control, I utilized the Account field in Dataverse along with Azure B2B Authentication. This approach involved associating roles in Power BI Desktop with specific accounts. In Power BI Services, I then linked these roles to security groups, ensuring thorough access management. Additionally, I employed modern business units in conjunction with the account table in Azure B2B. This allowed me to create custom security roles, providing granular permissions that differentiate between store workers, vendors, and owners. In the Power BI Workspace Reports. In a Power Platform project, I implemented row-level security (RLS) in a Power Apps Portal(A.K.A. Power Pages) for customers. Using Power BI Embedded services within Power Platform Admin But first I started by creating a role in Power BI Desktop and utilizing the Dataverse Contacts table. I mapped the 'adx_username' field to 'username()' for specific user data access, integrating Azure B2C Authentication. Furthermore, I customized the property for the contact to accounts using a security filter. Additional configurations were made in Portal management for table permissions and roles

  • @Data_guy_from_Bihar

    @Data_guy_from_Bihar

    6 ай бұрын

    Hey Nicole- Are you on linked in?

  • @SahilGupta-fr2vh
    @SahilGupta-fr2vh16 күн бұрын

    Good job

  • @ShreyasSinha
    @ShreyasSinha4 ай бұрын

    very nice video

  • @chaitanyalanka7043
    @chaitanyalanka70436 күн бұрын

    we have to use filters and we can get one link in google then we can place the ID/Name in that link then we will see the output for the particular person/ID the data we are getting for that particular ID/Name we have placed in the filters

  • @cocgamingstar6990
    @cocgamingstar69908 ай бұрын

    Woow excellent explanation 😊

  • @chandoo_

    @chandoo_

    8 ай бұрын

    Glad you liked it

  • @nyke_art
    @nyke_art8 ай бұрын

    Hi Chandoo. Are these questions asked for a fresher or an experienced?

  • @dbamentorparag
    @dbamentorparag13 күн бұрын

    Last few seconds you have mentioned hope you got that Job....

  • @amitgajkal4821
    @amitgajkal48213 ай бұрын

    For 7.22 question, the data is being imported into PBI system and not cloud or partial on cloud and some imported?

  • @sandeepkhugshal7122
    @sandeepkhugshal71224 ай бұрын

    Bhahut badhiya

  • @preetshah3793
    @preetshah37938 ай бұрын

    Make a video on tableau how use calculated field, parameters and action.

  • @chandoo_

    @chandoo_

    8 ай бұрын

    I already did. See this - kzread.info/dash/bejne/qYea26SwYdXSepc.html

  • @eshithareddy4361
    @eshithareddy43616 ай бұрын

    Hi chandoo, when will be the next weekend session ?

  • @statusfeed
    @statusfeedАй бұрын

    RLS is limiting data at row level, suppose i have 4 region data north, south, east and west i want north region manager to look at north region data only so under Modeling tab > Manage role, i will create a role named North Manager and i will restrict all the other regions data except north

  • @saidinesh4516
    @saidinesh45166 ай бұрын

    Hello brother Could you please make a video on Tableau

  • @celesteporter2918
    @celesteporter29185 ай бұрын

    When will you offfer another 2 day course like you offered in November 2023? I aminterested and hope you offer one within the next month.

  • @sivakumarisadineni3193
    @sivakumarisadineni31938 ай бұрын

    Good content want to join the paid classes as well for powerBI but they are a bit expensive

  • @chrism9037
    @chrism90378 ай бұрын

    Great video thanks Chandoo!

  • @chandoo_

    @chandoo_

    8 ай бұрын

    My pleasure!

  • @omkarshinde8154
    @omkarshinde81546 ай бұрын

    Hello Chandoo sir, I am looking for internship opportunity in data analytics..will you able help me in that.

  • @praveen439
    @praveen43912 сағат бұрын

    When can I expect next Power BI Weekend class

  • @poojaconda4139
    @poojaconda41393 ай бұрын

    really helpful! but a very silly question, Can i know why there's a shoe in your book case :P

  • @chandoo_

    @chandoo_

    3 ай бұрын

    Shure... It is a Lego Adidas Superstar set - 10282

  • @ManoSru
    @ManoSru26 күн бұрын

    Measures cannot be sliced na bro, how u used in Question 5

  • @aiasaiascon3894
    @aiasaiascon38946 ай бұрын

    You did work in a choco company???? WOW!!!! Me too man!!! Chocolate is awesome also besides You!!!

  • @ramyachilaka1995
    @ramyachilaka19957 ай бұрын

    Hi sir ,how can i purchase your online data analyst course . is there any email id which i can speak u in person regarding career path and course details.please do reply sir

  • @waqasbashir3539
    @waqasbashir35397 ай бұрын

    Hi everyone! Can someone give me dataset for dashboard.. i have assignment to Make dashboard but I don't have dataset... can any one help me?

  • @chandankumarmajhi6974
    @chandankumarmajhi6974Ай бұрын

    Please improve voice quality 🙏🏻

  • @gabenothing

    @gabenothing

    Ай бұрын

    he didn’t even need to make this video. he’s teaching you something. just pay attention. improve yourself man.

  • @MrTylerDirt
    @MrTylerDirtАй бұрын

    Акцент топ

  • @wasvendrachivane1910
    @wasvendrachivane19106 ай бұрын

    Best 🤌

Келесі