KEMBAR78
BI Developer Interview Question | PDF
Scribd
Upload
530 views1 page

BI Developer Interview Question

Uploaded by

Dimple
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
530 views1 page

BI Developer Interview Question

Uploaded by

Dimple
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

BI Developer Interview Question

In Power BI

1. Data Source and Query Mode difference


a. Which to use when
2. Diff b/w Measure and Calculated
a. Which to use when and which is better
3. Data Modelling
a. Difference between Star schema and Snowflake schema
b. Both Way filter flow and single-way
c. Active inactive relationship
4. Visual Use in Power bi
5. Dax, Filter
a. Time-related dax - MTD/YTD
b. Calculate and Filter diff
c. Diff between a switch and if
6. What is RLS and what example
7. Tooltip and drill through
8. MDX Query
9. Getway

In SQL

1. Joins, Self Join


2. Diff between Where and Having
3. Window Function**** (Rank, Dense Rank, Row Number)
4. What is Store Procedure(variable) and View - definition and syntax
5. Aggregation(Avg, sum, count)
6. Query optimization
7. Duplicate identify and delete
8. The difference between union and union all

Other tools

1. SSAS
2. Report Builder
3. SSIS
4. ADF
5. MDS

You might also like