Common Power BI & Tableau Interview Questions 2025

1

How to show profit and sales of each city under a state in the same worksheet?

Reference answer

If you want to show the profit and sales of each and every city under the state in the same worksheet, then follow a few steps. The data which you want to display under the state, it must be in the same worksheet. In the View, Size indicates the Sales, and Color indicates the profit of the respective state(which you have selected).

2

What is a dual axis?

Reference answer

For better visualization and comparison of two fields create two charts on same sheet by adding two fields either in the rows or columns shelf and use one field in another shelf. Now right click on the axis you want o perform dual axis on and select the dual axis to merge both the graphs. This comes in very handy for comparing two different measures on same dimension.

3

What is the significance of the Tableau Data Engine?

Reference answer

Tableau Data Engine is a robust Tableau feature that renders data to provide instant query responses. It also helps perform predictive analysis and seamlessly blends the output with the existing data infrastructure. It is not an in-memory Tableau technology- it hardly uses the computer RAM (primary memory), and it stores all its data in the secondary memory (disk).

4

How would you compare the CALCULATE and CALCULATETABLE functions in DAX?

Reference answer

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

5

What are Time Intelligence functions in DAX?

Reference answer

Functions used for date-based calculations: - TOTALYTD() — Year-to-date calculations. - PREVIOUSMONTH() — Retrieves previous month's data. - DATESBETWEEN() — Filters data within a date range.

6

What chart type is best suited to show proportions?

Reference answer

B) Pie Chart

7

What are the different views that Power BI Desktop contains?

Reference answer

Report View Data View Relationship View

8

What is Tableau used for?

Reference answer

Tableau is used to visualize data through charts and dashboards. It is used to analyze information and generate meaningful insights for businesses.

9

How to show axis in tableau?

Reference answer

You can show and hide axis based on your requirements. Right click on the axis and deselect show header to hide the axis. To show the axis right-click on the fields in row or column and select show header to bring back the hidden axis.

10

What is Tableau and its different products?

Reference answer

Tableau is a visualization and business intelligence software application that enables users and other organizations to create shareable, interactive dashboards, reports and data visualizations. Users can connect to different data sources with it, transform unprocessed data and can be used for data analysis and reporting purposes. The several products of Tableau include Tableau Desktop (for authoring reports), Tableau Server (for sharing and collaborating on reports), Tableau Online (a cloud-based version) and tableau mobile.

11

What do you know about many-to-many relationships in Power BI?

Reference answer

Many-to-many relationships involve a bridge or junction table that reflects the combinations of two dimensions. Either all possible combinations or those combinations that have occurred. A relationship with many-to-many cardinality in Power BI is composed of three features: Composite models: Allows a report to have two or more data connections, including DirectQuery connections or Import. With composite models, you can establish relationships with a many-many cardinality between tables. Relationships with a many-many cardinality: This approach removes unique values in tables. Storage mode: You can specify which visuals require a query to back-end data sources. This feature improves performance and reduces back-end load.

12

What are treemaps and heatmaps in Tableau?

Reference answer

Treemaps: Treemaps use nested rectangles that vary in size and color to help illustrate the size and ratios of data points compared to one another. Heatmaps: Heatmaps rely on colors to differentiate data points within a Tableau data set.

13

Where is data in Power BI often stored, and what are the two main types of Microsoft Azure cloud services?

Reference answer

More often than not, data in Power BI will be stored on the cloud, often in Azure. The two main types of Microsoft Azure cloud services include Azure Blob Storage and Azure SQL Database.

14

What is M language and how is it used in Power Query?

Reference answer

M is the formula language behind Power Query. It is used to define data transformation steps. Each step in Power Query generates M code, which can be edited in the Advanced Editor for custom logic.

15

What is Power Pivot Data Model?

Reference answer

It is a model that is made up of data types, tables, columns, and table relations. These data tables are typically constructed for holding data for a business entity.

16

What are the two different ways of sorting data in Tableau?

Reference answer

We can sort Tableau data using manual sorting and computed sorting. In manual sorting, we drag the dimension field order and rearrange them ad hoc. In computed sorting, we apply the sort button on an axis to sort the data.

17

How to remove 'All' options from a Tableau auto-filter?

Reference answer

The auto-filter provides a feature of removing 'All' options by simply clicking the down arrow in the auto-filter heading. You can scroll down to 'Customize' in the dropdown and then uncheck the 'Show "All" Value' attribute. It can be activated by checking the field again.

18

Use slicers to apply dynamic filters across visuals.

Reference answer

Add a slicer visual and select the field to filter. All visuals on the page that use that field will be dynamically filtered.

19

Why do we need BI?

Reference answer

You can take data and create reports at the click of a button. You can take data and create reports with a button click. It helps in attracting new customers to service and monitor existing customers. You can keep track of information and set your goals accordingly. In general, building an ETL solution (Extraction, Transformation, and Loading) ultimately helps to make better decisions. The ROI is very high Helps to make unwanted data into progressive information.

20

What is tableau desktop?

Reference answer

Tableau desktop is a product of Tableau which is used to create, edit and store data visualizations locally on a system. You have an option to publish the visualizations to server, online or public after its completed or maybe in between the process also depending on the requirements. Tableau desktop also allows its user to edit any file created on another system and in a same or lower tableau version.

21

What are aggregations in Power BI?

Reference answer

Aggregations pre-summarize data to reduce query time and improve performance.

22

What are dataflows in Power BI and some of their benefits?

Reference answer

Dataflows in Power BI let users create, manage, and reuse data preparation steps across multiple reports and dashboards. Benefits include: - Data Reuse: Dataflows can be reused in different reports and dashboards, saving time and ensuring consistency. - Improved Data Consistency: They centralize data transformation rules, leading to more accurate and reliable reports. - Centralized Data Management: They simplify data governance by storing and managing data in one place, making it easier to maintain quality. ? Dataflows in Power BI enable reusable data preparation across multiple reports and dashboards.

23

What are the Parts of Microsoft's Self-Service Business Intelligence Solutions?

Reference answer

Microsoft Self-Service BI has two parts: Excel BI Toolkit: Allows users to create reports interactively through data importing from distinct data sources as well as model data according to the requirement. Power BI: It is an online solution that empowers users for sharing interactive reports and queries that you have created with Excel BI Toolkit.

24

In Tableau 7.0, what does context filter mean?

Reference answer

Context filters can be set up to enhance performance when applying filters to a large data source. The other filters are only applied to the records that result after the context filter has been applied to the data source. Applying each filter to every record in the data source is avoided by following this approach. Context filters can be created to: - Boost performance- If you have a lot of filters configured or a large data source, your queries might be slow. One or more context filters can be applied to enhance performance. - Create a context filter that only includes only relevant values, and then establish a dependent numerical or top N filter.

25

What is your approach to troubleshooting performance issues in Power BI reports?

Reference answer

Look for: Problem-solving skills and understanding of performance optimization techniques. What to Expect: Explanation of diagnosing performance issues using tools like Performance Analyzer, optimizing data models, reducing visual complexity, and improving DAX formula efficiency.

26

How can you create a clustered column chart in Power BI?

Reference answer

To create a clustered column chart in Power BI, you can use the "Column Chart" chart type and specify the category and value fields. Once the chart is created, you can format it to show the values side-by-side.

27

How to connect mongodb with tableau?

Reference answer

An additional driver may be required to connect with Mongodb. I suggest you to download and install driver from: https://www.tableau.com/support/drivers. Once installed now open tableau and under connect select Mongodb BI connector (if you can't find it in the main list, under “To a server” menu you see an option named”More”, there you can find Mongodb BI connector). Then enter the name of server, enter username and password associated with the database. Select the “Require SSL” check box when connecting to an SSL server. Then select “Sign in”, now you are good to go with the data source.

28

Can extract files be used without any connections?

Reference answer

Extract files can be used without any connections and you can build your own visualization without connecting to the database.

29

How do you manage user access for reports shared via Power BI Service?

Reference answer

I use workspace roles (Admin, Member, Contributor, Viewer) for access control. For data-level security, I implement RLS. I also use apps to distribute reports to specific user groups.

30

What is SSBI?

Reference answer

SSBI stands as an abbreviation for Self-Service Business Intelligence. SSBI is a breakthrough in business intelligence. SSBI has enabled many business professionals with no technical or coding background to use Power BI and generate reports and draw predictions successfully.

31

What is the common table function for grouping data?

Reference answer

SUMMARIZE() Main groupby function in SSAS. Recommended practice is to specify table and group by columns but not metrics.You can use ADDCOLUMNS function. SUMMARIZECOLUMNS New group by function for SSAS and Power BI Desktop; more efficient. Specify group by columns, table, and expressions.

32

How do you apply incremental load in Power BI for large datasets?

Reference answer

I define rangeStart and rangeEnd parameters in Power Query. In Power BI Desktop, I configure incremental refresh policies in the table properties. After publishing, Power BI Service handles automatic refreshes based on the policy.

33

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

34

How to hide dashboard in tableau?

Reference answer

There is no way to hide a dashboard in tableau but it is possible to do so if you are publishing the dashboard to a website there you can set a command to show dashboard only when a particular button is clicked. And instead of hiding a dashboard you can go for hiding sheets before publishing the dashboard. So that by default when people view your viz only the dashboard will be visible to them and not the individual sheets.

35

How do you use variables in DAX and why are they useful?

Reference answer

Variables are declared using VAR and RETURN. They store intermediate results, improving readability and performance by evaluating expressions once. Example: VAR TotalSales = SUM(Sales[Amount]) RETURN TotalSales * 0.1.

36

