Basic Power BI Interview Questions for Beginners

1

How can you create a calculated table in Power BI?

Reference answer

A calculated table is created using DAX expressions that define the rows and columns of the table. To create a calculated table, you can use the "New Table" option in Power BI Desktop and then enter the DAX expression that defines the table.

2

What are different DAX Aggregate Funtions?

Reference answer

Common DAX Aggregate Functions: - SUM: Adds up all numeric values in a column. For example: SUM(Sales[Amount]) - AVERAGE: Calculates the average of numeric values in a column. For example: AVERAGE(Sales[Amount]) - MIN: Returns the smallest value in a column. For example: MIN(Sales[Amount]) - MAX: Returns the largest value in a column. For example: MAX(Sales[Amount]) - COUNT: Counts the number of non-blank values in a column. For example: COUNT(Sales[OrderID]) - COUNTA: Counts all non-empty values including text, numbers and dates. For example: COUNTA(Sales[CustomerName]) - COUNTROWS:Counts the number of rows in a table or table expression. For example: COUNTROWS(Sales) - DISTINCTCOUNT: Counts unique values in a column. For example: DISTINCTCOUNT(Sales[CustomerID]) - PRODUCT: Returns the product of all values in a column. For example: PRODUCT(Sales[Quantity]) - MEDIAN: Returns the median value of a column. For example: MEDIAN(Sales[Amount]) - SUMX: Row-wise sum then aggregate the results. For example: SUMX(Sales, Sales[Quantity] * Sales[Price])

3

How can you create a custom visual in Power BI using Vue.js?

Reference answer

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

4

What is the default storage mode in Power BI Desktop?

Reference answer

B) Import

5

You need to restrict data visibility so that regional managers only see data for their own region. How will you achieve this?

Reference answer

- Implement Row-Level Security (RLS) in Power BI. - Define roles in Power BI Desktop (e.g., [Region] = USERPRINCIPALNAME() mapping). - Publish report to Power BI Service and assign roles to specific users.

6

Highlight duplicate values while skipping the first occurrence.

Reference answer

Use conditional formatting with a formula like COUNTIF($A$1:$A1, A1)>1 applied to the range.

7

What are sets?

Reference answer

Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view.

8

What are the join types in Tableau?

Reference answer

In general, Tableau supports the following join types: - inner join: An inner join returns only the rows that have matching values in both tables. - left join: A left join returns all the rows from the left table, and the matching rows from the right table. If there is no match in the right table, it returns NULL values. - right join: A right join returns all the rows from the right table and the matching rows from the left table. If there is no match in the left table, it returns NULL values. - full outer join: A full outer join returns all the rows from both tables. It includes the matching rows from both tables and the non-matching rows with NULL values for the missing columns.

9

Describe a complex Tableau project you managed from start to finish.

Reference answer

At a financial services firm, I led a project to create a real-time dashboard for monitoring key performance indicators. We faced data integration challenges from multiple sources, which I addressed by implementing a robust ETL process. I collaborated closely with the business team to ensure their requirements were met. Ultimately, the dashboard improved decision-making speed by 30%, resulting in a significant boost in operational efficiency.

10

What is Power BI Dataflow?

Reference answer

- Dataflows store and preprocess data before loading into reports. - Allows reuse of data models across different reports.

11

Have u heard of Performance Analyzer? What is it used for?

Reference answer

Yes, it is used to measure and analyze the performance of each visual and DAX query in a Power BI report.

12

What is a column chart in Tableau?

Reference answer

A column chat visualizes the data as a set of rectangle columns, as their lengths are proportional to values when they represent the data. The horizontal axis shows the category to which they belong, and the vertical axis shows the values.

13

What are the critical components of the Power BI toolkit?

Reference answer

The critical components of Power BI are mentioned below. Power Query Power Pivot Power View Power Map Power Q&A

14

What are the different ways to optimize a Dashboard's Performance?

Reference answer

For a dashboard to load quickly, be responsive and offer a seamless user experience, its performance in Tableau must be optimized. Below are key techniques: 1. Data Source Optimization - Use extracts instead of live connections for large datasets. - Apply data source filters to restrict unnecessary rows. - Optimize joins and reduce custom SQL where possible. 2. Data Aggregation - Pre-aggregate data at the database level. - Summarize fields before bringing them into Tableau. 3. Filter Optimization - Prefer parameters over multiple quick filters when possible. - Use context filters for dependent filtering. - Minimize the number of quick filters and avoid using "Show All Values." 4. Parameter Optimization - Replace heavy filters with parameters when interactivity is required. 5. Sheet Optimization - Hide or remove unused sheets from the workbook. - Simplify visuals (avoid excessive marks, unnecessary detail). - Limit the number of sheets on a single dashboard. 6. Calculation Optimization - Minimize complex row-level calculations and use aggregated calculations. - Avoid redundant or nested calculations that slow query execution. - Use LOD Expressions wisely, as they can increase query time. 7. Dashboard Design Optimization - Reduce the number of visuals and marks displayed at once. - Use extract filters to limit data before loading. - Optimize images, maps and background graphics. 8. Performance Recording - Use Tableau's Performance Recording feature to identify bottlenecks. 9. Server and Publishing Optimization - For Tableau Server, schedule extract refreshes efficiently. - Use published data sources instead of creating duplicates across workbooks.

15

What are some key differences between Tableau Desktop and Tableau Public?

Reference answer

Tableau Desktop is a paid product that offers extensive features for data analysis and visualization, including connectivity to a wide range of data sources and the ability to save work locally. Tableau Public is a free version with limited data source connectivity and requires users to save their work to Tableau's public servers, making it accessible to anyone on the internet.

16

Tell me the four best features of Tableau.

Reference answer

Tableau is a powerful data visualization tool whose four best features are– · Tableau allows real-time data analysis. · It provides advanced visualizations (different types of graphs and charts). · Collaboration of data is possible with Tableau. · Tableau also provides a data blending facility.

17

Explain incremental data refresh.

Reference answer

Incremental refresh allows refreshing only new or changed data instead of the entire dataset, saving time and resources.

18

What is quick filter in tableau?

Reference answer

Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet.

19

Let's suppose a client has given you a project where you have to visualize the movement of a cyclone right from its initial stage. Also, your visualization chart should represent the time at which that cyclone entered certain countries. Which Tableau map will best fit this situation?

Reference answer

A flow map will best fit this scenario. Flow maps allow us to visualize the traversal path and what changes happened with time.

20

How to analyze trends in Sales over time. Which visualization will you use?

Reference answer

Answer: Use a Line Chart with Date on X-axis and Sales on Y-axis.

21

How do I prepare for Power BI certification?

Reference answer

Mindmajix instructor-led training completely prepares you for the certification. We provide two industry-specific projects in the course, which helps you have hands-on experience on all possible scenarios that are part of certification.

22

How do you integrate Power BI with on-premise SQL Server data?

Reference answer

I use an On-premises Data Gateway to connect Power BI Service to SQL Server. In Power BI Desktop, I select SQL Server as the data source and use Import or DirectQuery mode.

23

Explain the CALCULATE function in DAX.

Reference answer

CALCULATE() modifies calculations using filters. Syntax:

24

Why is data aggregation or disaggregation necessary for creating charts in tableau?

Reference answer

Aggregation and disaggregation commands tableau to combine data based on user requirement. If you want to create any chart than there are specific requirements of the chart to be made such as 1 dimension or 2 dimension and 1 measure or 2 measure. And for measures one need to specify the aggregation that is sum, median, average etc. or else by default all the values will be shown as sum. And the user might want to see a different outcome from the chart. So, it is very important to use the correct aggregation method or to disaggregate the data if required.

25

What is Power BI?

Reference answer

Power BI was introduced by Microsoft to combine the multiple data visualization features into one. Power BI is the new term for the data-driven industry and thus carries a lot of opportunities on its shoulders. It comes as a package of three major components: Power BI services Power BI Desktop Power BI mobile app With these three components, Power BI lets you create a data-driven insight into your business. Based on various roles, you can leverage Power BI to your benefits like creating reports, monitor progress, integrate APIs, and many more.

26

What are the three fundamental concepts of DAX?

Reference answer

Syntax: This is how the formula is written—the elements that comprise it. The syntax includes functions such as SUM (used when you want to add figures). If the syntax isn't correct, you'll get an error message. Functions: These are formulas that use specific values (also known as arguments) in a certain order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.

27

How do you use the Advanced Editor in Power Query?

Reference answer

The Advanced Editor displays the M code for all transformation steps. I use it to write custom M functions, optimize queries, or debug complex transformations. It provides full control over the data pipeline.

28

What are bookmarks in Power BI?

Reference answer

