Job Interview Questions for Power BI Developers Answered

1

What is a story in Tableau?

Reference answer

The story can be defined as a sheet which is a collection of series of worksheets and dashboards used to convey the insights of data. A story can be used to show the connection between facts and outcomes that impacts the decision-making process. A story can be published on the web or can be presented to the audience.

2

Describe a complex Power BI solution you architected. What challenges did you face and how did you overcome them?

Reference answer

I architected a multi-source solution combining SQL Server, Salesforce, and Excel. Challenges included data inconsistency and slow refresh. I used Power Query for cleaning, created a central semantic model, and implemented incremental refresh. I also set up a gateway for on-premises data.

3

What is the easiest method to navigate in Power BI?

Reference answer

The easiest method to navigate between different reports in Power BI is by using Bookmarks. Bookmarks capture the current state of a report page, including filters, slicers, and visuals. You can then link these bookmarks to buttons or images, making it simple for users to navigate between different report views or pages with just a click. You can also use buttons with pre-determined functions, such as Page Navigator, Bookmark Navigator, or a Back button, to simplify navigation.

4

What is the difference between a tiled layout and a floating layout in Tableau?

Reference answer

In a tiled layout, items don't overlap. The layout will be adjusted according to the dashboard size. In the floating layout, items can be placed on some other layers. Floating items can have fixed positions and sizes.

5

What role does Power BI play in your overall business intelligence strategy?

Reference answer

Look for: Strategic thinking and integration of Power BI within broader BI initiatives. What to Expect: Discussion on how Power BI fits into the company's BI ecosystem, its role in decision-making processes, and how it integrates with other BI tools and platforms.

6

What Are The Datacategories In Power Bi Desktop?

Reference answer

Address, City, Continent, Country, County, Latitude, Longitude, Postal Code, State, Place, Web URL, Image URL.

7

What is scatter plot in tableau?

Reference answer

A scatter plot is used to create a visualization between two or more measures with or without dimensions. To plot a scatter plot atleast one measure in row and one measure in column is required then further detailing can be done using various dimensions marks card over colour and details. Scatter plot plots the datapoints on an empty place and those datapoints take some sort of shape based on the values in measures.

8

Explain the use of window functions in SQL with a Power BI use case.

Reference answer

Window functions like ROW_NUMBER() or SUM() OVER (PARTITION BY) allow calculations across rows without grouping. In Power BI, they can pre-aggregate data in SQL for faster report performance.

9

What is a TDE file?

Reference answer

TDE is a file extension type exclusive to Tableau which stores information sourced from third-party sources such as Microsoft Excel. It is similar to a spreadsheet.

10

In Power BI, what distinguishes a matrix visualization from a table visualization?

Reference answer

A matrix visualization enables the grouping and summarization of data at several levels by presenting it in a tabular style with hierarchical row and column headers. In contrast, a table visualization shows data in a straightforward tabular style without any sort of summary or hierarchy.

11

Explain the difference between SUM and SUMX in DAX.

Reference answer

In DAX, both SUM and SUMX are used for adding up values, but they work in different ways. - SUM is used to add all values in a single column. It's straightforward and quick. For example, if you have a column of sales amounts, SUM can add up all the sales amounts in that column. - SUMX is more flexible. It goes through each row in a table, calculates an expression for each row, and then adds up those results. For example, consider a table with quantity and price columns. SUMX can calculate the total sales by multiplying quantity by price for each row and then adding up those values. ? SUM adds values in a single column. SUMX iterates over a table, calculating an expression for each row. Other commonly used iterator functions in DAX include AVERAGEX, MINX, MAXX, and COUNTX.

12

How do you use Power BI to create and manage KPIs (Key Performance Indicators)?

Reference answer

Look for: Knowledge of defining and visualizing KPIs in Power BI. What to Expect: Explanation of creating KPIs using measures and visualizations, setting targets and thresholds, and displaying KPIs effectively in reports and dashboards.

13

How does Assume referential integrity work?

Reference answer

In some scenarios, choosing the Assume Referential Integrity option from the Data menu will optimize query performance. When you select this option, Tableau will only include the connected table in the query if fields in the view directly mention it.

14

What is Row-Level Security (RLS)?

Reference answer

Row-Level Security (RLS) in Power BI restricts data access for specific users. This way, each user sees only the data relevant to them. This feature improves data security by filtering data based on the roles assigned to different users. Thus, only authorized people can access sensitive information.

15

What's the difference between slicers and filters? When would you use one over the other?

Reference answer

Slicers are visual controls that allow users to filter data interactively. Filters are hidden or applied at the visual, page, or report level. I use slicers for user-facing interactivity and filters for backend data control.

16

What are the differences between FIXED, INCLUDE, and EXCLUDE LOD expressions in Tableau?

Reference answer

These three are elements of this platform that performs different operations. FIXED is used for calculating the expression for a particular dimension level but view level dimensions are not included. INCLUDE integrates dimensions with view level of detail. EXCLUDE detach dimensions from the view level of detail.

17

What are the key differences between Tableau Desktop and Tableau Server?

Reference answer

Tableau Desktop is primarily used for creating and developing visualizations, offering a wide range of design and analytical features. Tableau Server, on the other hand, is designed for sharing, collaboration, and governance of those visualizations, ensuring secure access and scalability across the organization.

18

A business user says the numbers in your Power BI report don't match the source system. How do you troubleshoot this?

Reference answer

When someone says the numbers are wrong, I don't assume the report is broken. I narrow the gap first. I start by asking for the exact metric and time period where the mismatch occurs. I ask them for the number they see in the source system and how they calculated it. Without a precise comparison, troubleshooting becomes guesswork. Next, I check data freshness. I look at the dataset refresh history in Power BI Service and confirm when the last refresh ran successfully. Many discrepancies come from stale data or failed refreshes. After that, I check filters. I review report-level, page-level, and visual-level filters in the Filters pane. I also look at slicers that might be affecting the numbers. Sometimes, a hidden filter or a default slicer selection explains the difference immediately. If filters are not the issue, I move to the DAX measure. I read the formula carefully. I look for CALCULATE statements that add filter conditions. I check whether DISTINCTCOUNT is being used instead of COUNT, or whether blanks are being excluded implicitly. Even small filter conditions inside a measure can change totals significantly. Then I inspect the data model. I verify relationships, cardinality, cross-filter direction, and whether any many-to-many relationships exist. Incorrect relationships can duplicate rows or filter out data unintentionally. If I suspect duplication, I test counts at the table level to confirm. After that, I review Power Query transformations. I check whether rows were removed during cleaning, duplicate removal, error filtering, or type conversion issues that can drop records silently. I compare row counts before and after major transformation steps. If the issue still isn't clear, I go to the raw data. I export the data from the visual and run an equivalent SQL query against the source system. Then I compare the results row by row. That usually reveals whether the difference comes from transformation logic, modeling, or calculation rules. Once I identify the root cause, I document it clearly. I explain what caused the mismatch, whether it was a refresh delay, filter logic, relationship configuration, or business definition difference. If the report logic needs correction, I fix it. If the issue comes from differing metric definitions, I align with stakeholders and update the documentation so the same confusion doesn't happen again. Hence, this is what I do in short: I define the gap precisely, validate freshness and filters, review DAX and relationships, inspect transformations, and verify against raw data before concluding.

19

What are filters in Power BI and what types are available?

Reference answer

Filters enable the user to separate out critical data in columns and rows and use logical principles to filter data. Some filters you can use include auto, manual, drill-down, drill through, and URL filters.

20

What are the various types of filters in Tableau?

Reference answer

Tableau has 6 different types of filters: - Extract Filter: This filter retrieves a subset of data from the data source. - Dimension Filter: This filter is for non-aggregated data (discrete). - Data Source Filter: This filter refrains users from viewing sensitive information and thus reduces data feeds. - Context Filter: This filter creates datasets by applying presets in Tableau. - Measure Filter: This filter applies various operations like sum, median, avg, etc. - Table Calculation Filter: This filter is applied after the view has been created.

21

What are the major components of Power BI?

Reference answer

Power Query: It is one of the most important components of PowerBI to transform data. Power Query helps to extract data from different data sources like Oracle, SQL, Text/CSV files, Excel, etc. and even delete data from different sources.

22

What is an Unchanged Dimension?

Reference answer

Unchanged Dimension: Values are constant for unchanged dimensions. Example – Traffic Signals

23

What is the difference between clustered and non-clustered column charts in Power BI?

Reference answer

Clustered and non-clustered column charts are two types of visualizations in Power BI that help in representing data in an easily comprehensible form. - Clustered Column Chart: Used for displaying and comparing discrete categories of data, especially when the number of categories is relatively small. Each category has its own column, and the height of the column represents the quantity for that category - Non-Clustered (Stacked) Column Chart: Used to show the proportion of individual items to the whole. It's useful when you want to display the total size across a series of categories For example If you have sales data by product category for each region, a clustered column chart would be helpful to compare sales across regions for each product category. But, if you are interested in the contribution of each product category to total sales for each region, a non-clustered or stacked column chart would be a better choice. Choosing the right type of column chart ensures that data is presented clearly and effectively, facilitating better comparisons and insights.

24

What is Power Query in Power BI?

Reference answer

Power Query in Power BI is a data connection and transformation tool that helps you import, clean and reshape data before using it for analysis and reporting. It allows users to connect to multiple data sources, apply transformations and prepare the data without needing complex coding. - Used for data extraction, transformation and loading (ETL). - Provides a user-friendly editor to clean and format data. - Supports connections to databases, Excel, cloud services and APIs. - Uses the M language in the background for transformations.

25

What is a dual axis?

Reference answer

Dual Axis is an excellent phenomenon supported by Tableau that helps users view two scales of two measures in the same graph. Many websites like Indeed.com and other make use of dual axis to show the comparison between two measures and their growth rate in a septic set of years. Dual axes let you compare multiple measures at once, having two independent axes layered on top of one another. This is how it looks like:

26

Power BI can connect to which data sources?

Reference answer

The data source is the point from which the data has been retrieved. It can be anything like files in various formats (.xlsx, .csv, .pbix, .xml, .txt etc), databases (SQL database, SQL Data Warehouse, Spark on Azure HDInsight), or form content packets like Google Analytics or Twilio.

27

How is the FILTER function used?

Reference answer

The FILTER function returns a table with a filter condition applied for each of its source table rows. The FILTER function is rarely used in isolation, it's generally used as a parameter to other functions such as CALCULATE. FILTER is an iterator and thus can negatively impact performance over large source tables. Complex filtering logic can be applied such as referencing a measure in a filter expression. FILTER(MyTable,[SalesMetric] > 500)

28

Define LOD Expression.