What is the importance of conditional formatting in Power BI?

Reference answer

Conditional formatting in Power BI allows you to change the appearance of cells, rows, and columns based on their value. This feature helps to highlight certain values, identify trends, and draw attention to specific data points. For example You might use conditional formatting to highlight sales figures that exceed targets in green and those that fall short in red. This enhances the visual impact of your reports, making key data points stand out and facilitating quicker insights.

37

What are query parameters and Power BI templates?

Reference answer

Query parameters can be used to provide users of a local Power BI Desktop report with a prompt, to specify the values they're interested in. The parameter selection can then be used by the query and calculations. PBIX files can be exported as Templates (PBIT files). Templates contain everything in the PBIX except the data itself. Parameters and templates can make it possible to share/email smaller template files and limit the amount of data loaded into the local PBIX files, improving processing time and experience.

38

What are the basics needed for using Power BI?

Reference answer

To use Power BI, you need to have a web browser and a work email address. work email addresses finishing in .mil and .gov are not supported currently.

39

Explain how you handled a scenario where the client wasn't satisfied with the initial dashboard.

Reference answer

I scheduled a feedback session to understand their concerns. I iterated on the design, simplified visuals, and added more interactivity with slicers. After two revisions, the client approved the dashboard.

40

What is the Cost of Power BI?

Reference answer

Both Power BI Desktop and Power BI are free of cost. For Power BI Pro, users have to pay $9.99 per month after a 60-day free trial.

41

Describe a Tableau dashboard you developed that drove significant business outcomes.

Reference answer

At a previous position in a retail company, I led a project to create a dashboard using Tableau that visualized sales trends across different regions. The dashboard allowed the sales team to identify underperforming areas quickly. As a result, they implemented targeted marketing strategies that increased sales by 20% in those regions within three months. This experience reinforced my belief in the power of data visualization for informed decision-making.

42

How can you improve the performance of Tableau dashboards?

Reference answer

Use Data Extracts: Use Tableau extracts (.hyper files) instead of live connections whenever possible, as they are optimized for faster performance. Reduce Data Volume: Import only the necessary fields and rows. Remove unused columns and apply filters to limit the amount of data loaded. Use Context Filters: Apply context filters so Tableau processes a smaller dataset before applying other filters. Optimize Calculated Fields: Avoid complex or nested calculations. If possible, perform heavy calculations in the database or during data preparation. Limit High Cardinality Dimensions: Avoid using fields with too many unique values, such as transaction IDs or customer IDs, in visualizations. Reduce Number of Visualizations: Avoid placing too many worksheets in a single dashboard, as each worksheet runs separate queries. Optimize Joins and Data Model: Use only required tables and ensure joins are efficient to avoid unnecessary data duplication. Use Aggregated Data: Work with summarized data instead of highly detailed transactional data when possible. Optimize Filters: Use fewer filters and avoid quick filters with many unique values, as they can slow down the dashboard. Use Performance Recording: Tableau's Performance Recording tool helps identify slow queries and performance bottlenecks. Hide Unused Fields: Hide unused fields in the data source to reduce the data model size and improve performance. Reduce Marks in Views: Too many marks in a visualization can slow down rendering, so simplify charts when possible. Use Appropriate Chart Types: Some charts with heavy visual elements can slow dashboards, so choose efficient visualizations. Optimize Dashboard Layout: Avoid excessive formatting, floating objects, or too many interactive elements in a dashboard.

43

What is the data profiling concept in Power BI?

Reference answer

In Power BI, data profiling refers to the set of tools and techniques used to examine the state and quality of data as it is being imported through Power Query. This involves reviewing column distributions, identifying error counts, checking for empty or unique values, and more. This process helps users understand the structure, cleanliness, and accuracy of the data before it's loaded into Power BI for further analysis. While data profiling in Power BI is instrumental in ensuring data quality and integrity, it's specifically designed to aid users during the data import and transformation stages. This ensures that the data used in reports and dashboards is reliable, which is crucial for making sound business decisions based on accurate and insightful reporting.

44

What are the different types of charts available in Tableau?

Reference answer

Tableau offers a wide range of charts and different visualizations to help users explore and present the data effectively. Some of the charts in Tableau are: - Bar Chart: They can be used to compare values between categories or to demonstrate the distribution of data across categories. They help compare categorical data. - Line Chart: For displaying patterns and changes over time, line charts work incredibly well. To show how a single metric evolves, they are frequently used with time series data. - Area Chart: They are identical to line charts, however with an area chart, the area beneath the line is coloured. To highlight the contrasts between the variables, they are utilized with various multiple variables in the data. - Pie Chart: It displays pieces of an entire. They help demonstrate how data is distributed when each category represents a certain percentage of the total. - Tree Maps: They use layered rectangles to display hierarchical data. They are useful for illuminating hierarchical structures such as those found in files or organizational directories. - Bubble chart: Bubble charts are useful for comparing and visualizing data points with three separate properties. They are in use when you want to highlight data clusters, demonstrate relationships, etc. - Scatter Plot: They are used to show how two continuous variables relate to one another. They aid in the data's discovery of correlations, clusters or outliers. - Density Map: The distribution and concentration of data points or values within a 2D space are depicted using density maps. - Heat Map: Data is displayed on a grid using heat maps, where colour denotes value. They can be used to visualize big datasets and spot patterns. - Symbol Map: By adding symbols or markers to a map to indicate information about particular locations, symbol maps are used to portray geographic data. - Gannt Chart: To visualize tasks, their durations and dependencies over time, Gannt charts are used in project management. - Bullet Graph: They are used to monitor advancement toward a goal. They offer a convenient method of showing a measure, a target and performance ranges. - Box Plot(Box and Whisker): They are employed to show the data's distribution and spot outliers. The median, quartiles and possible outliers are displayed.

45

How do you measure the success of a Tableau dashboard or report?

Reference answer

I measure the success of a Tableau dashboard by defining clear metrics and KPIs that align with business goals. Additionally, I gather user feedback to assess engagement and analyze how the dashboard influences decision-making processes.

46

How do you display the Top 10 customers by profit in each region?

Reference answer

- Drag Customer Name to Rows, Profit to Columns. - Apply a filter on Customer Name → Top Tab → By Field → Top 10 by Profit. - Drag Region to Filters or Columns to segment by region.

47

Where is data stored in Power BI?

Reference answer

Most of the time, power BI gets assisted by the cloud to store the data. Power BI can use a desktop service. Microsoft Azure is used as the primary cloud service to store the data. Azure SQL Database Azure Blob Storage

48

What is Tableau?

Reference answer

Tableau is a business intelligence software that allows interactive visualization and handling of large amounts of data. It is used by businesses around the world to crunch numbers and use the insights for growth and development. Tableau is one of the most important tools for data analytics and visualization only competed by Apache Superset, Qlik and Metabase to name a few alternatives.

49

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

Reference answer

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

50

What are the different types of visualizations in Power BI?

Reference answer

Power BI offers a wide range of visualizations, including tables, charts, maps, gauges, cards, and custom visuals. These visualizations can be customized and formatted to meet specific reporting needs.

51

How can you convert a ‘number' type column into a ‘string type' column?

Reference answer

If it is a numerical column, it will have the # symbol above it. When you click on the # symbol, it will give you a drop-down list. From that drop-down list, you can select ‘String'.

52

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

Reference answer

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

53

What is the difference between Power BI and Tableau?

Reference answer

| Power BI | Tableau | |---|---| | It uses DAX for calculating measures. | It uses MDX for measures and dimensions | | It is qualified only to handle a limited amount of data. | It handles large volumes of data. | | It is qualified only to handle a limited amount of data. | It handles large volumes of data. | | The user interface is simple. | The user interface could be simpler. |

54

How do R and Python fit into Power BI?

Reference answer

Power BI allows for the use of R and Python for statistical analysis, machine learning, and sophisticated data manipulation. R and Python scripts for data transformation in Power Query and the creation of custom columns and tables in the data model are supported by Power BI. To create unique visualizations and analytical models, Power BI reports can now include R and Python graphics.

55

Where is the data stored in Power BI?

Reference answer

Primarily, Power BI has two sources to store data: Azure Blob Storage: When users upload the data, it gets stored here. Azure SQL Database: All the metadata and system artifacts are stored here. They are stored as either fact tables or dimensional tables.

56

How can you get more information about a particular column?

Reference answer

Every column gives you the describe option. When you click on the describe button, you will get more information about that particular column.

57

Why use Case statements over IF-THEN-ELSE statements?

Reference answer

Read about it here --> https://lnkd.in/dcaubJ37

58

What are the different types of visualization techniques in Power BI?

Reference answer

- Area charts - Funnel charts - Decomposition tree - Key influencers chart - Bar and column charts - Gauge charts - Doughnut charts - Combo charts

59

What is Power BI Embedded, and how is it used?

Reference answer

Power BI Embedded is an Azure service that allows developers to embed Power BI reports and dashboards into their applications. It provides a seamless experience for users to access analytics within the context of their software solutions.

60

How would you design a Power BI solution for an organization with 500+ users across multiple departments, each with different data access needs?

Reference answer

