Power BI developer interview questions in #INFOSYS

 Power BI developer interview questions in

INFOSYS

SQL:

1. What is difference between primery key and unique key?

2. What are constraints in SQL?

3.Write SQL query to find distinct cust ID with descending insert dates from table Sales with columns custID, invoice_date,sales, insert_date

4. Write SQL query to find duplicates.

5.Write SQL query to find customers with no orders from Table customer and order.

6. What are different commands used in SQL

7.Which command is used to update record and alter record

8. What is difference between truncate and drop?

Power BI:

1.What are connectivity modes?

2. What are gateways?

3.What is RLS....If HR Dept cant see some of department data how to resolve it?

4. What is schedule refresh?

5.How to optimize power BI report?

6. Which DAX functions are used?

7.What is difference between related and relatedtable?

8. What is difference between Rank and RankX?

9. What kind of transformations have been used?

10. What is difference between report and dashboard.

11. Which connectivity mode is used?

12.What will do if DAX function shows error?

13. Which visuals are used for conditional formatting.

14.How many types of relationship are in power BI.How to deal with inactive relationship.

15. What is cardinality?

16. What is diffrence between inner and outer joins

17.Which custom visuals u have used?

18. What is difference between star schema and snowflake schema?
19. When snowflake schema is used?

Comments

Post a Comment

Popular posts from this blog

PYTHON Interview Questions

 Q 1. What is Python?  Python is a high-level, interpreted programming language known for its readability and simplicity. It emphasizes code readability and allows developers to express concepts in fewer lines of code. Q 2. How do you comment out multiple lines of code in Python? You can use triple-quoted strings as a multi-line comment.  Q 3. Explain the difference between a list and a tuple. Lists are mutable (can be modified), while tuples are immutable (cannot be modified). Lists are defined using square brackets [], and tuples use parentheses (). Q 4. What is the purpose of the if __name__ == "__main__": statement? It allows you to execute a block of code only if the script is run directly and not imported as a module into another script. Q 5. How is memory management handled in Python? Python uses an automatic memory management system with a built-in garbage collector that handles memory allocation and deallocation. Q 6. Explain the concept of a decorator in Python....
Read more

𝐂𝐨𝐦𝐩𝐚𝐧𝐲 𝐖𝐢𝐬𝐞 𝐒𝐐𝐋 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬

  𝐂𝐨𝐦𝐩𝐚𝐧𝐲 𝐖𝐢𝐬𝐞 𝐒𝐐𝐋 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬 Here , I have listed out all SQL interview questions for your easy reference. 1. Amazon SQL Interview Question for Data Analyst Position [2-3 Year Of Experience ] | Data Analytics https://lnkd.in/g2RzsKdq 2. Airbnb SQL Interview Question | Convert Comma Separated Values into Rows | Data Analytics https://lnkd.in/gpMbU-dF 3. Adobe Interesting SQL Interview Question | Solving Using 2 Approaches | Data Analytics https://lnkd.in/g_-_9ymd 4. Spotify SQL Interview Problem | Top 5 Artists | Aggregation and Window Functions in SQL https://lnkd.in/gtfaugd3 5. L&T Technology Services SQL Interview Problem | Print Highest and Lowest Salary Employees in Each Department https://lnkd.in/ggY82FJW 6. Ameriprise Financial Services, LLC SQL Interview Problem | Data Analytics https://lnkd.in/gS_Yqq6c 7. Tiger Analytics SQL Interview Question for Data Engineering Position https://lnkd.in/ghjE_CXp 8. PwC SQL Inter...
Read more

Information about scheduling tools & Databricks

 Topics Covered: ●What is Apache Airflow? ●Features of Apache Airflow ●Components of Apache Airflow ●What is Databricks? ●What is Data Lakes? ●Features of a Data Lake ●Differences between a Data Lake and Data Warehouse ●Applications of Databricks What is Apache Airflow? ●Automation of work plays a key role in any industry and it is one of the quickest ways to reach functional efficiency. ●Most of us have to deal with different work flows like collecting data from multiple databases, preprocessing it, uploading it, and reporting it. ●Consequently, it would be great if our daily tasks just automatically trigger on defined time, and all the processes get executed in order. This is where Apache Airflow comes into picture. ●Apache Air flow is an open-source platform for developing, scheduling, and monitoring batch-oriented workflows ●Airflow’s extensible Python frame work enables you to build workflows connecting with virtually any technology. ●A web interface helps manage the state of ...
Read more