Reference answer

LOD (Level of Detail) Expression in Tableau is a powerful feature that allows users to compute aggregations at different levels of granularity than the visualization's primary data source. It provides the ability to control and manipulate the level of detail in calculations, regardless of the dimensions used in the view. With LOD expressions, users can create calculations that consider specific dimensions while ignoring others, resulting in more precise and flexible aggregations. There are three types of LOD expressions in Tableau: Fixed LOD: The fixed LOD expression allows users to compute an aggregation using specific dimensions, irrespective of the dimensions in the visualization. It is denoted by the `{FIXED}` keyword and enables users to create calculations that stay consistent across different levels of granularity. Include LOD: The include LOD expression computes an aggregation that includes the specified dimensions in addition to the dimensions in the visualization. It is represented by the `{INCLUDE}` keyword and is useful when users want to perform calculations that consider specific dimensions in addition to the dimensions on the view. Exclude LOD: The exclude LOD expression computes an aggregation excluding the specified dimensions from the dimensions in the visualization. It is denoted by the `{EXCLUDE}` keyword and is used to exclude specific dimensions while performing calculations. LOD expressions are valuable in various scenarios, such as comparing subsets of data, creating dynamic filters, and achieving complex calculations without the need for data reshaping or aggregation at the data source level. They provide users with fine-grained control over calculations and enhance the analytical capabilities of Tableau.

29

How to publish tableau reports to tableau server?

Reference answer

Open the workbook which you want to publish to tableau server. Make sure you are on an active sheet which is to be published to the server. Otherwise you won't be able to see the “Publish Workbook” under the “server” menu in the toolbar. Once you click on Publish Workbook then sign in to your tableau server account and give the name you want to save it with on the server.

30

What is RANK in Tableau and how to use it?

Reference answer

The RANK function in Tableau is used to assign a position (rank) to values in a dataset based on a measure. It helps in ordering data such as ranking top-performing products, regions or salespeople. Tableau offers multiple ranking methods like RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE. 1. Create a Worksheet: Drag and drop the dimension you want to rank like Product Name and the measure like Sales into the view. 2. Go to the Analytics Pane: On the left drag Rank and drop it on the visualization. 3. Configure Rank: - Right-click the Rank field → choose Edit Table Calculation. - Select the ranking method (Default, Dense, Modified, Unique). - Set the field on which the ranking should be based (Sales). The data will now display with ranks assigned based on your chosen measure.

31

Explain the difference between Power BI Desktop and Power BI Service.

Reference answer

Power BI Desktop and Power BI Service are essential components of Power BI. They each serve unique purposes. Power BI Desktop: - Used for creating reports and visualizations locally. - Allows you to connect to data sources, transform data, and build interactive reports on your computer. It's a free application with robust data modeling and visualization tools. Power BI Service: - Used for sharing and accessing reports online. - A cloud-based service where you can publish reports created in Power BI Desktop, share them, and access them from anywhere. It offers collaboration, dashboards, and data refresh capabilities. ? Power BI Desktop is for creating reports locally, while Power BI Service is for sharing and accessing reports online.

32

How to group in tableau?

Reference answer

A group is used to combine similar members in a field. There are multiple ways to create groups either by selecting data in view or from a field in the Data pane. Select multiple data points in view and then an option to group appears on the tool tip, you can use that option to create a group. Another way to create a group is from Data pane, Right click on a field and select create -> group. Now you can select several members that you want to group and then click group.

33

What are the purpose and benefits of using the DAX function?

Reference answer

DAX or Data Analysis Expression is a functional language which can create calculated columns and/or measures for smarter calculations to limit the data the dashboard has to fetch and visualize.

34

What is GetData in Power BI?

Reference answer

GetData offers data connectivity to various data sources. Connect data files on your local system. The supported data sources are: File: Excel, Text/CSV, XML, PDF, JSON, Folder, SharePoint. Database: SQL Server database, Access database, Oracle database, SAP HANA database, IBM, MySQL, Teradata, Impala, Amazon Redshift, Google BigQuery, etc. Power BI: Power BI datasets, Power BI dataflows.

35

What is the comprehensive working system of Power BI?

Reference answer

Data Integration: The first step is to extract and integrate the data from heterogeneous data sources. After integration, the data is converted into a standard format and stored in a common area called the staging area. Data Processing: Once the data is assembled and integrated, it requires some cleaning up. Raw data is not so useful therefore, a few transformation and cleaning operations are performed on the data to remove redundant values, etc. After the data is transformed, it is stored in data warehouses. Data Presentation: Now that the data is transformed and cleaned, it is visually presented on the Power BI desktop as reports, dashboards, or scorecards. These reports can be shared via mobile apps or web to various business users

36

What is the role of themes in Power BI?

Reference answer

Themes provide a coherent color and design scheme to your reports and dashboards, enhancing their aesthetic value and improving readability. More importantly, you can use custom themes to align the report's look and feel with your company's branding guidelines. Using themes ensures consistency and professionalism across reports, making them more engaging and easier to interpret.

37

What is a star schema?

Reference answer

A data modeling technique where a central fact table connects to multiple dimension tables for faster queries.

38

How can you improve the performance of a dashboard in Tableau?

Reference answer

In my experience, optimizing the performance of a Tableau dashboard is essential for providing a smooth user experience and ensuring that decision-makers can quickly access the insights they need. Here are some strategies I have found effective for improving dashboard performance: 1. Limit the amount of data: Use filters, aggregations, or data extracts to reduce the amount of data being processed and displayed in the dashboard. This helps speed up rendering and interactivity. 2. Optimize calculations: Review your calculated fields and use more efficient functions or expressions where possible. Try to avoid using row-level calculations or complex table calculations that can slow down performance. 3. Reduce the number of worksheets: Consolidate similar visualizations into a single worksheet or use dashboard actions to show and hide relevant information. This reduces the number of queries Tableau needs to execute when loading the dashboard. 4. Use extracts instead of live connections: Extracts are a snapshot of your data that can be stored locally or on Tableau Server. They are often faster than live connections, especially for large datasets or slow data sources. 5. Optimize dashboard layout and design: Use tiled layout containers instead of floating elements, as they render faster. Also, avoid using heavy custom formatting or unnecessary visual elements that can slow down the dashboard rendering. 6. Leverage Tableau Server features: If you're using Tableau Server, take advantage of features like data source caching, user filters, and performance monitoring to further optimize dashboard performance. In a previous project, I worked on a dashboard with multiple worksheets and a large dataset. By using data extracts, optimizing calculations, and consolidating worksheets, we significantly improved the dashboard performance, making it much more responsive for the end-users.

39

How does Tableau allow you to filter and customize data views?

Reference answer

Tableau allows you to filter data and customize views based on the specific information you need for yourself or to present to managers or clients. You can include or exclude specific data points, select particular headers, filter by date, or choose specific dimensions. You can also use calculations from the data to filter choices based on the total found for the calculations.

40

What are Measures in Tableau?

Reference answer

The data that we can measure or are quantifiable comes under Measures. These numerical metrics remain stored in tables and have foreign keys that uniquely refer to their interconnected dimension tables. For example, an employee table will have an employee ID, customer key, projects delivered, etc., belonging to a specific project or event.

41

In Power BI, how can a custom visual be created?

Reference answer

Based on D3.js and JavaScript, the Power BI Custom Visual SDK allows for the creation of custom visuals. Power BI has built-in visualization tools that developers may augment with custom graphics that can be loaded into dashboards and reports.

42

What are content packs in Power BI?

Reference answer

Content packs are packages comprising different Power BI objects such as reports, dashboards, datasets, etc. The two types of content packs are: Service provider content packs: Service providers such as Google Analytics, Salesforce, etc. provide pre-built content packages User-created content packs: Users can create their content packages and share them within the organization.

43

What is Power Pivot?

Reference answer

Power Pivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook. It lets you create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts. You can then further analyze the data so that you can make timely business decisions without requiring IT assistance.

44

What is the difference between joining and blending in Tableau?

Reference answer

Joining and blending are two ways to combine data from multiple sources in Tableau, but they differ in how they integrate the data. Joining combines data from different tables within the same data source by linking them together based on a common field. Joining creates a new, flattened table by combining the data from the linked tables. Blending, on the other hand, combines data from different data sources by linking them on a common field, but it does not combine the data into a single, flattened table. Instead, blending maintains the separate data sources and queries them independently. Blending is useful when working with large data sets or when maintaining the granularity of individual data sources is necessary.

45

Diff between OLAP & OLTP?

Reference answer

OLAP (Online Analytical Processing) is for complex queries and analysis. OLTP (Online Transaction Processing) is for transaction-oriented applications.

46

What is bin in tableau?

Reference answer

Bins in tableau are containers of equal size used to store data values fitting in bin size. In other words, bins group the data into groups of equal size or data which can be used in systematic viewing of data. All the discrete fields in tableau can also be considered as set of bins.

47

What is Visualization?

Reference answer

Visualization is a process to represent data in pictorial form like tables, graphs, or charts based on the specific requirement.

48

What are the different platforms from where you can pull data to process visualization?

Reference answer

Tableau allows us to connect and pull data from various platforms. Tableau supports data extraction from simple data storage systems such as MS Excel or MS Access and intricate database systems like Oracle. It can also pull data from cloud services like Microsoft Azure SQL database, Amazon Web services, or Google Cloud SQL.

49

Which tool – Power BI or Tableau – offers better integration with SQL Server, and why?

Reference answer

Power BI offers better integration with SQL Server due to native connectors, query folding, and seamless Azure ecosystem support. Tableau also connects well but requires more configuration for optimal performance.

50

How do you stay updated with new Power BI features and data analysis trends? Additionally, can you share how you applied a new feature or trend in a recent project?

Reference answer

I stay updated by following the Microsoft Power BI blog, attending community events like Data Days, and participating in forums such as the Power BI Community. I also take online courses and aim to pass certifications like PL-300. Recently, I applied the new Power BI 'Field Parameters' feature in a sales dashboard to allow users to dynamically switch between measures like revenue, profit, and quantity without creating multiple visuals. This improved dashboard interactivity and reduced maintenance overhead.

51

What are the different connections you can make with your dataset?

Reference answer

We can either connect live to our data set or extract data onto Tableau. Live: Connecting live to a data set leverages its computational processing and storage. New queries will go to the database and will be reflected as new or updated within the data. Extract: An extract will make a static snapshot of the data to be used by Tableau's data engine. The snapshot of the data can be refreshed on a recurring schedule as a whole or incrementally append data. One way to set up these schedules is via the Tableau server. The benefit of Tableau extract over live connection is that extract can be used anywhere without any connection and you can build your own visualization without connecting to database.

