# Question Companies Difficulty Type Frequency
A. Basics & Architecture
1 What is Power BI and its components? Microsoft, Deloitte Easy Theory Most frequent
2 Difference between Power BI Desktop, Service, and Report Server. Infosys, TCS Medium Theory Most frequent
3 What are advantages of Power BI over Excel? Amazon, EY Easy Theory Most frequent
4 Explain Power Query vs Power Pivot vs Power View. Capgemini, Accenture Medium Theory Normal
5 What are Power BI dataflows? Microsoft, Wipro Medium Theory Medium
B. Data Connections & Modeling
6 How do you connect Power BI to SQL Server? Amazon, Infosys Easy Practical Most frequent
7 Difference between Import vs Direct Query vs Live Connection. Google, Microsoft Medium Theory Most frequent
8 What is a Star Schema vs Snowflake Schema? Flipkart, TCS Medium Theory Most frequent
9 How to create relationships in Power BI? Amazon, Infosys Easy Practical Most frequent
10 Explain bi-directional relationships and risks. Microsoft, Deloitte Medium Theory Normal
C. DAX (Data Analysis Expressions)
11 What is DAX in Power BI? Infosys, Capgemini Medium Theory Most frequent
12 Difference between Calculated Columns vs Measures. Amazon, Microsoft Medium Theory Most frequent
13 Explain CALCULATE function in DAX. Google, Accenture Medium Practical Most frequent
14 Difference between SUMX and SUM. Infosys, TCS Medium Practical Normal
15 What are Time Intelligence functions in DAX? Amazon, Microsoft Hard Practical Most frequent
16 How do you calculate Year-to-Date (YTD) sales in DAX? Flipkart, Wipro Medium Practical Normal
17 Difference between EARLIER() and EARLIEST() in DAX. Microsoft, Infosys Hard Theory Rare
18 How to calculate moving averages using DAX? Amazon, Deloitte Medium Practical Normal
19 Explain context transition in DAX. Microsoft, Google Hard Theory Medium
20 What is row context vs filter context? Amazon, Infosys Hard Theory Most frequent
D. Visualization & Reports
21 What are custom visuals in Power BI? Infosys, TCS Easy Theory Normal
22 Difference between slicers and filters. Amazon, Flipkart Easy Practical Most frequent
23 How do you create drillthrough reports? Microsoft, Wipro Medium Practical Normal
24 What are bookmarks in Power BI? Infosys, Capgemini Medium Practical Normal
25 Difference between dashboard and report in Power BI. Amazon, Microsoft Easy Theory Most frequent
26 How to implement row-level security (RLS) in Power BI? Deloitte, EY Medium Practical Most frequent
27 How do you optimize Power BI dashboards for performance? Microsoft, Amazon Hard Practical Most frequent
28 Explain difference between Drillthrough and Drilldown. Infosys, Wipro Medium Theory Normal
29 How do you add tooltips to visuals? Amazon, TCS Easy Practical Normal
30 What are KPIs and how to build them in Power BI? Microsoft, Accenture Medium Practical Normal
E. Advanced Topics
31 What is incremental refresh in Power BI? Amazon, Deloitte Hard Practical Medium
32 Difference between composite models and single-source models. Microsoft, Infosys Hard Theory Medium
33 How to implement drillthrough filters across reports? Amazon, TCS Medium Practical Normal
34 What is the Q&A feature in Power BI? Microsoft, Infosys Medium Practical Medium
35 Explain role of gateways in Power BI. Amazon, Wipro Medium Theory Normal
36 How to schedule data refresh in Power BI Service? Infosys, TCS Easy Practical Most frequent
37 What is Power BI Embedded? Microsoft, Google Hard Theory Medium
38 Explain composite models in Power BI. Amazon, Accenture Hard Theory Medium
39 How to publish Power BI reports to the cloud? Infosys, Flipkart Easy Practical Most frequent
40 What are limitations of Power BI Free vs Pro vs Premium? Microsoft, Deloitte Medium Theory Most frequent
F. Business Scenarios
41 Create sales vs target dashboard using Power BI. Amazon, Flipkart Medium Practical Most frequent
42 How would you create a customer churn analysis report? Netflix, Amazon Hard Practical Medium
43 Design a financial dashboard with YoY comparisons. Deloitte, EY Medium Practical Normal
44 How to calculate revenue contribution by top 10% customers? Amazon, Walmart Medium Practical Normal
45 Build a supply chain dashboard with lead time KPIs. Flipkart, Amazon Hard Practical Medium
46 Design a call center performance report in Power BI. Infosys, TCS Medium Practical Normal
47 Create a region-wise sales heatmap. Amazon, BigBasket Easy Practical Most frequent
48 How would you track employee attrition using Power BI? Deloitte, Accenture Medium Practical Medium
49 Build a customer acquisition funnel in Power BI. Amazon, Flipkart Hard Practical Medium
50 Design an operations dashboard for logistics KPIs. FedEx, Amazon Hard Practical Medium
51 Explain limitations of Power BI for big data analysis. Microsoft, Amazon Medium Theory Normal
52 How would you share reports with non-licensed users? Infosys, Wipro Medium Theory Normal
53 What are Power BI Apps and when to use them? Microsoft, Capgemini Medium Theory Normal
54 How do you compare budget vs actuals in Power BI? Amazon, Deloitte Medium Practical Most frequent
55 What are some real-world cases where Power BI failed vs Tableau? Google, EY Hard Theory Rare