For 500+ users, I don't build separate datasets for every department. I design a centralized architecture. I start with shared datasets in Power BI Service. These datasets act as the single source of truth. They contain the data model, relationships, measures, and security rules. Department-specific reports then connect to these shared datasets using Live Connection. That way, reports stay lightweight and consistent. If I update a measure in the central dataset, every connected report reflects the change. Then, security has to scale. I implement dynamic Row Level Security using a mapping table that links UserEmail to Department, Region, and access level. This allows one security model to serve hundreds of users without manually assigning roles one by one. For workspace strategy, I separate workspaces by function, for example, Finance, Sales, and HR. Each workspace has clearly defined roles: Admin, Member, Contributor, and Viewer. This keeps ownership clear and prevents accidental changes to certified content. For distribution, I publish Apps rather than sharing individual reports. Each department gets a single app URL with curated content. That simplifies access and reduces confusion. Governance is critical at this scale. I use deployment pipelines to manage Dev, Test, and Production environments. I enforce naming conventions for datasets and reports. I certify or endorse trusted datasets so users know which ones to rely on. Capacity planning also matters. With 500+ users, I evaluate whether Premium capacity (P1 or higher) is required or whether Premium Per User is sufficient. The decision depends on dataset size, refresh frequency, and concurrent usage patterns. I monitor usage metrics regularly. If certain reports are rarely accessed, I review whether they should be archived or redesigned. I also use the data lineage view to understand upstream and downstream dependencies before modifying any shared dataset. At the tenant level, I align with governance policies, who can publish content, who can export data, and whether external sharing is allowed. So my approach focuses on centralization, scalable security, clear workspace ownership, structured deployment, and ongoing monitoring. That keeps the environment manageable even with hundreds of users.

61

How to create a parameter to switch between two measures in Tableau?

Reference answer

To achieve this, we need to create 2 views

62

What are the four options for joining data in Tableau?

Reference answer

Tableau has four options for joining data from different data points within a source: inner, left, right, and full outer. Each of these four joins has its own parameters, which can be helpful when organizing data depending on how you want to combine data points.

63

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

Reference answer

Power BI Desktop is a free downloadable application you can install on your local computer; contrary to that, Power BI is a SaaS product. Similarly to Power BI, Desktop enables users to effortlessly visualize, transform, and share data in a report form with the organization's stakeholders.

64

What is incremental refresh in Power BI?

Reference answer

Incremental refresh defines the division or separation of data that must be refreshed frequently, in order to refresh it separately from data that doesn't need to be refreshed often. This means that with incremental refreshes, only some parts of the data will be refreshed.

65

What is the Line Chart?

Reference answer

In Tableau, a line chart is a type of data visualization that represents data using connected data points plotted on a Cartesian coordinate system. It is used to display trends and patterns in the data over time or any continuous dimension. Key features of a line chart in Tableau: Connected Data Points: The primary feature of a line chart is the line that connects the data points, representing the trend or progression of the measure over the continuous dimension. Time Series Analysis: Line charts are especially useful for time series analysis, where the X-axis represents time or date and the Y-axis represents the values of the measure. Continuous Data: Line charts are suitable for visualizing continuous data, such as temperature, sales, stock prices, or any other data that varies continuously. Smooth or Stepped Lines: Tableau provides options to display lines as smooth curves or stepped lines, depending on the data and the desired visualization. Data Labels and Annotations: Users can add data labels and annotations to highlight specific data points or significant events. Trend Lines and Forecasting: Tableau allows users to add trend lines and perform forecasting to visualize and predict future trends based on historical data. Color Encoding: Users can use color to encode additional information, such as differentiating between multiple lines representing different categories or groups. Line charts are effective for visualizing and analyzing data that shows trends, changes over time, or any continuous progression. They are widely used for data exploration, time-based analysis, and making data-driven decisions based on patterns and insights revealed by the visualization.

66

What is tableau developer?

Reference answer

A tableau developer is one who knows how to create data visualizations and meaningful insights from raw data in tableau. A tableau developer should know how to create advanced dashboards that are easy to be used by other people and will be handy to them to understand the data easily

67

What is the difference between a calculated field and a calculated table in Power BI?

Reference answer

A calculated field is a column that is created in a table using a DAX expression, while a calculated table is a table that is created using a DAX expression. Calculated fields are used to perform calculations on existing columns in a table, while calculated tables are used to create new tables based on existing data.

68

How can you create a calculated table in Power BI using Power Query?

Reference answer

To create a calculated table in Power BI using Power Query, you can use the "New Source" option in the "Get Data" menu and select "Blank Query." Once the query is created, you can enter a Power Query expression that defines the rows and columns of the table.

69

What are common techniques for data shaping in Power Query?

Reference answer

Data shaping involves changing the "shape" or structure of your data to make it more suitable for analysis. In Power BI, you can apply several common data-shaping techniques like: - Removing unnecessary columns or rows - Splitting columns - Merging or appending queries - Grouping data - Pivoting or unpivoting columns For example Consider a table with a single column containing full names. (First name and last name combined). Well, you could split this column into "First Name" and "Last Name" to facilitate a more specific analysis: = Table.SplitColumn(Source, "FullName", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"FirstName", "LastName"}) These techniques are essential for preparing data for analysis, and ensuring the data is clean, accurate, and properly formatted for creating reliable reports and dashboards.

70

List out Tableau File Extensions.

Reference answer

In Tableau, various file extensions are used to save and manage different types of files. Here are some common Tableau file extensions: .twb: Tableau Workbook (.twb) files contain a single worksheet and its associated visualizations, calculations, and data connections. They are used to save individual Tableau worksheets and can be shared with others for analysis. .twbx: Tableau Packaged Workbook (.twbx) files are similar to .twb files but include all the necessary data sources and files needed to view the workbook. They are used to package and share workbooks along with their data sources for easy distribution. .tds: Tableau Data Source (.tds) files are XML-based files that store information about a data source connection. They contain the connection details, such as server information, database credentials, and query details, but do not include the actual data. .tdsx: Tableau Packaged Data Source (.tdsx) files are similar to .tds files but include the actual data source along with its connection details. They are used to package and share data sources with others for easy access. .tde: Tableau Data Extract (.tde) files are a proprietary file format used to store data in a highly compressed and optimized form. They are used to create extract files that improve performance by reducing data query times. .twm: Tableau Window Metadata (.twm) files store metadata about Tableau window settings, such as window size, position, and the state of sheets and dashboards. These files help restore the layout and state of the Tableau window when reopened. .tdc: Tableau Data Connection (.tdc) files are XML files used to customize and modify data connections. They can be used to specify custom connection settings and configurations for specific data sources. .tfl: Tableau Font List (.tfl) files are XML-based files that store font information used in Tableau workbooks. These files help maintain font consistency when sharing workbooks across different computers. These are some of the common Tableau file extensions that users encounter while working with Tableau workbooks, data sources, and related files. Each extension serves a specific purpose in the Tableau ecosystem.

71

How do you connect to data sources in Tableau?

Reference answer

The list of data connectors will appear in the Connect pane on the Start page. If you previously opened a worksheet and need to connect a new data source, you can navigate back to the Connect pane by clicking on Data Source at the bottom right of the page and selecting Add next to Connections, or by clicking on the Tableau logo in the top left corner.

72

What is the role of R and Python in Power BI?

Reference answer

R and Python are programming languages that have gained popularity in the data science domain owing to their powerful data analysis and visualization libraries. In Power BI, R and Python scripts can be utilized to prepare (cleanse and transform) data, create machine learning models, and create visualizations that are not natively available in Power BI. For example You might use R for complex statistical analysis or Python for advanced data manipulation and visualizations. Integrating R and Python with Power BI allows for more advanced analytics and custom visualizations, enhancing the tool's capabilities and providing deeper insights.

73

What data sources can Power BI connect to?

Reference answer

The list of data sources for Power BI is extensive, but it can be grouped into the following: Files: Data can be imported from Excel (.xlsx, xlxm), Power BI Desktop files (.pbix) and Comma Separated Value (.csv). Content Packs: It is a collection of related documents or files that are stored as a group. In Power BI, there are two types of content packs, firstly those from services providers like Google Analytics, Marketo, or Salesforce, and secondly those created and shared by other users in your organization. Connectors to databases and other datasets such as Azure SQL, Database and SQL, Server Analysis Services tabular data, etc.

74

Can you describe a time you used Tableau to uncover key business insights?

Reference answer

At a previous project with a retail client, I analyzed sales data to identify trends and customer behavior. Utilizing Tableau's forecasting and clustering features, I visualized sales patterns that revealed a 20% increase in demand for certain products during specific seasons. My findings led the client to adjust their inventory strategy, resulting in a 15% increase in sales over the next quarter.

75

What is the highest number of tables you can join in Tableau?

Reference answer

We can join 32 tables in tableau. However, the table size in tableau must be limited to 255 fields (columns).

76

What are Filters in Power BI? Name some.

Reference answer

Filters in Power BI are tools that help you refine and focus your data to display specific information. They control what data appears in reports. Power BI offers several types of filters: - Visual-level Filters: Apply only to the selected visual. - Page-level Filters: Apply to all the visuals on a specific report page. - Report-level Filters: Apply to all the visuals across the entire report. - Drill Through Filters: Enable users to right-click on a data point on one page (or in one report) to navigate to a different page (or different report) with more detailed information. ? Filters in Power BI control what data appears in reports.

77

How do you optimize the performance of a Tableau workbook?

Reference answer

A sales workbook once took 40 seconds to open. I removed unused dimensions, replaced row-level calcs with table-calc equivalents, and set an aggregated extract. The load time dropped to 5 seconds, and user engagement doubled.

78

What does DAX stand for and what is it used for?

Reference answer

DAX stands for data analysis expressions. These are formula languages used to carry out calculations and analyze data in Power Pivot. You can also use DAX to work out calculated columns, measures, and fields.

79

What are the key components of Power BI?

Reference answer

- Power BI Desktop — Local development tool for creating reports. - Power BI Service — Cloud platform for sharing and collaboration. - Power BI Mobile — Access reports on mobile devices. - Power BI Data Gateway — Connects on-premises data to cloud services. - Power BI Report Server — On-premises report hosting.