52

Explain when would you use Joins vs. Blending in Tableau?

Reference answer

If data resides in a single source, it is always desirable to use Joins. When your data is not in one place blending is the most viable way to create a left join like the connection between your primary and secondary data sources.

53

How can you control mark properties in Tableau?

Reference answer

There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip.

54

How do you aggregate data in Tableau?

Reference answer

Aggregating data in Tableau is an important aspect of data analysis, as it allows you to summarize and analyze data at different levels of granularity. In my experience, there are several ways to aggregate data in Tableau: 1. Using built-in aggregation functions: Tableau provides a range of built-in aggregation functions, such as SUM, AVG, MIN, MAX, COUNT, and MEDIAN. These can be easily applied to measures in your visualization by dragging and dropping the measure onto the view and selecting the desired aggregation function from the drop-down menu. 2. Creating calculated fields: If you need to perform more complex aggregations, you can create calculated fields using Tableau's formula editor. This allows you to define custom aggregations using a combination of built-in functions and operators. 3. Using table calculations: Table calculations are another powerful way to aggregate data in Tableau. They allow you to perform calculations across specific dimensions or measures in your visualization, such as calculating running totals or percent of total. 4. Using level of detail (LOD) expressions: LOD expressions are a powerful feature in Tableau that allows you to perform aggregations at different levels of granularity within a single visualization. By specifying a level of detail in your calculation, you can control how the data is aggregated, independent of the view's level of detail. 5. Aggregating data in the data source: In some cases, it might be more efficient to aggregate data directly in the data source, such as using SQL queries or data preparation tools like Tableau Prep. By choosing the appropriate method for aggregating data in Tableau, I can ensure that my visualizations and analyses are accurate and relevant to the specific questions I'm trying to answer.

55

Name the various operating systems on which developers can run Tableau.

Reference answer

Developers can run Tableau on Windows and Mac operating systems.

56

How does DAX handle data type conversion?

Reference answer

More often than not, the data types in DAX will be converted for you. For example, if you use a string for numeric expression, that string will be transformed into a number if the string is valid. If, however, there is an incompatibility issue in the data, where you have a text data type, and the function needs a date type, it will not work.

57

How do you automate Power BI report deployment across environments (dev, test, prod)?

Reference answer

Use deployment pipelines in Power BI Service. I define workspace stages for dev, test, and prod. Reports, datasets, and settings move between these stages. This avoids manual errors and keeps everything consistent during releases.

58

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

Reference answer

Connection information is the details of data that you want to bring into Tableau. Before publishing it, you can create an extract of the same. Published Data Source: It contains connection information that is independent of any workbook. Embedded Data Source: It contains connection information which is connected to a workbook

59

What is the difference between USERNAME() and USERPRINCIPALNAME()?

Reference answer

Used for dynamic RLS. - USERNAME(): Local machine login - USERPRINCIPALNAME(): Cloud identity (email)

60

How do LOD expressions solve the parallel period comparison problem?

Reference answer

LOD expressions solves the parallel period comparison problem by the following steps: (SUM([Sales]) - [Previous Year Sales]) / [Previous Year Sales] | {FIXED [Customer ID], DATETRUNC('month', [Date Comparison]): SUM([Sales])} | DATEADD('year', -1, [Order Date])

61

Find Top 5 Products by Sales in 2023.

Reference answer

Use a Top N filter in the visual: - Add Product and Total Sales - Apply Top N = 5 by Sales OR in DAX: Top5 Products = TOPN(5, SUMMARIZE(Sales, Sales[Product], "Sales", SUM(Sales[Amount])), [Sales], DESC)

62

What are the different views available in Power BI Desktop?

Reference answer

Power BI Desktop offers four different views to help you work with your data: - Report View: Create and arrange visuals, such as charts and graphs, to build your reports. You can add, format, and customize visuals to present your data insights effectively. - Data View: See the underlying data tables after they are transformed and loaded through Power Query. Inspect, filter, and understand your data before using it in your visuals. You can also create calculated columns in this view. - Relationship View: Define and manage the relationships between different data tables. You can create, edit, and visualize relationships to ensure your data model is accurate and well-structured. - DAX Query View: Query your data in order to understand it better and validate your measures. DAX queries return data from the model in the form of a table. Use the EVALUATE statement to specify what and how data is returned in the query. ? Report View for creating visuals, Data View for inspecting data, and Relationship View for managing relationships inside the model. DAX Query View to return specific data from the model.

63

Append vs Merge

Reference answer

Append: Combine tables vertically. Merge: Join tables horizontally.

64

How do you ensure the accuracy and integrity of the data you use in Tableau?

Reference answer

I ensure data accuracy and integrity by conducting thorough data validation and cleansing processes. Additionally, I implement automated data quality checks and regularly audit data sources to maintain consistency.

65

What types of Tableau files are available?

Reference answer

Various Tableau files are as follows: - Workbooks: Workbooks can contain one or more dashboards and worksheets. - Bookmarks: It is a simple approach to sharing your work quickly and only contains a single spreadsheet. - Packaged workbooks: It contains a workbook supporting local file data and corresponding background images. - Data extraction files: Data extract files are essentially local copies of all or part of the data source. - Data connection files: An XML file containing various connection-related data.

66

What function do themes serve in Power BI?

Reference answer

Power BI themes give reports and dashboards a unified colour scheme, typeface, and formatting. Applying themes at the report or Power BI Service levels enables businesses to give all of their dashboards and reports a unified appearance and feel.

67

Is Power BI free to use?

Reference answer

Power BI is available in two versions: Power BI Free and Power BI Pro. Users can use Power BI for free. However, the Power BI Pro subscription avails more from Microsoft Store. The subscription offers an enhanced version of various features available with the free Power BI account. Most business users use the subscribed account as it provides more data refreshers per day and other features than the free version.

68

What are some advanced features of Tableau that you have utilized in your work?

Reference answer

I have extensively used advanced features like Level of Detail (LOD) expressions to perform complex calculations and data blending to combine disparate data sources seamlessly. These features have enabled me to create highly detailed and accurate visualizations, significantly enhancing our analytical capabilities.

69

What's the difference between INNER JOIN and LEFT JOIN in SQL?

Reference answer

INNER JOIN returns only matching rows from both tables. LEFT JOIN returns all rows from the left table and matching rows from the right, with NULLs for non-matches.

70

Scenario: You are working on a report that needs to be refreshed every hour. How would you configure this in Power BI?

Reference answer

To schedule a report refresh every hour in Power BI, the user can use the scheduling feature. The user needs to navigate to the dataset settings and select the "Scheduled refresh" option, and set the refresh interval to one hour. It's important to ensure that the data source has the necessary permissions for the scheduled refresh to occur.

71

What are Append Queries in Power BI?

Reference answer

Append Queries in Power BI is a feature in Power Query Editor that allows you to combine rows from two or more tables into a single table. It's like stacking tables on top of each other. - Used when tables have similar columns. - Helps consolidate data from multiple sources. - Can append two tables at a time or multiple tables. Syntax Example: Table.Combine({Table1, Table2}) Here: - It combines Table1 and Table2 into a single table. - Resulting table contains all rows from both tables.

72

Can we use unused columns in Tableau filters?

Reference answer

Yes, we can use unused columns in tableau filters. Let us consider one example. In the data source, I have columns like emp_id, emp_name, emp_sal, emp_dep, and emp_designation. But, in reports, I am using emp_name in columns and emp-sal in rows. I can use emp_designation on filters.

73

What function does the Power BI API serve?

Reference answer

Developers may interact with Power BI resources programmatically thanks to the Power BI API, a RESTful web service. The API may be used to manage dashboards and reports, create and update datasets, refresh data, and embed Power BI information into online applications.

74

How to create hierarchy in tableau?

Reference answer

By default, tableau creates some hierarchy of data source based on the values in the fields. There is a custom way to create your own hierarchy. In Data pane just drag a field on top of another field then enter the name of hierarchy in the prompt and press ok. Then you can add additional fields into hierarchy also. Creating a hierarchy can help you to easily scroll through the categories of data you created which may be data based on location such as country, state, city, or region.

75

How can you integrate a Tableau dashboard with a web page or application?

Reference answer

We can integrate Tableau dashboard with web page or application to build dynamic and interactive web pages. The content is included in the web application by embedding options and APIs. Here are the steps to build a dynamic website on this tool: 1. Create and finalize the dashboard in Tableau Desktop. 2. Publish the dashboard to Tableau Server or Tableau Online. 3. Use the Share button to get the embed code. 4. Copy and paste the embed code into the HTML of the web page.

76

State the importance of data servers in Tableau.

Reference answer

There are two functions of a data server in Tableau. One, it allows continuous syncing of all data – from datasets to past calculations, aliases to definitions – on the server which can then be accessed from anywhere. This allows for a more wholesome approach during any given task. Thus, it provides security and fast access. Secondly, having a data server means one does not have to download all the required data to a local machine to run a visualization or a report. It can be pulled easily off the internet through the server.

77

How do you schedule data refreshes in Power BI Service?

Reference answer

Go to the dataset settings in Power BI Service. Under Scheduled Refresh, toggle it on and set the frequency (daily, weekly). Ensure the gateway is configured for on-premises sources.

78

What is view in tableau?

Reference answer

Any visualization created on a data source in a worksheet is known as view. A view can be anything, a plot, a chart, a graph or even a table can be a view. These views are then compiled on a dashboard to create final story and link them to each other.

79

What is an embedded data source in Tableau?

Reference answer

The embedded data source contains connection information but it is associated with the workbooks.

80

What are Data Types in Tableau?

Reference answer

Data types define the kind of data stored in a field, which determines how Tableau interprets and processes it. The main data types in Tableau include String (text), Number (whole or decimal), Date, Date & Time, Boolean (True/False), and Geographic data. Each data type is used differently in analysis and visualization. For example, String is used for text fields like Customer Name, Number is used for numeric values like Sales, and Date is used for time-based analysis. Choosing the correct data type helps Tableau perform accurate calculations and create appropriate visualizations.

81

What is the difference between ‘Append Query' and ‘Merge Query' in Power BI?

Reference answer

In Power BI, Append Query and Merge Query are used to combine data, but they work differently: Append Query: - Adds rows from one table to another. - Use it to stack data from tables with similar structures. Such as combining monthly sales tables into one table. Merge Query: - Combines columns from two tables based on a common key. - Use it to join tables by matching rows using a key column, similar to a SQL join. Such as merging a customer table with an orders table based on CustomerID. ? Append Query adds rows from one table to another. Merge Query combines columns from two tables based on a common key.

82

What is a Dataflow?

Reference answer

Reusable ETL layer in Power BI Service using Power Query Online.