Bookmarks in Power BI capture the current state of a report page, including filters, slicers, and the state of visuals. They are helpful when you want to showcase a particular view of your data or create a storytelling sequence in your report. For example You might create bookmarks to highlight different time periods or specific insights during a presentation. Using bookmarks enhances the storytelling aspect of your reports, allowing you to guide users through specific insights and findings effectively.

29

What is Tableau Pulse?

Reference answer

Tableau Pulse is a feature in Tableau that provides automated and personalized insights from data using AI-driven analytics. It continuously monitors key metrics and automatically delivers insights to users about important changes, trends, or anomalies in the data. Instead of manually checking dashboards, users receive data-driven updates and summaries directly through notifications, emails, or integrations like Slack. Tableau Pulse focuses on metrics-based analysis, helping users track business performance more easily. This helps organizations make faster and more informed decisions by proactively highlighting important insights from their data.

30

Explain the concept of a semantic model in Power BI and its benefits.

Reference answer

A semantic model is a structured data layer with defined relationships, measures, hierarchies, and metadata. It allows users to explore data without writing code. It improves reusability and consistency across reports.

31

How to do Performance Testing in Tableau?

Reference answer

Performance testing in tableau is very important as it will let you know how your workbook will operate once you make it publish it into the real world scenarios. To perform the performance testing first step is to set up test environment in tableau server and disable any automated or scheduled extract refresh schedules. Second step is to capture performance metrics using Tabjolt or any other tool then upgrade the test environment and run Tabjolt to check workbook performance. If there is no difference in performance then use a subset of workbooks to again test the performance after doing an extract refresh.

32

What is a Dashboard in Tableau?

Reference answer

A dashboard in Tableau is a collection of multiple visualizations (worksheets), text, images and interactive elements combined in a single view. It is used to present different aspects of data together, allowing users to compare, monitor and interact with insights at once. Instead of looking at charts separately, a dashboard brings them together for storytelling and decision-making. - Combines multiple views: You can place bar charts, maps, line charts and tables in one place. - Interactive controls: Filters, parameters and actions like highlight or go-to URL make dashboards dynamic. - Real-time updates: Refreshes automatically when the underlying data source updates. - Device-specific layouts: Can be optimized for desktop, tablet or mobile. - Storytelling: Lets you connect multiple charts into a meaningful narrative for business insights.

33

What must be installed to use Power BI?

Reference answer

To use the Power BI service for free, you need a work email and a web browser. With this, you can explore data as well as create reports in Power BI Desktop. The mobile app can be downloaded from the following stores: Google Play, App Store, and Windows Store.

34

How to create dashboard in tableau?

Reference answer

A tableau dashboard is the final step in creating the visualization. First of all, create all the charts in different sheets and then click on add new dashboard in the bottom most tab from where you were adding new worksheets. You can also right click on the add new sheet button and there you can select add new dashboard instead of a sheet. There is one more way to add new dashboard, go to dashboard in toolbar then select new dashboard. After following any of the above three ways you will get a new dashboard where you can drag the required sheets from left panel to the dashboard one by one and start applying your creativity to create an understandable story.

35

Can you explain how you use Power BI's built-in AI and machine learning features?

Reference answer

Look for: Experience with Power BI's AI capabilities like Q&A, Quick Insights, and AI visuals. What to Expect: Examples of using AI features to gain insights from data, such as natural language queries with Q&A, generating insights with Quick Insights, and using AI visuals like Key Influencers.

36

What is a discrete vs. a continuous value?

Reference answer

In Tableau, a discrete value is a distinct value that can be counted (number of dogs in the park, number of rainbow colors, etc.), while a continuous value is a numeric value that can take on any value within a range (150.38 lbs, 6 ½ hours, etc.). Discrete values (in blue) are typically used for categorical data, while continuous values (in green) are used for numerical data.

37

What are Context Filters in Tableau?

Reference answer

Context Filters are applied to the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau

38

SQL Question: 2nd Highest Salary

Reference answer

SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

39

What are the available formats?

Reference answer

Power BI is available in various formats: - Power BI desktop: For the desktop version - Power BI mobile app: For using the visualizations on mobile OS and share it - Power BI services: For online SaaS

40

How do you prioritize and manage multiple Tableau projects with tight deadlines?

Reference answer

I prioritize tasks by assessing project scope and deadlines, ensuring that critical tasks are addressed first. I use project management tools like Trello to track progress and facilitate collaboration, and I maintain regular communication with stakeholders to manage expectations and provide updates.

41

What kind of questions should I expect in a Tableau interview?

Reference answer

Expect practical, scenario-based questions. For example, "How would you handle a slow dashboard?" or "How do you approach cleaning messy data before visualization?" Interviewers want to see how you apply your Tableau skills in everyday business situations.

42

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

Reference answer

A stacked column chart is a chart that shows the composition of each category using stacked columns, while a stacked bar chart is a chart that shows the composition of each category using stacked bars. Stacked column charts are typically used to show changes over time, while stacked bar charts are used to compare values across categories.

43

Your Power BI report is running very slowly. Walk through how you would diagnose and fix the performance issues.

Reference answer

If a report runs slowly, I first try to isolate where the delay is coming from instead of immediately rewriting code. I start with Performance Analyzer in Power BI Desktop. I record a refresh and check how long each visual takes. Power BI breaks it down into DAX query time and visual rendering time. If the DAX query takes most of the time, the issue usually lies in the data model or measures. If rendering is slow, the visual may be pulling too much data or using complex interactions. Next, I check the data model. I look for unnecessary columns in large fact tables and remove any that are not used in visuals or calculations. I also verify data types; for example, IDs stored as text instead of integers increase memory usage. If Auto Date/Time is enabled while I already have a proper date table, I disable it to avoid hidden tables expanding the model. Then I review the DAX measures used in the slow visuals. If I see iterators like SUMX or COUNTX over large tables, I evaluate whether a simple aggregation like SUM or COUNT would work. Iterators often shift more work to the formula engine, which becomes expensive at scale. I also simplify CALCULATE expressions by using direct column filters instead of complex FILTER() logic wherever possible. Using variables (VAR) helps avoid recalculating the same expression multiple times. After that, I check the storage mode. If the model uses DirectQuery, every interaction sends queries back to the source system, which increases latency. If the dataset allows it, I switch to Import mode for better performance. In larger systems, I design a composite model with imported aggregation tables for summaries and DirectQuery only for detailed drillthrough. I also review Power Query to ensure query folding still works. If transformations break folding early, Power BI processes more data locally than necessary, increasing refresh time and memory load. If performance is still an issue, I use DAX Studio to analyze server timings and understand how much time the storage engine versus the formula engine consumes. That usually tells me whether the bottleneck is model design or DAX logic. That's the approach I follow: isolate the bottleneck, optimize the model, simplify calculations, and choose the right storage architecture.

44

Define TreeMap.

Reference answer

TreeMaps are a type of data visualization in Tableau that display hierarchical data as nested rectangles where the size and color of the rectangles indicate the values associated with the categories, revealing both the structure of the data and its quantitative aspects.

45

How do you handle row-level security (RLS) in large-scale Power BI deployments?

Reference answer

I define roles in Power BI Desktop using DAX filters based on user attributes like email or region. In Power BI Service, I assign users to roles via workspace settings. For large teams, I use Azure AD groups for scalability.

46

What is Tableau Data Server?

Reference answer

Tableau data server is a feature provided with Tableau server which allows its user to store Data extracts on one centralized server which can be accessed by different users to draw some visualization and analysis on data based on their understandings. This feature helps reducing the memory occupied by data storage because one extract can be used at multiple systems simultaneously.

47

Joins vs. Blending in Tableau.

Reference answer

Joining data means combining two sets of data from a single source (an Excel sheet, for example). Blending data involves the usage of two different sources (an Excel sheet and an Access report).

48

How do you handle null and special values in Tableau projects?

Reference answer

In my Tableau projects, I handle null and special values based on the data context and business needs. For measures, I often use ZN() or IFNULL() to replace nulls with zeros or default values - this ensures charts like KPIs or bar graphs display correctly. For dimensions, I use calculated fields to label nulls as "Unknown" or a relevant category. If the nulls aren't needed, I filter them out, especially to keep dashboards clean and focused. I also use visual options like "Show at default position" or tooltips to explain nulls when transparency is important. Overall, my approach balances clean visuals with accurate data storytelling.

49

What are different Tableau products?

Reference answer

