Power BI Interview Questions & Answers 2025

1

What do we understand by Power BI services?

Reference answer

Power BI provides services for its cloud-based business analytics. With these services, you can view and share reports via the Power BI website. Power BI is a web-based service for sharing reports. Power BI service can be best referred to as PowerBI.com, PowerBI workspace, PowerBI site, or PowerBI portal.

2

What are the main differences between self-service BI and managed enterprise BI?

Reference answer

The main differences between self-service BI and managed enterprise BI are as follows: Self-service BI facilitates ordered data incorporation, whereas managed BI makes it challenging to analyze data due to time constraints With self-service BI, companies don't need to communicate through third-party sellers, whereas managed BI requires interactions with third-party sellers to fully benefit from their data sources Although self-service BI doesn't require in-depth coding abilities, managed BI users must have the right coding skills to produce reports

3

What is DAX?

Reference answer

DAX, or Data Analysis Expressions, is a formula language used in Power BI, Excel Power Pivot, and SQL Server Analysis Services for data modeling and calculations. - Purpose: DAX is designed to perform data analysis and create complex calculations. It is used to create calculated columns, measures, and custom tables within Power BI. - Syntax: Similar to Excel formulas but more powerful. DAX allows operations like aggregations, filtering, and conditional logic on related tables or relational data. - Functions: DAX includes functions for math, statistics, logic, text, and time intelligence, helping you manipulate data and gain insights. ? DAX (Data Analysis Expressions) is a powerful formula language in Power BI for data modeling and creating complex calculations.

4

How do you embed views into webpages?

Reference answer

You can easily integrate interactive views from your Tableau Server or Tableau online onto webpages, blogs, web applications, or internet portals. But to have a look at the views, the permissions demand the viewer to create an account on the Tableau Server. To embed views, click the Share button on the top of the view and copy the embed code to paste it on the web page. You can also customize the embedded code or Tableau Javascript APIs to embed views.

5

What is Power Map?

Reference answer

Power Map is an Excel add-in that provides you with a powerful set of tools to help you visualize and gain insight into large sets of data that have a geo-coded component. It can help you produce 3D visualizations by plotting upto a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time stamped, it can also produce interactive views that display, how the data changes over space and time.

6

How do you automate Power BI reports?

Reference answer

- Power Automate: Used for scheduling report refreshes and notifications. - Scheduled Refresh: Set in Power BI Service to update data at specific intervals. - REST API: Automates data import/export and report generation.

7

What is Power Query?

Reference answer

The Power Query business intelligence tool was built by Microsoft, enabling users to import, clean, and transform data. All that's required is for you to write a query and, once written, run it. Its main benefit is that you can import data from various sources.

8

How do you flag outliers in Profit?

Reference answer

Use a calculated field with standard deviation: IF [Profit] > (AVG([Profit]) + 2*STDEV([Profit])) THEN "High Outlier" ELSEIF [Profit] < (AVG([Profit]) - 2*STDEV([Profit])) THEN "Low Outlier" ELSE "Normal" END This flags customers present across multiple years.

9

What are the critical components of the Power BI toolkit?

Reference answer

The most important components of PowerBI are: Power Query Power View Power Pivot Power Map Power Q&A Power Desktop Power Website PowerBI Mobile App

10

Have you ever trained someone on how to use Tableau? How did you approach the training process and ensure that they gained a solid understanding of the software?

Reference answer

Yes, I have trained a few colleagues on how to use Tableau in the past. When approaching the training process, my first priority was to determine their existing knowledge and experience with data visualization tools and their learning preferences. I believe that understanding someone's starting point and how they best learn is crucial to providing effective training. Once I had an understanding of their background, I tailored my training approach to fit their needs. I began with explaining basic concepts, such as Tableau's interface, data connection, and basic functionality. To ensure they had a solid understanding of these concepts, I used a combination of hands-on exercises, real-life examples, and visual aids to illustrate the key points. As we progressed, I moved on to more advanced features of the software, such as calculated fields, table calculations, and dashboard design. To help them retain the information, I encouraged practical application of these concepts through small projects that were relevant to their job responsibilities. This allowed them to see the immediate value of their new skills and helped to solidify their understanding of Tableau. Throughout the training process, I made sure to check in regularly and ask for feedback on their progress, adjusting my approach as needed. By being flexible and adapting to their learning style, I was able to effectively teach them how to use Tableau and ensure they had the skills required to excel in their roles.

11

What kind of KPIs have you created in past dashboards and how?

Reference answer

I created KPIs like revenue growth, customer churn rate, and inventory turnover. I used DAX measures with CALCULATE, DIVIDE, and time intelligence functions, and visualized them with KPI visuals and conditional formatting.

12

How do you handle performance issues in Tableau dashboards?

Reference answer

To handle performance issues in Tableau dashboards, I optimize data extracts and reduce data volume where possible. I also use efficient calculations and regularly monitor and tune the dashboard's performance to ensure it runs smoothly.

13

Does a context filter slow down performance?

Reference answer

Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time the view is triggered. So, if the context filter will be changed, the database needs to recompute and rewrite the temp table, which in turn slows down the performance.

14

What are the connectivity modes and refresh options in Power BI?

Reference answer

Power BI supports multiple connectivity modes and offers several refresh options, providing flexibility in how your data is updated and displayed. Connectivity Modes: - Import mode: Data is imported into Power BI's memory and refreshed based on your settings. Ideal for small to medium-sized datasets that do not require real-time updates - DirectQuery mode: Directly queries the data source for real-time updates. Suitable for large datasets where it's impractical to import all data Refresh Options: - Manual refresh: Manually refresh data by clicking on the 'Refresh Now' button - Scheduled refresh: Set up a schedule to refresh your data at specific intervals - Automatic page refresh (APR): Automatically refreshes the data on your report page based on a set time interval Choosing the appropriate connectivity mode and refresh option ensures your data is up-to-date and displayed correctly, improving the reliability of your reports.

15

Mention what is the difference between published data sources and embedded data sources in Tableau?

Reference answer

The difference between published data source and embedded data source is that, Published data source: It contains connection information that is independent of any workbook and can be used by multiple workbooks. Embedded data source: It contains connection information and is associated with a workbook.

16

What are the advantages of Power BI?

Reference answer

Here are the main advantages of Power BI Power BI integrates well with the existing application It contains rich and personalized Dashboards. publishing reports in a secure way Quick accessibility to data means there is no speed and memory issue

17

How do you handle a situation where stakeholders want different versions of the same report?

Reference answer

I create a single semantic model and use row-level security or report-level filters to tailor views. Alternatively, I use bookmarks and selection panes to toggle between versions within one report, reducing maintenance overhead.

18

What are Virtual Tables in DAX?

Reference answer

Tables created in memory during calculation — not physical.

19

What is a Semantic Model?

Reference answer

A semantic model in Power BI, previously known as a dataset, is the organized structure of underlying data used to build reports and dashboards. It includes tables, relationships, hierarchies, RLS (Row-Level Security) rules, measures, and other calculations. ? A semantic model in Power BI organizes all underlying data, including tables and calculations, used to build reports and dashboards.

20

Who typically uses Power BI?

Reference answer

In addition to business owners, Power BI is also used by business developers and business analysts. Whereas business analysts analyze the data of a business and create graphs to present it, business owners view and examine the data using Power BI. In contrast, business developers help develop applications by incorporating data into different apps.

21

What is Power BI Designer?

Reference answer

It is a stand alone application where we can make Power BI reports and then upload it to Powerbi.com, it does not require Excel. Actually, it is a combination of Power Query, Power Pivot, and Power View.

22

Explain how to schedule dataset refreshes from Azure Blob Storage.

Reference answer

In Power BI Service, go to dataset settings and enable scheduled refresh. Set the frequency and time. Ensure the gateway is configured if Blob Storage is on-premises, or use cloud credentials.

23

What is a Role enjoying Dimension?

Reference answer

Role enjoying Dimension: If one dimension is employed in multiple roles, then they are termed as Role enjoying Dimensions. Example – Date for e-commerce site order (Date of Order, Date of Shipment, Date of delivery)

24

Think that I am using Tableau Desktop & have a live connection to Cloudera Hadoop data. I need to press F5 to refresh the visualization. Is there anyway to automatically refresh visualization every 'x' seconds instead of pressing F5?

Reference answer

Here is an example of refreshing the dashboard for every 5 seconds. All you need to do is replace the api src and server url with yours. Tableau JavaScript API

25

What are the various Power BI versions?

Reference answer

The three major versions of Power BI are as follows: Power BI Desktop: The free interactive tool that connects multiple data sources, transforms data, and creates visualized reports. Power BI Premium: The premium version is used for larger organizations with a dedicated storage capacity for each user. With premium, data sets up to 50GB storage capacity can be hosted along with 100TB storage on the cloud as a whole. It costs $4995 per month. Power BI Pro: With the pro version, you get full access to the Power BI dashboard, creation of reports, along with unlimited sharing and viewing of reports. You also have a storage limit of 10GB per user

26

What do Quick Filters in Tableau do?

Reference answer

Each worksheet on a dashboard can be filtered using global fast filters so that each one has a dimension. They are especially helpful for workbooks that use the same data source, which can often be challenging and produce slower results.

27

How can you join tables in SQL, and what are the common types of joins used in Power BI?

Reference answer