83

What is the FILTER function in DAX?

Reference answer

FILTER is used to extract specific data from a table. Example: FILTER(Sales, Sales[Amount] > 1000)

84

What are the different types of joins in Power BI and their uses?

Reference answer

In Power BI, joins are used in Power Query to combine (merge) data from different tables based on a common key. Here are the main types of joins and their uses: Inner Join - Returns only the rows with matching keys in both tables. - Ideal for finding data that exists in both tables. Such as customers who have made purchases. Left Outer Join - Returns all rows from the left table and the matched rows from the right table. Unmatched rows from the right table will show as null. - Useful for keeping all records from the left table. Such as listing all employees and their departments, including those not assigned to any department. Right Outer Join - Returns all rows from the right table and the matched rows from the left table. Unmatched rows from the left table will show as null. - Useful for keeping all records from the right table. Such as listing all sales regions and their representatives, including regions without representatives. Full Outer Join - Returns all rows when there is a match in either the left or right table. Unmatched rows will show as null from the respective table. - Useful for retaining all records from both tables. Such as combining customer and order tables to see all customers and orders, including those with no matches. Anti Join - Returns rows from one table that do not have a match in the other table. - Useful for finding unmatched records. Such as identifying customers who have not made any purchases. ? In Power BI, different types of joins (Inner, Left Outer, Right Outer, Full Outer, and Anti Join) combine data from tables based on their specific purposes.

85

Why Power BI?

Reference answer

Power BI has simplified the workaround of getting data from various sources and collating them into one tool for proper management. We can share these interactive reports for different industries like retail, for free. Power BI is the new flash word in the data-driven tech industry today. The power BI opportunities are umpteen and spread across versions. With proper knowledge of the tool you can easily grab opportunities as a: Power BI data analyst Power BI developer Power BI software engineer Power BI project manager SQL Server Power BI developer Power BI consultant With good compensation, you get to work with a product's data and learn about its insights to make important decisions. Not just this, with the latest Gartner's BI and Analytics report, Power BI has emerged as the winner. With so much hype, learning Power BI is worth it.

86

How do you reshape data in Power BI?

Reference answer

Power BI offers a wide variety of data source connectivity options. Data Editor is one of the tools used to manipulate rows and columns of the data and helps you reshape it according to the requirements. With that, you have come to an end to this tutorial on “Top 50 Power BI Interview Questions and Answers for 2021”.

87

What is analysis in tableau?

Reference answer

Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.

88

What is a .twbx file in Tableau?

Reference answer

.twbx: It is a compressed file, where you have all files. It includes data source files, twb, and other files to produce the workbook. TWBX is obsolete for sharing because it will share the copy of the file instead of an original source file. .twbx is used for reports and we can view them using the Tableau viewer.

89

Difference between a calculated column and a measure.

Reference answer

A calculated column is computed row by row and stored in the model. A measure is calculated on the fly based on filter context and is not stored.

90

Can SQL and Power Query/Query Editor be used together?

Reference answer

Yes, a SQL statement can be defined as the source of a Power Query/M function for additional processing/logic. This would be a good practice to ensure that an efficient database query is passed to the source and avoid unnecessary processing and complexity by the client machine and M function.

91

How do you create relationships between multiple tables with ambiguous keys?

Reference answer

I analyze the data to understand key relationships. If keys are ambiguous, I create a bridge table or use composite keys. I also use DAX functions like TREATAS to handle complex mappings.

92

How do you use dashboard actions in Tableau?

Reference answer

Dashboard actions in Tableau are interactive elements that enable users to engage with the dashboard and drive insights. They allow users to perform tasks such as filtering, highlighting, or navigating to other sheets or dashboards. I often use dashboard actions to create a more dynamic and interactive experience for users. Here's how I typically use dashboard actions in Tableau: 1. Filter action: I like to think of this as a way to allow users to click on a data point in one view and have it filter the data in another view. To create a filter action, go to Dashboard -> Actions -> Add Action -> Filter, and configure the source and target sheets along with the desired filter behavior. 2. Highlight action: This is useful when I want users to be able to click on a data point in one view and highlight related data points in other views. To create a highlight action, go to Dashboard -> Actions -> Add Action -> Highlight, and configure the source and target sheets along with the desired fields to highlight. 3. URL action: I use this when I want to link to external resources, such as a webpage or a file. To create a URL action, go to Dashboard -> Actions -> Add Action -> Go to URL, and configure the source sheet and the URL template with the desired fields. 4. Navigation action: This helps me create a more guided analysis experience by allowing users to navigate between sheets or dashboards based on their selections. To create a navigation action, go to Dashboard -> Actions -> Add Action -> Go to Sheet, and configure the source sheet and target sheet or dashboard. By incorporating these dashboard actions, I can create a more engaging and interactive experience for users, enabling them to explore and analyze the data in a more intuitive way.

93

What are the limitations of tableau?

Reference answer

Tableau provides limited data pre processing because it is mainly designed for data visualizations. The layout of dashboards gets disturbed when opened on a different resolution screen. Price of Tableau is also high and they do not provide any custom plans for enterprises based on their requirements. For free users using Tableau and publishing their work on tableau public can create security issues as it does not provide any security to files uploaded on tableau public server.

94

What is a Slowly ever-changing dimension?

Reference answer

Slowly ever-changing dimension: The value of the dimension changes over an amount of time for slowly ever-changing dimensions. Example – student of worker

95

How does AIR reduce time-to-hire?

Reference answer

AIR reduces time-to-hire by 80% through conversational voice interviews, resume matching & stack ranking, customizable scoring frameworks, and enterprise-scale assessments in 16+ languages.

96

What happens when you click the Infocus mode of a tile on the PowerBI dashboard on the browser?

Reference answer

When you click the Infocus mode of a tile on the PowerBI dashboard on the browser, the selected tile expands and takes the full space

97

What are the key principles of effective data visualization in Tableau?

Reference answer

From what I've seen, effective data visualization in Tableau is about communicating information clearly and efficiently so that the audience can easily understand the insights and make informed decisions. In my experience, there are several key principles to follow: 1. Choose the right chart type: Select the most appropriate visualization based on the data and the story you want to tell. For example, use bar charts for comparing discrete categories, line charts for time series data, and scatter plots for showing relationships between two measures. 2. Keep it simple: Avoid clutter and unnecessary elements in your visualizations. Stick to a clean design that focuses on the data and helps the audience quickly grasp the insights. 3. Use color effectively: Use color to highlight key data points, emphasize patterns, or differentiate categories. Be mindful of colorblind users and choose accessible color palettes. 4. Label and annotate: Provide clear labels and annotations to guide the audience through the visualization, making it easy to understand the axes, legends, and data points. 5. Arrange the dashboard logically: Organize your visualizations in a logical flow, so the audience can easily follow the story and find the information they need. 6. Be mindful of data granularity: Ensure that the level of detail in your visualizations matches the needs of the audience and the insights you want to convey. One useful analogy I like to remember is to think of data visualization as a form of visual storytelling. By following these principles, you can create compelling and effective visualizations that help your audience understand the data and make better decisions.

98

Is Power BI a good career?

Reference answer

Five major reasons why Power BI will create a good career path for you: Gartner's framework for the Analytics and BI Magic Quadrant 2021. There is a big market for Microsoft Power BI Consultants in almost every industry. In perspective, Qlik and Tableau (both high in Gartner ranking) have a market cap close to 1% of Microsoft. Top companies offering lucrative Power BI career opportunities. Variety of job roles available: Power BI Analyst/Developer Data Analyst Business Analyst Business Intelligence Analyst Business Intelligence Developer Business Intelligence Manager

99

What is forecasting in Tableau? Which method does Tableau provide to perform forecasting?

Reference answer

Forecasting predicts a measure's future value (rate, cost, and other numerical estimations). There are various types of data forecasting mechanisms available in data analysis; however, Tableau offers only the exponential smoothing forecasting method.

100

How to set up Auto-refresh in Power BI?

Reference answer

Auto-refresh can be done using the Power BI Service. First, go to the dataset settings in Power BI Service. Configure the refresh schedule by setting the frequency, such as daily or weekly. Ensure your data source credentials are correctly entered. ? Use the refresh schedule in Power BI Service to keep data automatically up to date.

101

What is a measure in Power BI?

Reference answer

A measure in Power BI is a dynamic calculation created using DAX (Data Analysis Expressions) formulas. Unlike calculated columns, measures are not stored in your data model. Instead, they are calculated on the fly when used in reports. This makes them highly flexible for performing calculations like sums, averages, and more complex aggregations based on the current context of your report. Measures are crucial for dynamic data analysis. For example, you can create a measure to calculate total sales, average sales per region, or year-over-year growth. Then, you can use these in any visual or report. ? A measure in Power BI uses DAX for dynamic calculations, evaluated on the fly in reports.

102

How do you manage and optimize relationships in a complex data model?

Reference answer

I use a star schema with one-to-many relationships from dimension to fact tables. I avoid bi-directional filters unless necessary. I also hide foreign key columns and use hierarchies to simplify navigation. Performance is monitored via DAX Studio.

103

How can you publish a Power BI report?

Reference answer

To publish a Power BI report, you can use the Power BI Service to upload the report file created in Power BI Desktop. Once the report is uploaded, it can be shared with others and accessed from anywhere with an internet connection.

104

How do you implement row-level security in Tableau?

Reference answer

Row-level security in Tableau is implemented by restricting data access based on user roles or attributes. This is done by creating filters in the data source or calculated fields that use user functions like USERNAME() to dynamically control what data each user can view. Publishing data sources with embedded security filters ensures consistency across workbooks and dashboards.

105

Explain the difference between SUM and SUMX in DAX.

Reference answer

SUM adds up a column directly. SUMX evaluates an expression for each row, then sums the result. SUMX is more flexible when calculations need logic per row.

106

Mention what are different Tableau files?

Reference answer

Different Tableau files include: Workbooks: Workbooks hold one or more worksheets and dashboards Bookmarks: It contains a single worksheet and its an easy way to quickly share your work Packaged Workbooks: It contains a workbook along with any supporting local file data and background images Data Extraction Files: Extract files are a local copy of a subset or entire data source Data Connection Files: It's a small XML file with various connection information

107

How do you embed a Tableau view into a web page?

Reference answer

Views can be embedded by Tableau server and online on web pages, applications, blogs and portals. Embedding a view into a web page includes clicking on the share button from the top of the view > copy and paste embed code on the web page. This view can only be seen by creating an account on the server.

108

How to apply a context filter in Tableau?

Reference answer

