Power BI Questions Data Modeling: Question: Explain the difference between a relationship and a join in Power BI. My Answer: In Power BI, a relationship defines how tables are related to each other using primary and foreign keys, whereas a join is used to combine data from multiple tables based on a related column. DAX Functions: Question: How do you create a calculated column and measure in Power BI? Give an example. My Answer: A calculated column is created using the 'New Column' feature in Power BI and is computed row by row. For instance, Total Sales = Sales[Quantity] * Sales[Price]. A measure, on the other hand, is created using the 'New Measure' feature and is calculated on the fly, such as Total Sales = SUM(Sales[Quantity] * Sales[Price]). Visualizations: Question: Describe a scenario where you would use a clustered column chart over a stacked column chart. My Answer: A clustered column chart is useful when you need to compare multiple categories across different series side by side, whereas a stacked column chart is better for showing the part-to-whole relationships within each category. Power Query: Question: How do you handle data cleaning and transformation in Power BI using Power Query? My Answer: In Power Query, data cleaning and transformation are handled using various steps like removing duplicates, filtering rows, splitting columns, merging queries, and applying transformations such as changing data types or creating custom columns. Excel Questions Formulas and Functions: Question: How do you use VLOOKUP and what are its limitations? My Answer: VLOOKUP is used to search for a value in the first column of a table and return a value in the same row from a specified column. Its limitations include not being able to search from right to left and issues with performance when handling large datasets. Pivot Tables: Question: Explain how you would use a pivot table to analyze sales data. My Answer: A pivot table can be used to summarize and analyze sales data by dragging fields into the rows, columns, values, and filters areas. For instance, to analyze total sales by region and product, you would place 'Region' in rows, 'Product' in columns, and 'Sales Amount' in values. Data Visualization: Question: What are sparklines and how would you use them in a report? My Answer: Sparklines are tiny charts embedded in a cell that provide a visual representation of data trends. They are useful in reports for showing trends over time without taking up much space, such as displaying monthly sales trends next to the total sales value for each product. Advanced Functions: Question: How do you use the INDEX and MATCH functions together? My Answer: INDEX and MATCH functions are used together to perform a more flexible lookup than VLOOKUP. MATCH finds the position of a value in a column or row, and INDEX returns the value at that position in another column or row. For example, =INDEX(B2:B10, MATCH("Product", A2:A10, 0)) returns the value in column B where "Product" is found in column A.