Joining tables in SQL is a fundamental skill that enables you to combine data from two or more tables based on a related column between them. It correctly ensures that you can effectively combine and analyze related data from multiple sources, providing comprehensive insights. This is particularly important in Power BI, where data from various sources is often brought together for analysis and visualization. SQL supports several types of joins, each serving different purposes and use cases. Common Types of Joins: - INNER JOIN: Returns rows when there is a match in both tables. It is used when you want to include only the records that have corresponding entries in both tables - LEFT JOIN (or LEFT OUTER JOIN): Returns all rows from the left table and the matched rows from the right table. If there is no match, the result is NULL on the side of the right table. It is used when you want to include all records from the left table regardless of whether there are matching records in the right table - RIGHT JOIN (or RIGHT OUTER JOIN): Returns all rows from the right table and the matched rows from the left table. If there is no match, the result is NULL on the side of the left table. It is used when you want to include all records from the right table regardless of whether there are matching records in the left table - FULL JOIN (or FULL OUTER JOIN): Returns rows when there is a match in one of the tables. It includes all records from both tables, with NULLs in place where the join condition is not met The choice of which type of join to use depends on the specific requirements of your query and the relationships between the tables. Making the correct choice is critical to ensure the completeness and accuracy of your query results. For example If you need to ensure that all records from the primary table are included regardless of whether they match the secondary table, a LEFT JOIN would be appropriate.

28

How do you import data into Power BI from Excel?

Reference answer

Click on “Get Data” in Power BI Desktop, select “Excel,” then choose your file. After that, you can load the data directly or edit it in Power Query first.

29

What is query folding in Power BI?

Reference answer

Query folding is used when steps defined in the Query Editor are translated into SQL and executed by the source database instead of your device. It helps with scalability and efficient processing.

30

Build a chart showing the top five and bottom five sales by customer

Reference answer

Let's first build a calculated field by entering the following expression: IF RANK(SUM([Sales]), 'desc') <= 5 THEN 'Top 5' ELSEIF RANK(SUM([Sales]), 'asc') <= 5 THEN 'Bottom 5' ELSE NULL END Next, we'll drag the new field to the Filters shelf and select 'Top 5' and 'Bottom 5' only. Drag the field to the Rows shelf too. Now, let's add the Customer Name to the Rows shelf and the Sales field over the Text label. You're done!

31

What is a calculated field and How do we create it in Tableau?

Reference answer

A calculated field in Tableau is a user-defined field created by applying a formula or calculation to existing fields in your dataset. It can involve mathematical, string, logical or date operations to generate new insights, measurements or aggregations that are not available in the original data. Calculated fields are useful for deriving custom metrics, creating new dimensions or modifying existing data, giving you more flexibility in analysis and visualization. They can be used across worksheets, dashboards and reports. Steps to Create a Calculated Field in Tableau: - Open the data source or the Tableau worksheet. - Right-click anywhere in the "data" window on the left and select "Create Calculated Field". - Use fields, functions and operators in the calculated field editor to create your own calculations. - To save the calculated field, select "OK".

32

We have a situation with one source and multiple destinations. This data represents the one-way traveling of drones from a source taking an item for delivery from the warehouse. We have the data, and we want to visualize it. Which Tableau map will you use to represent such a situation?

Reference answer

A spider map best fits this scenario. Spider maps can represent situations when we have to work with hubs connecting multiple data points having different routes.

33

Can you describe a project where you used advanced Tableau calculations or custom SQL to solve a business problem? What was your process for determining the best approach?

Reference answer

One of my favorite projects was when I used advanced Tableau calculations and custom SQL to help improve the efficiency of a sales team at my previous company. The business problem was that the sales team was spending too much time manually analyzing their sales performance and not enough time on selling. My first step was to discuss with the sales team and understand their current process and the pain points. I then explored the available data and identified key performance indicators that would be useful for the sales team to monitor. After analyzing the data, I realized that some of the calculations required were quite complex, such as calculating sales efficiency, conversion rates, and average deal sizes, and would require the use of advanced Tableau calculations. I considered a few alternatives, like using Tableau's built-in functions or creating calculated fields in the data source itself, but I eventually decided that using custom SQL would be the best approach to solve the problem. There were two main reasons for this decision: First, the custom SQL allowed me to perform complex calculations and aggregations at the data source level, which made the resulting visualizations more efficient. Second, it made it easier to maintain and update the calculations since they were centralized in the data source. To implement this solution, I first wrote custom SQL queries to calculate the necessary metrics and tested them thoroughly to ensure accuracy. Then, I built interactive Tableau dashboards that presented the data in a user-friendly manner, allowing the sales team to easily track their performance and identify areas for improvement. The sales team was delighted with the new dashboards, as it saved them considerable time and made their analysis more data-driven, ultimately leading to more informed decision-making and better sales performance.

34

Why and how would you use a custom visual file?

Reference answer

A custom visual file is used when none of the pre existing visuals fit the business needs. Custom visual files are generally created by Developers which can be used in the same way as prepackaged files.

35

What are content packs in Power BI?

Reference answer

Content packs for services are pre-built solutions for popular services as part of the Power BI experience. A subscriber to a supported service, can quickly connect to their account from Power BI to see their data through live dashboards and interactive reports that have been pre-built for them. Microsoft has released content packs for popular services such as Salesforce.com, Marketo, Adobe Analytics, Azure Mobile Engagement, CircuitID, comScore Digital Analytix, Quickbooks Online, SQL Sentry and tyGraph.

36

Can you describe a Power BI project you've worked on and your role in it?

Reference answer

I worked on a sales dashboard for a retail client. My role included data extraction from SQL Server, building a star schema model, creating DAX measures for KPIs like YTD sales and gross margin, and designing interactive reports with slicers and drill-through pages.

37

What is the need for signing up with a work email?

Reference answer

Power BI does not have email addresses provided by telecommunications providers and consumer email services, thus there is a need of signing up with work email.

38

What are Power BI visuals, and how do you customize them?

Reference answer

Power BI visuals are graphical representations of data in reports and dashboards. Users can create standard visuals like bar charts, line graphs, pie charts, and custom visuals using third-party tools or custom scripts. Customization includes formatting, colors, labels, and interactions.

39

Difference Between Visual, Report and Dashboard in Power BI

Reference answer

| Aspect | Visual | Report | Dashboard | |---|---|---|---| | Definition | A single chart, graph or tile representing data. | A collection of multiple visuals on one or more pages. | A single-page view that pins visuals from one or more reports. | | Purpose | Display one data insight. | Analyze data in detail with multiple visuals. | Monitor key metrics and KPIs at a glance. | | Interactivity | Can be filtered, sliced or highlighted individually. | Fully interactive with slicers, filters and drill-through. | Limited interactivity and mostly view-only. | | Creation | Created directly in Power BI Desktop. | Created in Power BI Desktop with multiple visuals. | Created in Power BI Service by pinning report visuals. | | Share | Cannot export individually. | Can be exported as PDF or PowerPoint. | Can share dashboard links or embed in apps. |

40

What are Power BI Apps and how are they used for report sharing?

Reference answer

Power BI Apps bundle dashboards, reports, and datasets into a single package. They are published to a workspace and shared with users or groups. Apps provide a focused view and simplify distribution.

41

How do you display the top 5 and bottom 5 customers by sales in Tableau?

Reference answer

Ok, I will first create a field by using the following expression: IF RANK(SUM([Sales]), 'desc') <= 5 THEN 'Top 5' ELSEIF RANK (SUM[Sales]),'asc') <= 5 THEM 'Bottom 5' ELSE NULL END | Next, I drag the newly created field to the Filters shelf and choose only the 'Top 5' and 'Bottom 5' options. After that, I place the same field onto the Rows shelf. Then, I add Customer Name to the Rows shelf as well, and drag the Sales field onto the Text label to display the values. That completes the setup.

42

What are the different views in the Power BI Desktop?

Reference answer

Power BI Desktop has three main views, each designed for a specific task: - Report View: This is the default workspace, where you actually build your visualizations and interactive reports. It's where most users spend the majority of their time, designing visuals, formatting reports, and getting everything ready to publish. - Data View: Here, you can see your data clearly organized into tables. It's useful for performing data transformations, reviewing the data you've imported, and creating calculated columns or measures using the DAX language. - Model View (also called Relationship View): In this view, you manage how your data tables relate to each other. You can set or adjust relationships between different tables, helping ensure your data model works correctly and efficiently supports your visualizations.

43

How can you find the Top 5 products by Sales in Tableau?

Reference answer

We can display only the top 5 products based on sales using: - Drag Product Name to Rows and Sales to Columns. - Right-click on Product Name → Filter → Top Tab. - Choose Top 5 by Sales (Sum). This will display only the top 5 products.

44

How to Remove Null and Duplicate Values in Power BI

Reference answer

1. Removing Null Values: - Go to Power Query Editor. - Select the column(s) where you want to remove nulls. - From the Home tab → Remove Rows → Remove Blank Rows. Example: If a CustomerID column has null values, they will be removed. 2. Removing Duplicate Values: - In Power Query Editor, select the column(s) where duplicates may exist. - From the Home tab → Remove Rows → Remove Duplicates. Example: If the Sales table has duplicate OrderID, selecting OrderID and removing duplicates will keep only unique orders.

45

Can we automate Tableau Reports? If yes, how?

Reference answer

Yes, we can automate reports in Tableau. First, we must publish/release the Tableau report to the tableau server. When publishing, there will be an option to schedule reports. In that section, we have to specify when to refresh the data.

46

Describe the distinctions between Power BI Service and Power BI Desktop.

Reference answer

While Power BI Service is a cloud-based platform for sharing, collaborating, and publishing reports and dashboards, Power BI Desktop is a Windows-based tool for creating reports and data models. Developers and web analysts are the main users of Power BI Desktop, while end users access and work with the reports through Power BI Service.

47

Describe a time you solved a data inconsistency issue in Power BI.

Reference answer

I encountered mismatched date formats between Excel and SQL Server. I used Power Query to standardize dates and created a unified date table. This resolved aggregation errors and improved report accuracy.

48

How is Power BI different from Excel?

Reference answer

Power BI offers interactive dashboards, real-time updates, advanced visualizations, and scalability, unlike Excel's static reports.

49

Explain the difference between CALCULATE and CALCULATETABLE.

Reference answer

CALCULATE modifies filter context and returns a scalar value. CALCULATETABLE modifies filter context and returns a table. Both are used for dynamic filtering in DAX.

50

What is bi-directional cross-filtering?

Reference answer