Tableau like other BI tools has a range of products: - Tableau Desktop: Desktop product is used to create optimized queries out from pictures of data. Once the queries are ready, you can perform those queries without the need to code. Tableau desktop encompasses data from various sources into its data engine and creates an interactive dashboard. - Tableau Server: When you have published dashboards using Tableau Desktop, Tableau servers help in sharing them throughout the organization. It is an enterprise-level feature that is installed on a Windows or Linux server. - Tableau Reader: Tableau Reader is a free feature available on Desktop that lets you open and views data visualizations. You can filter or drill down the data but restricts editing any formulas or performing any kind of actions on it. It is also used to extract connection files. - Tableau Online: Tableau online is also a paid feature but doesn't need exclusive installation. It comes with the software and is used to share the published dashboards anywhere and everywhere. - Tableau Public: Tableau public is yet another free feature to view your data visualizations by saving them as worksheets or workbooks on Tableau Server.

50

Why do we need Power Query when Power Pivot can import data from mostly used sources?

Reference answer

Power Query is a self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in. It allows users to pull data from various sources, manipulate said data into a form that suits their needs and load it into Excel. It is most optimum to use Power Query over Power Pivot as it lets you not only load the data but also manipulate it as per the users needs while loading.

51

Write a DAX measure for running total (cumulative sales) per customer.

Reference answer

RunningTotal = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales), Sales[Date] <= MAX(Sales[Date]) && Sales[CustomerID] = MAX(Sales[CustomerID])))

52

How can you sort a particular column in a table?

Reference answer

Every column has these three lines. When you click on that,you can either sort that in ascending order or descending order.

53

How can you merge two datasets like Online Sales and Store Sales into one?

Reference answer

Use Append Queries in Power Query. Syntax: Combined Sales = Append(Online Sales, Store Sales)

54

What is the difference between VALUES and DISTINCT in DAX?

Reference answer

In DAX, VALUES and DISTINCT are used to get unique values, but they work slightly differently: - VALUES: Returns a single column or table (depending on the input) of unique values, including a blank row for null values. It's useful when you need to consider all unique entries, including blanks. - DISTINCT: Returns unique values by removing duplicates, but does not include a blank row for null values. ? VALUES returns unique values including blanks. DISTINCT removes duplicates without including blanks.

55

I have two columns, Ticket date and Ticket Resolution date. How to find the duration of resolution? In case the Ticket Resolution contains Null Values, the duration should be based on days taken till date?

Reference answer

Duration = DATEDIFF(Ticket[Date], COALESCE(Ticket[ResolutionDate], TODAY()), DAY)

56

Explain the Bookmark feature in Power BI.

Reference answer

- Bookmarks allow users to capture and save a report's current state, including applied filters and slicers. - Useful for navigating between different report views dynamically.

57

How can you load a PDF file in Tableau?

Reference answer

On the main page, you would have the “connect to” pane on the left side. From there, you can select “PDF File”

58

How does Tableau compare to other BI tools?

Reference answer

Even if you don't have extensive knowledge of other BI tools, you may still be able to chat about the differences between Tableau and Excel charts. If you have experience with PowerBI, you can learn more about the comparative advantages and disadvantages by reading our PowerBI v. Tableau: Which Should You Choose in 2024? article. A few of the advantages of Tableau over other BI tools include: - a user-friendly interface: the drag-and-drop feature allows an inexperienced user to ramp up fairly easily and start building charts in minutes; - the wide range of data sources that are supported by the application: from relational databases to flat files to web sources, there are many ways to connect your data using Tableau; - design flexibility: Tableau's flexibility allows users to design custom visualizations; and - a supportive user community: the large and active community of users makes it easy to get your Tableau questions answered. One of the downsides of Tableau is its pricing model. At $70/user/month, that's an $840 license per user on an annual basis (before any sales discount is applied). It's not cheap!

59

What is Power BI?

Reference answer

Power BI is a cloud-based data-sharing environment. Once you have developed reports using Power Query, Power Pivot, and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation.

60

What data gateway options are available and when do you use each?

Reference answer

On-premises Data Gateway (standard) for multiple users and Personal Gateway for single-user scenarios. I use the standard gateway for enterprise deployments with scheduled refreshes and live queries.

61

How do you restrict access to the data?

Reference answer

Tableau provides several ways to restrict data access to users, including user-level security, row-level security, and column-level security. Here is a brief overview of each approach: - User-level security: User-level security is used to restrict access to Tableau content based on user login credentials. With user-level security, you can define which users can access specific workbooks, views, and data sources within Tableau. - Row-level security: Row-level security is used to restrict access to specific rows of data within a dataset based on the user's login credentials. - Column-level security: Column-level security is used to restrict access to specific columns of data within a dataset based on the user's login credentials. By using user-level, row-level, and column-level security, you can ensure that only authorized users have access to specific data within your Tableau environment. This can help you to maintain data privacy, confidentiality, and security.

62

What do you know about Row Level Security? And how do you implement it?

Reference answer

Row-level security restricts the data that users view and access based on filters. To configure rowlevel security, users can define rules and roles within Power BI Desktop and publish them to Power BI Service. Also, the username() function can restrict data in the table to the current user. However, to enable row-level security, a Power BI Pro subscription account is essential, and Excel sheets can be used when converted to the .pbix file format. Following are the ways to implement Row Level Security in Power BI: Define roles and rules in Power BI Desktop Validate the roles within Power BI Desktop Manage security on your model Validating the role within the Power BI service

63

How do calculated fields in Tableau compare with DAX measures in Power BI?

Reference answer

Calculated fields in Tableau are row-level or aggregate expressions, similar to DAX measures. DAX is more powerful for time intelligence and filter context manipulation, while Tableau is more intuitive for quick calculations.

64

Name some commonly used tasks in the Query Editor.

Reference answer

Some commonly used tasks in the Query Editor are: Connect to Data: Get Data from various sources and Transform data. Shape Data: Transform your data according to requirement to clean and shape it Group Rows: You can group the values of many rows into one single value by summarizing Pivot Columns: Pivot columns and create a table with aggregated values

65

How can you create a custom visual in Power BI using SVG and D3.js?

Reference answer

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

66

Tell me about a time when you had to collaborate with a team of data analysts or business stakeholders to develop a Tableau dashboard. How did you ensure that everyone's needs and expectations were met?

Reference answer

In my previous role, I was asked to work with a team of data analysts and several business stakeholders to develop a Tableau dashboard for a retail client. The goal was to provide insights into customer purchasing behavior, sales trends, and inventory management. First, I arranged a kick-off meeting to gather the entire team and establish a clear understanding of the project requirements and desired outcomes. During this meeting, I listened carefully to each team member's input, asked questions to clarify their needs, and took diligent notes. I then created a mock-up of the dashboard and shared it with the team to gather feedback. After receiving the team's input, I identified areas that needed improvement and collaborated closely with the data analysts to ensure that the underlying data was accurate and up-to-date. Throughout the process, I maintained open lines of communication, providing regular updates on my progress and addressing any concerns that arose. Once the dashboard was complete, I organized a final review session where I walked the team through the dashboard, ensuring that it met their expectations and answered all key business questions. I also provided training to the team on how to use the dashboard, ensuring they were comfortable navigating and interpreting the data. The end result was a well-received dashboard that the retail client could use to make informed decisions on their sales and inventory strategies. By maintaining strong communication, being open to feedback, and staying focused on the project's goals, I was able to work effectively with the diverse team and deliver a successful Tableau dashboard.

67

How do you combine data from multiple systems like Excel, SQL Server, and Google Sheets in Tableau?

Reference answer

I often work with data from multiple systems - like Excel, SQL Server, and Google Sheets. First, I assess whether I can combine them within Tableau using data blending or joins, or if it's better to pre-join them outside Tableau using tools like Power Query or SQL views. When blending in Tableau, I ensure that the primary and secondary sources are properly related and avoid over-complicating the visual with too many secondary fields. I'm also careful with performance and consistency, often validating results by comparing row-level data from each source. This ensures reliable outputs, even from diverse inputs.

68

Diff between Union & UnionAll?

Reference answer

UNION removes duplicates, UNION ALL keeps all rows.

69

Which chart will you use to visualize the distribution of data across different quartiles?

Reference answer

A Box Plot (also called a Box-and-Whisker Plot) is the best chart to visualize data distribution across quartiles. It summarizes the dataset using key statistics: - Box: Represents the Interquartile Range (IQR: Q1 to Q3). - Line inside the box: Median (Q2). - Whiskers: Extend to minimum and maximum values within a range. - Outliers: Plotted as individual points beyond whiskers. Box plots are useful for quickly identifying central tendency, spread, skewness and outliers making them ideal for statistical comparison across groups.

70

What is meant by Deployment Pipelines?

Reference answer

A feature in Power BI Service to manage the lifecycle of content across development, test, and production stages.

71

What is a table calculation in Tableau?

Reference answer