Step 1: Drag the subcategory dimensions to the row shelf and measure sales to the column shelf. Now choose the horizontal bar chart as chart type and again drag the sub-category dimensions to the filter shelf. Then we will get the following chart. Step 2: Right-click on the Sub-Category field in the filter shelf and go to the Top fourth tab. Choose the option field, from the next drop-down and choose the option Top 10 by Sales Sum as shown in the following screenshot. Step 3: Drag the dimension Category to the filter shelf. Right-click on the general tab to edit and under that choose Furniture from the list. As you can see the result shows three subcategories of products. Step 4: Right-click the Category: Furniture filter and select the option Add to Context. This produces the final result, which shows the subcategory of products from the category Furniture which are among the top 10 subcategories across all the products.

109

What is a KPI in Power BI?

Reference answer

A KPI visual displays progress toward a target, helping monitor key business metrics.

110

Can you provide an example of how you used data densification in your work?

Reference answer

An example where I used data densification was when I had to analyze website traffic data with missing days due to tracking errors. By using domain padding, I was able to create a continuous timeline in Tableau, which helped me better understand the overall traffic trends and identify potential issues with the tracking system.

111

Where do you reshape data in Power BI?

Reference answer

The data can be reshaped in Data Editing of PowerBI.

112

What is the difference between Relationships and Joins in Tableau?

Reference answer

Relationships and Joins are both used to combine multiple tables in Tableau, but they work at different levels. Relationships work at the logical layer, where tables remain separate and Tableau decides how to combine the data dynamically during analysis. This approach preserves the original structure of each table and helps avoid unnecessary duplication of data. It is especially useful when working with tables that have different levels of detail. On the other hand, Joins work at the physical layer, where tables are merged into a single table before analysis. The join is performed based on a common field, and types of joins include Inner Join, Left Join, Right Join, and Full Join. Since the tables are physically combined, joins can sometimes create duplicate rows or affect the data if the relationship between tables is not handled properly. Relationships are generally preferred in modern Tableau because they provide more flexibility and maintain data integrity.

113

What are some best practices for designing Tableau dashboards?

Reference answer

A fairly common question that comes up during Tableau interviews is about dashboard design. Make sure to discuss key points, like designing with the audience in mind, eliminating clutter, using colors and shapes strategically, as well as using the right kind of chart for the information you're looking to convey. Another important aspect is the ability to control user flow in a dashboard. The user shouldn't feel "stuck" at any point of using the dashboard. Instead, the dashboard should be designed in a way that allows the user to seamlessly click into a tile, drill-down into it, expand the data into a new view, and return back to the home page. For more design tips, check out our blog post on Best Practices for Designing Dashboards.

114

List a few business intelligence tools that are compatible with Tableau.

Reference answer

Google Analytics, Microsoft Power BI, and IBM Watson are a few examples of traditional BI tools that are compatible with Tableau.

115

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.

116

What are the key DAX concepts?

Reference answer

Some of the key DAX concepts are contexts, functions, and syntaxes: Context. A row context applies to a particular row in a table when a formula's function affects the row. In contrast, filter context applies when you apply several filters to a calculation. Function. Functions refer to values or “arguments” used in a certain order to carry out a computation. There are a few different categories such as statistical, date or time, and logical. Syntax. Syntax rules apply when creating a formula. If you're not paying attention to the syntax, you might receive an error message.

117

What is the difference between a left join and an inner join in Power BI?

Reference answer

A left join returns all the rows from the left table and matching rows from the right table, while an inner join returns only the matching rows from both tables. Left joins are used to include all the rows from one table, even if there is no matching data in the other table, while inner joins are used to include only the rows that have matching data in both tables.

118

Find Year-over-Year (YoY) Growth in Sales.

Reference answer

We can write dax query like: YoY Sales Growth = DIVIDE( [Total Sales] - CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Date[Date])), CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Date[Date])) )

119

What are the different connectivity modes in Power BI?

Reference answer

The three major connectivity modes in Power BI are: Direct Query: The method allows direct connection to the Power BI model. The data doesn't get stored in Power BI. Interestingly, Power BI will only store the metadata of the data tables involved and not the actual data. The supported sources of data query are: - Amazon Redshift - Azure HDInsight Spark (Beta) - Azure SQL Database - Azure SQL Data Warehouse - IBM Netezza (Beta) - Impala (version 2.x) - Oracle Database (version 12 and above) - SAP Business Warehouse (Beta) - SAP HANA - Snowflake - Spark (Beta) (version 0.9 and above) - SQL Server - Teradata Database Live Connection: Live connection is analogous to the direct query method as it doesn't store any data in Power BI either. But opposed to the direct query method, it is a direct connection to the analysis services model. Also, the supported data sources with live connection method are limited: - SQL Server Analysis Services (SSAS) Tabular - SQL Server Analysis Services (SSAS) Multi-Dimensional - Power BI Service Import Data (Scheduled Refresh): By choosing this method, you upload the data into Power BI. Uploading data on Power BI means consuming the memory space of your Power BI desktop. If it is on the website, it consumes the space of the Power BI cloud machine. Even though it is the fastest method, the maximum size of the file to be uploaded cannot exceed 1 GB until and unless you have Power BI premium (then you have 50 GB at the expense). But which model to choose when depends on your use and purpose.

120

In Power BI, how can you plan a data refresh?

Reference answer

The Power BI Service allows you to schedule a data refresh in Power BI. You can set the time of day, the timezone, and the refresh frequency (daily, weekly, etc.) in the dataset settings. You can also utilize the Power BI API to dynamically check the refresh status or set up email alerts for refresh failures.

121

What are the three basic concepts of DAX?

Reference answer

The three core fundamental concepts of DAX are Syntax, Functions, and Context: - Syntax: It is the formula that involves functions. The result will show a syntax error if you type the wrong syntax. - Function: These are arguments filled in Syntax to give a specific order. - Context: Contexts are two types – Row Context and Filter Context. Row Context is applied to find a row in a table, and Filter Context is used when more than one value is applied to obtain a value.

122

What are sets and groups?

Reference answer

Sets and groups are used group data based on some specific conditions. The main difference between these two is that a group can divide the dataset into multiple groups whereas a set can have only two options which is either in or out. A user should choose to apply group or sets based on the requirements.

123

What is the difference between a slicer and a filter in Power BI?

Reference answer

In Power BI, a slicer is an interactive visual tool that lets users filter data on a report page. Slicers can be dropdowns, checkboxes, or buttons. Users click them to filter visuals on the same page. By editing interactions, you can control which visuals are controlled by slicers. By syncing slicers, you can make them active across the report. They are highly interactive and visible to users. Filters, on the other hand, can be set in the background to control what data is included in the report visualizations. Users can change filters from the filter pane unless they're locked. Filters are less prominent and less intuitive compared to slicers. Filters, can be applied at different levels: - Visual-Level: Controls data for a specific visual. - Page-Level: Affects all visuals on a single report page. - Report-Level: Applies to all pages in the report, providing broader data control. While slicers are highly interactive and visible to users, filters can be set in the background to control the data without being as prominently displayed in the report visualization. ? The main difference between slicers and filters lies in their visibility and user interactions. Slicers are interactive tools for filtering data on a report page. They're part of the report canvas. Filters can be applied from a side pane at visual, page, or report levels and can be set in the background.

124

What is Tableau Pulse?

Reference answer

Tableau Pulse is an AI-powered insight experience designed to proactively deliver personalized metrics and insights to users. This means you can receive automated explanations, trend detection, and contextual insights driven by AI. No need for manually exploring dashboards. This helps business users focus more on decision-making rather than data exploration. It provides different features, including: - Automated insights and trend detection. - Personalized metrics based on user role. - Contextual explanations for data changes.

125

What is an embedded data source? How is it different from a published data source?

Reference answer

An embedded data source contains information that is connected to a workbook. A published data source works independently.

126

How do you collaborate with business users or data teams when building reports?

Reference answer

I start with requirement gathering sessions to understand KPIs and data sources. I share wireframes for feedback, use shared datasets for consistency, and conduct UAT sessions. Regular check-ins ensure alignment with business needs.

127

What is Power Pivot?

Reference answer

Power Pivot enables you to import millions of rows from heterogeneous sources of data into a single excel sheet. It lets us create relationships between the various tables, create columns, calculate using formulas, and create PivotCharts and PivotTables. At a time there can be only one active relationship between the tables which is represented by a continuous line.

128

What do you understand by Business Intelligence?

Reference answer

Business Intelligence is a method that utilizes technology for data analysis and information delivery to leaders, managers and employees in making strategic business decisions. As part of the BI process, organizations gather data from internal IT systems and external sources, prepare it for analysis, run queries against the data, create data visualizations, BI dashboards and reports and then make the analytics results for making decision related to operations and strategic planning.

129

How do filters and slicers work in Power BI?

Reference answer

Filters and slicers are two essential elements in Power BI that you use to refine the data shown in visuals. - Filter: Applied to an entire report or visual, allowing you to include or exclude data based on specific conditions. For example, you might filter a sales report to only show transactions from a particular region or period - Slicer: A type of filter that is applied on the canvas and makes it easier for report users to filter the data the way they want. A slicer can be used to filter the data in visuals, charts, or tables While both filters and slicers serve to limit the data that's displayed, slicers are meant to be used interactively on a report canvas, providing a more user-friendly filtering experience. Using these tools effectively ensures that users can explore and analyze data in a way that meets their specific needs, enhancing the interactivity and usability of reports.

130

What are the different types of relationships in Power BI?

Reference answer

In Power BI, relationships define how data tables are connected. There are three main types: One-to-One (1:1) - Each row in one table is related to one row in another table. - Example: Linking an employee table to an employee details table where each employee ID is unique in both tables. - Generally, it's good practice to merge such tables into a single table. One-to-Many (1:*) - Each row in one table can be related to multiple rows in another table. - Example: Linking a customer table to an orders table where each customer can have multiple orders. Many-to-Many (*:*) - Rows in one table can relate to multiple rows in another table and vice versa. - Example: Linking a student table to a courses table. Students can enroll in many courses and courses can have many students. ? In Power BI, relationships connect tables in three main ways: One-to-One, One-to-Many, and Many-to-Many.

131

What is Power BI Desktop?

Reference answer

Power BI Desktop is the main application I use for working with Power BI. It's an all-in-one workspace where I can connect to data, clean it, build data models, and create visuals and interactive reports from scratch. Beyond just cleaning data, Desktop lets me model relationships between datasets, build custom formulas with DAX, and design polished reports that I can publish directly to Power BI Service. It brings together all the key Power BI features in a single, easy-to-use desktop interface.

132

How to schedule a report refresh in Tableau?

Reference answer

When we are publishing the reports to Tableau Server, there we will find an option to schedule the report, just select the time when you want to refresh the data.