Bi-directional cross-filtering is a feature that allows filters to flow in both directions between related tables. This provides more control over how data is filtered and can simplify the model by reducing the need for complex DAX formulas. This feature enhances data model flexibility and accuracy, enabling more comprehensive analysis.

51

Why is the ‘Get Data' icon used in Power BI?

Reference answer

The ‘Get Data' icon is used to see significant data sources. In simple language, when you click on the ‘Get Data' icon, a drop-down menu will appear and show all the data sources from which you have ingested data. Data can be ingested from any source file like Excel, CSV, XML, JSON, PDF, or SharePoint. Usually, databases for such data files are SQL, Access, SQL Server analysis services, IBM, MySQL, or Oracle. Power BI datasets and data flows should be compatible with each other.

52

What is a line chart in Tableau?

Reference answer

The line chart is a popular type of diagrammatic way for visualizing the data, it connects the individual data points to view the data. We can easily visualize the series of values, we can see trends over time or predict future values. The horizontal axis holds the category to which it belongs and the vertical axis holds the values.

53

How to install tableau?

Reference answer

To install tableau on your system you need to download the installation file from: https://www.tableau.com/support/releases. Select the required type from left pane that is Desktop, Prep, Online, Server and Mobile. Once the installation file is downloaded just install the product on your system by following the steps and please note that tableau desktop comes with a trial period of 14 days for that you need to register using your email id and rest all the types of Tableau are paid and mostly used in industry. You can also go for the tableau public which is an open source tableau tool with lifetime validity. For using Tableau Public visit: https://public.tableau.com/en-us/s/download and enter your email id then click on download the app. The download will begin itself and after the download is completed install the file on your system and sign up using the same email id you used for downloading the file. The drawback for using tableau public is that you cannot save the file on local system you can only save on tableau public's online server and hence making it visible to anyone with the link and giving them the authority to download your work.

54

How do you create a dynamic measure for multiple categories?

Reference answer

Use DAX functions like SWITCH() or IF() combined with slicers for dynamic calculation.

55

Tell me about a challenging Tableau project you worked on and how you overcame obstacles.

Reference answer

At Wipro, I worked on a project to create a dashboard for sales performance analysis using complex data from multiple sources. One challenge was ensuring data accuracy due to discrepancies in source systems. I collaborated with the data engineering team to implement a data cleaning process and used Tableau's blending features to merge data effectively. The final dashboard provided actionable insights, leading to a 15% increase in sales performance within a quarter.

56

How do you manage user roles and permissions in Power BI Service?

Reference answer

Roles are set up in Power BI Desktop using RLS rules. After publishing, I assign users to these roles through the workspace settings in Power BI Service.

57

What is Tableau Data Server?

Reference answer

Tableau server acts a middle man between Tableau users and the data. Tableau Data Server allows you to upload and share data extracts, preserve database connections, as well as reuse calculations and field metadata. This means any changes you make to the data-set, calculated fields, parameters, aliases, or definitions, can be saved and shared with others, allowing for a secure, centrally managed and standardized dataset. Additionally, you can leverage your server's resources to run queries on extracts without having to first transfer them to your local machine.

58

How can you define relationships between tables in Power BI?

Reference answer

There are two options for defining relationships between tables in Power BI. Users can define relationships manually by using foreign and manual key features, or they can also define relationships automatically. In terms of the active relationships between tables, only one is possible for Power Pivot data models, represented by continuous (not broken) lines. For inactive relationships, you can have several of them, which are characterized by dotted lines.

59

What is a dual axis?

Reference answer

A dual axis in Tableau is a technique used to combine two separate visualizations on a single axis. It allows users to compare two measures or sets of data with different scales or units of measurement. Start by adding 2 different measures in the same row, either the Rows or the Columns section. Right-click into the second measure and select Dual Axis. You'll now see the measures plotted on the same chart but with two different axes.

60

What are Power BI Dataflows, and how do they differ from datasets?

Reference answer

Power BI Dataflows are a collection of data transformations and entities stored in the Power BI service. Dataflows allow for data reuse and ETL processes across multiple reports and workspaces. Unlike datasets, dataflows focus on data preparation and can be used as a data source for multiple datasets.

61

Difference between Power BI and Tableau?

Reference answer

The major differences between Power BI and Tableau are: While Power BI uses DAX for calculating columns of a table, Tableau uses MDX (Multidimensional Expressions). Tableau is more efficient as it can handle a large chunk of data while Power BI can handle only a limited amount. Tableau is more challenging to use than Power BI

62

What is a Stacked Bar chart?

Reference answer

A stacked bar chart is a type of data visualization that represents data using horizontal or vertical bars, where each bar is divided into segments or stacked sections to show the contribution of different categories or subgroups to the total value. Key features of a stacked bar chart: Segments (Stacks): The primary feature of a stacked bar chart is the segments or stacks within each bar. Each segment represents a specific category or subgroup, and the length or height of the segment corresponds to the value of that category. Total Value: The total height (for vertical bars) or width (for horizontal bars) of the bar represents the total value, which is the sum of the values of all segments. Categorical Data: Stacked bar charts are suitable for visualizing categorical data with multiple subcategories. Comparison of Proportions: Stacked bar charts are useful for comparing the proportions of different subcategories within each category. Color Encoding: Each segment in the stacked bar chart is typically assigned a different color to visually differentiate between the subcategories. Axis Labels and Titles: Stacked bar charts come with axis labels and titles to provide context and explanation for the data being visualized. Stacked bar charts are commonly used to display the composition of data, showing how different subcategories contribute to the whole. They are effective for visualizing data with multiple categories and subgroups, making it easy to identify patterns and comparisons within the data. However, it's important to use stacked bar charts with caution, as they can become visually cluttered and less effective when dealing with large numbers of subcategories or complex data.

63

What is a Report?

Reference answer

The report is a Power BI feature that is a result of visualized data from a single data set. A report can have multiple pages of visualization.

64

Difference Between Row Context and Filter Context in DAX

Reference answer

| Aspect | Row Context | Filter Context | |---|---|---| | Definition | Applies row by row in a table. | Applies filters to a set of data for a calculation. | | How It Works | Each row is treated individually for the calculation. | Only the rows that meet the filter conditions are considered. | | Usage | Used in calculated columns and iterators (e.g., SUMX). | Used in measures, slicers, report filters or CALCULATE function. | | Example | Profit = Sales[Amount] – Sales[Cost] (for each row) | Total Sales for Region = "India" shows sum only for India. |

65

Can you tell me what the difference between Power BI personal Gateway and Data Management Gateway is?

Reference answer

Power BI Personal Gateway is used for reports that are deployed in Powerbi.com. On the other hand, data management is an app that installs the gateway on source data machines to deploy reports on Sharepoint and schedule to refresh automatically.

66

What are Add-ins in Power BI?

Reference answer

Add-ins in Power BI are extra tools or extensions that you can integrate with Power BI to extend its functionality. They allow users to bring in advanced visuals, connect with other applications or use specialized features that aren't available by default. Types of Add-ins: - Custom Visuals: Imported from AppSource or developed by users. It can include heat maps, word clouds, etc. - Office Add-ins: Power BI add-ins available in tools like Excel and PowerPoint to embed or analyze Power BI data. - Third-party Add-ins: External connectors and tools that integrate Power BI with services like Salesforce, Adobe Analytics, etc. Example: - Embedding Power BI reports in PowerPoint using the Power BI add-in. - Importing a Hierarchy Slicer visual from AppSource into Power BI Desktop.

67

Can we create relational joins in Tableau without creating a new table?

Reference answer

Yes, we can create relational joins in Tableau without creating a new table

68

What is the DATEADD function in Tableau?

Reference answer

DATEADD function adds an increment to date and returns a new date. The increment is decided by the data part and interval together. This function can perform several date calculations and operations like building rolling averages, calculating future dates, etc. Let's take an instance of creating a calculated field. The syntax of this function will be as follows: | DATEADD (interval, number, date) |

69

What is the difference between Power BI Mobile and Power BI Desktop?

Reference answer

Power BI Mobile is a mobile application that allows users to view and interact with Power BI reports and dashboards on their mobile devices, while Power BI Desktop is a desktop application that is used to create and publish reports and visualizations.

70

How can you create a custom connector in Power BI?

Reference answer

To create a custom connector in Power BI, you can use the Power Query SDK to build a connector using C# or Visual Basic. Once the connector is built, it can be imported into Power BI and used to connect to a data source.

71

What are the main products of Tableau?

Reference answer

Tableau has 4 main products.

72

What is the difference between a scatter chart and a bubble chart in Power BI?

Reference answer

A scatter chart is a chart that shows the relationship between two variables, while a bubble chart is a chart that shows the relationship between three variables using circles of different sizes. Scatter charts are typically used to show the correlation between two variables, while bubble charts are used to show the correlation between three variables.

73

Explain the use of Level of Detail (LOD) expressions in Tableau.

Reference answer

I used a FIXED LOD to calculate customer lifetime value at the customer level despite visualizing data by month. This kept CLV constant across drill-downs and avoided duplicated sums that would have inflated revenue projections.

74

Explain the difference between ALL() and ALLEXCEPT().

Reference answer

ALL(): Ignores all filters in a table. ALLEXCEPT(): Ignores filters except for specified columns.

75

How do you merge and append queries in Power Query?

Reference answer

Merge combines columns from two tables based on a matching key, similar to SQL joins. Append stacks rows from two or more tables with the same columns. Both are available in the Home tab of Power Query Editor.

76

What data sources we can connect with Tableau?

Reference answer

Various data sources are supported by Tableau such as: - Databases: Relational databases like MySQL, PostgreSQL, etc, NoSQL databases like MongoDB and Cloud-based databases such as Amazon Redshift, snowflake, etc. - Cloud Storage Services: We can Cloud Storage Services like Amazon S3, Google Cloud Storage and Azure Blob Storage - Web Connectors: It provides different web connectors to connect to web-based APIs and services, allowing you to pull data from sources like Google Analytics, Salesforce, JSON, etc. - Statistical and Analytics software: Integration with statistical tools like R and Python to execute advanced analytics and machine learning models. - Data Servers and OLAP cubes: Connection to data servers and OLAP cubes such as Microsoft Analytics Services(SSAS) and SAP HANA. - Excel and Text files: We can directly connect to Microsoft Excel spreadsheets and text files(CSV, TSV) to import data.