A table calculation is a specific field in Tableau based on data in a file. Tableau allows you to make basic calculations across a row or a column within a data set, or you can create more involved calculations that utilize multiple columns and rows simultaneously using specific parameters on which calculations you should perform first.

72

Explain responsive slicers in Power BI.

Reference answer

On a Power BI final report page, a developer can resize a responsive slicer to various sizes and shapes, and the data collected in the container will be rearranged to find a match. If a visual report becomes too small to be useful, an icon representing the visual takes its place, saving space on the report page.

73

Apply IFERROR in nested formulas for error handling.

Reference answer

Wrap the formula in IFERROR(formula, value_if_error) to return a custom value when an error occurs.

74

Can you discuss your experience with Tableau extensions and how they can enhance functionality?

Reference answer

I have used Tableau extensions like the DataRobot extension to integrate predictive analytics directly into dashboards, enhancing decision-making capabilities. Additionally, I developed a custom extension to automate data refreshes, significantly improving workflow efficiency.

75

How do you use bookmarks and selection panes in interactive dashboards?

Reference answer

Bookmarks capture report states for navigation or storytelling. Selection panes control visibility of visuals. I combine them to create drill-through experiences or toggle between views.

76

What are custom visuals in Power BI?

Reference answer

Using Power BI visualizations, you can apply customized visualizations like charts, KPIs, etc. from the rich library of PowerBI's custom visuals. It refrains the developers from creating it from scratch using JQuery or Javascript SDK. Once the custom visual is ready, it is tested thoroughly. Post testing, they are packaged in .pbiviz file format and shared within the organization. Types of visuals available in Power BI are: Custom visual files. Organizational files. Marketplace files.

77

What is the use of an On-premises Data Gateway in Power BI administration?

Reference answer

It connects Power BI Service to on-premise data sources. It supports live queries and scheduled refreshes. The gateway runs in the background and must stay online.

78

What is a worksheet in Tableau?

Reference answer

Worksheet is a basic building block of performing data visualization. It has drag and drop fields that construct graphs, charts and tables. It has a feature of customization by which individuals can include filters, charts and manipulate the formatting inside the sheet. They can design unique visualizations with this feature. It is also possible to create computed fields, data blending and reference lines on a worksheet.

79

What is the difference between calculated columns and measures in Power BI?

Reference answer

Calculated columns are columns created in the data model using DAX expressions that perform calculations on each row of data. Measures are also created using DAX, but they aggregate data across multiple rows or tables in the data model. Measures are typically used in visualizations and reports to display aggregate values, such as totals or averages.

80

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

Reference answer

A histogram is a chart that shows the distribution of data within a range of values, while a bar chart is a chart that shows the value of each category using bars. Histograms are typically used to show the frequency of data within a range, while bar charts are used to compare values across categories.

81

How does bi-directional cross filtering work in Power BI data models?

Reference answer

It allows filters to flow both ways between tables. Useful for slicers affecting multiple related tables. But it can introduce circular dependencies or performance issues if used wrongly.

82

What is a Conformed Dimension?

Reference answer

Conformed Dimension: If any dimension is provided by various business areas, then such a dimension is termed a Conformed Dimension. Example – Time (9-5) for any company or hospital or college

83

Is Tableau smart enough to perform strategic acquisition?

Reference answer

Tableau is smart enough to perform strategic acquisition because it can deliver knowledge-based insights with rich visuals that other tools fail to provide. Furthermore, it can conjointly arrange data for different purposes and improvise our methods for producing a crisp understanding of data.

84

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

Reference answer

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

85

What is a histogram?

Reference answer

A histogram is a visual representation with the help of which we can understand the distribution of numerical data.

86

Is there any way of performing load testing in Tableau? If yes, how?

Reference answer

Yes, we can perform load testing in Tableau using TabJolt. It is a server performance testing Tableau server, and tableau does not support this third-party software directly. So, we can install this performance testing server using other open-source applications.

87

Find employees under the same manager who also earn identical salaries.

Reference answer

Use a self-join on manager_id and salary, excluding the same employee.

88

What is a Power BI designer?

Reference answer

A flexible new tool under the Power BI umbrella is the Power BI Designer. It empowers users to create intuitive dashboards and reports that allow them to change their data's visual views easily. This tool is the most popular and best for better analytics and informed decision-making. This designer tool is a host of drag-and-drop features that enable you to place content exactly where you want it to be in a report.

89

What's the main difference between Power BI and Tableau?

Reference answer

When it comes to data visualization tools, Power BI and Tableau are often compared due to their popularity. Although they have overlapping functionalities, key differences exist: Power BI: - Integration: Power BI integrates seamlessly with other Microsoft products, making it a suitable choice for organizations already using Microsoft services like Excel, Azure, and SQL Server. It's the tool of choice for Microsoft heavy offices - Cost: Power BI is generally more cost-effective, with flexible pricing options that cater to small and medium-sized businesses as well as large enterprises - Ease of Use: Power BI is known for its user-friendly interface, which is intuitive for users familiar with Microsoft products Tableau: - Advanced Visualization Capabilities: Tableau offers a wide variety of sophisticated visualization options and greater flexibility in designing dashboards. It is often preferred for its superior visual analytics - User Community and Support: Tableau has a robust user community and extensive resources for learning and troubleshooting, which can be advantageous for users seeking advanced support and training - Adoption in Large Businesses: Tableau is frequently chosen by large enterprises that require complex data visualization and analysis capabilities Knowing the differences between these two will aid in selecting the right tool based on the organization's infrastructure, budget, and visualization needs.

90

How do you optimize Power BI reports for performance?

Reference answer

To optimize Power BI reports for performance, follow these best practices: - Reduce the Amount of Data: Load to the data model only the columns you require for analysis. Remove unnecessary columns and filter out unnecessary rows. - Ensure Efficient Data Models: Design data models with proper relationships and avoid unnecessary columns and tables. - Use Aggregations: Aggregate data at the source to minimize the data processed by Power BI. - Simplify Visuals: Use fewer and simpler visuals to reduce rendering time. - Optimize DAX Calculations: Write efficient DAX formulas and avoid complex calculations on large datasets. - Limit Direct Queries: Use import mode instead of direct query mode when possible to improve performance. Power BI provides several optimization tools. Run the built-in Performance Analyzer to catch and address any lags before you publish the report. When using Direct Query, consider query reduction. You can apply it from the Optimization presets menu. It turns off cross-highlighting and cross-filtering and adds an Apply button to the filter pane. That way the data doesn't reload with every change you make. ? Optimize slow performance in Power BI reports by reducing the amount of data, designing efficient data models, simplifying visuals, aggregating data, optimizing DAX, and limiting direct queries.

91

What is a bar chart in Tableau?

Reference answer

The bar chart visualizes the data as a set of rectangle bars, as their values are proportional to lengths when they represent the data. The vertical axis shows the category to which they belong to and the horizontal axis shows the values. So, the bar chart is a vertical version of the Column chart.

92

What are Parameters in Tableau?

Reference answer

Parameters are dynamic values, we can replace the constant values in calculations.

93

Where is the data stored in Power BI?

Reference answer

Power BI primarily stores data in two secure locations within the Microsoft Azure environment: - Azure Blob Storage: This is where your actual data (the content you upload or import) is securely stored. - Azure SQL Database: This stores all metadata, system configurations, and artifacts related to Power BI, like data models and report definitions. All data stored in Power BI is protected through encryption and secure access controls, ensuring business information remains safe at all times.

94

Create a frequency map for each character in a string.

Reference answer

Use a dictionary and loop through the string, incrementing the count for each character.

95

What is a dashboard in Power BI?

Reference answer

A dashboard is a single-page, real-time view of visuals from one or more reports. It helps users track performance at a glance.

96

How do you manage and monitor Tableau Server performance?

Reference answer

Managing Tableau Server performance involves monitoring metrics through Admin views and tools like TabMon, optimizing extracts and workbooks, and balancing user sessions. Regular updates, permission management, and proactive log monitoring ensure smooth operation. For high traffic, clustering and load balancing improve scalability.

97

In Power BI, what distinguishes a slicer from a filter?

Reference answer

A slicer is a Power BI graphic feature that lets users choose particular values or ranges to filter data in a report. Compared to conventional filters, slicers offer a more interactive and user-friendly method of filtering data. Conversely, filters are not visible to the end user because they are applied directly to the data model or specific visualizations.

98

What are extracts and schedules in Tableau server?

Reference answer

Data extracts are the subsets of data created from data sources. Schedules are scheduled refreshes made on extracts after publishing the workbook. This keeps the data up-to-date. Schedules are strictly managed by the server administrators.

99

What is a Power BI Gateway?