80

What are the different modes of Data Gathering?

Reference answer

Import, DirectQuery, Composite, Live Connection.

81

What is tableau server?

Reference answer

Tableau server is used to organize, edit, share, and collaborate on Tableau dashboards created on Tableau desktop. It is safer for organizations as the data will be private to the members of the company and also administrator has the power to give limited control to its user such as only view or edit or both depending on the requirement.

82

What is the importance of star schema in Power BI data modeling?

Reference answer

Star schema optimizes performance by reducing data redundancy and simplifying relationships. It improves query speed and DAX calculations by keeping fact and dimension tables separate.

83

What are the differences between Power Query and Power Pivot?

Reference answer

| Power Query | Power Pivot | |---|---| | It is all about analyzing data. | It involves getting and transforming data. | | It is an ETL service tool. | It is an in-memory data modeling component. |

84

How do you display the top and bottom five values of a view in Tableau?

Reference answer

Top and bottom five values of a view are displayed by a multistep process. The following are the steps of this process: 1. Create a calculated field using: RANK(SUM[measure], 'asc') <= [Parameter] OR RANK(SUM[measure], 'dsc') <= [Parameter] 2. Drag the newly created field to the Filters shelf and choose only the 'Top 5' and 'Bottom 5' options. 3. Place the same field onto the Rows shelf. 4. Add Customer Name to the Rows shelf as well, and drag the Sales field onto the Text label to display the values.

85

What are AI visuals in Power BI?

Reference answer

Key Influencers, Decomposition Tree, Anomaly Detection for AI-driven insights.

86

Can you describe a situation where you had to troubleshoot a performance issue in a Tableau workbook?

Reference answer

A workbook froze when filtering by product. The performance recorder showed a runaway LOD. I rewrote it as a pre-calculated field in the database, slashing query time from 45 seconds to 4.

87

What are the various type of users who can use Power BI?

Reference answer

Anyone and everyone can use PowerBI to their advantage. But even then a specific set of users are more likely to use it viz: Business Users: Business users are the ones who constantly keep an eye on the reports to make important business decisions based on the insights. Business Analysts: Analysts are the ones who create dashboards, reports, and visual representations of data to study the dataset properly. Studying data needs an analytical eye to capture important trends within the reports. Developers: Developers are involved while creating custom visuals to create Power BI, integrating Power BI with other applications, etc. Professionals: They use Power BI to check the data scalability, security, and availability of data

88

Is Power BI available on-premises?

Reference answer

No, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services and other data sources. You can also schedule refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway – Personal.

89

What are the most common DAX functions used?

Reference answer

Some of the most commonly used DAX functions are listed below: - Aggregation Functions: SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT - Information Functions: ISBLANK, ISFILTERED, ISCROSSFILTERED - Statistical Functions: GEOMEAN, MEDIAN - Logical Functions: IF, AND, OR, SWITCH - Date & Time Functions: DATEDIFF, DATEVALUE - Filter Functions: VALUES, ALL, FILTER, CALCULATE, TOPN - Other Functions: UNION, INTERSECT, EXCEPT, NATURALINNERJOIN, NATURALLEFTEROUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY, VAR

90

What is the M language in Power BI?

Reference answer

The M language (also called M-Code) is a scripting language used within Power Query in Power BI. It's what's behind the scenes when you're connecting, cleaning, reshaping, and combining data from different sources. While the Power Query Editor interface allows you to perform most of these tasks visually, knowing M-code lets you fine-tune transformations, automate data-cleaning steps, or handle more complex scenarios. It's especially helpful if you need greater control or precision than what the graphical interface offers.

91

Can Tableau be installed on both Windows and macOS?

Reference answer

Yes, Tableau can be installed on both the Windows Operating system and macOS.

92

What is the difference between Power BI and Power Query?

Reference answer

Power BI and Power Query are both Microsoft products that are used for data analysis and reporting, but there are some key differences between the two. Power BI is designed for business intelligence and data visualization, while Power Query is a data transformation and cleaning tool that is used to connect to and transform data from various sources.

93

What are some differences in data modeling between Power BI Desktop and Power Pivot for Excel?

Reference answer

Power Pivot for Excel supports only single directional relationships (one to many), calculated columns, and one import mode. Power BI Desktop supports bi-directional crossfiltering connections, security, calculated tables, and multiple import options.

94

What are the different refresh options in Power BI?

Reference answer

Power BI has four main refresh options, each used for a specific purpose: - Package refresh: Synchronizes Power BI Desktop files stored in OneDrive or SharePoint Online with Power BI Service. It doesn't refresh the underlying data, it just keeps your reports up-to-date with any changes you made in the desktop file itself. - Model refresh (or Data refresh): Updates the actual data within your dataset by pulling fresh data from the original sources, like databases or cloud services. This is typically scheduled regularly (like daily or weekly) to keep your reports current. - Tile refresh: Automatically refreshes the individual visuals (tiles) on a dashboard approximately every 15 minutes or whenever underlying data changes. You can also manually force this refresh to ensure the latest insights are shown immediately. - Visual container refresh: Updates cached visuals within your reports when data changes, ensuring anyone viewing the report sees accurate visuals reflecting the latest data.

95

What are custom visuals in Power BI?

Reference answer

In PowerBI you can create your own visualizations from the library of custom visualizations. A development project has to be created then test the visual in PowerBI service. Once the visualization is customized, it is thoroughly checked and tested before posting. After testing, the visualization is saved in .pbiviz file format before sharing. But you need to be a PowerBI Pro user in order to make custom visualizations.

96

Have you used Power BI in combination with Azure services like Synapse or Data Lake?

Reference answer

Yes, I have connected Power BI to Azure Synapse for large-scale analytics and used Azure Data Lake for data storage. DirectQuery and import modes were used based on latency requirements.

97

Name the different connectivity modes available in Power BI?

Reference answer

There are three main connectivity modes used in Power BI. SQL Server Import An SQL Server Import is the default and most common connectivity type used in Power BI. It allows you to use the full capabilities of the Power BI Desktop.

98

What is KPI in Power BI?

Reference answer

A KPI (Key Performance Indicator) in Power BI is a visual used to track progress toward a specific goal or business target. It helps measure performance by comparing actual values against a target value. - KPI visuals show status (current value), target (goal) and trend (progress over time). - Useful for monitoring metrics like sales vs. target, revenue growth, customer satisfaction, etc. - Created using measures in DAX (for actual and target values). Example: If you want to track Sales Performance: - Actual Sales = SUM(Sales[Amount]) - Target Sales = 1,00,000 - KPI visual shows whether actual sales are below, meeting or above the target.

99

How can you keep data neat in Tableau when working with large volumes of data?

Reference answer

When we are working with large volumes of data, incredible data may be messed up. With Tableau, you can easily create hierarchies to keep your data neat. Even if you don't need it, it is built into your data, which you can easily manage or organize the data and you can track the data easily.

100

What data sources can Power BI connect to?

Reference answer

- Files: Excel, CSV, JSON. - Databases: SQL Server, MySQL, Oracle. - Cloud Services: Azure, Google Analytics, Salesforce. - APIs: REST APIs, OData.

101

What is DAX in Power BI and why is it used?

Reference answer

DAX stands for Data Analysis Expressions. It is a formula language used in Power BI to create custom calculations, measures, and columns. It works like Excel functions but is optimized for data models and reporting.

102

How do you handle data refreshes and updates in a Tableau Server environment?

Reference answer

I stagger refresh schedules by data priority—financials at 6 a.m., marketing at 7 a.m.—and enable extract encryption. Failure alerts hit our Slack channel so we can rerun jobs promptly.

103

How does Power BI handle null values and blank values? What is the difference?

Reference answer

In Power BI, NULL values usually come from the data source, such as a SQL database. Once the data is imported into the VertiPaq engine, those NULLs are represented as BLANK in DAX. BLANK is DAX's internal representation of "no value." I can also explicitly return it using the BLANK() function. They behave slightly differently from zeros or empty strings. For example: - In arithmetic, BLANK behaves like zero. BLANK() + 5 returns 5. - In text concatenation, BLANK behaves like an empty string. - In visuals, BLANK shows as an empty cell, not as 0. This distinction matters in reporting. In a line chart, BLANK creates a gap in the line. A value of 0 creates a visible point at zero. That changes how trends appear. When handling missing values, I usually use ISBLANK() or COALESCE(). For example: IF(ISBLANK([Sales]), "No Data", [Sales]) Or: COALESCE([Sales], 0) DIVIDE is also important here. If I divide by zero using the division operator, I get an error. If I use DIVIDE, it returns BLANK by default when the denominator is zero. That prevents errors from appearing in visuals. Another subtle point is that BLANK is not the same as 0 in filter logic. If I filter for values equal to 0, BLANK values are excluded. In the filter context, BLANK and 0 are distinct. So I think of it this way: - NULL is the source-level concept. - BLANK is the DAX representation. - BLANK behaves like zero in arithmetic but remains distinct in filtering and visualization behavior.

104

How does Power BI handle real-time data?

Reference answer

- Streaming datasets (push data via APIs). - DirectQuery (connect directly to a database). - Azure Stream Analytics (real-time IoT data).

105

What is the CALCULATE function in DAX?

Reference answer

The CALCULATE function evaluates the sum of the Sales table Sales Amount column in a modified filter context. It is also the only function that allows users to modify the filter context of measures or tables. Moving ahead, you will step up to the following Power BI Interview Questions from the Intermediate Level.

106