Tableau (55 Questions)

# Question Companies Difficulty Type Frequency
A. Basics & Architecture
56 What is Tableau and its main products? Salesforce, Infosys Easy Theory Most frequent
57 Difference between Tableau Desktop, Tableau Server, Tableau Public. Amazon, Deloitte Medium Theory Most frequent
58 What are extracts vs live connections in Tableau? Google, TCS Medium Theory Most frequent
59 Difference between Tableau vs Power BI. Microsoft, Infosys Medium Theory Most frequent
60 What is Tableau Prep and when is it used? Deloitte, Accenture Medium Theory Normal
B. Data Connections & Modeling
61 How do you join vs blend data in Tableau? Amazon, Wipro Medium Practical Most frequent
62 What is the difference between inner join, left join, right join in Tableau? Infosys, TCS Easy Practical Most frequent
63 What are data extracts in Tableau? Google, Capgemini Medium Theory Normal
64 How do you optimize large datasets in Tableau? Amazon, Flipkart Hard Practical Medium
65 What is the difference between dimension and measure? Infosys, Wipro Easy Theory Most frequent
C. Calculations
66 What are calculated fields in Tableau? Amazon, Deloitte Medium Practical Most frequent
67 Difference between table calculations vs calculated fields. Microsoft, Infosys Medium Theory Normal
68 How to use Level of Detail (LOD) expressions? Amazon, TCS Hard Practical Most frequent
69 Difference between FIXED, INCLUDE, and EXCLUDE LOD. Google, Infosys Hard Theory Most frequent
70 Explain RANK and INDEX functions in Tableau. Flipkart, Wipro Medium Practical Normal
71 What are parameter actions in Tableau? Microsoft, Amazon Medium Practical Normal
72 How do you calculate moving averages in Tableau? Infosys, Capgemini Medium Practical Normal
73 Explain WINDOW_SUM and WINDOW_AVG in Tableau. Amazon, Microsoft Medium Practical Normal
74 How to calculate YoY growth in Tableau? Deloitte, EY Medium Practical Normal
75 Difference between ZN() and IFNULL() in Tableau. Infosys, Wipro Medium Practical Normal
D. Visualization & Reports
76 What are dashboards in Tableau? Amazon, TCS Easy Theory Most frequent
77 How do you create interactive filters in Tableau dashboards? Infosys, Capgemini Medium Practical Most frequent
78 Difference between story and dashboard in Tableau. Salesforce, Deloitte Medium Theory Normal
79 How to create dual-axis charts in Tableau? Amazon, Flipkart Medium Practical Most frequent
80 How to add reference lines and bands? Microsoft, Infosys Easy Practical Most frequent
81 What is Tableau’s Show Me feature? Amazon, TCS Easy Practical Normal
82 How do you build heatmaps in Tableau? Infosys, Wipro Medium Practical Most frequent
83 How to create bullet charts in Tableau? Deloitte, EY Medium Practical Normal
84 How do you implement drill-down in Tableau? Amazon, Microsoft Medium Practical Most frequent
85 What are dashboard actions in Tableau? Google, Infosys Medium Practical Normal
E. Advanced Topics
86 What are extract filters vs data source filters? Infosys, TCS Medium Theory Most frequent
87 Explain context filters in Tableau. Amazon, Wipro Medium Theory Most frequent
88 How to improve performance of dashboards in Tableau? Microsoft, Infosys Hard Practical Most frequent
89 What are Tableau extensions? Salesforce, Deloitte Medium Theory Normal
90 How to implement row-level security in Tableau? Amazon, EY Medium Practical Most frequent
91 How to schedule extracts in Tableau Server? Infosys, TCS Easy Practical Most frequent
92 Difference between live connection vs extract. Amazon, Google Medium Theory Most frequent
93 What are Tableau Data Roles? Infosys, Capgemini Medium Theory Normal
94 Explain Tableau Hyper engine. Salesforce, Amazon Hard Theory Medium
95 What are incremental extracts in Tableau? Microsoft, Infosys Medium Practical Normal
F. Business Scenarios
96 Create sales vs target dashboard in Tableau. Amazon, Flipkart Medium Practical Most frequent
97 Build a churn prediction dashboard using Tableau. Netflix, Amazon Hard Practical Medium
98 Create a supply chain dashboard with lead time KPIs. Flipkart, Deloitte Hard Practical Medium