Reference answer

A Power BI Gateway acts as a bridge between on-premises data sources and cloud-based Power BI Service, allowing secure data transfer.

100

In Power BI, what distinguishes a pie chart from a doughnut chart?

Reference answer

Data is shown as segments of a circle in a pie chart, where the sizes of the segments correspond to the values. A doughnut chart resembles a pie chart except that it has a hole in the middle that makes it look like a ring. The percentage of each group within the total is displayed in both charts. Nevertheless, doughnut charts can also have a label or a total value displayed in the centre hole for further information.

101

How can you create a drill-through visualization in Power BI?

Reference answer

To create a drill-through visualization in Power BI, you can use the "Drillthrough" feature to define the relationship between the two visualizations. Once the relationship is defined, you can add drill-through buttons to the original visualization that allow users to navigate to the drill-through visualization.

102

What are tiles in Power BI dashboards?

Reference answer

Tiles are individual visual elements on a dashboard representing specific data metrics.

103

What is the Time Intelligence function?

Reference answer

It is a function that allows manipulating data using periods.

104

Mention some applications of Power BI

Reference answer

There are multiple applications of Power BI; some of them are as follows: Business Analysis Data Analysis Database Administration IT Professional

105

Mention all the primary components of the Tableau Server.

Reference answer

The primary components of Tableau Server are: - Application Server - Data engine - Repository - Data Server - Gateway - VizQL Server - Search and License - Backgrounder

106

What are the different data types in Tableau?

Reference answer

Tableau supports 7 various different data types: - String - Numerical values - Date and time values - Boolean values - Geographic values - Date values - Cluster Values

107

What are the major differences between Power BI and Excel?

Reference answer

Power BI and Excel are both used for data analysis, but they have significant differences: Data Relationships: - Excel: Supports single directional relationships (one-to-many). - Power BI: Supports bi-directional relationships for more complex data models. Cross-Filtering: - Excel: Does not support bi-directional cross-filtering. - Power BI: Enables bi-directional cross-filtering for interactive reports. Security: - Excel: Limited security features for data access and sharing. - Power BI: Robust security features. This includes Row-Level Security (RLS), to control data access based on user roles. Data Import Options: - Excel: Primarily uses single import mode. - Power BI: Offers multiple import options, including Import Mode and DirectQuery for real-time data connectivity. ? Use Excel for detailed data analysis, financial modeling, and ease of use. Power BI is superior for interactive visualizations, handling large datasets, and secure, collaborative reporting.

108

What do you understand by blended axis?

Reference answer

In Tableau, measures can share a single axis so that all the marks are shown in a single pane. Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. We can blend multiple measures by simply dragging one measure or axis and dropping it onto an existing axis.

109

What are Power BI visualizations?

Reference answer

Power BI supports: - Bar, Line, Pie Charts. - Tables & Matrices. - Maps & Scatter Plots. - Custom Visuals from the Marketplace.

110

Can you explain a few ways of how a Power Query can transform the data?

Reference answer

Power Query is available through getting & Transform in Excel 2016 or Power Pivot.

111

What is Power BI Embedded?

Reference answer

Power BI Embedded is a feature that allows developers to embed Power BI visualizations and reports directly into their applications. This feature allows users to access Power BI reports and dashboards without leaving the application.

112

What is the difference between a line chart and an area chart in Power BI?

Reference answer

A line chart is a chart that shows how a value changes over time, while an area chart is a chart that shows the composition of a category using an area. Line charts are typically used to show trends in data, while area charts are used to show the proportion of each category over time.

113

Does Tableau have security permissions for Tableau Public?

Reference answer

Tableau does not have any security permissions or to protect the data in Tableau public. Whatever we shared in Tableau public those files, workbooks can be viewed by all users. There is no security option in Tableau public.

114

How to connect R with tableau?

Reference answer

First of all, download and install R to your system, then install a package known as Rserve using the command: install. packages (“Rserve”) and once installed you don't need to perform this step every time you are trying to use R from tableau. Whereas the next steps are required to be executed every time you want to connect R with tableau. Now use the command: library (Rserve) to import the library to current working environment and then type Rserve() in the command window to connect R with Tableau. Now switch to Tableau and under help menu and select “Manage R connection”, enter sever name as “Localhost” and a port of “6311”. Click on “Test Connection” button to make sure that everything is working fine and finally click on Ok to close.

115

What is RLS? How many types and how to implement?

Reference answer

RLS (Row-Level Security) restricts data access. Types: Static and Dynamic. Implement by creating roles in Power BI Desktop and using DAX filters.

116

What do you mean by grouping?

Reference answer

Power BI Desktop helps you to group the data in your visuals into chunks. You can, however, define your groups and bins. For grouping, use Ctrl + click to select multiple elements in the visual. Right-click one of those elements and, from the menu that appears, choose Group. In the Groups window, you can create new groups or modify existing ones.

117

What is DAX?

Reference answer

Data Analysis Expression (DAX) is a library of formulas used for calculations and data analysis. This library comprises functions, constants, and operators to perform calculations and give results. DAX lets you use the data sets to their full potential and provide insightful reports. DAX is a functional language containing conditional statements, nested functions, value references, and much more. The formulas are either numeric (integers, decimals, etc.) or non-numeric (string, binary). A DAX formula always starts with an equal sign. A: Name of the project B: Start of the DAX formula C: DAX function (to add) D: Parentheses defining arguments E: Name of the table F: Name of the field G: Operator

118

How can you optimize Power BI report performance?

Reference answer

There are several ways to optimize Power BI report performance, including reducing the number of visuals on a page, using filters to limit the amount of data displayed, minimizing the use of calculated columns, and using incremental refresh to load only new or updated data.

119

Explain any two limitations of Power BI.

Reference answer

- Limited data export options: Power BI offers fewer formats for exporting reports. For specific export formats, you need to have a subscription. - Performance issues with large datasets: Power BI experience performance issues when working with large datasets. It impacts the efficiency of the data analysis process.

120

Why to use Power BI?

Reference answer

Power BI offers a simple setup to connect, transform and visualize raw data from multiple sources. These data are further used to extract valuable information for business needs. Non-technical users can use Power BI tools to create dashboards and reports. Moreover, the secure cloud service of Power BI enables you to view the dashboard, report, and share them with the team and stakeholders. The AI feature of Power BI comes in the form of Power Query and Power Q&A. By easily giving voice commands, you can work with these features. Small businesses can use the Power BI desktop version to visualize their data without technical support.

121

Find the state with the lowest profit ratio

Reference answer

First, we'll create a calculated field and enter the following formula: SUM([Sales]) / SUM([Profit]) Next, drag the state field to the Rows shelf and the new calculation to the Columns shelf and over the Text label icon. Finally, sort the chart in ascending order. Your answer is the first state in the list.

122

Identify products with revenue higher than the average across all products.

Reference answer

Use a subquery to compute the average revenue and then filter products where revenue > that average.

123

How do you handle performance issues with slow visuals?

Reference answer

Reduce visuals per page. Avoid complex DAX in visuals. Optimize filters and slicers.

124

Find Average Sales per Customer.

Reference answer

We can write dax query like: Avg Sales per Customer = DIVIDE( SUM(Sales[Amount]), DISTINCTCOUNT(Sales[CustomerID]) )

125

How can we visualize the multiple dimensional data like correlations or covariance in Tableau?

Reference answer

It might be difficult to visualize covariance or correlation between numerous dimensions in Tableau since these metrics frequently use pairwise comparisons. To learn more about relationships, you can construct heatmaps and scatter plots. - Create a scatter plot matrix for pairwise comparisons. - Use a heatmap to represent relationships with color. - Calculate correlations using table calculations or custom formulas. - Add interactivity with parameters or filters.

126

Which career options are open in Power BI?

Reference answer

Beginners and experts both prefer Power BI, and the most preferred career options in this are: - Business analysts - Business owners or scientists - Business developers

127

List some Edit interactions options in Power BI.

Reference answer

Filter: It thoroughly filters the visual/tile based on the filter selection of another variable. Highlight: Highlights only the related elements on the visual None: Ignores the filter selection from another tile/visual.

128

What are the key differences between Import, DirectQuery, and Live Connection modes in Power BI?

Reference answer

Import mode loads data into Power BI's memory for fast performance. DirectQuery queries the source directly for real-time data but can be slower. Live Connection connects to an existing Analysis Services model for centralized governance.

129

How do you handle performance issues in large Power BI reports?

Reference answer

I try to reduce columns, limit visuals per page, and use star schema. I avoid complex DAX when possible. Aggregating data upstream helps a lot. Also, using import mode over DirectQuery improves speed.

130

