Power BI Questions et reponses d'entretien
Question 16. How do you create a hierarchy in Power BI?
To create a hierarchy in Power BI, you can drag and drop related fields onto each other in the Fields pane. For example, you can create a date hierarchy by dragging the Year, Quarter, and Month fields onto the axis in a visual.
Question 17. What is the role of Power BI Dataflows?
Power BI Dataflows allow users to extract, transform, and load (ETL) data into a Power BI dataset. It provides a way to centrally manage and reuse data preparation steps across multiple reports and dashboards.
Question 18. How can you implement time intelligence in Power BI?
Time intelligence in Power BI involves using DAX functions to analyze and compare data over time. Functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN are commonly used for time-based calculations.
Question 19. What is the purpose of the 'Card' visual in Power BI?
The 'Card' visual in Power BI is used to display a single, key data point. It is often used to show a summary or a key performance indicator (KPI) in a concise and easily readable format.
Question 20. How can you handle errors in Power Query?
In Power Query, errors can be handled using the 'try...otherwise' construct. This allows you to specify alternate values or actions when an error occurs during data transformation.
Les plus utiles selon les utilisateurs :