77

What do you mean by the content pack?

Reference answer

A content pack is defined as a ready-made collection of visualizations and Power BI reports using your chosen service. You'd use a content pack when you want to get up and running quickly instead of creating a report from scratch.

78

How to calculate percentage in tableau?

Reference answer

To calculate the percentage of data on your worksheet. Go to Analysis pane and select Percentages of, there you will see a lot percentage options such as percentage of table, column, row, pane, row in pane, column in pane and cell. Select any of the above options then define the total value o which percentage is to be calculated. The option you choose will be uniform to all the rows and columns and there is no way to specify different options to rows and columns.

79

What is a dimension vs. a measure in Tableau?

Reference answer

In Tableau, a dimension is a categorical variable that describes data, while a measure is a numerical value that can be aggregated or computed in some way. Dimensions are typically used to group and slice data, while measures are used to calculate and analyze data.

80

Explain about Bidirectional Cross-Filtering in Power BI?

Reference answer

One of the most important features of Power BI is Bidirectional cross-filtering. This feature allows you to apply filters on both sides of a table relationship, using right-to-left and left-to right options for their calculations. Through this, modelers can know how exactly particularrelationships can work in multiple contexts.

81

How do you increase the performance of a slow workbook?

Reference answer

If you are experiencing slow workbook performance in Tableau, there are several strategies you can use to improve performance. - Optimize data sources: One of the main reasons for slow workbook performance in Tableau is a poorly optimized data source. To improve performance, you should ensure that your data source is properly optimized by removing unnecessary joins, filtering out unused fields, and aggregating data at the appropriate level. - Optimize your workbook: Another way to improve performance is to optimize your workbook by simplifying the layout, removing unused fields and sheets, and minimizing the use of complex calculations and visualizations. You should also consider reducing the number of dashboard elements and filters to improve performance. - Use data extracts: Data extracts are pre-aggregated subsets of data that can be used to speed up workbook performance. By using data extracts, you can reduce the amount of data that Tableau needs to process, which can improve performance. - Use filters: Filters can be used to reduce the amount of data that Tableau needs to process, which can improve performance. You can use filters to restrict the data that is displayed in your visualization, or to remove unnecessary data from the view.

82

Are there any limitations to file sizes in Tableau?

Reference answer

In Tableau, there are no limitations to the file sizes. Moreover, there is no row or column limit to import the data.

83

Describe your experience with Power Query and how you use it for data transformation in Power BI.

Reference answer

Look for: Practical experience with Power Query Editor for data cleaning, transformation, and preparation. What to Expect: Examples of using Power Query for tasks like data merging, filtering, pivoting, and creating custom columns to prepare data for analysis.

84

Does Tableau support multi-valued parameters?

Reference answer

Tableau, currently not supporting the multi-valued parameters. As Tableau parameters are not dynamic, we cannot filter the list of values at runtime.

85

What is bi-directional cross-filtering?

Reference answer

Bi-directional cross-filtering is a feature that allows filters to flow in both directions between the tables. This allows more control over data filtration and forms a simple model by reducing the need for DAX formulas.

86

What is “M language.”

Reference answer

M is a programming language used in Power Query as a functional, case-sensitive language similar to other programming languages and easy to use.

87

Which language is used in Power Query?

Reference answer

M-code, officially known as the Power Query Formula Language, is the programming language used in Power Query to facilitate data transformation and manipulation. It is a functional, case-sensitive language designed to be readable and accessible, especially for those new to programming. M-code provides a rich set of features that enable users to import, filter, shape, and combine data from a wide variety of sources.

88

Describe a scenario where you overcame a data analysis challenge using Tableau.

Reference answer

Our e-commerce team suspected mobile-cart abandonment spikes. I blended Google Analytics with checkout logs, used LODs to isolate first-time mobile users, and visualized drop-offs. The insight led to a one-click checkout feature, cutting abandonment by 12% within a month.

89

How will you explain the disaggregation and aggregation of the data in Tableau?

Reference answer

Disaggregation and aggregation are two different modes for developing or creating scatter plots. Developers use these techniques for comparing and measuring data values. Sum, average, median, count, etc., are examples of aggregation functions. In disaggregation, we analyze every data source row both dependently and independently.

90

Where is the fn FILTER() used? How is it diff from ALL(). Write a sample DAX using FILTER()?

Reference answer

FILTER() returns a table filtered by a condition. ALL() returns all rows ignoring filters. Example: CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Amount] > 100))

91

What are the key components of Power BI Desktop?

Reference answer

Power BI Desktop consists of several tools and components that work together to turn raw data into insightful visuals: - Power Query: A self-service ETL tool for extracting, transforming, and loading data from disparate sources. It allows users to perform a wide range of data manipulations, such as filtering, sorting, aggregating, and merging data - Power BI Data Model: Allows you to establish relationships between different datasets, enabling meaningful integration into dashboards, reports, and analysis - DAX (Data Analysis Expressions): A formula language similar to Excel formulas, used for advanced data manipulation and creating powerful calculations - Visualizations: Graphical representations of data, including bar charts, line graphs, scatter plots, pie charts, and custom visuals from the Power BI marketplace Understanding the synergy between Power Query, the Data Model, and DAX is crucial, and so you might be asked how to use these effectively together. If asked how you might use these, a good response could be: "I start by using Power Query to pull data from different sources and perform initial data cleaning and transformation. Then I create relationships between different tables in the Data Model. I define KPIs that incorporate those related datasets with DAX. Finally, I leverage Power BI Desktop to create interactive reports and dashboards from the prepared data, which are then shared with the team for better decision-making."

92

What distinguishes a Power BI column chart from a bar chart?

Reference answer

In a bar chart, values are represented by the length of the horizontal bars that depict the data. In contrast, data is shown as vertical bars in a column chart, where the height of the bars indicates the values. Though data with lengthy category labels or a large number of categories are typically better displayed in bar charts, both types of charts can be used to compare data across categories.

93

What are the different role-based licenses Tableau offers?

Reference answer

Role-based licenses allow a series of capabilities at different price points. Tableau offers three different types of Role-based Licenses. - Viewer: This license allows users to view and communicate with the workbook of the Tableau server. - Creator: This license grants the use of Tableau Desktop plus Tableau Prep-Builder. This license also allows creating and publishing of new workbooks, the editing of embedded data sources, and producing new connections. - Explorer: This license grants access to workbook authoring and collaboration capabilities through a web page or browser.

94

How to create a group in Tableau?

Reference answer

Option 1: We can create the group by using the calculated field. Example: IF [Container]='Jumbo Box' then ‘Big Containers' ELSEIF [Container]='Jumbo Drum' then ‘Big Containers' ELSEIF [Container]='Large Box' then ‘Big Containers' ELSEIF [Container]='Medium Box' then ‘Midsize Containers' ELSEIF [Container]='Wrap Bag' then ‘Midsize Containers' ELSEIF [Container]='Small Box' then ‘Little Containers' ELSEIF [Container]='Small Pack' then ‘Little Containers' END The above calculation creates the group with four values: Little Containers, Big Containers, Small Containers, Midsize Containers. Option 2: Create a set from the group, and use the set in the calculated field. Step 1: Right-click on the Data Pane and then select Create Set. Step 2: Create a set dialogue box that will open, Enter the field name. Select the group, on the general tab. Step 3: Click Ok.

95

Convert a mixed string like 'abc123xyz' to uppercase without using .upper().

Reference answer

Iterate through characters and use ord() to check if it's a lowercase letter, then subtract 32 to convert to uppercase.

96

What are the different views available in Power BI Desktop?

Reference answer

There are three views: - Report View: Design visual reports - Data View: View and inspect tables - Model View: Manage relationships between tables

97

Tell me something about measures and dimensions?

Reference answer

In Tableau, when we connect to a new data source, each field in the data source is either mapped as measures or dimensions. These fields are the columns defined in the data source. Each field is assigned a dataType (integer, string, etc.) and a role (discrete dimension or continuous measure). Measures contain numeric values that are analyzed by a dimension table. Measures are stored in a table that allows storage of multiple records and contains foreign keys referring uniquely to the associated dimension tables. While Dimensions contain qualitative values (name, dates, geographical data) to define comprehensive attributes to categorize, segment, and reveal the data details.

98

How can multiple measures share a single axis?

Reference answer

Multiple measures can share a single axis so that all the marks will be shown in a single pane. We can blend measures by dragging the 1st measure on one axis and the 2nd on the existing axis.

99

How can you create a custom connector in Power BI using ODBC?

Reference answer

To create a custom connector in Power BI using ODBC, you can use the Power Query SDK to build a connector using ODBC. Once the connector is built, it can be imported into Power BI and used to connect to a data source.

100

How to add logo in tableau dashboard?

Reference answer

In the objects pane in dashboard there is an option to import image. Make sure that you have selected the floating type instead of by default tiled option. Drag and drop image object to dashboard and then select the logo from your system saved in .jpg, .png or .jpeg format. To use it as a background user can use the small drop down option on the right side of the image and select send to back and then increase the size of image so as to make it as a watermark logo.

101

How can you create a custom visual in Power BI using TypeScript?

Reference answer

To create a custom visual in Power BI using TypeScript, you can use the "Custom Visual" feature to write TypeScript code that generates the visualization. Once the code is written, you can add it to your report and use it like any other visual.

102

What is data densification in Tableau?

Reference answer