What is the difference between sets, bins and groups in Tableau?

Reference answer

| Basis | Set | Bin | Group | |---|---|---|---| | Definition | Subset of data based on conditions or selection. | Divides continuous numerical data into intervals. | Combines multiple dimension members into one category. | | Nature | Dynamic (condition-based) or fixed (manual). | Fixed intervals or size defined by user. | Manual grouping and fixed unless edited. | | Purpose | Highlight, filter or compare specific data points. | Simplify continuous data for visualization like histograms. | Simplify and categorize categorical data for easier visualization. | | Data Type | Dimensions or measures. | Only measures (numerical data). | Only dimensions. | | Usage Example | Top 10 products by sales or customers in a region. | Age groups: 0–10, 11–20, 21–30, etc. | Combine "USA" and "Canada" as "North America". | | Calculation | Can be used in calculated fields for analysis. | Can be used in calculations after creating intervals. | Mainly for visualization and not directly used in calculations. |

131

What is a calculated column in Power BI?

Reference answer

A calculated column in Power BI is a new column you create in your data model using DAX (Data Analysis Expressions) formulas. It performs calculations row by row and adds the results to an existing table. This feature is useful for adding new data fields based on existing data, enhancing your reports and analysis. ? A calculated column in Power BI uses DAX to add new fields to a table.

132

How does AIR handle enterprise-scale AI voice interviews?

Reference answer

AIR conducts enterprise-scale AI voice interviews and delivers structured scorecards to your ATS automatically.

133

Which is a single-page canvas that uses visualizations to depict a story?

Reference answer

PowerBI service dashboard is a single-page canvas that uses visualizations to depict a story.

134

What is Power BI, Business Intelligence and its key features?

Reference answer

Power BI is a data visualization tool developed by Microsoft. It enables users to establish connections with diverse data sources, transform and manipulate data, generate interactive reports and dashboards and share insights with others. Power BI is extensively used in organizations to analyze data and make informed decisions based on data-driven insights. BI stands for Business Intelligence which refers to collecting, analyzing and delivering business data to support decision-making in organizations This system uses a variety of tools, applications and practices to transform raw data and organise them into valuable insights. By doing so, companies can make informed decisions, spot trends and improve their overall performance. Power BI is a useful tool with many features. Some notable features include: - It enables users to visualize data and share that visualization with others. - Users are able to browse and examine data from all sources (in a unified view). - Users may scale across enterprises while benefiting from integrated governance and security. - Users can see an output once it has been generated on any device that supports the Power BI application. - Users can run queries on reports using basic English terms.

135

List the benefits of using variables in DAX.

Reference answer

Improve performance Improve readability Reduce complexity Simplify debugging

136

What are the supported file extensions in Tableau?

Reference answer

The supported file extensions used in Tableau Desktop are: - Tableau Workbook (TWB): contains all worksheets, story points, dashboards, etc. - Tableau Data Source (TDS): contains connection information and metadata about your data source - Tableau Data Extract (TDE): contains data that has been extracted from other data sources. - Tableau Packaged Workbook (TWBX): contains a combination of the workbook, connection data, and metadata, and the data itself in the form of TDE. It can be zipped and shared. - Tableau Packaged Data Source (TDSX): contains a combination of different files. - Tableau Bookmark (TBM): to earmark a specific worksheet.

137

What are the different products offered by Tableau?

Reference answer

The tool includes several different products, such as data analytics visualization with desktop and web versions, Tableau Server services, and Tableau Cloud services. These require a license and fees to use. However, you can also access free public and reader versions.

138

What are the seven data types in Tableau?

Reference answer

Tableau categorizes data into seven different data types that you can use: Text or string values, Geographic values, Numerical values, Cluster group values, Date values, Boolean values, and Date and time values.

139

What is Tableau?

Reference answer

Tableau is the most powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards.

140

What are parameters in Tableau and how are they used?

Reference answer

Parameters in Tableau allow you to set specific variables that can filter data and control how your data appears to viewers. You may create parameters based on a constant value or create more dynamic parameters using a list of variables that can change and adapt each time you modify data.

141

You receive conflicting requirements from two departments for the same dashboard. How would you resolve this?

Reference answer

I would facilitate a meeting with both departments to prioritize common metrics. If conflicts remain, I build a core dashboard with shared KPIs and add department-specific pages or bookmarks. Clear documentation of decisions helps avoid future issues.

142

What is Continuous data in Tableau?

Reference answer

Continuous data roles consist of any value within the finite or infinite intervals. For Example – age, unit price, order quantity. Continuous values are displayed as green icons in the data window and green pills on shelves. Continuous fields cannot be sorted.

143

What is Power Query?

Reference answer

Power query is a function that filters transforms, and combines the data extracted from various sources. It helps to import data from databases, files, etc and append data

144

How do you ensure data accuracy in your Tableau visualizations?

Reference answer

To ensure data accuracy, I always start by validating the data sources against known benchmarks. I use Tableau's data interpreter to clean any inconsistencies. I also collaborate with data analysts to conduct regular audits of the datasets. For example, at Infosys, I implemented a checklist for data validation that reduced errors in our dashboards by 30%. This focus on data integrity is crucial for making reliable business decisions.

145

How do you approach data governance and compliance in Power BI?

Reference answer

Data governance and compliance in Power BI involve ensuring data accuracy, consistency, and security. This includes: - Implementing data classification and labeling to identify sensitive data. - Defining and enforcing data access policies and permissions. - Monitoring and auditing data usage and report sharing. - Ensuring compliance with industry regulations and standards, such as GDPR and HIPAA.

146

What is the use of filters in Power BI?

Reference answer

Filters help control what data is shown. You can filter at the visual, page, or report level. They help users focus on relevant insights without changing the actual data.

147

What is the difference between the Tableau Worksheet, Dashboard, Story and Workbook?

Reference answer

| Basis | Worksheet | Dashboard | Story | Workbook | |---|---|---|---|---| | Definition | A single sheet for visualizing data (charts, graphs, tables). | A collection of multiple worksheets and objects in a single view. | A sequence of dashboards or worksheets arranged to tell a data story. | The file that contains all worksheets, dashboards, stories and data connections. | | Purpose | Analyze and visualize data in one view. | Combine multiple views for comprehensive analysis. | Present insights in a structured, narrative format. | Store and organize all Tableau content in one file. | | Components | Charts, tables, graphs, calculations. | Worksheets, images, filters and text objects. | Dashboards and worksheets arranged sequentially. | Worksheets, dashboards, stories, data connections and formatting. | | Use Case | Explore a single metric or dimension. | Monitor KPIs or multiple metrics together. | Explain trends, insights or findings to stakeholders. | Save, share and manage Tableau projects. |

148

How do you remove "All" options from a Tableau auto-filter?

Reference answer

Simply click the down arrow in the auto-filter heading to remove "All" options from the auto-filter. You can scroll down to the dropdown menu labeled "Customize" and uncheck it.

149

What do you mean by parameters in Tableau?

Reference answer

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

150

Binders, Bookcases, Chairs, and Copiers are some of the subcategories included in the source data. It is necessary to merge all of these Sub-categories into a single dimension known as "Office Supplies." What method can be applied to fulfill this requirement?

Reference answer

A Group can be used to unite Fields into a new dimension. You can use groups to combine data from various dimension values, which appear as a new dimension field under Dimensions once they have been grouped. A dashboard's data quality can also be improved using a group. For example, suppose a visualization contains data values like the United States, USA, or the US. In that case, all of these values can be combined into a single Group to create a value like the USA.

151

What do you understand by inner join in Tableau?

Reference answer

With the help of inner join, we can combine two tables where the resultant table is a combination of common records of both the tables.

152

What happens if you misunderstand the filter context in Power BI?

Reference answer

Misunderstanding filter context in Power BI can lead to significant issues in data analysis, primarily through the creation of measures and visualizations that produce inaccurate or misleading results. Common pitfalls include incorrect aggregation of data and discrepancies in visualizations due to conflicting filter contexts. Avoiding these pitfalls ensures the integrity and reliability of data analysis and reporting.

153

What are some familiar sources for data in the Get Data menu in Power BI?

Reference answer

A few familiar data sources are Excel, Power BI datasets, web, text, SQL server, and analysis services.

154

How would you define Power BI as an effective solution?

Reference answer

PowerBI is a cloud based Business Intelligence tool to analyze and visualize raw data that can be fetched from a wide range of data sources. It consolidates business analytics with data visualization and helps any organization to make business decisions based on data.

155

When publishing workbooks on Tableau online, sometimes a error about needing to extract appears. Why does it happen occasionally?

Reference answer

This happens when a user is trying to publish a workbook that is connected to an internal server or a file stored on a local drive, such as a SQL server that is within a company's network.

