PASS EVERY TIME! 50 Power BI Interview Questions & Breakdown ✔ [PDF] #1
In this video I will do a complete breakdown and explaination of Power BI Interviews, what are the different types and then go through 50 of the most common and top Power BI Interview questions and anwsers.
This video is for beginner and experienced Power BI Interviews.
🔗 LINKS
🔴 Don't forget to subscribe, thanks: / @transformita
✅ Connect on LinkedIn: / rajausmaanayub
📁 files - https://www.dropbox.com/scl/fi/yxpe9e...
🕐 What this video will cover & Timestamps
Part 1:
0:00 Introduction
0:18 Training Material
0:27 What are the two types of Power BI Interviews?
0:45 What are Interviewers testing for?
1:08 What you need to do during a technical test?
Part 2:
3:42 What is Power BI
4:07 What are the components of Power BI
5:08 What are the different license types
6:12 What is DAX
6:30 What data sources can Power BI connect to?
8:01 How do we Connect to Data in Power BI?
7:10 What is import mode?
7:26 What is Direct Query?
8:00 to multiple data sources at the same time
8:33 What is Power Query?
9:00 Difference between calculated columns and measures?
9:35 What are relationships in Power BI
9:34 What are the different types of relationships?
10:39 What is a Star Schema?
DAX
11:28 What is the Calculate Function and what does it do?
11:56 What are Iteretor Functions
12:38 What does the ALL Function do?
13:07 What does the USERELATIONSHIP Function do?
13:38 Name me some visualisation Types?
14:05 What is a Slicer in Power BI
14:27 What is a Drill Through?
14:56 What are bookmarks
15:25 What is Row Level Security?
16:01 What is the Power BI Gateway
16:56 What are Power BI Apps
17:23 How to optimise your dataset and models?
17:43 What is Query Folding?
18:29 How do you publish reports to the Power BI Service
How do you schedule data refreshes?
19:30 What is the Power BI admin portal
19:58 How do you manage access in power BI
NEW
20:28 You have multiple data sources with different structures that need to be combined in one report.
You need to track live updates from a database in your report.
20:58 Your report needs to show different views based on user interactions, like clicking on visuals.
You’re asked to identify outliers in sales performance.
20:26 You are required to aggregate and analyze over 100 million records from a SQL database.
Your organization wants to migrate its reporting from on-premises servers to Power BI in the cloud.
What are Variables?
What considerations should be made when choosing a machine to install the gateway on?
Why would you have multiple gateways?
Why would you want to turn off the auto/date time feature in Power BI?
How would you handle merging data from two different systems with inconsistent data formats in Power BI?
What are paginated reports?
Why would I work with shared Datasets and whats the concept behind it?
How does incremental refresh work and whats the point behind it?
what is the difference between row context and filter context and how does it work?
What is the difference between ALL and ALLSELECTED
What is the SWITCH function
What are Field Parameters