In my experience, data densification typically occurs in two scenarios: 1. Domain padding: Domain padding happens when Tableau fills in missing values along a continuous axis, such as dates or numbers. For example, if I have monthly sales data with missing months, Tableau can pad the missing months with null values to create a continuous timeline. This helps me see trends and patterns more clearly in my visualizations. 2. Domain completion: Domain completion occurs when Tableau fills in missing combinations of dimensions in a cross-tabulation or matrix. For example, if I have data on sales by product and region, but some product-region combinations are missing, Tableau can complete the matrix by adding null values for the missing combinations. This enables me to analyze the data more effectively and identify potential gaps or opportunities. A useful analogy I like to remember is that data densification is like filling in the gaps in a puzzle, making it easier to see the whole picture.

103

What is the comprehensive working system of Power BI?

Reference answer

Power BI's working system mainly comprises four steps: Data Importing: The first step is to import the data and convert it into a standard format and store it in a staging area. Data Cleaning: After assembling the data, it requires transformation or cleaning to remove unimportant values. Data Visualization: Now the data is visually represented on the Power BI desktop as reports and dashboards using powerful visualization tools. Save and Publish: Finally when your report is ready you can save and publish these reports that can be shared across users via mobile apps or web.

104

How Do You Add a web page to a Tableau Dashboard?

Reference answer

You can integrate a Tableau dashboard or report into a web application or web page to build dynamic web pages with interactive Tableau visuals. You can include Tableau content in a web application using its embedding options and APIs. To create a dynamic website in Tableau, follow these steps: - Open your dashboard and go to the Objects pane. - Drag the Web Page object onto the dashboard. - In the dialog box, enter the desired URL (can also be dynamic based on field values). - To make it interactive, go to Dashboard → Actions → Add Action → Go to URL. - Configure the action to open the web page based on user selections.

105

What is data visualization?

Reference answer

Data visualization means the graphical representation of data or information. We can use visual objects like graphs, charts, bars, and a lot more. Data visualization tools provide an accessible way to see and understand the data easily.

106

How do you monitor and audit Power BI usage across your organization?

Reference answer

Use the Power BI Admin Portal and audit logs. It shows who accessed what, when, and how. You can also connect activity logs to Power BI for custom usage reports.

107

What are the building blocks of Power BI?

Reference answer

Everything you do in Power BI is built from these key building blocks: - Visualizations: These are the visuals that clearly communicate insights from your data. Examples include bar charts, pie charts, line graphs, or even maps that highlight sales performance geographically. - Datasets: Collections of data gathered from various sources, such as Excel spreadsheets, CSV files, databases, or cloud services. Datasets are the foundation you use to create reports and visualizations. - Reports: These are pages that combine multiple related visuals to clearly tell a data-driven story. For instance, you might create a detailed sales performance report or a marketing campaign analysis. - Dashboards: Dashboards are simplified one-page summaries that highlight the most important visuals from one or more reports. They provide quick insights at a glance, allowing stakeholders to easily track key metrics and business performance. - Tiles: Individual visuals on a dashboard or report, such as a single bar chart or a KPI card. Each tile conveys a specific insight or piece of information clearly and concisely.

108

What is an Area Chart?

Reference answer

An area chart is a type of data visualization that represents data using a series of data points connected by a line, with the space between the line and the axis filled with color to form a shaded area. It is used to display the cumulative data over time or any continuous dimension and is similar to a line chart, but with the area under the line filled. Key features of an area chart: Connected Data Points: Like a line chart, an area chart has data points connected by a line, representing the trend or progression of the measure over time or any continuous dimension. Cumulative Representation: The area between the line and the axis is filled with color, representing the cumulative sum of the measure at each data point. Time Series Analysis: Area charts are commonly used for time series analysis, where the X-axis represents time or date and the Y-axis represents the values of the measure. Continuous Data: Area charts are suitable for visualizing continuous data, such as population growth, revenue over time, or any data that varies continuously. Stacked Area Chart: Tableau provides the option to create a stacked area chart, where multiple area charts are stacked on top of each other to show the contribution of different categories or subgroups to the total. Color Encoding: The color of the area can be used to differentiate between multiple lines representing different categories or groups. Area charts are effective for visualizing data trends, showing the cumulative impact of data over time, and comparing the contributions of different categories to the total. They are widely used in data analysis, time-based analysis, and forecasting to gain insights into data patterns and changes over time.

109

What is the difference between a tree and heat map?

Reference answer

Both the maps help in analyzing data. While a heat map visualizes and compares different categories of data, a treemap displays a hierarchical structure of data in rectangles. Heat map visualizes measures against dimensions by depicting them in different colors. Similar to a text table with values defined in different colors. Treemap visualizes the hierarchy of data in nested rectangles. Hierarchy levels are displayed from larger rectangles to smaller ones. Example - Below treemap shows aggregated sales totals across a range of product categories: Image - tableau.com

110

What are the different file extensions used in Tableau and what are their significance?

Reference answer

Tableau uses different file extensions for workbooks, data sources, and extracts. The most important ones are: | Extension | Purpose / Significance | |---|---| | .twb | Tableau workbook storing layout and visualizations and references data without including it. | | .twbx | Packaged workbook with embedded data and can be shared independently of the original data source. | | .hyper | Tableau Data Extract file for faster querying and analysis and stores snapshots of data. | | .tds | Tableau Data Source file storing connection and schema info without data. | | .tdsx | Packaged data source including extracts for sharing across workbooks. | Other extensions: - .tbm: Bookmark of a single visualization. - .twbx (Server) / .tds (Server): Used for publishing workbooks or data sources to Tableau Server or Tableau Online.

111

How do you improve Power BI report performance?

Reference answer

- Reduce dataset size (remove unused columns). - Optimize DAX calculations using variables. - Use aggregations instead of raw data. - Disable unnecessary visuals.

112

What is the difference between a data source and a data gateway in Power BI?

Reference answer

A data source is a physical location where the data is stored, such as a database or file, while a data gateway is a software component that allows Power BI to connect to data sources that are located behind a firewall or on-premises.

113

How do you create a treemap in Tableau?

Reference answer

A treemap is a visualization that displays hierarchical data as a set of nested rectangles. Each rectangle represents a category or group, and its size corresponds to a specific measure. Treemaps are great for comparing proportions within a hierarchy and can help identify patterns or outliers. To create a treemap in Tableau, follow these steps:1. Drag the "Treemap" chart type from the "Show Me" panel onto the canvas. 2. Drag the dimension you want to use for grouping (e.g., Category) onto the "Rows" shelf. 3. Drag the measure you want to use for sizing the rectangles (e.g., Sales) onto the "Size" shelf. 4. (Optional) Drag another dimension or measure onto the "Color" shelf to add color encoding. For example, if you have a dataset containing sales data by product category and subcategory, you could create a treemap to visualize the sales proportion for each subcategory within its parent category.

114

What are the three main filters used in Power BI reports?

Reference answer

There are three main filters used in Power BI reports. In addition to report-level filters, there are also visual-level and page-level filters: Report-level filters let you filter reports found on every page of your report Visual-level filters are used to filter or reduce data seen by the visualization and apply only to visualizations Page-level filters apply to particular pages: if you want to filter the data and have one page dedicated to one set of data and another dedicated to a different one, you could use page-level filters for this purpose

115

How to create a calculated field in Tableau?

Reference answer

Click the drop down to the right of Dimensions on the Data pane and select "Create > Calculated Field" to open the calculation editor. Name the new field and create a formula. Take a look at the example below:

116

What would you do if a report fails to refresh?

Reference answer

- Check data source connectivity. - Verify gateway is running. - Adjust query load settings.

117

Can you create custom columns in Power Query? Give an example.

Reference answer

Yes, in Power Query, go to Add Column > Custom Column. Example: = [Quantity] * [Price] creates a new column for total amount. M code can also be written for complex logic.

118

What is the difference between tableau and power bi?

Reference answer

Tableau performs better as compared to Power Bi on huge data sets. Tableau's customer support is better for free as well as paid users but Power Bi only have dedicated customer support for paid users. Tableau can connect multiple data sources and also allows the user to store information on the server whereas Power Bi have limited connections to data sources and focuses on reporting and analytical modelling instead of storing data. Power Bi has better graphical user interface as compared to Tableau, it is very easy to use software.

119

What are the primary requirement for a table to be used in Power Map?

Reference answer

For a data to be consumed in power map there should be location data like: Latitude/Longitude pair Street, City, Country/Region, Zip Code/Postal Code, and State/Province, which can be geolocated by Bing

120

What is the difference between Traditional BI Tools and Tableau?

Reference answer

Traditional BI Tools vs Tableau Traditional BI Tools 1. Architecture has hardware limitations. 2. Based on a complex set of technologies. 3. Do not support in-memory, multi-thread, multi-core computing. 4. Has a predefined view of data. Tableau 1. Do not have dependencies. 2. Based on Associative Search which makes it dynamic and fast 3. Supports in memory when used with advanced technologies. 4. Uses predictive analysis for various business operations. It allows anyone to connect to the respective data. Visualizes and creates interactive, shareable dashboards.

121

How would you combine data from multiple sources?

Reference answer

Use Merge Queries or Append Queries in Power Query to integrate SQL, Excel, and cloud datasets.

122

How do you use table calculations in Tableau, and what are some common use cases?

Reference answer

In my experience, table calculations in Tableau are powerful features that allow users to perform computations on the visible data in a view. They are executed locally on the Tableau platform and can be applied to measures or dimensions. To use table calculations, you simply need to right-click on a pill in the view and select "Add Table Calculation" or click on the small triangle icon on the pill and choose "Quick Table Calculation." Some common use cases for table calculations include: 1. Running Totals: I've found this particularly useful when I want to display the cumulative sum of a measure, such as sales or profit, over time. 2. Moving Averages: In my last role, I used this to analyze trends by smoothing out fluctuations in data, making it easier to identify patterns. 3. Percent of Total: This helps me compare the contribution of individual data points to the overall total, which is great for understanding the distribution of sales across different categories or regions. 4. Rank: I like to think of this as a way to identify top or bottom performers in a dataset, such as ranking products by sales or customers by revenue. 5. Year-over-Year Growth: In my experience, this is a valuable calculation for analyzing growth trends in data over time, particularly for financial and sales data.