156

What are bookmarks in Power BI?

Reference answer

Bookmarks capture the current state of a report page, including filters, slicers, and visuals, for storytelling and presentations.

157

How does a Tableau dashboard allow representation of parameters?

Reference answer

Tableau dashboard allows the representation of parameters in four ways only. They don't allow any multiple values like a filter can do. They only allow a single value.

158

What is GetData in Power BI?

Reference answer

Get Data is a simple icon on Power BI used to import data from the source.

159

Use INDEX + MATCH to look up a value to the left of your reference column.

Reference answer

Use INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) to return a value from a column to the left.

160

What is Tableau, and why do businesses use it?

Reference answer

Tableau is a leading visual analytics platform that turns raw data into interactive dashboards without requiring heavy coding. Companies choose it because analysts can connect to almost any data source, iterate visuals in minutes, and share results securely on Tableau Server. For instance, at my last job I replaced a weekly Excel report with a Tableau dashboard that auto-refreshed every hour, freeing four analyst hours per week and giving leadership real-time sales visibility. That blend of speed, clarity, and governance is why Tableau remains my preferred tool.

161

What is Power BI Desktop?

Reference answer

Power BI Desktop is a free desktop application that can be installed right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and creating reports with highly interactive visualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others.

162

Can you convert a string type column into a number type column?

Reference answer

No, it is not possible to convert a string type column into a number type column. When you do this, all the values would change to null.

163

Explain the difference between Import mode, DirectQuery, and Live Connection in Power BI. What are the trade-offs?

Reference answer

I decide between these modes based on three things: data volume, freshness requirements, and how much control I need over the model. Import mode loads data into Power BI's in-memory VertiPaq engine during refresh. Once imported, queries run against memory, which makes it the fastest option for report interaction. It supports the full DAX engine and all Power Query transformations. The trade-off is size and refresh dependency. The dataset must fit within capacity limits, 1 GB in Pro and much larger limits in Premium. Data is only as fresh as the last refresh. If the source changes every minute, Import won't reflect that until the next scheduled refresh. I choose Import when: - The dataset fits within memory limits. - Performance is critical. - Near real-time data isn't required. DirectQuery does not store data in Power BI. Every visual interaction sends a query to the source system in real time. That means the report always shows the latest data. The trade-off is performance and feature limitations. Query speed depends entirely on the source database. Complex visuals generate multiple queries. Some DAX functions are restricted, and heavy transformations are limited compared to Import mode. I use DirectQuery when: - The dataset is too large to import. - Real-time or near real-time access is required. - The source database is well-optimized and can handle frequent queries. Live Connection is similar in that Power BI does not store the data locally. However, instead of querying a relational database, it connects to an existing Analysis Services model or another published Power BI dataset. The semantic model lives elsewhere. The trade-off here is flexibility. I cannot modify the underlying model, add new tables, or perform Power Query transformations. I'm consuming a centrally managed model. The advantage is governance and reuse; multiple reports can rely on a single trusted dataset maintained by a central team. Since 2020, composite models have allowed combining Import and DirectQuery tables in the same model. For example, I might import dimension tables for fast filtering and keep a very large fact table in DirectQuery. I can also use dual storage mode for dimension tables so they behave as Import for some queries and DirectQuery for others. So my decision framework looks like this: - If performance matters most and data fits in memory -> Import. - If real-time access is required and the source can handle the load -> DirectQuery. - If the organization already maintains a governed semantic model -> Live Connection. - If I need both scale and speed -> Composite model with aggregation and dual storage strategy.

164

Explain how relationships are defined in Power BI Desktop?

Reference answer

Relationships between tables are defined in two ways: Manually – Relationships between tables are manually defined using primary and foreign keys. Automatic – When enabled, this automated feature of Power BI detects relationships between tables and creates them automatically.

165

Can you list some limitations of context filters?

Reference answer

There are some limitations associated with context filters in Tableau. These are: - The context filter requires time when a data set contains a lot of data. - Working with context filters becomes challenging when the time-to-market is less. - Tableau's Context filter is not suitable for frequent change.

166

Mention some advantages of Power BI?

Reference answer

Few advantages of using Power BI are : PowerBI can input a huge quantity of data Information can be visualized using powerful templates and visualizations Users get cutting edge intelligence technologies and powerful algorithms that are updated regularly User can have personalised dashboards which are easy to access and understand Users can perform queries on reports using DAX language

167

What is a Calculated Field, and How Will You Create One?

Reference answer

Calculated fields are created using formulas based on other fields. These fields do not exist but are created by you. You can create these fields to: - Segment data - Convert the data type of a field, such as converting a string to a date. - Aggregate data - Filter results - Calculate ratios There are three main types of calculations that you can create: - Basic Calculations: Transform values of the data fields at the source level - Level of Detail (LOD) Expressions: Transform values of the data fields at the source level like basic calculations but with more granular access - Table Calculations: Transform values of the data fields only at the visualization level To create calculate fields: In Tableau, navigate to Analysis>Create a calculated field. Input details in the calculation editor. And, done!

168

What is the order of operations for how things are executed in Tableau?

Reference answer

The order of operations, also called the query pipeline, is the order in which actions, or operations, are executed in Tableau. As you add filters to your dashboard, they will execute in the order determined by the order of operations. You'll notice that some operations can conflict with each other, leading to unexpected results. In the Superstore dataset, let's say we're interested in the top 10 customers by sales volume in New York City only. After applying the city and customer filters, we'll get a different list of top customers than what originally returned. That's because both filters are dimension filters so they get executed "at the same time." The idea is to set another filter level, in this case, the context filter, so the filters get applied in the correct order. To do that, right click on the City:New York City filter and select Add to Context. Your problem is now resolved.

169

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

Reference answer

A table is a visual component that shows data in a tabular format, while a matrix is a visual component that shows data in a tabular format with subtotals and grand totals. Tables are typically used to show detailed data, while matrices are used to summarize data.

170

How will you embed any web page into your Tableau Dashboard?

Reference answer

Embedding any web page to the Tableau dashboard requires the following steps. - First, we have to go to our dashboard. - Under the 'Objects', we will look for the 'Webpage' option. - Double-click that option. - It will come up with a dialog box. - Paste or type your URL or website link in that dialog box. - We will see that the URL page is reflected in our dashboard.

171

What is the purpose of the IF function in Tableau and how is it used?

Reference answer

The IF function in Tableau is used to build calculated fields that test a given condition and return various values depending on whether it is true or false. This is a form of conditional logic. The IF function is valuable for introducing logic and control flow into your Tableau calculations, allowing you to tailor data processing and visualizations to your needs. To use the IF function in Tableau: - To use the IF function, go to the "Analysis" menu and select "Create calculated field". - Write the IF expression in the following format: IF condition THEN value_if_true ELSE value_if_false END - Use IF to apply conditional formatting such as changing the color of data points based on condition.

172

What are the five fully automated steps in AIR's process?

Reference answer

The five fully automated steps cover from application to ranked, verified talent, with zero recruiter coordination required until you're ready to interview.

173

What are Power BI Content Packs?

Reference answer

Content Packs are pre-built datasets, reports, and dashboards shared within an organization.

174

What are the different file formats supported in Power BI?

Reference answer

- .PBIX — Power BI Desktop files. - .PBIT — Power BI template files. - .CSV/.XLSX — Data import files. - .JSON — Custom data source files.

175

Tell Me 5 Filter Functions?

Reference answer

FILTER, ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS.

176

How can you produce custom visualizations in Power BI?

Reference answer

With Power BI, you have the option of producing custom visualizations, which are packages that feature code to help users visualize data. To create custom visuals, you need to use specific programming languages such as JQuery. JavaScript is another programming language that you can use to produce custom visuals.

177

What is the difference between a tree map and heat map?

Reference answer

A heat map can be used for comparing categories with color and size. With heat maps, you can compare two different measures together. A tree map also does the same except it is considered a very powerful visualization as it can be used for illustrating hierarchical data and part-to-whole relationships.

178

What is the use of the “Get Data” icon in Power BI?

Reference answer

When users in Power BI click on the icon “Get Data”, a drop-down menu displays all data sources from which data can be ingested. Data can directly get ingests from sources such as Excel, XML, PDF, JSON, CSV, and SharePoint folder databases and formats such as SQL, SQL Server Analysis Services, IBM, Access, Oracle, MySQL, and much more.

179

How to schedule Refreshes?

Reference answer

In Power BI Service, go to dataset settings and configure scheduled refresh under the 'Scheduled refresh' section.

180

What are the various Power BI versions?

Reference answer