133

What are user roles in Tableau Server?

Reference answer

User roles in the Tableau data server provide access privileges to different sensitive data. Each level and user role has its terms of accessibility of data. Tableau offers different types of user roles like - Site Administrator - Server Administrator - Interactor - Publisher - Unlicensed - Viewer

134

How do you approach data blending and integration in Tableau?

Reference answer

In a customer 360 view, CRM data lived in Salesforce, transactions in Postgres. I created a Tableau relationship on Customer_ID and let each source maintain its own level of detail, which preserved row integrity and simplified calcs compared to traditional blending. When lag appeared, I materialized a unified view in Snowflake and switched Tableau to a single extract.

135

Diff between Merge & Append Queries?

Reference answer

Merge combines columns from two tables based on a matching key. Append stacks rows from two tables vertically.

136

What are the main components of the Power BI toolkit?

Reference answer

The main components of the Power BI toolkit include: - Power Query: Helps you easily connect to multiple data sources, clean and transform raw data, and prepare it for analysis. - Power Pivot: Allows you to create advanced data models, define relationships between datasets, and perform powerful calculations using the DAX language. - Power Map: Lets you create visually engaging 3D maps, making it easier to analyze and communicate location-based or geographic data clearly. - Power Q&A: A feature that lets users ask natural-language questions directly about their data and receive instant, intuitive visual answers without complex queries. - Power View: Enables you to build interactive visuals quickly (e.g., charts, graphs, and maps) so users can easily explore and interpret data.

137

What are KPIs in Power BI?

Reference answer

KPIs (key performance indicators), are essential visual indicators that show the progress that has been made when working towards a goal. They help businesses establish their target and base values when working towards a goal and also indicate the status threshold, i.e. the difference between lower and higher thresholds.

138

What is assume referential integrity in tableau?

Reference answer

Assume referential integrity is useful in cases where you know that two data sources have same references in a column. Then you can use the assume referential integrity feature to define the relation between both the data sources and perform a join on two data sources. To implement referential integrity, drop second table on side of the first table and then it will ask you to match the column to perform join then select the reference column and tableau will join based on the reference and type of join provided.

139

When do we use Joins, Relationships, and Data Blending in Tableau?

Reference answer

Joins are used when multiple tables come from the same data source and need to be physically combined into a single table before analysis. They are useful when you need row-level data from multiple tables and want to merge them using a common key such as Customer ID or Order ID. Relationships are used when tables should remain separate but still be connected logically. Tableau combines the tables dynamically during analysis based on the fields used in the view. Relationships are preferred when working with tables that have different levels of detail, as they help avoid data duplication. Data blending is used when data comes from different data sources that cannot be directly joined. In this case, one data source acts as the primary source and the other as the secondary source, and the data is combined at the visualization level using a common field. Union is used when you want to combine data from tables that have the same structure, such as adding rows from multiple files or tables into one dataset. This is useful when data is stored in separate files or tables but has the same columns. Joins combine tables physically, relationships connect tables logically, data blending combines data from different sources, and unions stack similar tables by rows.

140

Can you provide an example of a Tableau dashboard you created that had a significant impact on business decisions?

Reference answer

At my previous role with Telstra, I developed a Tableau dashboard that integrated sales and customer service data to track KPIs across departments. The dashboard allowed managers to visualize trends and identify areas needing improvement. After implementation, we saw a 25% increase in sales team performance due to targeted training based on insights drawn from the dashboard. User feedback highlighted its ease of use, prompting me to continually refine visualizations for better clarity.

141

What is RLS & how did you implement it?

Reference answer

RLS limits data access. Implemented using roles in Desktop + dynamic RLS with USERPRINCIPALNAME() in Service.

142

How can you view a SQL file generated by Tableau Desktop?

Reference answer

The developer or software engineer can click the My Tableau Repository folder by navigating the My documents from the PC. Here, the developer can find the SQL file. If the developer or the software engineer uses the live connection to the data source, they must check for the log.txt or tabprotosrv.txt files to witness the Tableau-generated SQL.

143

How would you create a sales dashboard for a retail company?

Reference answer

Connect Power BI to sales databases. Clean data using Power Query. Create measures for revenue, profit, and sales growth. Use visuals like bar charts, line graphs, and slicers.

144

How do you ensure data quality and accuracy in your Tableau dashboards?

Reference answer

At Oracle, I implemented a comprehensive data validation process for our Tableau dashboards. Before importing data, I worked closely with the data engineering team to ensure data integrity, applying ETL processes for cleaning and transformation. I documented all data sources and transformations meticulously and set up regular audits to monitor data quality. This proactive approach helped us maintain a 98% accuracy rate in our dashboards, ensuring decision-makers relied on precise insights.

145

Can we have two active relationships between two tables in Power BI?

Reference answer

No, you cannot have two active relationships between two tables in Power BI at the same time. Power BI allows only one active relationship between any two tables. However, you can have multiple inactive relationships. These can be activated in specific DAX calculations using the USERELATIONSHIP function.

146

How do you write a SQL query to find duplicate records in a table?

Reference answer

SELECT column1, column2, COUNT(*) FROM table GROUP BY column1, column2 HAVING COUNT(*) > 1;

147

Difference Between Power View and Power Map?

Reference answer

| Aspect | Power View | Power Map | |---|---|---| | Purpose | Used for creating interactive reports and dashboards. | Used for 3D geographical data visualization. | | Visualization Style | Tables, charts, cards, maps and interactive visuals. | 3D maps, globe view and time-based animations. | | Focus | Focuses on data analysis and storytelling through visuals. | Focuses on geospatial analysis (data across locations and over time). | | Interactivity | Highly interactive with filtering, slicing and drill-down. | Allows exploration of data over time and geography. | | Integration | Part of Excel add-ins and connected with Power BI for reports. | Available as an Excel add-in (later called 3D Maps). |

148

How to embed views onto Webpages?

Reference answer

You can embed interactive Tableau views and dashboards into web pages, blogs, wiki pages, web applications, and intranet portals. Embedded views update as the underlying data changes, or as their workbooks are updated on Tableau Server. Embedded views follow the same licensing and permission restrictions used on Tableau Server. That is, to see a Tableau view that's embedded in a web page, the person accessing the view must also have an account on Tableau Server. Alternatively, if your organization uses a core-based license on Tableau Server, a Guest account is available. This allows people in your organization to view and interact with Tableau views embedded in web pages without having to sign in to the server. Contact your server or site administrator to find out if the Guest user is enabled for the site you publish to. You can do the following to embed views and adjust their default appearance: Get the embed code provided with a view: The Share button at the top of each view includes embed code that you can copy and paste into your webpage. (The Share button doesn't appear in embedded views if you change the showShareOptions parameter to false in the code.) Customize the embed code: You can customize the embed code using parameters that control the toolbar, tabs, and more. For more information, see Parameters for Embed Code. Use the Tableau JavaScript API: Web developers can use Tableau JavaScript objects in web applications. To get access to the API, documentation, code examples, and the Tableau developer community, see the Tableau Developer Portal.

149

How can you create a calculated hierarchy in Power BI?

Reference answer

To create a calculated hierarchy in Power BI, you can use the "New Hierarchy" option in the "Fields" pane and select the columns that you want to include in the hierarchy. Once the hierarchy is created, you can use it to group data in your visualizations and reports.

150

How to create a calculated field in Tableau?

Reference answer

Step 1: Select Analysis -> drop down will open -> Select Create calculated field Step 2: The Calculation Editor Box will open, and give the name to the calculated field. Step 3: Enter a formula in the calculation editor. Example: Sum(Profits)/Sum(Sales). (Calculation Editor validates the formula) Step 4: Click, OK. Now, the new calculated field added to the data pane.

151

What is query folding in Power Query? Why is it important, and how do you verify it?

Reference answer

I think of query folding as Power Query pushing work back to the source system instead of doing it inside Power BI. When query folding happens, Power Query translates my transformation steps into a native query, usually SQL, and executes it on the database server. That means filtering, grouping, or joining happens at the source. Power BI only imports the final result. If folding does not happen, Power BI first pulls all the raw data into memory and then applies transformations locally. On large datasets, this increases refresh time and memory usage significantly. For example, if I filter a 100-million-row SQL table down to one year of data and folding works, the SQL server returns only that one year. If folding breaks early, Power BI downloads all 100 million rows first and then filters them locally. That difference directly affects performance. Most basic transformations fold when using relational sources like SQL Server, Oracle, or PostgreSQL. Filtering rows, removing columns, sorting, grouping, joins, and simple data type changes usually fold. Folding often breaks when I add complex custom columns using M functions, merge with a non-relational source like Excel, or use functions like Table.Buffer(). Some pivot and unpivot operations can also break folding depending on the source. Step order matters. I always place foldable steps first, filtering rows and removing unnecessary columns early in the query. I push complex transformations to the end. Once folding breaks at a certain step, all steps after that run inside Power BI. To verify folding, I right-click a step in Power Query and choose "View Native Query." If the option is available, that step still folds. If it's grayed out, folding has already broken at that stage. Query folding only works with relational data sources. Excel, CSV, and SharePoint files do not support native query translation in the same way, so transformations on those sources always run locally. For deeper analysis, I use Query Diagnostics to monitor refresh behavior and understand where time is spent. That helps identify whether the bottleneck is at the source system or inside the Power BI engine. So I treat query folding as a performance lever. If I preserve it, refresh is faster and more efficient. If I break it too early, I shift unnecessary load into Power BI.

152

Are Power View and Power Query the same?

Reference answer

Power View can be used to download data to Excel as well as make nice transformations. Example: Filter, merge multiple sources, calculate, etc. Power View enables you to present the data in reports

153

What skills are needed to use Power BI effectively?

Reference answer

In addition to analytical skills, to use Power BI you also need technical knowledge and knowledge of algorithms. You also need coding, numerical reasoning, and mathematical skills. A good understanding of the principles of business intelligence will also be very helpful.

154

What is the difference between a calculated column and a measure in Power BI? When should you use each?

Reference answer