123

You want to combine multiple date tables into one master date table. How do you do it?

Reference answer

- Use Power Query - Append Queries - Combine all date tables - Remove duplicates. MasterDate = Table.Distinct(Table.Combine({Date1, Date2, Date3}))

124

Explain what M language is in Power BI?

Reference answer

M is a query formula language used in Power BI Query Editor to prepare data before loading in the Power BI model. Power Query works with Excel, Analysis Services, and Power BI workbooks. Its core functionality is to filter and combine, i.e., to mash up data from one or more rich collections of supported data sources. Any such data mashup is expressed using Power Query M Formula Language.

125

Differentiate between Power BI and Excel.

Reference answer

| Basis | Power BI | Excel | |---|---|---| | Tabular reports | It is not very good at making tabular reports. | It excels in tabular reports. | | Duplicate table | Power BI cannot display duplicate tables. | Excel easily creates and displays duplicate tables for users. | | Analytics | Power BI offers simpler and better analytics. | It provides advanced analytics with the required formulas. | | Reports | It allows the creation of interactive and personalized reports. | It cannot perform advanced cross-filtering or make interactive reports. |

126

How do you handle data integrity issues when building Tableau reports?

Reference answer

In my previous position at ANZ Bank, I always began by conducting a thorough data validation process to identify missing or duplicate entries. I utilized Python scripts for automated cleaning, which significantly reduced manual errors. I also worked closely with the data engineering team to ensure that the data I was using was accurate and relevant to the business needs. By implementing these best practices, I ensured that my Tableau reports were based on reliable data, leading to more informed decision-making.

127

What are the main elements of the Power BI package?

Reference answer

Power BI primarily consists of three core elements: - Power BI Desktop: A free desktop app for connecting to data, transforming it, and creating interactive reports and visualizations. - Power BI Service: A cloud-based service that lets you publish your reports online, allowing teams to access dashboards, share insights securely, and collaborate easily. - Power BI Mobile Apps: These let users view and interact with Power BI reports on their phones or tablets, making insights available anytime, anywhere.

128

How can you convert SSRS to Power BI?

Reference answer

Following are the ways to integrate SSRS with Power BI: SSRS report items such as charts can be pinned to Power BI dashboards. By clicking the tile option in Power BI dashboards will bring users to SSRS reports To keep the dashboard tile refreshed, a subscription is created. Power BI reports will be published to the SSRS portal.

129

What is the difference between a bullet chart and a gauge chart in Power BI?

Reference answer

A bullet chart is a chart that shows progress towards a goal or target using a horizontal bar and additional visual elements, while a gauge chart is a chart that shows progress towards a goal or target using a circular gauge. Bullet charts are typically used to show progress towards a goal in a more detailed manner, while gauge charts are used to show progress towards a goal in a simpler manner.

130

What are discrete and continuous data in Tableau?

Reference answer

Tableau helps represent data in two different forms. Data can be either discrete or continuous; separate, individual, and distinct data come under discrete data values. When data forms a consecutive whole with constant fluctuation and without interruption, it is called continuous data.

131

What is a Power BI dashboard?

Reference answer

The Power BI dashboard lets you view the critical elements of a story based on data and access various reports. The data is concisely presented on the dashboard, which is usually only one page long. A dashboard contains tiles that users can pin to the page to present key data insights.

132

What is disaggregation and aggregation of data?

Reference answer

The process of viewing numeric values or measures at higher and more summarized levels of the data is called aggregation. When you place a measure on a shelf, Tableau automatically aggregates the data, usually by summing it. You can easily determine the aggregation applied to a field because the function always appears in front of the field's name when it is placed on a shelf. For example, Sales becomes SUM(Sales). You can aggregate measures using Tableau only for relational data sources. Multidimensional data sources contain aggregated data only. In Tableau, multidimensional data sources are supported only in Windows. According to Tableau, Disaggregating your data allows you to view every row of the data source which can be useful when you are analyzing measures that you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine what age participants were most satisfied with the product.

133

What is the difference between Power BI and Excel?

Reference answer

While both Power BI and Excel are used for data analysis and reporting, there are some key differences between the two. Power BI is designed for business intelligence and data visualization, while Excel is more of a general-purpose spreadsheet application. Power BI allows for more complex data modeling and visualizations, while Excel is better suited for simple calculations and analysis.

134

How do you ensure security in Tableau workbooks?

Reference answer

I create a user map table linking Tableau usernames to region codes, then apply a row-level data source filter. That way, a North America manager never sees EMEA figures. I also leverage SSL connections and enforce least-privilege roles on Tableau Server.

135

I hv a table with EmpNo, EmpName, ManagerNo and as Columns. I hv two records. (1,ABC,2) & (2,DEF,3)2nd record is the Manager details of the 1st record. Write a query to get the EmpName and ManagerName?

Reference answer

SELECT e.EmpName, m.EmpName AS ManagerName FROM Employees e LEFT JOIN Employees m ON e.ManagerNo = m.EmpNo

136

Which Tableau data types are preferable while dealing with structured data?

Reference answer

We can prefer using Text (string) values and numerical values as the two popular data types while dealing with structured data in Tableau. Tableau Desktop works best with structured data because the data remains arranged in a tabular format (in rows and columns).

137

How do you handle data refresh failures in production Power BI reports? What's your monitoring and alerting strategy?

Reference answer

I treat refresh reliability as part of production ownership, not just something to fix when it breaks. For monitoring, I regularly check the dataset refresh history in Power BI Service. It shows success or failure status, duration, and error messages. But I don't rely only on manual checks. I enable refresh failure notifications in dataset settings, so I receive an email if a scheduled refresh fails. That covers basic monitoring. For larger environments, I automate monitoring. I use the Power BI REST API with Power Automate to track refresh status across multiple workspaces. I build a small monitoring dashboard that shows refresh success rates, failure frequency, and average duration. If a refresh fails, I trigger a Power Automate flow that sends a Teams notification to the BI team with the dataset name, workspace, error message, and a direct link. When a failure happens, I diagnose based on the error type. If the gateway is offline, I check the gateway server and ensure the service is running. In production setups, I configure a gateway cluster with multiple nodes for high availability, so one server failure doesn't break refresh. If credentials expire, I update them immediately in dataset settings and document renewal cycles to avoid repeated failures. If the source database times out, I review the query performance. I may optimize the SQL, reduce data volume, or implement incremental refresh so the dataset does not reprocess the entire history every time. If memory limits are exceeded, especially in Pro workspaces with the 1 GB dataset limit, I reduce model size or recommend moving to Premium capacity. I also maintain a simple runbook that lists common failure scenarios and resolution steps. That reduces response time and ensures consistency across the team. Here, the difference between reactive and proactive management is visibility. If I know refresh health trends and have alerts configured, I can respond before users even notice a problem.

138

What factors do you consider when choosing between Import, DirectQuery, and Live Connection in a solution?

Reference answer

I look at data size, update frequency, latency, and performance needs. For speed, I prefer Import. For real-time needs, I consider DirectQuery or Live connections to Analysis Services.

139

What is Power Query in Power BI?

Reference answer

Power Query is a data transformation and cleaning tool in Power BI that allows users to connect to various data sources, transform and shape the data, and load it into the data model. It can be used to perform a wide range of data cleaning and transformation tasks.

140

What are the advantages of Tableau?

Reference answer

Some of the advantages of using Tableau: - Data visualization: Rather than having complex computations over an Excel sheet, Tableau provides beautiful insights, data blending, and dashboarding derived from the data. - Create interactive visualizations: Tableau provides a drag-n-drop facility to quickly let the users interact with the data. You can check some of the templates created using Tableau in the Tableau gallery. With Tableau's gallery of templates, you can choose your option and customize it. With data visualization features, you can easily embed tons of information in the form of infographics that appeal to the audience. - Ease of implementation: With drag-and-drop options, Tableau is reportedly easier to use. This is one such tool that you can learn without having any coding background or experience in Python, Business objects, or DOMO. - Handle large amounts of data: Tableau is competent enough to handle millions of rows without affecting the dashboard performance. - Integration of scripting languages: With Tableau, you can perform complex data computations using scripting languages like Python and R by importing some visuals or packages. - With much hype around data analytics and visualization, it is important to get well-versed with the tools simplifying the data journey. We have curated a list of interview questions ranging from beginner's level to expert to help you land a job in your preferred expertise.

141

How do you create a parameterized dashboard in Tableau?

Reference answer

Creating a parameterized dashboard in Tableau involves using parameters to allow users to interactively change the data displayed on the dashboard. Here's my go-to approach for creating a parameterized dashboard: 1. Create a parameter: Right-click on the Data pane and select "Create Parameter." Define the parameter properties, such as data type, allowable values, and default value. 2. Use the parameter in a calculated field: Create a new calculated field that incorporates the parameter in its formula. For example, if you have a parameter for selecting a measure, the calculated field might be something like IF [Parameter] = "Sales" THEN [Sales] ELSE [Profit] END. 3. Add the calculated field to the view: Use the calculated field in your visualization to dynamically change the data displayed based on the parameter selection. 4. Show the parameter control: Right-click on the parameter in the Data pane and select "Show Parameter Control." This will add the parameter control to the view, allowing users to interact with the parameter. 5. Incorporate the parameter in the dashboard: Finally, incorporate the parameter control and the visualization that uses the calculated field in your dashboard. This will enable users to interact with the dashboard and see the data update based on their parameter selections.

142

What is Tableau Prep, and how does it fit into the Tableau ecosystem?

Reference answer

Tableau Prep is a tool designed to help users clean, combine, and transform their data before analysis in Tableau Desktop. It provides a visual interface for data preparation tasks and integrates seamlessly with Tableau Desktop to ensure that the prepared data is ready for visualization.

143

Handling many-to-many relationships in your data model.

Reference answer