PowerBI has three versions currently: Microsoft PowerBI Free/ Desktop – It is for anybody who wants to see their business insights from the data with visualizations. Microsoft PowerBI Pro – It is the full version of PowerBI which enables unlimited viewing, reporting and sharing of reports which PowerBI Desktop doesn't support.

181

What is Power BI, and what are its main uses?

Reference answer

Power BI is a business analytics tool by Microsoft that transforms data into interactive dashboards and reports, helping organizations make informed decisions.

182

What are drill-through filters in Power BI?

Reference answer

Drill-through filters allow users to drill down into more detailed data by clicking on a specific data point in a visualization. The filter context is passed to a second page or visualization that shows more detailed data related to the selected data point.

183

What would you do if a Tableau dashboard isn't displaying data correctly?

Reference answer

If a Tableau dashboard isn't displaying data correctly, I would first check the data source connection to ensure it's live and properly configured. Next, I would review any filters applied to make sure they are set correctly. I'd also look into calculated fields for any errors and use the 'View Data' feature to verify data integrity. If the issue persists, I would consult Tableau's documentation or collaborate with a team member to find a solution, ensuring that I document my findings for future reference.

184

What are the three fundamental concepts of DAX?

Reference answer

Syntax This is how the formula is written—that is, the elements that comprise it. The Syntax includes functions such as SUM (used when you want to add figures). If the Syntax isn't correct, you'll get an error message. Functions These are formulas that use specific values (also known as arguments) in a particular order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.

185

How many categories are Dimensions divided into?

Reference answer

Dimensions are divided into 9 various categories

186

What is data modelling in Power BI and how do relationships work within it?

Reference answer

Data modelling in Power BI is the process of structuring and organizing data so that it can be used effectively for analysis and reporting. It involves: - Creating tables (from data sources). - Defining calculated columns, measures and hierarchies. - Establishing relationships between tables. A key part of data modelling is creating relationships between two tables, which connect data using common fields like CustomerID or ProductID. These relationships can be: - One-to-Many (1:*): One record relates to multiple records like One Customer → Many Orders. - Many-to-Many (:); Multiple records relate to multiple records like Students ↔ Courses. - One-to-One (1:1): When each row in one table matches exactly one row in another like Employee → Employee ID.

187

How do you use CALCULATE in DAX to apply custom filters?

Reference answer

CALCULATE modifies the filter context of a measure. For example, CALCULATE(SUM(Sales[Amount]), Product[Category] = "Electronics") sums sales only for the Electronics category, overriding any existing filters.

188

What are the data destinations for Power Queries?

Reference answer

There are two destinations for output we get from power query: Load to a table in a worksheet. Load to the Excel Data Model.

189

Explain the difference between slicers and filters in Power BI.

Reference answer

- Slicers: Visual tools used to filter data in reports. Slicers provide an interactive way for users to select specific values and refine the data displayed. - Filters: Applied to reports, pages, or visuals, filters control the data displayed by limiting the dataset based on specified criteria. Filters can be static or dynamic.

190

How do you ensure your Power BI reports are accessible and user-friendly for non-technical business users?

Reference answer

I design reports assuming the user will not read documentation. The layout itself should guide them. First, I keep the structure consistent. Slicers stay in the same position across pages, usually at the top or left. Navigation buttons or page tabs follow a consistent pattern. I align colors with the company branding so the report feels familiar. I use progressive disclosure. The first page shows a high-level summary with key KPIs. Additional pages provide deeper analysis through drill-through or drill-down. I avoid overwhelming users with too much detail upfront. Every visual has a clear, descriptive title written in business language, not technical column names. Axis labels use familiar terms. I add data labels only where they add clarity. If a feature requires interaction, I guide the user. I may add a small text box explaining how to use slicers or drillthrough. I often include a "Reset Filters" button using bookmarks so users can quickly return to the default view. For mobile users, I configure the phone layout manually instead of relying on auto-generated layouts. That ensures KPIs stack logically and remain readable on smaller screens. Accessibility is a priority. I add alt text to all visuals for screen readers. I ensure sufficient color contrast and avoid conveying meaning through color alone. For example, I combine color with icons or labels. I also check tab order so keyboard navigation works properly. For major rollouts, I conduct short walkthrough sessions to explain how to use the dashboard. I also collect feedback through embedded forms or follow-up surveys to refine usability. Power BI supports features like alt text, keyboard navigation, and high-contrast mode. I make sure those are configured properly. My goal is simple: a non-technical user should understand what the dashboard shows and how to interact with it within a few minutes, without needing technical guidance.

191

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

Reference answer

A slicer is a visual component that allows users to filter data based on a specific category, such as date, region, or product. A filter, on the other hand, is a data manipulation function that allows users to exclude or include certain data based on criteria defined by the user.

192

How do you create and use sets in Tableau?

Reference answer

In my experience, sets in Tableau are a powerful feature that allows you to create custom groups based on a specific condition or a range of values. I like to think of them as dynamic selections that can be used in calculations, filters, and visualizations. To create and use sets in Tableau, you can follow these steps: 1. First, right-click on the dimension you want to base your set on, and then choose "Create Set" from the context menu. 2. In the "Create Set" dialog box, you can define the set by selecting members or by using a condition. For example, you might create a set of top 10 customers by sales or a set of products with a specific category. 3. After creating the set, it will appear in the "Sets" section of the Data pane. You can then drag and drop the set onto your visualization or use it in calculations, filters, or other visual elements. 4. Sets can also be combined using operators like union, intersection, or difference to create more complex selections. For example, in my last role, I created a set of high-performing products by filtering on the profit margin. Then, I used this set in a visualization to compare the sales of high-performing products to other products, which helped the sales team focus on promoting the most profitable items.

193

What is Tableau Prep and how is it used for Data Cleaning?

Reference answer

Tableau Prep is a data preparation tool used to clean, combine, and transform raw data before analysis in Tableau. It helps users prepare data through a visual and step-by-step workflow, making it easier to understand the data preparation process. Tableau Prep allows users to remove duplicates, handle missing values, change data types, split or merge fields, and join or union multiple datasets. By cleaning and preparing the data beforehand, it ensures that the data used in Tableau dashboards is accurate, consistent, and ready for analysis.

194

What is story in Tableau?

Reference answer

A story is a sheet that contains a sequence of worksheets or dashboards that work together to convey information. You can create stories to show how facts are connected, provide context, demonstrate how decisions relate to outcomes, or simply make a compelling case. Each individual sheet in a story is called a story point.

195

What is a calculated column in Power BI and why would you use them?

Reference answer

Calculated Columns are DAX expressions that are computed during the model's processing/refresh process for each row of the given column and can be used like any other column in the model.

196

Can you have a table in the model which does not have any relationship with other tables?

Reference answer

Yes. There are two main reasons why you can have disconnected tables: The table is used to present the user with parameter values to be exposed and selected in slicers. It uses the table as a placeholder for metrics in the user interface

197

How do you connect Power BI to Azure Data Lake?

Reference answer

I use the Azure Data Lake Storage Gen2 connector in Power BI. I select the container and folder, then load or transform data. For large datasets, I use DirectQuery or incremental refresh.

198

Have you ever encountered a problem while working with Tableau that you did not know how to solve? How did you go about finding a solution?

Reference answer

A few months back, I was working on a project where I had to create a complex dashboard incorporating multiple data sources. At one point, I realized that I needed to create a specific calculated field to reflect the right output, but I was unsure about the correct formula. To solve this issue, I first tried googling possible solutions and referring to Tableau's official documentation, but I was still stuck. Realizing that I needed more help, I decided to reach out to my colleagues who had faced a similar situation in the past. One of them pointed me in the right direction and suggested a new approach. I then combined their advice with some additional research to come up with a solution that fit the project's requirements perfectly. This experience taught me the importance of collaboration and utilizing available resources to overcome challenges in Tableau. It also motivated me to dive deeper into learning about calculated fields, ensuring I am better prepared for similar situations in the future.

199

What is data blending in tableau?

Reference answer

Data blending is an advanced joining of two different data sources. For example, one data source contains annual sales of a product in different countries and second data source contains countries and their monthly profit and loss values. A simple join won't work in this case because of different levels of segregation. First step will be to aggregate the values in second data source based on year and then perform a join. All these steps can be completed with great ease in tableau. Because tableau can identify the common field of country and year between two data sources and perform a post aggregate join by itself.

200

What is Power Query?

Reference answer

A data transformation tool in Power BI that allows importing, cleaning, and reshaping data before analysis.

DON'T WANT TO MISS A THING?

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

Basic Power BI Interview Questions for Beginners | 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

Basic Power BI Interview Questions for Beginners | SPOTO

Earn a certification to make your resume stand out.

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