How do you balance technical feasibility and business expectations?

Reference answer

I communicate technical constraints early, such as data latency or performance limits. I propose alternatives like aggregated data or simplified visuals. Regular demos help align expectations with reality.

107

How to add custom colors in tableau?

Reference answer

Tableau offers various colour palettes which a user can use to define a legend or to be used in formatting. But sometimes due to client's requirements we need to use some specific colours in our view. So instead of defining the colour each and every time you can create a custom palette which can be used whenever you open a workbook. To create a custom colour palette, go to “My tableau Repository” in the documents folder of your system. Open “Preference.tps” file in a text editor to create the custom palette. By default, the file will be empty with just opening and closing line of workbook. You need to define the colour palette in between these two lines and there are three types of colour categories that can be defined. One of them is categorical which is defined using type = “Regular” and second one is sequential and it comes under the type = “ordered-sequential” and last comes diverging colour which is of the type = “ordered-diverging”. Also, kindly note that the colour should be defined in the HTML #RRGGB order.

108

What are continuous and discrete field types?

Reference answer

Tableau's specialty lies in displaying data differently either in continuous format or discrete. Both of them are mathematical terms used to define data where continuous means without interruptions and discrete means are individually separate and distinct. While the blue color indicates discrete behavior, the green color indicates continuous behavior. On one hand, the discrete view defines the headers and can be easily sorted, while continuous defines the axis in a graph view and cannot be sorted. Image - tableau.com

109

What is the difference between a funnel chart and a pyramid chart in Power BI?

Reference answer

A funnel chart is a chart that shows the stages of a process and the number of people or items that move from one stage to the next, while a pyramid chart is a chart that shows the proportion of each category using a pyramid shape. Funnel charts are typically used to show the conversion rate of a process, while pyramid charts are used to show the hierarchy of the categories.

110

Can you explain a complex Power BI dashboard you have built and how it helped business users?

Reference answer

I built a sales performance dashboard for a retail client with drill-through pages, dynamic KPIs, and time intelligence. It helped managers identify underperforming regions and adjust strategies, leading to a 15% sales increase.

111

List some uses of the Tableau Reporting tool.

Reference answer

With the help of Tableau reporting, users can witness different types of visualizations, like analyzing forecasts, viewing data trends, or investigating data at granular levels by slicing it as necessary. There are various reports like tables, workbooks, spreadsheets, custom dashboards, PDFs, etc.

112

What is the difference between a Live Connection and an Extract in Tableau?

Reference answer

A Live Connection queries the data source in real time, while an Extract stores a snapshot of data inside the platform. Live connections are useful when real-time data is required, but they depend heavily on database performance. Extracts are preferred for faster performance, large datasets, and scheduled refreshes. These are mostly useful when real-time updates are not mandatory.

113

What data types does Tableau support?

Reference answer

Tableau supports below data types. Data Type: String, Meaning: Character Sequence. Enclosed in ''. Examples: 'Tableau', 'World' Data Type: Number (Whole), Meaning: Integers, Examples: 9 Data Type: Number (decimal), Meaning: Floating values., Examples: 123.45 Data Type: Boolean, Meaning: They are logical values., Examples: TRUE, FALSE Data Type: Date, Meaning: Date, Examples: "02/01/2015" Data Type: Date & Time, Meaning: Date and Time, Examples: 01 January 2019 05:55:00 PM Data Type: Geographic Values, Meaning: Geographical Values, Examples: India, Italy, Canada

114

How do you manage real-time dashboards?

Reference answer

Use streaming datasets, push datasets, or the PubNub connector to visualize live data.

115

Scenario: You are working on a report that needs to be shared with external stakeholders. How would you ensure that the data is secure and only accessible to authorized users?

Reference answer

To control access to the report in Power BI, security features can be used. This involves defining roles and assigning permissions to each role. Azure Active Directory can also be considered to manage user authentication and access. To ensure security, the report should be published to a secure workspace within Power BI Service, and any sensitive data should be encrypted both in transit and at rest.

116

What Is An On-Premises Data Gateway?

Reference answer

A bridge that connects on-premises data sources to Power BI Service for secure data refresh.

117

What is a parameter Tableau? And how does it work?

Reference answer

In Tableau, a parameter is a dynamic placeholder that allows users to input values that can be used in calculations, filters, and various other aspects of a visualization. It is a powerful feature that enhances the interactivity and flexibility of Tableau dashboards and reports. How Parameters Work in Tableau: Creating a Parameter: To create a parameter in Tableau, you define its data type (integer, float, string, date, etc.) and set its allowable values, which can be a range, list, or a set of individual values. Interactivity: Once a parameter is created, it appears as a control element on the Tableau dashboard. Users can interact with the parameter by changing its value using a dropdown, slider, or input field. Parameter in Calculations: Parameters can be incorporated into calculations and formulas in Tableau. For example, you can create a calculated field that uses a parameter to dynamically adjust the calculation based on the user's input. Dynamic Filters: Parameters can be used as dynamic filters, allowing users to filter data by selecting values from the parameter dropdown. This allows users to interactively control what data they want to view. Comparisons and Scenarios: Parameters are valuable for creating comparisons and scenarios. Users can change the parameter value to view different subsets of data or compare different aspects of the visualization. Customizing Dashboards: Parameters can also be used to customize dashboard elements, such as titles, captions, and labels. This helps in creating more personalized and user-friendly dashboards. Storytelling: Parameters enhance storytelling capabilities by allowing users to interactively control visual elements and view different perspectives of the data. Parameters provide a level of user control and flexibility, allowing for a more interactive and insightful data analysis experience. They empower users to explore data, make data-driven decisions, and gain deeper insights from visualizations without needing to modify the underlying data or calculations.

118

What are the two main options for saving data in Tableau?

Reference answer

Two main options for saving data in Tableau are files with a .twb extension and files with a .twbx extension. Tableau workbook files, or .twb files, are XML documents that contain the structure for interacting with Tableau but not the actual data. Meanwhile, Tableau packaged workbooks, or .twbx files, include a .twb file as well as data sources packaged together in one file.

119

How to create a dynamic title for your report page that changes based on the selected year.

Reference answer

Use a Card visual with a measure: DynamicTitle = "Sales Report for " & SELECTEDVALUE(Date[Year])

120

Your report loads slowly due to large data volume. What steps would you take to improve performance?

Reference answer

First, I would remove unused columns and reduce the data volume with filters. I would optimize DAX measures by avoiding nested iterations. Disabling auto date/time and summarizing data at source level helps too.

121

What is more important: 'Accurate Numbers' or 'Best Visualization'?

Reference answer

Both are critical, but accuracy takes precedence. Without accurate data, even the best visualizations mislead decision-makers. However, combining accuracy with effective visuals provides maximum insights.

122

What are the main components of Power BI, and how do they interact with each other?

Reference answer

Look for: Knowledge of Power BI Desktop, Power BI Service, Power BI Mobile, and Power BI Report Server. What to Expect: Explanation of how data is imported and transformed in Power BI Desktop, published to Power BI Service, and viewed on Power BI Mobile, including how these components integrate for seamless data reporting.

123

What are the various types of refresh options provided in Power BI?

Reference answer

Package refresh – This synchronizes your Power BI Desktop or Excel file between the Power BI service and OneDrive, or SharePoint Online. Model or data refresh – This refreshes the dataset within the Power BI service with data from the original data source. Tile refresh – This updates the cache for tile visuals every 15 minutes on the dashboard once data changes. Visual container refresh – This refreshes the visible container and updates the cached report visuals within a report once the data changes.

124

What is a bullet graph in Tableau?

Reference answer

A bullet graph is a variant of Bar graph. It is responsible for comparing the performance of one measure with other measures.

125

How to create and manage relationships in Power BI Desktop?

Reference answer

As the name suggests, relationships in Power BI are used to define connections or the relation between two or more tables. To perform analysis on multiple tables, relationships are used. To create and manage relationships in Power BI Desktop: On the Home tab, select Manage Relationships > New. In the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship. In the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then choose OK.

126

How do you optimize a slow SQL query used in Power BI reports?

Reference answer

I use indexing, reduce columns in SELECT, avoid SELECT *, and apply filters early. I also use query folding to push transformations to SQL Server and analyze execution plans.

127

What is a histogram chart best used for in Tableau?

Reference answer

Histogram is the best chart for showing how data points are distributed in a single variable. It displays the counts and frequency of data points inside predetermined bins or intervals. This representation is viewed for observing outliers, patterns and distributional shape from central tendencies. Histogram charts are especially beneficial for understanding the distribution of numerical and continuous data.

128

What is VIZQL?

Reference answer

VIZQL is Visual Inquiry Language. It is a combination of VIZ and SQL. It is similar to SQL language. But instead of SQL commands, the VIZQL language converts data queries into visual images.

129

What is a What-If parameter and how have you used it?

Reference answer

A What-If parameter allows users to simulate scenarios by adjusting a slicer. I used it for price sensitivity analysis, where users change a discount percentage to see its impact on revenue.

130

How do you differentiate between dimensions and measures in Tableau?

Reference answer

I explain it like this: dimensions slice the data—product, region, month—while measures do the math—sales, profit, quantity. In Tableau you see blue pills for discrete dimensions and green for continuous measures. On a recent retail dashboard, treating 'Order Date' as a continuous measure let me plot a smooth sales trend line, but switching it to a discrete dimension created month-over-month bars for management's detailed view. That flexibility hinges on knowing the difference.

131

How do you validate the accuracy of data 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.

132

How many maximum tables can you join in Tableau?

Reference answer

You can join a maximum of 32 tables in Tableau.

133