Use a bridge table to resolve many-to-many relationships, or use DAX functions like CROSSFILTER to adjust filter direction.

144

What is Power BI Gateway?

Reference answer

Power BI Gateway is a client application that allows on-premises data sources to be accessed from the Power BI Service. It can be used to refresh data from on-premises data sources, such as SQL Server, Oracle, and SharePoint.

145

Explain the building blocks of Microsoft Power BI.

Reference answer

The important building blocks of Power BI are as follows: Visualizations Visualization is the process of generating charts and graphs for the representation of insights on business data. Datasets A dataset is the collection of data used to create a visualization, such as a column of sales figures. Dataset can get combined and filtered from a variety of sources via built-in data plugins.

146

Why do people get confused between Discrete & Dimension and Continuous & Measure in Tableau?

Reference answer

People get confused because most dimensions are displayed as discrete fields and most measures are displayed as continuous fields by default in Tableau. This makes it seem like dimension always means discrete and measure always means continuous, which is not always true. Dimension and Measure describe the type of data, while Discrete and Continuous describe how the data is displayed in the visualization. For example, a measure like Sales can be changed to discrete, and a dimension like Date can be used as continuous. Because they often appear together in practice, many beginners assume they mean the same thing.

147

Name the key components of Power BI.

Reference answer

Power BI includes several components such as Desktop, Service, Mobile, and Report Server.

148

What are the most common data-shaping techniques?

Reference answer

The most common data shaping techniques are: - Removing columns and rows - Apply sort order - Adding indexes

149

What is Power BI?

Reference answer

Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

150

What is a Power BI App?

Reference answer

A Power BI App bundles related dashboards and reports. This makes data access and interaction more organized and consistent. It is shared with user groups, ensuring everyone has access to the right data. - Packaged Content: An app can include one or more dashboards and reports. - Sharing: Apps make it easy to share these collections with other users, ensuring they have access to the right data. - Navigation: Users can easily navigate through the app to find the specific data they need. This eliminates the need to search through multiple individual reports or dashboards. - Updates: When the data or reports within an app are updated, the changes are automatically available to all users of the app. ? A Power BI App bundles dashboards and reports for organized, consistent data access and easy sharing with user groups.

151

Why do businesses choose Tableau?

Reference answer

This question may seem highly subjective; however, it strikes at the core idea that Tableau is more than a tool to "make pretty charts" but one that serves the purpose of deriving insights from raw data. The point of a business intelligence tool is, after all, to provide business intelligence! As noted by Howard Dresner, Chief Research Officer at Dresner Advisory Services, in a recent DataFramed podcast on the State of BI: Business intelligence, a term that I coined back in 1989, was always intended to be an umbrella term, not tied to a specific technology. It's really about fact-based analysis, which is driven by data. We've seen that evolve, and now, you look at things like agentic analytics and conversational analytics, those are all part of business intelligence because the intent is to deliver the same capabilities. How do we deliver data-driven fact-based analysis? Howard Dresner, Chief Research Officer at Dresner Advisory Services

152

What is Tableau and how does it help in data analysis?

Reference answer

Tableau is an analytics tool that helps you create visualizations of different types of data on various topics, making it easier to explain the data in charts, graphs, and other visualizations. It allows you to manage, express, and analyze large amounts of data concisely to help your clients and coworkers better understand a particular topic. With its connectivity to any database and easy-to-create visualizations, Tableau can help empower you to drive sound decisions based on insights you glean from data.

153

Describe Power BI Designer

Reference answer

Power BI is a stand-alone application to make Power BI reports and upload them to Powerbi.com; it does not require excel. It is the combination of Power Pivot, Power View, and Power Query.

154

What is the DRIVE Program Methodology?

Reference answer

DRIVE program methodology creates a structure around data analytics derived from enterprise deployments. The drive methodology is iterative in nature and includes agile methods that are faster and effective.

155

What is query fusion in Tableau?

Reference answer

Query fusion is an ability of this platform. It combines more than one query into a single query to reduce the number of queries. This fusion gives better performance by minimizing the requirement of data space, load and network traffic. The system automatically fuses queries whenever it is possible.

156

How is data security implemented in Power BI ?

Reference answer

A DAX expression is applied on a table filtering its rows at query time. Dynamic security involves the use of USERNAME functions in security role definitions. Typically a table is created in the model that relates users to specific dimensions and a role.

157

What is data modeling?

Reference answer

Data modeling is the analysis of data objects that are used in a business or other context and also used as identification of the relationships among these data objects. It is the first step of doing object-oriented programming.

158

How do you implement row-level security (RLS) in Power BI?

Reference answer

Row-level security (RLS) restricts data access for users based on roles. In Power BI, RLS can be implemented by defining roles and DAX rules to filter data based on the user's login information. This ensures that users can only view data relevant to their role.

159

Diff between ALL(), ALLSELECTED(). Where is it used?

Reference answer

ALL() removes all filters from a table or column. ALLSELECTED() respects external slicer selections but removes internal filters. Used in DAX for calculations like % of total.

160

How can you create a custom theme in Power BI?

Reference answer

To create a custom theme in Power BI, you can use the "Themes" feature to define the colors, fonts, and other visual elements that you want to use. Once the theme is created, you can apply it to your reports and visualizations.

161

What is a Hyper file in Tableau?

Reference answer

Hyper file is a well optimized data engine format of this platform. It stores extracts for faster data inputting and querying, manages huge data stores and optimizes for parallel processing. TDE is the older format in comparison to other data engines that do not have these features. It is almost replaced by hyper files.

162

How do you optimize DAX calculations for large datasets?

Reference answer

Avoid nested functions. Use variables (VAR). Reduce row context using aggregation functions.

163

How does the dual axis work in Tableau?

Reference answer

In the same graph, two different metrics are analyzed at two different scales using a dual axis. With two independent axes placed on top of each other, you can compare several attributes on a single graph. When you see a black dashed line visible, move the field to the right side of the display and drop it to add the measure as a dual-axis. You can also select Dual Axis by right-clicking on the Columns or Rows shelf.

164

Visualization displays Sum (Profit) by Zipcode. Additionally, the customer wants to see "Sum (Profit) at the State level" in the same visualization. What kind of function is applicable in this situation?

Reference answer

LOD expressions are used to aggregate outside of the view's level of detail. In this situation, ZipCode determines the degree of detail. Therefore, a developer can create a calculated field using the calculation editor or with the following LOD expression and set it in the Detail shelf if they want to calculate the Sum by Profit at the State level. {Fixed [State]: SUM ([Profit])} This expression will be calculated at the state level and overlook the ZipCode-related view dimension.

165

What data sources can you connect to Power BI?

Reference answer

he Power BI data sources are extensive, which are divided as follows: Files: Data can be imported from Power BI Desktop files (.pbix), Excel (.xlsx, xlxm), and Comma Separated Value (.csv). Content Packs: It refers to the collection of related files or documents that are stored as a group. There are two types of content packs in Power BI: those from service providers including Google Analytics, Salesforce, or Marketo, and those created and shared by other users in the organization. Connectors: To connect databases and other datasets, including Database, Azure SQL, and SQL Server Analysis Services tabular data, etc.

166

What is the difference between Power BI and Tableau?

Reference answer

Both Power BI and Tableau are powerful BI tools used for analyzing data and creating visualizations, but there are a few key differences: - Cost: Power BI is generally more affordable, making it a good option for smaller businesses or budget-conscious teams. Tableau tends to be pricier, but some enterprises prefer it for its advanced visualization capabilities. - Formulas and queries: Power BI primarily uses the DAX language, which is familiar to users who know Excel. Tableau mainly relies on MDX, a language focused on multidimensional data queries. - Visual capabilities: Tableau is known for its highly customizable, advanced visualizations, making it popular among data visualization specialists. Power BI also creates great visuals, but it shines particularly in creating straightforward, intuitive reports and dashboards quickly. - Data connectivity: Both tools connect to many data sources, but Tableau has traditionally supported a wider variety of data connections. However, Power BI's connectivity options have expanded significantly in recent years. - Learning curve: Power BI tends to be easier for beginners or business users to learn because of its similarity to Microsoft Excel. Tableau has a steeper learning curve but offers greater flexibility for advanced visual analytics.

167

Describe your experience with Power BI and how you typically use it in your projects.

Reference answer

Look for: Understanding of Power BI's capabilities, practical usage, and specific projects or scenarios where it was applied. What to Expect: The candidate should discuss using Power BI for data visualization, report creation, and dashboard development, highlighting specific use cases and results achieved.

168

How do you manage data security within Power BI Service for shared content?

Reference answer

I use row-level security (RLS) for data-level restrictions and workspace roles for access control. I also apply sensitivity labels and audit logs to monitor usage.

169

How do you schedule a data refresh in Power BI?

Reference answer

- In Power BI Service, use Scheduled Refresh. - Requires a Power BI Gateway for on-premises data.

170

Common DAX Optimization Tips

Reference answer

- Avoid complex nested functions - Use variables (VAR) - Reduce row context with calculated columns

171

What are actions?

Reference answer

In Tableau, actions refer to a set of interactive behaviors that allow users to navigate and interact with data visualizations. There are several types of actions in Tableau, including: - Filter: applies the same filter from one view to another; - Highlight: marks important information while muting others; - Go to URL: redirects the user to an external resource, which can include another Tableau workbook, a file, or a web page; - Go to Sheet: helps navigate between sheets, dashboards, and stories within a Tableau workbook; - Change Parameter: allows users to dynamically update the visualization by changing the parameter values; and - Change Set Values: allows users to dynamically update the visualization by selecting a subset of elements to include in the analysis.

172

Scenario: You are working with a large dataset that is slowing down the report's performance. How would you optimize the report's performance in Power BI?

Reference answer

To optimize a Power BI report's performance, one should first review the report design, ensuring best practices such as minimal visuals, limited data points, and appropriate visuals. Utilizing Power BI's data modeling features, like creating table relationships, calculated columns, and summary tables, can help reduce data queried. Additionally, using the performance analyzer tool can identify bottlenecks in the report and enable the necessary steps to be taken to address them.

