Interviewer: What is a tile in Power BI?
You: In Power BI, a tile is a visual representation of a report element that you can pin to a dashboard. It's essentially a snapshot of a visual, table, chart, or other report element that provides a quick overview of key insights. Tiles allow users to access important information at a glance without having to navigate through the entire report.
Interviewer: Can you describe your daily routine as a Power BI developer?
You: Certainly! My typical day involves a combination of tasks. I start by reviewing any new requirements or changes from stakeholders. I then work on data modeling, transforming and cleaning data using Power Query, and creating visuals in Power BI Desktop. Once the visuals are ready, I create reports, add interactivity, and create calculated measures using DAX. Finally, I publish the reports to Power BI Service, where I fine-tune dashboards, ensure data refresh, and collaborate with team members.
Interviewer: What have you worked on with Power Pivot?
You: In Power Pivot, I've primarily focused on creating data models within Excel workbooks and Power BI Desktop. I've used Power Pivot to combine multiple data sources, define relationships, and create calculated columns and measures using DAX. This has allowed me to build interactive reports and dashboards that offer in-depth insights to end-users.
Interviewer: What is a query context in Power BI?
You: A query context in Power BI refers to the subset of data that is temporarily filtered or modified based on the interactions and selections made by users. It's essential in calculating measures accurately using DAX, as DAX expressions take into account the current row's context within visuals. This context includes filters, slicers, and selections applied to the visual or report.
Interviewer: How do we refresh a dashboard in Power BI?
You: To refresh a dashboard in Power BI, you would typically need to refresh the underlying dataset or data source. This involves going to Power BI Service, opening the respective dataset, and initiating a manual refresh. Once the data refresh is complete, the visuals and reports within the dashboard will reflect the updated data.
Interviewer: Can we refresh a dashboard automatically? You: Yes, we can set up automatic data refresh for a dashboard in Power BI Service. This ensures that the data displayed in the dashboard is always up-to-date without manual intervention. However, automatic refresh depends on data source connectivity, permissions, and the refresh schedule you configure.
Interviewer: How do you schedule a dashboard refresh?
You: To schedule a dashboard refresh, you can navigate to Power BI Service, open the dataset associated with the dashboard, and set up a refresh schedule. This involves specifying the frequency (daily, weekly, etc.) and time for the refresh to occur. Keep in mind that the availability of refresh options might depend on your Power BI licensing and connectivity to data sources.
Interviewer: How many data types have you worked with in Power BI?
You: I have experience working with a wide range of data types in Power BI, including numerical, text, date/time, boolean, and hierarchical data types. Additionally, I've worked with custom data types created using Power Query's "Add Custom Column" feature to enrich data during the transformation process.