Explain about Power BI Desktop

Reference answer

Power BI Desktop is a free desktop application that can be installed on your computer. It cohesively works with the Power BI service by providing advanced data modeling, shaping, exploration, and creating reports with highly interactive visualizations. It enables users to save the work to a file or publish their reports and data right to your Power BI site to share with others. Below are the distinct Excel BI add-ons. Power Query to find, edit and load external data Power View for designing interactive and visual reports PowerPivot to analyze data modeling Power Map for displaying insights in 3D Map

134

What is Power BI and how does it help data analysts?

Reference answer

Power BI (Power Business Intelligence) by Microsoft is a powerful tool for interactive data visualization and business intelligence. It handles complex and large datasets efficiently and allows data to be pulled from various sources, such as Excel spreadsheets and cloud-based SQL Server databases, transforming it into interactive, live dashboards and reports. This visual experience enables non-technical business users to access and drill down into the data to uncover business insights. This is crucial because it empowers analysts to turn raw data into meaningful visual representations, facilitating better decision-making and insights for non-technical stakeholders.

135

What are the different types of refreshing data for our published reports?

Reference answer

There are four main types of refresh in Power BI. Package refresh, model or data refresh, tile refresh and visual container refresh.

136

Difference between Calculated Field and Quick Table Calculation?

Reference answer

| Basis | Calculated Field | Quick Table Calculation | |---|---|---| | Definition | A user-defined field created using formulas or expressions on existing data fields to derive new measures or dimensions. | A pre-built transformation applied to an existing measure in a worksheet to calculate things like running totals, percent of total, moving average, etc. | | Purpose | To create custom calculations that are not already present in the data source. | To quickly perform common analytical calculations on measures without writing formulas manually. | | Scope | Can be used anywhere in the workbook (worksheets, dashboards, etc.). | Applied only at the worksheet level and specific to the measure and view. | | Customization | Fully customizable; you can use strings, dates, logical, mathematical and aggregation functions. | Limited to pre-defined calculations; customization is mainly in choosing options like direction (table across, down, etc.). | | Dependency on View | Independent of the current visualization. | Dependent on the layout and structure of the current view. |

137

How do you handle a situation where the data source schema changes unexpectedly and breaks your Power BI report?

Reference answer

If a schema change breaks the report, I respond in three phases: identify, fix, and prevent. First, I identify what changed. I open Power Query and check the error messages. Usually, I see errors like "Column not found" or data type mismatch issues. I trace which tables and columns are affected and determine whether the issue impacts the entire dataset or only specific visuals. At the same time, I inform stakeholders that the report is temporarily impacted and give an estimated timeline for resolution. Clear communication prevents confusion and builds trust. Next, I fix the issue. If a column was renamed, I update the transformation steps in Power Query. If a column was removed or its data type changed, I adjust the transformations and any DAX measures that reference it. After making changes, I test the entire report thoroughly to ensure no downstream logic is affected. Once validated, I republish the dataset and confirm that scheduled refresh runs successfully. For prevention, I prefer using database views instead of connecting directly to raw tables. Views act as a contract layer. If the underlying schema changes, the database team can adjust the view without breaking my report. I also document dependencies, which tables and columns the report relies on. In Power Query, I avoid hard-coding steps that assume a fixed column order. When possible, I add validation logic to handle missing columns more gracefully. If the architecture allows, I use Dataflows as an abstraction layer between the source and datasets. That way, schema changes can be handled once at the Dataflow level rather than in every report. Finally, I enable refresh failure alerts in Power BI Service so I get notified immediately if a schema change causes a refresh failure.

138

What is Fabric?

Reference answer

Microsoft Fabric is an end-to-end data analytics platform. It integrates various data services and tools into a single, unified experience. Data engineers and admins use the platform to manage and integrate the organization's data infrastructure. It facilitates collaboration between data engineers, data scientists, and business analysts. Power BI is part of Microsoft Fabric. Other services include Data Engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, and Databases. Many Azure products are bundled into Fabric, like Synapse Analytics, Azure Machine Learning, Data Lake Storage, Databricks, and more. It also includes OneLake, which is the centralized storage. It's a single point of entry for all the internal data sources (like OneDrive for data). ? Microsoft Fabric is a comprehensive data analytics platform that integrates various data services, including Power BI, into a unified experience.

139

How do you secure Power BI reports?

Reference answer

- Row-Level Security (RLS). - Workspace permissions. - Data encryption.

140

How can you optimize Power BI performance?

Reference answer

Reduce model size using a star schema. Avoid unnecessary calculated columns. Use aggregations and query folding. Optimize visuals and remove unnecessary elements.

141

How can you create a drill-through report in Power BI using a parameter?

Reference answer

To create a drill-through report in Power BI using a parameter, you can define a parameter in the original report that is used to filter the data in the drill-through report. Once the parameter is defined, you can add a drill-through button that passes the parameter to the drill-through report.

142

How do you connect Power BI to a data source?

Reference answer

Click on “Get Data” and choose the source – Excel, SQL Server, web, etc. Then load or transform it.

143

What is the selection pane used for in Power BI?

Reference answer

If I wanted to view all featured elements on the page, I'd use the selection pane. Similarly, if I wanted to hide the visuals, I could use the selection pane to achieve this.

144

What is a Composite Model?

Reference answer

Allows combining Import + DirectQuery sources in one report.

145

How can you create a waterfall chart in Power BI?

Reference answer

To create a waterfall chart in Power BI, you can use the "Waterfall" chart type and specify the initial value, the positive values, and the negative values. Once the chart is created, you can format it to show the change in value for each category.

146

What is Power BI? How is it used in business intelligence?

Reference answer

Power BI is a Microsoft tool used for data visualization and reporting. It helps turn raw data into interactive dashboards and reports that support better decision-making. Companies use it to track KPIs, spot trends, and share insights in real-time.

147

What are the different filters in Tableau and how are they different from each other?

Reference answer

In Tableau, filters are used to restrict the data from database. The different filters in Tableau are: Quick , Context and Normal/Traditional filter are: Normal Filter is used to restrict the data from database based on selected dimension or measure. A Traditional Filter can be created by simply dragging a field onto the 'Filters' shelf. Quick filter is used to view the filtering options and filter each worksheet on a dashboard while changing the values dynamically (within the range defined) during the run time. Context Filter is used to filter the data that is transferred to each individual worksheet. When a worksheet queries the data source, it creates a temporary, flat table that is uses to compute the chart. This temporary table includes all values that are not filtered out by either the Custom SQL or the Context Filter.

148

What are some of differences in data modeling between Power BI Desktop and Power Pivot for Excel?

Reference answer

Here are some of the differences: Power BI Desktop supports bi-directional cross filtering relationships, security, calculated tables, and Direct Query options.

149

How do you calculate the percentage of total in a field in Tableau?

Reference answer

The percentage of total in a field can be calculated with a simple process. This process includes choosing percentages from the 'analysis' option. It will show different percentages like table, table in the pane, row, row in the pane and cell. Select the one total value from them on which we have to determine the percentage. The system will calculate the percentage after selecting the option.

150

What is a Degenerated Dimension?

Reference answer

Degenerated Dimension: Degenerated dimensions have primary keys only without any matter of info.

151

What is a Power BI desktop?

Reference answer

To access the Power BI features, visualize data, or model them to create reports, you can simply download a desktop version of Power BI. With the desktop version, you can extract data from various data sources, transform them, create visuals or reports, and share them using Power BI services

152

Why would someone not use Tableau?

Reference answer

The limitations of using Tableau are: - Not cost-effective: Tableau is not that cost-effective when we compare it well with the other available data visualization tools. In addition to this, it has software upgrades, proper deployment, maintenance, and also training people for using the tool. - Not so secure: When it comes to data, everyone is extra cautious. Tableau focussed on security issues but fails to provide centralized data-level security. It pushes for row-level security and creates an account for every user which makes it more prone to security glitches. - BI capabilities are not enough: Tableau lacks basic BI capabilities like large-scale reporting, building data tables, or creating static layouts. It has limited result-sharing capabilities, email notification configuration is limited to admins, and the vendor doesn't support trigger-based notifications.

153

How do you use parameters in Power BI reports?

Reference answer

Look for: Understanding of dynamic report generation using parameters. What to Expect: Explanation of creating and using parameters in Power BI to enable dynamic data filtering and customization of reports based on user input.

154

What is the difference between a relative date slicer and a standard date slicer in Power BI?

Reference answer

A relative date slicer is a slicer that allows users to filter data based on a relative date range, such as the last 7 days or last month. A standard date slicer, on the other hand, allows users to filter data based on a specific date range, such as a specific month or year.

155

How do you stay updated with new features and releases in Tableau?

Reference answer

I block an hour each month to read release notes and spin up a sandbox workbook. Participating in 'Makeover Monday' keeps my skills sharp and exposes me to creative ideas.

156

How do you handle situations where executives request frequent changes to published reports?

Reference answer

I use a structured change request process. I maintain a development workspace for changes, test thoroughly, and deploy via pipelines. I also educate executives on the impact of changes and suggest self-service features like slicers to reduce dependency.

157

Explain z-order in Power BI?

Reference answer

Z-order is a design strategy used to arrange visuals over shapes. It can also be defined as a method applied to implement when reports consist of multiple elements. Moreover, this can also be used to refresh the display when items in a report are changed.

158

What is DAX?

Reference answer

To do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX). It is a formula language used to compute calculated column and calculated field. DAX works on column values. DAX can not modify or insert data. We can create calculated column and measures with DAX but we can not calculate rows using DAX.

159

How to view underlying SQL Queries in Tableau?