173

What are the different types of Power BI licenses?

Reference answer

- Power BI Free — Basic report creation. - Power BI Pro — Sharing and collaboration features. - Power BI Premium — Enterprise-level scalability.

174

What all services have u used from Power BI Service?

Reference answer

Workspaces, dashboards, reports, datasets, dataflows, gateways, deployment pipelines, and apps.

175

What are filters in Power BI?

Reference answer

Filters sort data based on the condition applied to it. Filters enable us to select particular fields and extract information in a page/visualization/report level. For example, filters can provide sales reports from the year 2019 for the Indian region. Power BI can make changes based on the filters and create graphs or visuals accordingly. Types of filters are: - Page-level filters: These are applied on a particular page from various pages available within a report. - Visualization-level filters: These are applied to both data and calculation conditions for particular visualizations. - Report-level filters: These are applied to the entire report.

176

What is a published data source in Tableau?

Reference answer

The published data source contains connection information that is independent of workbooks and can be used by multiple workbooks.

177

Explain DAX

Reference answer

DAX stands for Data Analysis Expressions. It is a collection of operators, functions, and constants used to calculate formulas and return values. In other words, it helps you create new info from data you already have.

178

What is your approach to training and mentoring others in using Tableau?

Reference answer

I develop structured training programs that include hands-on workshops and real-world examples to ensure practical understanding. Additionally, I provide continuous support and feedback to help team members improve their skills over time.

179

How do you implement security when working with Azure and Power BI together?

Reference answer

I use Azure AD for authentication, RLS for data-level security, and managed identities for service-to-service connections. I also encrypt data in transit and at rest using Azure security features.

180

What is Tableau Reader?

Reference answer

Tableau Reader is a free desktop application, where you can read and interact with the Tableau packaged workbooks. It can only open the files but cannot create new connections to the workbook.

181

Can you describe a project where you used Tableau to derive actionable insights?

Reference answer

In my internship at a retail company, I worked on a project to analyze customer purchasing trends. I connected Tableau to our sales database and created dashboards that visualized sales performance by region and product category. By identifying that our sales in the northern region were declining, I was able to present actionable insights to the marketing team, who then adjusted their campaign strategies. The result was a 15% increase in sales in that region over the next quarter.

182

What is the role of the Semantic Model in Power BI?

Reference answer

The semantic model is the data layer with relationships, measures, and hierarchies. It enables consistent reporting across multiple reports and allows users to explore data without technical skills.

183

What are KPIs in Power BI?

Reference answer

KPI is abbreviated as Key Performance Indicator. Any professional organization has teams and employees follow the KPI protocols. The organizations set up KPIs for all the employees. These KPIs act as their targets. These KPIs are compared to previous performance and analyze the progress.

184

What is aggregation and dis-aggregation in Tableau?

Reference answer

Aggregation is the simple concept of averaging values in a given data set column. If a specific report contains the historical change in prices of a product, aggregation will help in finding its average value. In most cases, Tableau automatically aggregates a given set of data. Disaggregation is the opposite of averaging, which can be helpful if a user wants individual data points. Both aggregated and disaggregated data can also be utilized in a single worksheet.

185

How do you find retention – customers who purchased in consecutive years?

Reference answer

Create a calculated field: IF MIN(YEAR([Order Date])) = 2023 AND MAX(YEAR([Order Date])) = 2024 THEN "Retained" ELSE "Not Retained" END

186

What is Tableau?

Reference answer

Tableau is a business intelligence software that visually represents data from varied sources to create interactive and shareable dashboards. This tool has made the entire process of analyzing data and questioning your product-market fit, easier. It has various built-in features for data exploration without getting overwhelmed by the software elements.

187

How do you troubleshoot issues with filters and parameters in Tableau?

Reference answer

When troubleshooting issues with filters and parameters in Tableau, I follow these steps: 1. Understanding the filter or parameter's purpose: I start by reviewing the intended functionality of the filter or parameter to ensure it aligns with the business requirements and the dashboard's purpose. 2. Checking the filter or parameter setup: In my experience, issues with filters and parameters can often be traced back to their setup. I verify that the filter or parameter is configured correctly, including its data type, allowable values, and default value. 3. Examining the filter or parameter's impact on the view: I've found that filters and parameters can sometimes have unintended consequences on the view. I test the filter or parameter by applying it to the view and observing the results. If the results are unexpected, I revisit the filter or parameter setup and make any necessary adjustments. 4. Assessing interaction with other filters and parameters: From what I've seen, issues can arise when filters and parameters interact with each other in unexpected ways. I test the filter or parameter in combination with other filters and parameters to ensure they're working together as intended. 5. Verifying the context of filters: I check if the filter is a context filter and ensure that it's configured correctly. Context filters can impact the behavior of other filters, so it's crucial to verify their setup. 6. Reviewing calculations and table calculations: I examine any calculations or table calculations that use the filter or parameter to ensure they're accurate and functioning as intended. By following these steps, I can effectively troubleshoot and resolve issues with filters and parameters in Tableau.

188

How would you resolve a situation where users misinterpreted a sales trend chart due to missing data?

Reference answer

Yes, in one project, users misinterpreted a sales trend chart due to a sudden drop caused by missing data in one region. They thought sales had drastically fallen, but it was actually due to data not being uploaded on time. To resolve this, I added tooltips that explained the cause of any data gaps, and I used annotations on the chart to provide context. I also created a small data quality indicator on the dashboard to flag when data was incomplete. This greatly improved transparency and user trust in the dashboard.

189

What tools did AIR replace for one enterprise team?

Reference answer

AIR replaced resume screening, skills assessments, phone screening, and scheduling tools, with ROI positive in the first month.

190

Tell me about a time you had to redesign or optimize an existing Power BI report. What changes did you make and why?

Reference answer

In one case, I inherited a report that had 15 visuals on a single page and took around 45 seconds to load. Users complained that it was slow and difficult to navigate. I began by analyzing performance using Performance Analyzer. I found that three visuals relied on complex DAX measures that scanned the entire fact table repeatedly. The model also had about 30 unused columns and several bi-directional relationships, which created ambiguous filter paths. First, I optimized the data model. I removed unused columns to reduce model size. I replaced certain calculated columns with measures where appropriate to reduce storage overhead. I changed bi-directional relationships to single-direction to eliminate ambiguity and improve performance. Then I reviewed the DAX. I simplified nested CALCULATE and FILTER patterns by using direct column filters where possible. I introduced variables with VAR and RETURN to avoid recalculating the same expressions multiple times. Next, I redesigned the layout. Instead of one overloaded page, I split the content into three focused pages with clear drill-through navigation. I replaced a large flat table with a matrix to better handle hierarchical data. After the changes, load time dropped from about 45 seconds to around 3 seconds. The model size decreased noticeably. User feedback improved significantly, and survey scores increased from roughly 3.2 to 4.5 out of 5.

191

What are responsive slicers in Power BI?

Reference answer

Responsive slicers dynamically adjust to different screen sizes and orientations. This feature ensures that visuals remain clear and accessible on any device, enhancing the report's appearance and usability. Responsive slicers improve the user experience, especially for stakeholders who access reports on various devices, by maintaining the integrity and clarity of visualizations across different screen sizes.

192

What is a heatmap? Give an example.

Reference answer

A heatmap is a type of visualization used to demonstrate a set of data through varying shades of colours where the darkest shade of a specific colour denotes an extreme value (high intensity/density). It is typically used to compare two or more measures. A quick example of a heatmap would be to understand the anatomy of the human body and observe the level of warmth depending upon the temperature of specific organs. If the red-yellow combination of colours is used, the areas that show red will denote the maximum temperature.

193

What is the difference between calculated columns and measures?

Reference answer

Calculated Columns: Row-level calculations in tables. Measures: Aggregated calculations are evaluated on the fly during analysis.

194

Which gives better performance: Calculated columns or measures?

Reference answer

Measures generally offer better performance than calculated columns in Power BI. - Memory Usage: Measures use less memory because they are not stored in the data model. Calculated columns are stored and thus consume more memory. - Dynamic Calculation: Measures are calculated on the fly during query time. This make them efficient for dynamic and context-sensitive calculations. Calculated columns are computed during data load. This can slow down performance if the dataset is large. - Flexibility: Measures adapt to different contexts within reports, providing real-time results based on filters and slicers. Calculated columns, once created, do not change unless the data is refreshed. ? Measures are generally faster and more efficient for dynamic calculations. Calculated columns are better suited for static, row-level data.

195

What are Power BI data sources?

Reference answer

Power BI supports a wide range of data sources, including databases, cloud services, flat files, and live data streams. Some popular sources include SQL Server, Excel, SharePoint, Azure, and Google Analytics.

196

What is the full form of LOD in tableau?

Reference answer

The full form of LOD is Level of Details.

197

When will you use geographical data type in Tableau?

Reference answer

You will use a geographical data type in Tableau to create a map view for any data with spatial questions.

198

How would you define Power BI as an effective solution?

Reference answer

Power BI is a strong business analytical tool that creates useful insights and reports by collating data from unrelated sources. This data can be extracted from any source like Microsoft Excel or hybrid data warehouses. Power BI drives an extreme level of utility and purpose using interactive graphical interface and visualizations. You can create reports using the Excel BI toolkit and share them on-cloud with your colleagues.

199

How do you design a Power BI report for mobile users?

Reference answer

I use the mobile layout view in Power BI Desktop to arrange visuals vertically. I prioritize key metrics, use large fonts, and avoid complex interactions. Testing on actual devices ensures usability.

200

What is a hierarchical field?

Reference answer

A hierarchical field in tableau is used for drilling down data. It means viewing your data in a more granular level.

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

Power BI Interview Questions & Answers 2025 | SPOTO

Earn a certification to make your resume stand out.

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

Power BI Interview Questions & Answers 2025 | SPOTO

Earn a certification to make your resume stand out.

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now