I decide between a calculated column and a measure based on when the calculation should run and whether it needs to respond to filters. A calculated column is computed during data refresh. Power BI stores the result in the model as a physical column. Every row gets a value, and that value does not change unless the dataset refreshes. A measure, on the other hand, is computed at query time. Power BI evaluates it only when a visual needs it. It is not stored in the model. It calculates dynamically based on the current filter context. The difference becomes clearer when you think about the evaluation context. A calculated column has row context by default. It evaluates one row at a time during refresh. A measure works in a filter context. Its result changes depending on slicers, filters, and the level of aggregation in the visual. I use a calculated column when: - I need the result available as a field in a slicer, filter, or axis. - The value is fixed per row, such as concatenating First Name and Last Name. - I need the column to participate in relationships. - The logic describes something inherent to each row, like profit per transaction. I use a measure when: - I need aggregations like SUM, AVERAGE, COUNT, or ratios. - The result must change when users apply slicers. - I'm building time intelligence calculations like YoY or MoM. - The calculation depends on the filter context. A common mistake is using calculated columns for aggregations. For example, creating a column that computes total sales per customer and then summing that column in a visual. It may appear correct at first, but it doesn't truly respect the dynamic filter context the way a measure does. Measures are recalculated at every level of aggregation, which is what you usually want in reports. There's also a model size impact. Calculated columns increase memory usage because their values are stored. On large tables, which can significantly increase the dataset size. Measures do not consume storage the same way because they are computed on demand. So what I really think is: If the value belongs to each row and doesn't need to change based on interaction, I use a calculated column. If the value should respond to filters, slicers, or aggregation levels, I use a measure.

155

Which Tableau data visualization technique will you use for the following scenarios? - For showing the time span or duration of any activity. - For displaying aggregate book sales from January to October - For presenting quarter-wise revenue growth

Reference answer

- We can use a Gantt chart to show any activity's time span or duration. - We can use a Treemap to display a particular duration's aggregate book sales. - We can use the waterfall chart to present the quarterly revenue growth.

156

What is the Page shelf in Tableau?

Reference answer

Page shelf is a customizable feature for breaking views into different pages. It is customized according to different factors. It shows an alternative view of each page after performing this feature. This method analyzes the way the page is affecting the other data.

157

How do you pivot data in Tableau?

Reference answer

Pivoting data in Tableau is a useful technique for transforming data from a wide format to a long format, making it easier to analyze and visualize. In my experience, there are two main ways to pivot data in Tableau: 1. Pivoting data in the data source: When connecting to a data source, you can pivot your data directly in the Data Source tab. To do this, you simply select the columns you want to pivot, right-click, and choose "Pivot". This will create a new table with two columns: one for the pivoted field names and one for the corresponding values. 2. Pivoting data using a calculated field: If you need to pivot data that is already in your visualization, you can create a calculated field to achieve this. This involves using a combination of IF statements and aggregation functions to create a new field that represents the pivoted data. For example, let's say I have a dataset with columns for "Product", "Sales", and "Profit", and I want to pivot the "Sales" and "Profit" columns into a single "Value" column. I would create a calculated field like this: ```IF [Measure Type] = 'Sales' THEN [Sales]ELSEIF [Measure Type] = 'Profit' THEN [Profit]END``` Then, I would use this calculated field in my visualization, along with a new dimension called "Measure Type" that contains the values "Sales" and "Profit". By pivoting data in Tableau, I can easily restructure my data to better suit the needs of my analysis and visualization, ultimately leading to more insightful and meaningful results.

158

What is Power Pivot?

Reference answer

Power Pivot is an add-on provided by Microsoft for Excel since 2010. Power Pivot was designed to extend the analytical capabilities and services of Microsoft Excel.

159

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

Reference answer

A data model is a collection of tables, relationships, and calculations that define the structure of the data in Power BI. A data source, on the other hand, is the physical location where the data is stored, such as a database, file, or web service.

160

What is the difference between a waterfall chart and a stacked bar chart in Power BI?

Reference answer

A waterfall chart is a chart that shows the change in value for each category using columns that are either positive or negative, while a stacked bar chart is a chart that shows the composition of each category using stacked bars. Waterfall charts are typically used to show the change in value over time, while stacked bar charts are used to show the composition of each category.

161

What should you do if pre-packaged visual files fail to align with your needs?

Reference answer

In certain situations, you might need to use a visual file when the pre-packaged ones fail to align with your needs. For this, you might hire a developer to build one for you, which can be imported and used to visualize critical information for your team.

162

What is an area chart in Tableau?

Reference answer

An area chart is nothing but a line chart, the area between the x-axis and lines will be color or patterns. These charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

163

What are calculated tables and how do they differ from calculated columns?

Reference answer

Calculated tables are new tables created using DAX, stored in the model, and used for relationships or lookup purposes. A calculated column adds a new column to an existing table, storing values row by row. Calculated tables consume more memory but are useful for bridging or filtering.

164

What are Dimensions in Tableau?

Reference answer

Dimensions are descriptive attributes of data. Those will be stored in the dimensions table. For example, customer information like name, number, and email will be stored in the dimension table.

165

What's the difference between joining and blending?

Reference answer

| Basis | Joining | Blending | |---|---|---| | Data Source | Works with tables from the same data source. | Works with tables from different data sources. | | Relationships | Requires a common field (like ID) to link tables. | Links data on-the-fly using matching fields and no predefined relationship needed. | | Data Combining | Produces a single merged table with all relevant fields. | Keeps sources separate and combines them at query time for visualization. | | Data Transformation | Can perform calculations and aggregations across joined tables. | Can perform calculations within a single source but not across blended sources. | | Performance | Faster and uses database processing. | Slower and combines data at runtime, especially for large datasets. |

166

Explain the concepts of relationship defining and types in Power BI

Reference answer

Defining relationships between tables allows you to create meaningful insights by connecting related data across multiple tables. For example You might define a relationship between a Sales table and a Products table using the Product ID field that's common to both. Power BI supports three types of relationships: - One-to-one: Each row in Table A corresponds to one row in Table B, and vice versa - One-to-many: Each row in Table A can relate to multiple rows in Table B, but each row in Table B relates to only one row in Table A - Many-to-one: Each row in Table A can relate to only one row in Table B, but each row in Table B can relate to multiple rows in Table A Properly defining relationships ensures accurate data modeling and meaningful analysis, which is crucial for reliable insights.

167

What is the difference between Power BI and Tableau?

Reference answer

| Basis | Tableau | Power BI | |---|---|---| | Provider | Salesforce-owned and integrates with Salesforce. | Microsoft product and integrates with Excel, SQL Server, Azure. | | Ease of Use | Steeper learning curve, advanced analytics. | User-friendly, easier for beginners. | | Data Connectivity | Many databases, online services, cloud platforms. | Native connectors, especially Microsoft apps, plus custom connectors. | | Visualization | Complex visuals, high customization. | Interactive dashboards, simpler analytics. | | Collaboration | Tableau Server/Online, fine-grained access. | Power BI Service, integrates with Teams & SharePoint. |

168

How will you visualize overseas sales using Power BI?

Reference answer

- Indicate overseas using map visuals. - Take a map visualization and include a country column with bubble size for sales. - Add product names to map 1 (with product name column) and map 2 (without product name column).

169

What is the M language in Power Query?

Reference answer

The M language is the programming language behind Power Query, a key component of Power BI that is used for data extraction and transformation. "M" stands for "mashup," signifying that this language is designed to combine, transform, and clean data from various sources. You might be asked to write a few lines of "M language" during your interview, so it is worthwhile to get comfortable with it. For example You could create a new custom column with "M language" using a simple formula like this: = Table.AddColumn(Source, "Custom", each [Column1] + [Column2]) Understanding M language allows for more advanced and customized data transformations, enhancing your ability to prepare data for analysis.

170

How do you validate and test data accuracy in Power BI reports?

Reference answer

I compare Power BI totals with source queries, use DAX Studio for measure validation, and set up unit tests with sample data. I also involve business users in UAT to confirm accuracy.

171

What are custom visualizations in Power BI?

Reference answer

Power BI allows users to add customized visual elements to their reports and dashboards. These custom visuals, which can be created by users or third-party developers, offer unique ways to present and analyze data beyond the standard visuals provided by Power BI. By exploring the Custom Visuals Gallery in Power BI, users can discover and integrate these custom visuals into their reports to enhance the presentation and analysis of data. These custom visuals are especially useful when industries require specialized chart types or when the standard visuals don't meet specific visualization requirements. Overall, custom visuals in Power BI enable users to create more engaging and tailored reports and dashboards.

172

Define Heat Map.

Reference answer

A heat map is a type of color-coded matrix used in Tableau to graphically show data values along two axes. In this case, darker colors represent greater values while lighter hues represent lower ones. since a result, it is an effective instrument for data analysis and visualization, since it can be used to spot trends and patterns even in massive datasets.

173

Is there any support by Power BI available for mobile devices?

Reference answer

Yes, Power BI supports mobile devices. It consists of apps for iOS devices, Windows 10 devices, and Android smartphones. You can install Power BI apps from the below app stores: Google Play Apple Store Windows Store

174

Scenario: You are working on a report that needs to show data from multiple data sources. How would you bring this data together in Power BI?

Reference answer

Power BI's data modeling features can be used to create relationships between data sources. The data can be imported into Power BI, and relationships between tables can be defined based on common fields. In addition, data transformation features such as merging and appending queries can be considered to bring the data together before importing into Power BI.

175

What are the main components of Power BI?

Reference answer

Key components include – - Power BI Desktop - Power BI Service (online) - Power BI Mobile - Power Query - Power Pivot - Power View These work together to import, transform, analyze, and share data.

176

How do you integrate Power BI reports into a web application or portal?

Reference answer

Use the Power BI JavaScript API and embed tokens. First, publish your report to Power BI Service. Then get the report ID and embed URL. Use an Azure AD app for authentication. Finally, use the API in your app's frontend.

177

How do you handle a report showing incorrect data?

Reference answer

- Check data source integrity. - Verify DAX formulas and filters. - Inspect relationships in the data model.

178

What are Measures and Dimensions?

Reference answer

Measures and Dimensions are attributes that define a specific dataset in Tableau. Measures are measurable quantities of data which are analysed against dimensions. Any number of measures can be added to a single string, which is governed by dimensions. For example, an inventory of an online shop can have a total number of items, their prices, number of items sold historically, payment mode, etc. All of these can be considered measures. On the other hand, dimensions are basically descriptions which allow visualization to take place. They allow a user to describe a single metric in different ways. A dimension table consists of all these descriptions.

179

What are the various versions of Power BI?

Reference answer

Power BI Desktop Power BI service Mobile Power BI apps for iOS and Android devices

180

What is a Tableau dashboard?

Reference answer

Tableau dashboard is a group of various views that allows you to compare different types of data simultaneously. Datasheets and dashboards are connected if any modification happens to the data that directly reflects in dashboards. It is the most efficient approach to visualize the data and analyze it.

181

How do you incorporate user feedback into your Tableau projects?

Reference answer

I collect user feedback through surveys and user testing sessions, then analyze it to identify common themes and areas for improvement. By implementing these changes and communicating updates to stakeholders, I ensure the dashboards meet user needs and expectations.

182