Reference answer

Viewing underlying SQL Queries in Tableau provides two options: Create a Performance Recording to record performance information about the main events you interact with workbook. Users can view the performance metrics in a workbook created by Tableau. Help -> Settings and Performance -> Start Performance Recording Help -> Setting and Performance -> Stop Performance Recording. Reviewing the Tableau Desktop Logs located at C:UsersMy DocumentsMy Tableau Repository. For live connection to data source, you can check log.txt and tabprotosrv.txt files. For an extract, check tdeserver.txt file.

160

How did AIR help during a holiday season hiring surge?

Reference answer

AIR handled all initial screening and interviews for hiring 1,200 warehouse and CS roles in 6 weeks, with the same team size as when hiring 400.

161

Write a sample DAX using DATEADD

Reference answer

SalesPrevYear = CALCULATE(SUM(Sales[Amount]), DATEADD(Calendar[Date], -1, YEAR))

162

How can you share Power BI reports with external users?

Reference answer

Power BI enables you to share dashboards and reports with other users within your organization. This sharing can be done in a few ways, the most common of which is to publish your report to the Power BI service and then either share the report with specific people or distribute it via a link or an embedded code. When it comes to external users, the Power BI service allows you to share content outside of your organization using Azure Active Directory B2B (Business to Business). This way, external users can access the shared content securely. Securely sharing reports with external users ensures that stakeholders outside the organization can access up-to-date insights while maintaining data security and governance.

163

What is the difference between Discrete and Continuous fields in Tableau?

Reference answer

Discrete fields represent separate and distinct values and create headers in the view. They are typically categorical data such as Region, Category, or Customer Name. In Tableau, discrete fields are shown in blue. Continuous fields represent a range of numeric values and create an axis in the visualization. They are usually quantitative data such as Sales, Profit, or Quantity. In Tableau, continuous fields are shown in green. Discrete fields divide the data into individual categories, while continuous fields show data across a continuous range or scale.

164

What is the purpose of a parameter in Tableau?

Reference answer

In Tableau, a parameter is a dynamic placeholder that allows users to input values that can be used in calculations, filters, and various other aspects of a visualization. The purpose of a parameter is to make a Tableau dashboard or report more interactive and flexible by allowing users to control certain aspects of the data analysis without needing to modify the underlying data. Key purposes and benefits of using parameters in Tableau: Interactivity: Parameters enable interactivity in Tableau visualizations. Users can change the parameter value, and the visualization updates dynamically, providing real-time exploration of data. Flexible Filtering: Parameters can be used as dynamic filters, allowing users to filter data by selecting values from a dropdown or inputting specific values. Conditional Calculations: Parameters can be incorporated into calculations and formulas, making calculations dynamic and adaptable to user preferences. Comparisons: Parameters facilitate comparing different scenarios or data subsets. Users can switch between various parameter values to see how different settings impact the visualization. Storytelling: Parameters enhance storytelling capabilities by allowing users to interactively control the visual elements and view different perspectives of the data. Dashboard Customization: Parameters allow users to customize dashboard elements, such as titles, captions, and labels, making the dashboards more personalized and user-friendly. Ad Hoc Analysis: Parameters enable ad hoc analysis by allowing users to experiment with different data views without altering the original data or report. Using parameters in Tableau provides a level of user control and flexibility, allowing for a more interactive and insightful data analysis experience. It empowers users to explore data, make data-driven decisions, and gain deeper insights from visualizations without requiring technical changes to the underlying data sources or calculations.

165

Name the variety of Power BI Formats.

Reference answer

Power BI is available mainly in three formats, as mentioned below. Power BI Desktop: Open-Source version for Desktop users Power BI Services: For Online Services Power BI Mobile Application: Compatible with mobile devices

166

What are Custom Visuals in Power BI?

Reference answer

- Custom-built charts, graphs, and visuals using JavaScript libraries like D3.js. - Available through Power BI Visual Marketplace.

167

What are Fact and Dim tables in SQL?

Reference answer

Fact tables store quantitative data (e.g., sales). Dimension tables store descriptive attributes (e.g., product, customer).

168

What are the parts of Microsoft self-service in BI solutions?

Reference answer

Microsoft's self-service feature has two parts: - Excel BI toolkit: The BI toolkit helps users create interactive reports using imported data from multiple data sources. Data can be easily modeled per the company's requirement to present in the report. - Power BI: This self-service solution allows users to share interactive reports created using the Excel BI Toolkit.

169

What does it mean when a user gets an error while publishing a workbook?

Reference answer

It happens when the user is trying to publish the workbook which is connected to the internal or local server that means the company's network.

170

What are many-to-many relationships and how can they be addressed in Power BI ?

Reference answer

Many to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred. Bi-Directional Crossfiltering relationships can be used in PBIX. CROSSFILTER function can be used in Power Pivot for Excel. DAX can be used per metric to check and optionally modify the filter context.

171

What is Power BI Desktop

Reference answer

Power BI Desktop is an open-source application designed and developed by Microsoft. Power BI Desktop will allow users to connect to, transform, and visualize your data with ease. Power BI Desktop lets users build visuals and collections of visuals that can be shared as reports with your colleagues or your clients in your organization.

172

Which industries and verticals prefer a heat map over other forms of data visualization?

Reference answer

Industries like marketing, defense, and consumer data analysis prefer to use a heat map over other forms of representation. Heat maps are also helpful for getting visual insights on election results and analyzing user behavior on web apps.

173

How do you connect a Fact Table and a Dimension Table in Power BI?

Reference answer

You connect a fact table and a dimension table in Power BI using a key column. Here's how it works: - Key Column: The key column is a unique identifier present in both the fact table and the dimension table. It links the two tables together. - Process: In the Power BI Model view, you create a relationship by dragging the key column from the dimension table to the corresponding key column in the fact table. ? Connect a fact table and a dimension table in Power BI using a key column as the unique identifier between them.

174

What is general formatting in Power BI and its views?

Reference answer

Power BI provides different views for different purposes: - Report view: For designing reports - Data view: For viewing and understanding the underlying data - Model view: For understanding and modifying the relationships between different data tables General formatting in Power BI refers to the adjustment of the aesthetics of the reports and visuals to improve readability and comprehension. This includes basic formatting like color and font adjustments, to advanced formatting options such as conditionally changing colors based on data values. Good formatting enhances data visualization, making it easier to understand and interpret. Furthermore, consistent formatting across reports enhances the professional appearance of the reports.

175

How can Tableau handle large datasets?

Reference answer

Use Data Extracts: Create Tableau extracts (.hyper files) to improve performance because extracts are optimized for faster querying. Filter Data at the Source: Apply data source filters or custom SQL to bring only the required data into Tableau. Aggregate Data: Work with summarized or aggregated data (such as monthly or yearly totals) instead of very detailed transactional data. Optimize the Data Model: Use efficient joins and relationships, and remove unnecessary tables and columns to reduce complexity. Limit the Number of Marks: Avoid creating visualizations with too many marks or high-cardinality fields like transaction IDs. Use Context Filters: Context filters help reduce the dataset first, making other filters more efficient. Use Performance Recording: Tableau provides a Performance Recording feature that helps identify which queries or visualizations are slowing down the dashboard. Reduce Dashboard Complexity: Avoid adding too many worksheets, filters, or heavy calculations in a single dashboard. Use Proper Data Types: Ensure fields use the correct data type to avoid unnecessary processing. Optimize Calculated Fields: Avoid complex calculations in Tableau if they can be handled in the database or ETL layer before loading the data.

176

What are the different types of charts available in Tableau?

Reference answer

Tableau provides many types of charts to represent data in different ways. Some commonly used charts include: Bar Chart: Used to compare values across categories. Line Chart: Used to show trends or changes over time. Pie Chart: Used to represent proportions of a whole. Scatter Plot: Used to show the relationship between two numerical variables. Map Chart: Used to visualize geographical data. Tree Map: Used to represent hierarchical data with nested rectangles. Heat Map: Uses color intensity to show patterns or density in data. Area Chart: Used to show trends over time with emphasis on volume. Histogram: Shows the distribution of numerical data across ranges. Box Plot: Displays the distribution of data and identifies outliers. Bubble Chart: Uses circles of different sizes to represent data values. Gantt Chart: Commonly used to visualize project timelines and schedules. Packed Bubbles: Displays hierarchical data using circles of varying sizes. Dual Axis Chart: Combines two measures in the same visualization for comparison.

177

What is Power Pivot in Power BI?

Reference answer

Power Pivot in Power BI is a data modelling component that lets you build relationships between tables, create calculations and manage large datasets efficiently. It uses DAX (Data Analysis Expressions) to define calculated columns, tables and measures making it possible to perform advanced analysis beyond simple visualizations. - Helps in creating relationships between multiple tables. - Allows complex calculations using DAX. - Optimized for handling large volumes of data. - Works as the engine behind data models in Power BI.

178

Can you have multiple functional relationships with tables in the Power Pivot data model?

Reference answer

No, there cannot be multiple inactive functional relationships. Only one relationship can be established in the Power Pivot data model.

179

What is the difference between a slicer and a drill-down in Power BI?

Reference answer

A slicer is a visual component that allows users to filter data based on a specific category, while a drill-down is a visual component that allows users to navigate through different levels of detail within a visualization. Slicers are typically used to filter data, while drill-downs are used to explore data.

180

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

Reference answer

A waterfall chart is a chart that shows how an initial value is affected by a series of positive and negative values, while a stacked chart is a chart that shows the composition of each category using stacked bars or columns. Waterfall charts are typically used to show changes in financial data, while stacked charts are used to compare values across categories.

