Data Analyst @ Wipro | SQL | Python | Excel | Power BI | Specialized in Data Visualisation and Data Analytics
📌Power BI Technical Questions asked in LTIMindtree 📌 Explain the concept of bi-directional cross-filtering in Power BI. What are its implications on performance and when should it be used or avoided? 0️⃣ Describe the process of implementing row-level security in Power BI. How does this change when using DirectQuery vs. Import mode? 1️⃣ How would you handle slowly changing dimensions in Power BI? Discuss both Type 1 and Type 2 SCDs? 2️⃣ Explain the differences between calculated columns and measures in DAX. Provide scenarios where you would use each? 3️⃣ How can you implement many-to-many relationships in Power BI? Discuss different approaches and their pros and cons? 4️⃣ Describe the EARLIER and EARLIEST functions in DAX. Provide examples of when you would use each? 5️⃣ How would you approach creating a dynamic TopN report in Power BI without using parameters? 6️⃣ Explain the concept of evaluation contexts in DAX (row context vs. filter context). How do these affect calculation results? 7️⃣ Discuss the differences between Import mode, DirectQuery mode, and Composite mode in Power BI. When would you choose each? Microsoft Fabric Questions: 8️⃣ What is Microsoft Fabric and how does it relate to Power BI? 9️⃣ Explain the concept of a lakehouse in Microsoft Fabric. How does it differ from traditional data warehouses? 1️⃣0️⃣ Describe the process of setting up a dataflow in Microsoft Fabric. How does this differ from Power BI dataflows? 1️⃣1️⃣ How can you use Spark in Microsoft Fabric for data processing? Provide an example scenario? 1️⃣2️⃣ Explain the concept of DirectLake in Microsoft Fabric. How does it impact Power BI report performance? Follow Saddam Hussain for more.... #SQL #Python #Excel #DataScience #Upskill #DataAnalyst #Powerbi #interview #DataAnalysis #Data #Excel #R #dataanalystjobs