Retrieve the top 3 revenue-generating products within each category.

Reference answer

Use a window function like ROW_NUMBER() or DENSE_RANK() partitioned by category and ordered by revenue descending, then filter for rank <= 3.

183

What is a TreeMap Heat Map?

Reference answer

TreeMap Heat Map represents the data hierarchically and shows them as a set of nested rectangles. It represents the data graphically which uses multiple colors to represent different values. It is used for comparing the categories with colors, and size, and it can also be used for illustrating the hierarchical data and part-to-whole relationships. It is used for comparing the categories based on color and size. And also it is great in spotting patterns based on the density of the information. The colors and size of rectangles are respective to the values of the data points When their values are higher or the density of records, the data will represent in dark color.

184

Where are Tableau Desktop Log files placed?

Reference answer

Tableau Desktop Log files are placed in C: UsersMy DocumentsMy Tableau Repository. In case of live connection to any data source, check the log file “log.txt” and “tabprotosrv.txt” files. In case of extract connection to any data source, check the “tdeserver.txt” file which has detailed information about queries.

185

What happens if you delete something in Tableau Public?

Reference answer

Tableau public is like a repository, if you delete anything in the Tableau public the data will be lost, even if links are in other locations and blogs. We cannot access those links.

186

Your data model has a many-to-many relationship between Students and Courses (a student takes multiple courses, a course has multiple students). How do you handle this in Power BI?

Reference answer

I don't model this as a direct many-to-many unless I have a strong reason to. I usually introduce a bridge table. In this case, I create an Enrollments table that contains two columns: StudentID and CourseID. Each row represents one enrollment. Then I build two relationships: - Students (1) -> Enrollments (*) - Courses (1) -> Enrollments (*) This converts the many-to-many relationship into two one-to-many relationships through the bridge table. It keeps the model predictable and easier to reason about. I set the cross-filter direction to Single on both relationships. I avoid bi-directional filtering at the model level because it can introduce ambiguity and unexpected filter propagation, especially in larger models. If I need bi-directional behavior for a specific scenario, I handle it inside a measure using DAX rather than enabling it globally. For example, I may use CROSSFILTER() inside CALCULATE if I need to temporarily change filter direction for a specific calculation. Power BI does support many native many-to-many relationships. I can directly relate Students and Courses with many-to-many cardinality. However, I use that carefully. Native many-to-many relationships can produce confusing results, especially when writing measures like DISTINCTCOUNT. If filters propagate in unexpected ways, totals may not match intuition. Performance is another consideration. Bi-directional filtering across large tables increases the number of filter paths Power BI evaluates. In complex models, that slows down queries and makes debugging harder. So my default approach is: - Use a bridge table (Enrollments). - Keep relationships single-directional. - Control special filter behavior in DAX when needed. - Avoid native many-to-many unless the model is simple and the behavior is clearly understood. In this way, the model stays scalable, performant, and easier to maintain.

187

What are some ways to improve a Power BI report's performance?

Reference answer

The following are some methods for enhancing Power BI report performance: - Minimizing the number of columns in the data model and utilizing suitable data types. - Avoiding complicated measures and producing effective DAX computations. - Cutting down on the quantity of data handled by using aggregations and summary tables. - Using slicers and filters to restrict the amount of data that is shown in visualizations. Just the modified data will be updated by incremental refresh.

188

How can you rename a column in a table?

Reference answer

You can just double click the name of the column and give in the new name over there.

189

How do you create dynamic titles in Power BI reports?

Reference answer

By using DAX measures like: DynamicTitle = "Sales Report for " & SELECTEDVALUE(Region[Region]) Apply this measure in a card visual to display a title based on filters.

190

Which database gives the best performance when connected live?

Reference answer

Native Database gives the best performance when connected live.

191

What is a composite model in Power BI?

Reference answer

A model combining DirectQuery and Import Mode to optimize performance and handle large datasets.

192

What is the Schedule Refresh feature in Power BI?

Reference answer

The Schedule Refresh feature in Power BI is used to keep your datasets up to date automatically. It is particularly useful when dealing with cloud-based or online data sources that frequently update. With Schedule Refresh, you can set up time intervals at which Power BI automatically connects to your data source, imports the fresh data, and updates your datasets and reports. For example In a retail scenario where your cloud-based inventory data gets updated every couple of hours, scheduling a refresh ensures that your Power BI inventory report always shows the latest data without manual intervention. Automating data refreshes ensures that reports and dashboards are always current, providing stakeholders with the most up-to-date information for decision-making.

193

What are different type of filters in tableau?

Reference answer

1. Extract Filter - When applied: While creating an extract. - What it does: Reduces the dataset before Tableau loads it. This makes dashboards faster because only the required data is stored in the .hyper file. - Example: If your dataset has 10 years of sales, you can extract only the last 3 years. 2. Data Source Filter - When applied: At the data connection stage i.e it applies to the entire workbook. - What it does: Limits data globally for security or consistency. Every sheet and dashboard will only see the filtered data. - Example: If you give data access to a manager in Asia, apply a data source filter to only show records where Region = Asia . 3. Context Filter - When applied: Before other filters (works as a primary filter). - What it does: Creates a temporary subset of data, and then other filters work only on this subset. This improves performance with large data. - Example: If you apply Region = Asia as a context filter and then a category filter, Tableau will only check categories inside Asia. 4. Dimension Filter - When applied: On discrete (categorical) fields like names, categories or IDs. - What it does: Filters out entire rows of data based on selected categories. - Example: Filter Category = Furniture , so only furniture sales are shown in charts. 5. Measure Filter - When applied: On continuous (numerical) fields like Sales, Profit or Quantity. - What it does: Keeps or removes rows of data based on numeric conditions. - Example: Show only customers where Profit > 5000 . 6. Quick Filter (Show Filter) - When applied: On dashboards or worksheets (user-facing). - What it does: Allows interactive filtering through dropdowns, checkboxes, sliders or radio buttons. - Example: Add a Year quick filter → end-users can pick 2020, 2021 or 2022 from a dropdown. 7. Conditional Filter - When applied: By writing conditions in the filter dialog. - What it does: Filters based on custom logic or aggregate conditions. - Example: Only show products with SUM(Sales) > 5000 orAVG(Profit Margin) > 15% . 8. Top N Filter - When applied: As part of a dimension filter. - What it does: Displays only the top or bottom N records based on a measure. - Example: Show Top 10 Customers by Sales. 9. Relative Date Filter - When applied: On date fields. - What it does: Dynamically filters data based on today's date (relative). Updates automatically when the dataset refreshes. - Example: Show data for Last 30 Days, This Quarter or Next 6 Months. 10. Slicing Filter - When applied: On categorical fields for segmentation. - What it does: Divides the dataset into slices or parts for focused analysis. - Example: Slice sales by Region, then by Category to compare different segments. 11. Table Calculation Filter - When applied: After table calculations are done (last stage). - What it does: Filters based on calculated results like rank, running total or index. - Example: Show only the Top 5 products after applying a RANK() calculation.

194

Why Tableau? What are its advantages?

Reference answer

● Enables quick data analysis with powerful visualization capabilities. ● Can handle large volumes of data efficiently. ● Provides interactive dashboards for better data exploration. ● Allows easy sharing of reports and dashboards through Tableau Server or Tableau Cloud. ● Supports real-time analysis, helping organizations make faster data-driven decisions.

195

You're building a Power BI report for a retail company. What KPIs and visualizations would you include in a sales performance dashboard?

Reference answer

For a retail dashboard, I focus on metrics that directly reflect revenue, profitability, and operational efficiency. At a minimum, I include: - Total Revenue - Gross Profit Margin (%) - Units Sold - Average Order Value (AOV) - Sales Growth (YoY or MoM) - Revenue per Store - Customer Count - Basket Size These give both financial and operational visibility. On the executive summary page, I place KPI cards at the top for Revenue, Margin, and Units Sold. I often include small trend indicators or sparklines to show direction over time. Below that, I use a line chart to show monthly sales trends with prior-year comparison. A map visual works well for regional distribution if geography matters. For product analysis, I include a matrix that shows category and subcategory performance. A scatter plot helps visualize margin versus sales volume, which highlights high-volume low-margin versus low-volume high-margin products. If deeper root-cause analysis is required, I add a decomposition tree to explore revenue drivers dynamically. For store or regional performance, I enable drillthrough from the summary page. A user can click on a region and navigate to a page showing store-level metrics. I use bar charts to rank top and bottom-performing stores. If targets exist, I include a target versus actual comparison, often with a bar or bullet-style visual rather than a cluttered gauge. For customer insights, I include segmentation visuals, for example, new versus returning customers over time. I may also rank customers by lifetime value if the business tracks that. I keep each page limited to five to seven visuals to avoid clutter. Line charts for trends, bar charts for comparisons, and KPI cards for the current state. I use a consistent color scheme aligned with company branding and ensure that important metrics stand out visually. If mobile access is required, I design a mobile layout separately so KPIs stack cleanly and remain readable. The key is not adding every possible visual, but structuring the dashboard around how retail managers think: revenue trends, margin health, product performance, store comparison, and customer behavior.

196

How is data security implemented in Power BI?

Reference answer

Power BI applies models with Row Level Security. Dynamix security involves using USERNAME functions in definitions. A DAX expression can be applied to tables filtering their rows at query time. A table is typically created in the model that relates to specific dimensions and roles.

197

What is the use of the VALUES function in DAX?

Reference answer

VALUES returns a single-column table of unique values from a column, respecting current filter context. It is often used to get distinct values for calculations or to avoid blank rows.

198

How do you handle large-scale data ingestion into Power BI from Azure?

Reference answer

I use Azure Data Factory to ingest and transform data, then load into Azure Synapse or SQL Database. Power BI connects via DirectQuery or Import with incremental refresh to manage volume.

199

What is Tableau data engine?

Reference answer

An analytical database that computes instant query responses, predictive analysis of the server, and integrated data. The data engine is useful when you need to create, refresh, or query extracts. It can be used for cross-database joins as well.

200

What is a parameter in Tableau?

Reference answer

The parameter is a variable (numbers, strings, or date) created to replace a constant value in calculations, filters, or reference lines. For example, you create a field that returns true if the sales are greater than 30,000 and false if otherwise. Parameters are used to replace these numbers (30000 in this case) to dynamically set this during calculations. Parameters allow you to dynamically modify values in a calculation. The parameters can accept values in the following options: - All: Simple text field - List: List of possible values to select from - Range: Select values from a specified range

DON'T WANT TO MISS A THING?

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

Job Interview Questions for Power BI Developers Answered | 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

Job Interview Questions for Power BI Developers Answered | SPOTO

Earn a certification to make your resume stand out.

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