181

How would you define Power BI as an effective solution?

Reference answer

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

182

What are Sets, Parameters, and Groups in Tableau?

Reference answer

Sets are used to define a custom subset of data based on conditions or selection. They allow analysts to focus on specific parts of the data, such as Top N customers, profitable products, or selected categories. Sets can be dynamic (change automatically based on conditions) or fixed (manually selected). They are often used for comparisons like In/Out analysis in dashboards. Parameters are dynamic inputs created by the user that allow interaction with the dashboard. Unlike filters, parameters can control calculations, filters, reference lines, and even change measures or dimensions in a visualization. For example, a parameter can allow a user to choose which metric to display, such as Sales, Profit, or Quantity. Groups are used to combine multiple dimension values into a single category to simplify analysis. For example, several cities can be grouped into a region, or multiple product categories can be grouped into one broader category. Groups help in organizing and reducing the complexity of the data when there are too many individual values.

183

What are the Relationships in Data Modelling?

Reference answer

One-to-One, One-to-Many, Many-to-Many.

184

What is the difference between a tree map and a sunburst chart in Power BI?

Reference answer

A tree map is a chart that shows the composition of a category using rectangles of different sizes, while a sunburst chart is a chart that shows the composition of a category using concentric circles. Tree maps are typically used to show the proportion of each category, while sunburst charts are used to show the hierarchy of the categories.

185

Why do we need to convert analyzed data to visualization?

Reference answer

It becomes apparent for the human brain to interpret visual inputs easily. Translating the analyzed data to a visual context helps absorb new insights in a much better form.

186

What are the building blocks of Power BI?

Reference answer

The major building blocks of Power BI are: - Datasets: Dataset is a collection of data gathered from various sources like SQL Server, Azure, Text, Oracle, XML, JSON, and many more. With the GetData feature in Power BI, we can easily fetch data from any data source. - Visualizations: Visualization is the visual aesthetic representation of data in the form of maps, charts, or tables. - Reports: Reports are a structured representation of datasets that consists of multiple pages. Reports help to extract important information and insights from datasets to take major business decisions. - Dashboards: A dashboard is a single-page representation of reports made of various datasets. Each element is termed a tile. Tiles: Tiles are single-block containing visualizations of a report. Tiles help to differentiate each report.

187

In what situation can we use sets?

Reference answer

We can use sets to determine a subset of data depending on certain conditions. Sets are custom fields that rely on a computed condition. For example, a set might contain the project names having a 1 lac Rs—budget as its threshold condition.

188

What is Row-Level Security in Tableau?

Reference answer

Row-Level Security (RLS) in Tableau is used to control which rows of data a user can see when they access a dashboard or report. Instead of creating separate dashboards for different users, Tableau allows a single dashboard to display different data depending on the user who logs in. This helps protect sensitive data while still allowing multiple users to access the same report. RLS is usually implemented using User Filters, Security Tables, or Calculated Fields that reference functions like USERNAME() or USERDOMAIN(). These functions identify the logged-in user and filter the data accordingly. For example, if a company has sales data for multiple regions, a regional manager will only see the rows related to their region, while a senior manager may see all regions. Another common method is using a security mapping table, where users are mapped to the data they are allowed to view. Tableau then uses this table to filter the data automatically. Row-Level Security is widely used in organizations to maintain data confidentiality, enforce access control, and ensure users only see relevant information.

189

What are other aggregated fields available in Tableau?

Reference answer

In addition to common aggregation functions like SUM, AVG, COUNT, COUNTD, MIN, and MAX, Tableau also provides other aggregation options that help summarize data in different ways. Some other aggregated fields include: MEDIAN: Returns the middle value in a dataset. ATTR (Attribute): Displays a value only if all rows have the same value; otherwise it shows “*”. VAR (Variance): Measures how much the data values differ from the average. VARP (Variance Population): Calculates variance for the entire population. STDEV (Standard Deviation): Measures how spread out the data values are from the average. STDEVP (Standard Deviation Population): Calculates standard deviation for the entire population.

190

How can you use WINDOW_AVG function to calculate a moving average in Tableau?

Reference answer

To calculate a moving average using the 'WINDOW_AVG' function in Tableau: Create a calculated field, in the editor, write the 'WINDOW_AVG' function to calculate the moving average. The function can be used as : WINDOW_AVG([measure] , [start], [End]) - To add the moving average to your visualization in Tableau, drag and drop the calculated field onto your worksheet and configure the calculation by right-clicking on it to access the "Edit Tableau Calculation" dialog. - To control the window size or the number of data points included in the moving average calculation, you can use the '[start]' and '[end]' arguments in the 'WINDOW_AVG' function. - After this, you can customize the format and interact with your visualization.

191

How do you handle many-to-many relationships in Power BI?

Reference answer

Power BI supports direct many-to-many relationships, allowing tables to connect without unique values. However, using this feature can cause issues. Risks of Direct Many-to-Many Relationships: - Ambiguous Results: Undefined relationships can lead to incorrect data in reports. - Complexity: Makes the data model harder to understand and maintain. - Complex DAX measures: Handling these relationships may require more complex DAX measures. - Performance Issues: Complex queries can slow down your reports, especially with large datasets. Recommended Approach: Use a Bridge Table A bridge table simplifies your data model and ensures accurate analysis. Here's how to set it up: - Create a Bridge Table: This table should contain unique key combinations from the two tables with the many-to-many relationship. - Establish Relationships: Connect each original table to the bridge table with one-to-many relationships. This resolves the many-to-many issue ? Many-to-many relationships can lead to incorrect analysis in Power BI. Use a bridge table to simplify your data model and improve accuracy.

192

What are the differences between measures and dimensions in Tableau?

Reference answer

Different factors make measures and dimensions different, including: | Factors | Measures | Dimension | | Nature | These are quantitative and numerical data fields that represent quantities, values and amounts. | These are qualitative and categorical data fields that represent categories, attributes and labels. | | Usage | These are used to perform mathematical and logical operations like sum, average, multiplication, etc. | These are used to group and segment data, build hierarchies and create visualizations. | | Examples | Sales, profit, quantity, etc. | Region, product name, category, etc. |

193

What are the different stages in the working of Power BI?

Reference answer

There are three different stages in working on Power BI, as explained below. Data Integration Data Processing Data Presentation Data Integration The primary step in any business intelligence is to establish a successful connection with the data source and integrate it to extract data for processing.

194

How do inactive relationships work, and when would you use USERELATIONSHIP()?

Reference answer

Inactive relationships exist in the model but are not used by default. USERELATIONSHIP() activates them temporarily within a measure, useful for scenarios like comparing sales by order date vs ship date.

195

Can you provide an example of how Power BI can be used in a specific industry?

Reference answer

Power BI can be used across various industries, such as healthcare, finance, retail, and manufacturing. For example, in healthcare, Power BI can be used to analyze patient data, track hospital performance, monitor staff efficiency, and optimize resource allocation. By integrating with electronic health records (EHR) systems, Power BI provides valuable insights into patient outcomes and operational metrics.

196

Should I share personal Tableau projects during an interview?

Reference answer

Absolutely. Sharing personal projects shows passion and initiative. Whether it's a dashboard you built for a hobby, a side project, or a course assignment, walking through it briefly can highlight your creativity and problem-solving skills.

197

How to perform query tasks in Power BI Desktop?

Reference answer

Power Query is available in Power BI Desktop through the power query editor. To open the power query editor, select Edit Queries from the Power BI Desktop home tab. The ribbon in Power Query Editor consists of five tabs – home, transform, add column, view, and help.

198

How to create donut chart in tableau?

Reference answer

There is no direct way to create a donut chart in tableau but there are two tricks to create it. If you want to show a donut chart in a sheet first of all plot a pie chart and then add another measure to rows shelf. Now you can see two pie charts on the sheet change the colour of second pie chart to match the background colour and reduce its size, now right click on second instance in rows shelf and select dual axis then remove all the details which are not required. The second way to create a donut chart will work only in a dashboard. First create a pie chart in a sheet and import it to dashboard then place a circular image with same colour as of the background and move it to the centre.

199

What kind of specialists typically use Power BI?

Reference answer

Power BI is popular across various roles, especially those responsible for analyzing data and making decisions based on it. You'll commonly see it used by: - Business Analysts: To quickly identify business trends, spot opportunities, and present insights clearly to stakeholders. - Data Analysts: To efficiently analyze and visualize complex datasets, simplifying the discovery of actionable insights and trends. - Project Managers: They use dashboards to monitor project progress, spot bottlenecks, and keep teams aligned on KPIs and timelines. - Data Scientists: While they often use specialized analytical tools, data scientists also leverage Power BI for sharing results, especially when communicating complex models to non-technical stakeholders. - Marketing Specialists: They use it to quickly visualize customer data, track campaign performance, and adjust strategies based on clear, real-time feedback. - Finance Professionals: Frequently rely on Power BI to perform budget analysis, financial forecasting, and generate visual reports for stakeholders. - Executives and Managers: Many senior leaders prefer Power BI's simplicity and real-time visualizations to stay updated on organizational performance and make informed strategic decisions.

200

Mark each user's first and last transaction in a dataset.

Reference answer

Use ROW_NUMBER() partitioned by user ordered by transaction date ascending for first, and descending for last.

DON'T WANT TO MISS A THING?

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

Common Power BI & Tableau Interview Questions 2025 | SPOTO

Earn a certification to make your resume stand out.

DON'T WANT TO MISS A THING?

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

Common Power BI & Tableau Interview Questions 2025 | SPOTO

Earn a certification to make your resume stand out.

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