Good Interview Questions to Ask as a Tableau Developer

1

When we have data with a hierarchical structure, such as product categories and subcategories, which chart will be best suitable to show this hierarchy?

Reference answer

A TreeMap is ideal for visualizing hierarchical data such as product categories and subcategories. 1. Structure: Uses nested rectangles to represent hierarchy. - Parent categories: Larger rectangles. - Subcategories: Smaller rectangles within the parent. 2. Quantitative representation: Rectangle size indicates the value or magnitude. 3. Additional encoding: Colors can represent another metric like sales or profit. 4. Interactivity: Viewers can click on parent rectangles to explore subcategories.

2

What steps do you follow to publish a report from Power BI Desktop to the Power BI Service?

Reference answer

Save the report, click Publish in the Home tab, select a workspace, and confirm. After publishing, configure dataset settings like scheduled refresh and permissions in the Service.

3

Explain your experience with integrating Tableau with other tools or platforms.

Reference answer

I used the TabPy server to run a k-means clustering model directly from Tableau, letting marketers segment customers on the fly without leaving their dashboard.

4

Power BI can connect to which data sources?

Reference answer

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

5

How does Power BI use the Data Gateway?

Reference answer

One solution that facilitates secure data transfers between Power BI solution and on-premises data sources is called the Data Gateway. Serving as a link between the two, it enables Power BI to retrieve and update data from on-premises sources without putting the source of the data online.

6

What is the Rank Function in Tableau?

Reference answer

Rank function is used to give positions (rank) to any measure in the data set. Tableau can rank measure in the following ways: - Rank: The rank function in Tableau accepts two arguments: aggregated measure and ranking order (optional) with a default value of desc. - Rank_dense: The rank_dense also accepts the two arguments: aggregated measure and ranking order. This assigns the same rank to the same values but doesn't stop there and keeps incrementing with the other values. For instance, if you have values 10, 20, 20, 30, then ranks will be 1, 2, 2, 3. - Rank_modified: The rank_modified assigns the same rank to similar values. - Rank_unique: The rank_unique assigns a unique rank to each and every value. For example, If the values are 10, 20, 20, 30 then the assigned ranks will be 1,2,3,4 respectively.

7

When and how we use SCRIPT_REAL functions in Tableau?

Reference answer

SCRIPT_REAL is one of Tableau's SCRIPT functions that allow you to run external R or Python code inside Tableau. It specifically returns real (decimal) values as output. SCRIPT_REAL(" # R or Python code goes here # For example, in Python: import numpy as np return np.mean(_arg1)", SUM([Sales])) We can use SCRIPT_REAL when: - We want to perform advanced statistical, mathematical or machine learning operations that Tableau alone cannot handle. - The result we expect is numeric with decimals (e.g., probabilities, regression outputs, statistical measures). - We are integrating Tableau with R (via Rserve) or Python (via TabPy) to extend Tableau's calculation capabilities. Example Use Case: - Predicting customer churn probability using a logistic regression model in Python. - Running time-series forecasting from R and returning predicted numeric values. - Calculating correlation or regression coefficients not available natively in Tableau.

8

What all role have u handled in Power BI Service?

Reference answer

Admin, Member, Contributor, Viewer roles in workspaces.

9

What is the purpose of time intelligence functions in Power BI?

Reference answer

Time intelligence functions in Power BI simplify analyzing time-based data. They help users calculate and compare data across different periods, such as days, months, quarters, and years. These functions create measures that adjust based on the date context. This makes it easy to track trends, compare current and past performance, and forecast future outcomes. Examples of Time Intelligence Functions: - SAMEPERIODLASTYEAR: Returns a table of dates shifted by one year back in time from the current date context. Use it as filter inside CALCULATE to return an aggregated value for the previous year. Useful for year-over-year comparisons. - DATESYTD: Returns a table of dates for the year to date in the current context. Use it inside CALCULATE to return a running total. Or use TOTALYTD for a simpler syntax. - DATEADD: Shifts dates by a specified number of intervals (days, months, quarters, years), useful for creating custom date ranges. ? Time intelligence functions in Power BI simplify analyzing time-based data by enabling calculations and comparisons across different periods.

10

What is the data limit for Tableau Public?

Reference answer

Yes, Tableau Public can only allow 10 million rows to users for data visualization.

11

How will you define the Tableau Dashboard?

Reference answer

Tableau dashboard is a combination of different data views. These data views are various forms of visualizations that data analysts produce using Tableau. If the BI analyst or the data analyst makes specific changes in the data, it gets directly reflected in the dashboard.

12

What are the advantages of using VAR? Write a sample DAX fn using VAR?

Reference answer

VAR improves readability and performance by storing intermediate results. Example: VAR TotalSales = SUM(Sales[Amount]) RETURN TotalSales

13

What are Parameters in Power BI?

Reference answer

User-defined inputs to make reports dynamic and reusable.

14

What are the key stages to work through when using Power BI?

Reference answer

There are a few key stages to work through when using Power BI, including integrating, processing, and presenting data. Data integration is the process of connecting with the source of the data and extracting it Processing data refers to the process where Power BI will take note of the values that are missing or the values that are not accurate and process the data thoroughly Presenting data means that Power BI will use the data that has been retrieved from the source and display it in visualizations or charts

15

What are your thoughts on using data storytelling in Tableau?

Reference answer

In my annual revenue story, I arranged dashboards sequentially: overview, drill-down, root cause, and action plan. Annotations guided viewers, and storytelling mode ensured a smooth narrative arc.

16

What is Tableau Data Engine?

Reference answer

Tableau Data Engine is a really cool feature in Tableau. Its an analytical database designed to achieve instant query response, predictive performance, integrate seamlessly into existing data infrastructure and is not limited to load entire data sets into memory. If you work with a large amount of data, it does takes some time to import, create indexes and sort data but after that everything speeds up. Tableau Data Engine is not really in-memory technology. The data is stored in disk after it is imported and the RAM is hardly utilized.

17

What is Power BI Report Server?

Reference answer

Power BI Report Server is an on-premises solution that allows users to create and share Power BI reports within their organization's network. This solution is designed for organizations that require strict control over their data and cannot store data in the cloud.

18

What is Incremental Refresh?

Reference answer

Only refreshes new/changed data – improves performance in large datasets.

19

How to create sets in tableau?

Reference answer

Sets are custom fields used to compare and ask questions about a subset of data. For creating a set on dimension, right-click on a dimension in data pane and select create -> set. In general tab select the fields that will be considered for computing the set. Specify the conditions to create set in conditions tab and you also have the option to select top N members in dataset based on any field in the top tab. When a set is created it divides the measure into two parts namely in and out of the set based on the conditions applied by the user.

20

Tell me about the usage of Filters in Tableau.

Reference answer

Filters in Tableau help to restrict the content from entering the Tableau workbook. It is a process of separating specific values or a collection of values from a result set. Tableau caters to different types of filters like- - Context filters - Extract filters - Filters on dimensions - Data source filters - Table calculation filters - Filters on measures

21

Differentiate between connect live, import all data and Import some data.

Reference answer

- Connect live- establishes a direct connection to your data. Your data source's speed will affect performance. - Import all data - imports an extract of the entire data source into Tableau's fast data engine. - Import some data- extracts a subset of your data and imports it into Tableau's fast data engine. With this option, you must use filters to specify the data you want to extract.

22

Make KPI showing whether actual sales met the target. How do you create it?

Reference answer

Create Actual Sales and Target Sales measures, then use a KPI visual to compare. Syntax: Actual Sales = SUM(Sales[Amount]) Target Sales = SUM(Targets[TargetAmount])

23

How do you handle streaming data?

Reference answer

Use streaming datasets, push datasets, or API connectors for real-time dashboards.

24

What do you understand by right join in Tableau?

Reference answer

With the help of right join, we can combine two tables, where we will get all the records from the right table but only the matched records from the left table.

25

Define a TDE file.

Reference answer

TDE stands for Tableau Desktop Extension and has the extension .tde. TDE file indicates a file that holds data from external files, such as CSV files, MS Excel, or MS Access.

26

What are the different data aggregation functions in Tableau?

Reference answer

Tableau has many different data aggregation functions used in Tableau: - SUM: Calculates the sum of the numeric values within a group or partition. - AVG: Computes the average of the numeric values. - MIN: Determines the minimum value. - MAX: Determines the maximum value. - COUNT: Count the number of records or non-null values. - VAR: Computes the variance of the sample population. - VARP: Computes the variance of the entire population. - STEDV: Compute the standard deviation of the sample population. - STEDVP: Calculate the standard deviation of the entire population.

27

What are the types of visualizations in Power BI?

Reference answer

Visualization is a graphical representation of data. We can use visualizations to create reports and dashboards. The kinds of visualizations available in Power BI are Bar charts, Column charts, Line chart, Area chart, Stacked area chart, Ribbon chart, Waterfall chart, Scatter chart, Pie chart, Donut chart, Treemap chart, Map, Funnel chart, Gauge chart, Cards, KPI, Slicer, Table, Matrix, R script visual, Python visual, etc

28

What are Power BI custom visuals?

Reference answer

Power BI also offers extensions beyond its standard visual capabilities (like bar charts, pie charts, and line graphs) through Custom Visuals. They can be created by anyone and shared with others, allowing for unique, tailored visual representations of data that wouldn't be possible with the standard set of visuals. It's worth noting that some TypeScript or JavaScript skills - and ideally familiarity with the D3 JavaScript library - are typically needed to create these custom visuals. Custom visuals allow for better alignment with specific business objectives and more efficient data communication, providing a higher degree of customization in reporting.

29

What are the differences between a Power BI dataset, Report and a Dashboard?

Reference answer

| Aspect | Power BI Dataset | Power BI Report | Power BI Dashboard | |---|---|---|---| | Purpose | Data storage and modeling | Data visualization and analysis | Data presentation and navigation | | Function | Stores, cleans and prepares data for reporting. | Displays visualizations and insights from a dataset. | Organizes visuals and reports into a single-page view. | | Created In | Built in Power Query or Power BI Desktop. | Created and edited in Power BI Desktop. | Created in Power BI Service by pinning visuals from reports. | | Interactivity | No direct user interactivity. | Fully interactive with filters, slicers and drill-through. | Limited interactivity (supports drill-through but not full filtering). | | Export Options | No export or print options. | Allows export of visuals and reports. | Can export dashboard visuals but with limited options. |

30

Tableau is a Windows-only tool. True or False?

Reference answer

False, it is available for Mac too

31

What is query folding in Power Query?

Reference answer

Query folding pushes data transformations back to the source, improving performance.

32

What is the difference between a dashboard and a report in Power BI?

Reference answer

A dashboard is a high-level summary of key performance indicators and metrics, while a report provides more detailed information and analysis. Dashboards typically include visualizations that are updated in real-time, while reports may be more static and require manual updates.

33

Why might you have a table in the model without any relationships to other tables?

Reference answer

There are mainly 2 reasons why we would have tables without relations in our model: A disconnected table might be used to present the user with parameter values to be exposed and selected in slicers (e.g. growth assumption.) DAX metrics could retrieve this selection and use it with other calculations/metrics. A disconnected table may also be used as a placeholder for metrics in the user interface. It may not contain any rows of data and its columns could be hidden but all metrics are visible.

34

Describe a challenging problem you solved using Power BI. What was your approach and the outcome?

Reference answer

Look for: Problem-solving skills, creativity, and practical application of Power BI features. What to Expect: A detailed explanation of the problem, the steps taken to address it, the Power BI tools and techniques used, and the positive impact of the solution.

35

What is row-level security in Power BI and how do you implement it?

Reference answer

Row-level security (RLS) restricts data access for users based on roles. You define roles and DAX filters in Power BI Desktop. After publishing, assign users to roles in Power BI Service.

36

Is Tableau a good tool for business analysts?

Reference answer

Yes

37

What are Cascading filters in Tableau?

Reference answer

Cascading filters mean filter2 values are dependent on filter1 values. For Example, filter1 is country and if we select “India” for filter1, filter2 values should show all Indian states. This feature we can achieve by using the option “Only Relevant Values”.

38

Mention some significant ways of improving Tableau's performance.

Reference answer

There are different ways of improving Tableau's performance. Some well-known techniques are: - We can minimize the scope of data and keep only the data that we need for our visualization. It will eventually decrease the volume of data making Tableau's processing faster. - To run our Tableau workbook faster, we can use the Extract. - We can avoid using strings while dealing with numbers and prefer using Boolean and integer values. It is because they are faster than strings. - We can hide unnecessary or unused fields. - We can also eliminate needless calculations and sheets. - Eliminating the number of marks from the view can also help bypass information overload.

39

Could you describe Power BI's data shaping concept?

Reference answer

Data shaping is the process of reorganising and modifying data to prepare it for reporting and analysis. Power Query in Power BI offers a variety of transformation capabilities, including filtering, sorting, merging, appending, pivoting, and aggregating data, and it may be used to shape data.

40

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

Reference answer

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

41

What is Power BI Q&A?

Reference answer

Power BI Q&A is a natural language tool that helps in querying your data and getting the results you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your questions and shows you a restated query of what it is looking from your data.

42

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

Reference answer

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

43

Why We Will Use Direct Query Mode?

Reference answer

For real-time data access without importing, when data is too large to import, or when data changes frequently.

44

What is Assume referential integrity?

Reference answer

In some cases, you can improve query performance by selecting the option to Assume Referential Integrity from the Data menu. When you use this option, Tableau will include the joined table in the query only if it is specifically referenced by fields in the view.

45

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

Reference answer

DAX is much more than Power BI. If you learn DAX as a functional language, you become better as a data professional. DAX is based on different nested filters which magnificently improves the performance of data merging, modeling, and filtering tables.

46

What does RLS stand for in Power BI?

Reference answer

B) Row-Level Security

47

How to show a trend of cumulative sales over the year.

Reference answer

Create a Running Total measure in DAX: Cumulative Sales = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Date), Date[Date] <= MAX(Date[Date])))

48

Difference between Power BI and Tableau?

Reference answer

Both PowerBi and Tableau are business intelligence tools for generating reports and data visualization but they do have a few significant differences. Data Source: PowerBI does not have as wide access to data sources as Tableau when compared. Tableau has a wider range of access to various data sources.

49

Explain the difference between a calculated column and a measure.

Reference answer

In Power BI, calculated columns and measures both create new data, but they serve different purposes. Calculated Column: - Calculated during data load. - Stored in the table like any other column. - Best for row-level calculations. Each row in the table gets a value. - Use when you want to place the calculated results in a slicer. - Example Use: Adding profit margin for each sale. Measure: - Calculated on the fly during query time. - Result not stored in the table. Calculated dynamically. - Best for aggregations and calculations that depend on the context of the report, like totals or averages. - Example Use: Summing up total sales for a selected time period. ? Calculated columns are computed during data load and stored in the table, while measures are calculated on the fly during query time and are not stored.

50

Can you name the different joins available in Tableau?

Reference answer

Tableau joins are the same as that SQL. These are: - Left join - Right join - Inner join - Full outer join

51

What is data visualization in Tableau?

Reference answer

Data visualization is a way to represent data that is visually appealing and interactive. With advancements in technology, the number of business intelligence tools has increased which helps users understand data, data sets, data points, charts, graphs, and focus on its impact rather than understanding the tool itself.

52

How do you optimize Power BI reports for performance?

Reference answer

Optimizing Power BI reports involves several best practices, such as: - Reducing the data model size by removing unnecessary columns and tables. - Using calculated columns sparingly and favoring measures. - Limiting the number of visuals and interactions on a single page. - Implementing proper indexing and partitioning in data sources. - Using aggregations and summarized data instead of detailed data.

53

What is the role of the VertiPaq engine in Power BI?

Reference answer

VertiPaq is Power BI's in-memory storage engine. It compresses data using columnar storage and dictionary encoding. This allows fast querying and report performance. It's used when you import data into Power BI.

54

How to generate longitude and latitude in tableau?

Reference answer

Generating longitude and latitude is very easy in tableau. Drag and drop countries or states or cities or any geographical field to the view and tableau automatically plots the places on the map. Then select all the data points and right-click then select view data. In the view data tab, you can see the generated longitude and latitude in front of the related country name. This data can also be exported from tableau to be used in another software or maybe in another data source.

55

Explain Time Intelligence Functions

Reference answer

Examples: - TOTALYTD(), DATESINPERIOD(), SAMEPERIODLASTYEAR() Used for date-based calculations.

56

Suppose my license expires today, will users be able to view dashboards or workbooks which I published in the server earlier?

Reference answer

If your server license expires today, your username on the server will have the role 'unlicensed' which means you cannot access but others can. The site admin can change the ownership to another person so that the extracts do not fail.

57

How do you use bookmarks in Power BI Desktop?

Reference answer

Bookmarks capture the current state of a report page, including filters, slicers, and visual visibility. They are used for storytelling and navigation. You can create them in the Bookmarks pane and link them to buttons.

58

What is the difference between a donut chart and a pie chart in Power BI?

Reference answer

A donut chart is a chart that shows data as a ring divided into slices, while a pie chart is a chart that shows data as a circle divided into slices. Donut charts are typically used to show the composition of a category with a hole in the center, while pie charts are used to show the composition of a category.

59

Difference Between COUNTROWS and DISTINCTCOUNT in DAX

Reference answer

| Function | Purpose | Example | |---|---|---| | COUNTROWS | Counts the total number of rows in a table or table expression (including duplicates) | COUNTROWS of Sales counts all rows in the Sales table | | DISTINCTCOUNT | Counts the number of unique values in a column | DISTINCTCOUNT of Sales[CustomerID] counts unique customers in Sales |

60

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

Reference answer

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

61

Find Total Employees who joined after 2020.

Reference answer

We can write dax query like: Employees_After2020 = CALCULATE( COUNTROWS(Employee), Employee[JoiningYear] > 2020 )

62

Have you ever presented a Tableau dashboard to a non-technical audience? How did you ensure that they understood the data and insights being presented?

Reference answer

During my time at XYZ Company, I was responsible for creating a Tableau dashboard that showcased our sales performance across different regions and product categories. I had to present this dashboard to our senior management team, which consisted of individuals with varying levels of technical expertise. To make sure they understood the data and insights being presented, I followed these steps: 1. Know my audience: I researched the backgrounds of the attendees and noted their roles, level of technical expertise, and any specific concerns they had regarding the sales data. 2. Focus on key insights: I spent time analyzing the dashboard to identify the most important insights that would be of interest to the audience, such as trends, outliers, and success stories. 3. Simplify the visuals: I made sure that my visualizations were clean, clutter-free, and used clear labels, making it easier for the non-technical audience to follow along. 4. Provide context: During the presentation, I explained the background and context of the data being presented, addressing any known concerns and ensuring the audience understood the relevancy of the data. 5. Use relatable analogies: I used analogies and examples familiar to the audience, such as comparing sales performance to a sports game, which made the data more relatable and engaging. After the presentation, I received positive feedback from the senior management, who appreciated my effort to make the dashboard accessible and easy to understand. They were able to make data-driven decisions based on the insights I had presented, which ultimately led to improved sales performance in the following quarter.

63

What is the file extension for Tableau data extract and Tableau Map source?

Reference answer

The file extension for Tableau data extract is .tde, and the Tableau Map source is .tms. Tableau Data Extract files are particular files that comprise a local copy of the whole data set, and it can be a subset of the source data. Tableau Map Source are specific files that contain default map-layer settings developers need to specify for their workbooks.

64

In Power BI, what distinguishes a clustered column chart from a non-clustered one?

Reference answer

With columns arranged according to the category axis, a clustered column chart shows data independently for each category. Data is shown in a single column for each category in a non-clustered column chart, also known as a stacked column chart. Different data series are represented by segments that are stacked on top of one another.

65

What are some disadvantages of Power BI?

Reference answer

While Power BI is extremely powerful and widely adopted, it does come with certain limitations: - Not always intuitive: While user-friendly overall, some advanced features can be challenging for beginners, requiring additional learning. - Data limitations: The free version restricts dataset sizes to 1 GB, limiting its use for larger datasets without upgrading to a paid version. - Real-time constraints: Not all data sources offer seamless real-time connections, requiring extra steps or configurations. - Filter persistence: Filters adjusted by users can't be permanently saved within visual reports, which can be inconvenient when revisiting dashboards. - Licensing restrictions: Access to features like increased data storage, frequent refresh cycles, and collaborative sharing typically requires a Power BI Pro or Premium subscription.

66

What is DRIVE Program Methodology?

Reference answer

It is a product of iterative sessions previously used and tested by enterprise deployments. It is based on best practises and allows a user to follow a specific set of actions to avoid errors and expedite reporting or visualization process.

67

What is your approach to data transformation in Power BI using Power Query?

Reference answer

I start by connecting to the data source, then clean data by removing duplicates, fixing data types, and handling nulls. I merge or append tables as needed and apply filters to reduce volume. All steps are documented in Power Query.

68

What is OneLake Data Hub?

Reference answer

OneLake Data Hub, formerly Power BI Data Hub, is a shortcut on the Power BI ribbon that lets users find and connect to existing Microsoft Fabric items. Such as Power BI semantic models, lakehouses, warehouses, or Datamarts. OneLake is akin to OneDrive for data, providing integrated cloud storage and a single entry point for all internal data sources. ? OneLake Data Hub allows users to connect to Microsoft Fabric items. It serves as integrated cloud storage for all internal data sources, similar to OneDrive for data.

69

What is the difference between Traditional BI and Tableau BI Architecture?

Reference answer

Traditional BI Tableau BI Architecture has hardware limitations. Tableau does not have dependencies. It does not support in-memory, multi-thread, and multi-core computing. It supports memory when using advanced technologies. It has a predefined view of data. It uses predictive analysis for various business operations. We should need a good knowledge of BI and skills. It is easy to work and understanding without the knowledge of BI and the skills data security is provided data security is not provided for the public, whereas in the professional version.

70

What are the different connectivity modes in Power BI?

Reference answer

- SQL Server Import: SQL Server is the most common connectivity type that allows full utilization of Power BI desktop capabilities. - Direct Query: It is only available for specific data sources. It only stores metadata. - Live Connection: When using the live connection, the report interacts directly with existing analysis services models like SQL server analysis services, Azure analysis services, or Power BI dataset services.

71

What are the components of Power BI?

Reference answer

Power BI consists of three main components: Power BI Desktop, Power BI Service, and Power BI Mobile. Power BI Desktop is used to create reports and data models, while Power BI Service is a cloud-based service that allows users to publish, share and collaborate on their reports. Power BI Mobile is a mobile application that allows users to access their reports on-the-go.

72

What are sets?

Reference answer

Sets are custom fields created as a subset of the data in your Tableau desktop. Sets can be computed based on conditions or created manually based on the dimensions of the data source. For example, A set of customers that earned revenue more than some value. Now, set data may update dynamically based on the conditions applied. Learn More

73

Difference Between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE

Reference answer

| Function | Description | Example (Values: 100, 90, 90, 80) | |---|---|---| | RANK | Assigns the same rank to tied values but leaves gaps in the sequence. | 100 → 1 (rank), 90 → 2, 90 → 2, 80 → 4 | | RANK_DENSE | Assigns the same rank to tied values but does not leave gaps in the sequence. | 100 → 1, 90 → 2, 90 → 2, 80 → 3 | | RANK_MODIFIED | Averages the ranks for tied values and assigns that average rank to each. | 100 → 1, 90 → 2.5, 90 → 2.5, 80 → 4 | | RANK_UNIQUE | Assigns a unique rank to each row, even if values are tied (no duplicates). | 100 → 1, 90 → 2, 90 → 3, 80 → 4 |

74

How do you publish a Power BI report from Desktop to the Service?

Reference answer

In Power BI Desktop, click Publish in the Home tab. Select a workspace in Power BI Service. The report and dataset are uploaded. You can then configure settings like scheduled refresh and permissions.

75

What is DAX Studio, and how can it help optimize queries?

Reference answer

DAX Studio is a tool for analyzing and optimizing DAX queries. It helps debug, check performance, and identify bottlenecks using query plans and metrics.

76

What are marks in tableau?

Reference answer

Marks card is very useful in detailing the chart as it can be used to give different colours based on a category and change the size of line or circle or bars in the charts based on any measure value. Marks card is also used to set labels on the chart and also provide detailing to the view. It is also used to manage the tooltip and format the tooltip which should improve the visualizations.

77

In what way Tableau determines null values and exceptional values? How can we handle such data in Tableau?

Reference answer

When we have data fields with negative values with a logarithmic axis or null values without any specific type, Tableau can't plot them in a graph or chart. Tableau designates such data with an indicator symbol at its lower right corner. We can click that indicator to handle such data, and choose options like - Filter Data and - Show data at default position The ‘filter data' helps eradicate null values through filtering, and hence, they remain away at the time of data visualization or analysis and calculation. The 'Show data at default position' option helps place the data at the default location in the axis at the time of data visualization.

78

Can you describe your development methodology?

Reference answer

I work in two-week sprints. Each Tableau request becomes a user story—e.g., 'As a sales manager, I want a weekly pipeline view.' We define acceptance criteria, demo on Friday, gather feedback, then iterate.

79

What are Power BI Dataflows? How do they differ from datasets?

Reference answer

I see Dataflows as the ETL layer in the Power BI ecosystem, and datasets as the semantic modeling layer. A Dataflow is created in Power BI Service using Power Query Online. It extracts data from sources, transforms it, and stores the cleaned result in Azure Data Lake Storage in Common Data Model (CDM) format. The output is structured, reusable tables. A dataset, on the other hand, is the data model behind a report. It contains tables, relationships, measures, calculated columns, hierarchies, and security rules. Reports and dashboards query datasets, not dataflows directly. The key difference that I find here is responsibility. Dataflows handle data preparation. Datasets handle modeling and reporting logic. If I build complex transformations directly inside a dataset and then create five reports that need the same cleaned tables, I end up duplicating ETL logic five times. With Dataflows, I centralize that transformation once and let multiple datasets connect to it. That improves consistency and reduces maintenance. For example, a central analytics team can create a standardized "Customer" Dataflow that cleans, deduplicates, and formats customer data. Different business teams can then build their own datasets on top of that shared entity without redefining business rules. Dataflows refresh independently. They cache the transformed data in the data lake. When a dataset refreshes, it can pull from the Dataflow instead of the raw source systems. That reduces load on operational databases and ensures consistent transformation logic across reports. Within Dataflows, I can use linked entities to reference tables from another Dataflow without duplicating data. I can also create computed entities, which apply additional transformations on top of existing Dataflow entities. This allows layered transformation design. With newer Fabric-enabled environments, Dataflow Gen2 expands capabilities further by improving scalability and integration within Microsoft Fabric. So I separate concerns like this: - Dataflows for reusable, centralized ETL. - Datasets for relationships, measures, security, and report-level logic.

80

Can you give an example of using time intelligence functions for YTD or QTD metrics?

Reference answer

Yes. TOTALYTD(SUM(Sales[Amount]), 'Date'[Date]) calculates year-to-date sales. DATESQTD filters dates for the current quarter. These functions require a proper date table marked as a date table.

81

What is SSBI in the context of Power BI?

Reference answer

SSBI means self-service business intelligence. It's an approach that facilitates the process of using Power BI without any specific coding experience or technical knowledge. For this reason, SSBI makes Power BI accessible to many professionals.

82

What are the three fundamental concepts of DAX?

Reference answer

Three fundamental concepts of DAX are as follows: 1. Row Context - Refers to calculations performed row by row in a table. - Example: Calculating Profit = Sales[Amount] – Sales[Cost] for each row. 2. Filter Context - Refers to the subset of data applied to a calculation using filters, slicers or measures. - Example: Total Sales for a specific Region or Year. 3. Context Transition - Occurs when row context is converted into filter context inside a measure, typically with functions like CALCULATE(). - Example: Using CALCULATE(SUM(Sales[Amount]), Region="India") in a measure.

83

What are Dataflows? Have u configured them?

Reference answer

Dataflows are reusable data transformation components in Power BI Service. Yes, I have configured them for ETL processes.

84

Can we refresh our Power BI reports once uploaded to cloud (Share point or Powebi.com)?

Reference answer

Yes we can refresh our reports through Data Management gateway(for sharepoint), and Power BI Personal gateway(for Powerbi.com)

85

What are content packs in Power BI?

Reference answer

Content packs in Power BI are pre-packaged collections of dashboards, reports, and datasets that provide out-of-the-box insights for services like Google Analytics and Microsoft Dynamics, so you can use a ready-made template. Content packs speed up the process of gaining insights by providing ready-to-use reports and dashboards, making it easier for users to analyze data without starting from scratch. Using content packs can also significantly reduce the time and effort required to set up reports and dashboards, allowing for quicker insights and more efficient data analysis.

86

What is a parameter in the tableau?

Reference answer

A parameter is used to replace a constant value from calculations, filters and reference line. A parameter can be a number, date or string datatype. A user can be given direct control over parameters to modify the filters and calculations based on the requirements.

87

Name the components of a Dashboard.

Reference answer

Left pane of the dashboard shows two tabs, named dashboard and Layout. By default, when you create a new dashboard the user will land of dashboard tab. First button is of device preview which allows the developer to understand the preview of the dashboard on different devices such as tablet, mobile and desktop. Next comes the size of dashboard which can be modified by the developer. After that there is the option to drag and drop sheets to be used in the dashboard. And then there is the option to use various objects such as image, webpage, text, horizontal container, vertical container, blank, navigation button and extensions. Then we have the option to switch to Tiles or Floating option before using the sheets or objects on the dashboard, although we have the option to change this setting at a later point but we should prefer using these buttons. And the last option in this tab is a checkbox of show dashboard title. Now the next tab “Layout” is used to define the size of various floating objects on the dashboard and also setting their x and y coordinates to define their locations. Then we have the option to draw the border on the outer side of the charts and objects and also, we can change the background colours of from here.

88

What are the data sources in Power Query?

Reference answer

Power BI can connect to a wide variety of data sources, spanning from traditional databases to cloud-based services and even online services such as social media. Some common data sources include: - Traditional databases: SQL Server, Oracle, IBM DB2, etc - Cloud-based services: Azure SQL Database, Azure Data Lake Storage, etc - Files: Excel, CSV, XML, JSON, etc - Online services: SharePoint Online, Google Analytics, Dynamics 365, etc Understanding the variety of data sources helps in effectively integrating and analyzing data from multiple platforms, providing a comprehensive view of the business.

89

How would you design a dashboard for a sales director who needs a high-level overview with drill-down capabilities?

Reference answer

I would follow the given steps: 1. Start with a high-level KPI summary (total sales, profit, growth). 2. Add interactive filters for region, time period, and product category. 3. Use a line chart for sales trends and a bar chart for performance by region. 4. Enable drill-down actions so clicking on a region shows detailed data for that area. 5. Use parameters for dynamic views like switching between sales and profit. This approach keeps the dashboard clean, improves performance, and ensures users focus on actionable insights instead of overwhelming information.

90

What are dual axes?

Reference answer

Dual axes are used to analyze two different measures at two different scales in the same graph. This lets you compare multiple attributes on one graph with two independent axes layered one above the other. To add a measure as a dual-axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.

91

What do you understand by full join in Tableau?

Reference answer

With the help of the left join, we can combine two tables, where we will get all the records from the right table and also all the records from the left table.

92

Can you discuss a time when you had to adapt your Tableau approach based on stakeholder requirements?

Reference answer

Initially, I created a sales dashboard focusing on monthly trends, but stakeholders requested a shift to weekly insights for more granular analysis. I quickly adapted by reconfiguring the data aggregation and updating the visualizations, resulting in more actionable insights for the team.

93

Explain Power BI Query Editor

Reference answer

Power BI Query Editor is used to transform or edit data files before they are loaded. The Query Editor plays the role of an intermediate data container where you can transform data by selecting rows and columns, splitting rows and columns, pivoting and unpivoting columns, etc. The modifications done by the Query Editor are not reflected in the actual datasheet.

94

What are Aggregation Functions in Tableau?

Reference answer

Aggregation functions in Tableau are used to summarize or combine multiple data values into a single result. They help analyze large datasets by performing calculations such as totals, averages, or counts. Tableau automatically aggregates measures in visualizations to make the data easier to interpret. Some commonly used aggregation functions include: SUM: Calculates the total of values. AVG: Calculates the average of values. COUNT: Counts the number of records. COUNTD: Counts the number of unique values. MIN: Returns the smallest value. MAX: Returns the largest value.

95

What is a workbook in Tableau?

Reference answer

Workbook is the highest level of a container that presents in this framework. It is also referred to as a document that accommodates several dashboards, tales and spreadsheets. This document stores the complete project, including data visualization and connection. Workbook has some main files to build, store and share projects. All the elements required for data analysis and visualization are stored in these files only. Workbooks manages several dashboards, narratives and worksheets. One can make data source integrations, give parameters and build computed fields on a workbook level.

96

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

Reference answer

Power BI Report Builder is a desktop application that is used to create paginated reports, while Power BI Desktop is a desktop application that is used to create interactive reports and visualizations. Power BI Report Builder is typically used for more traditional reporting scenarios, while Power BI Desktop is used for more interactive and visual reporting scenarios.

97

How do you handle missing or null values during data transformation in Power Query?

Reference answer

I use Replace Values to fill nulls with a default, Remove Rows to delete null rows, or conditional columns to handle them based on logic. The approach depends on the data and business rules.

98

What are the most used DAX functions?

Reference answer

SUM(), AVERAGE(), CALCULATE(), FILTER(), RELATED(), TOTALYTD(), IF().

99

Does Power BI store data?

Reference answer

Datasets are the data sources that are uploaded or connected to databases. These sources include Excel workbooks and Power BI Desktop files. The following are also included in your data capacity. Reporting Services on-premises visualizations are pinned to a Power BI dashboard.

100

Can you explain a complex Power BI project you've worked on, detailing the challenges you faced and how you overcame them?

Reference answer

A complex Power BI project I worked on involved integrating data from multiple sources, including SAP BO and SQL databases, to create a unified sales and financial reporting dashboard. The main challenge was handling data inconsistency and performance issues due to large datasets. I overcame this by using Power Query to clean and transform data, implementing star schema modeling for optimized performance, and using incremental refresh policies to manage data load times. Additionally, I collaborated with stakeholders to refine requirements and used row-level security to ensure data access compliance.

101

What are the best practices for building an efficient data model in Power BI?

Reference answer

Use a star schema with dimension and fact tables. Avoid bi-directional relationships unless needed. Rename columns clearly. Reduce cardinality when possible. Always hide unnecessary columns from the report view.

102

What are a few ways to improve Tableau performance?

Reference answer

Following are a few ways to improve the performance

103

How do you use Power BI to track KPIs and business performance over time?

Reference answer

I use KPIs, slicers, and time intelligence DAX functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD. These help show actual vs target values and trend changes over time with clear visuals.

104

Did you work on Sensitivity Labels?

Reference answer

Yes! Sensitivity Labels classify and protect sensitive data in Power BI, ensuring compliance and security with protection policies.

105

What is the maximum data limit per client for the free version of Power BI?

Reference answer

With a Power BI Free licence a user can use 10 GB of storage in the cloud for hosting Power BI reports. The maximum size a Power BI report can be used in the cloud is 1GB.

106

Mention important components of SSAS.

Reference answer

Some essential components of SSAS are: - OLAP Engine: An OLAP engine is used extensively by end users to run ad hoc queries quickly. - Data Drilling: It is a way of exploring details about data with multiple levels of granularity. - Slicer: The data slicing process in SSAS is used to store data in rows and columns. - Pivot Tables: It helps switch between various listed categories of data stores within rows and columns.

107

What is DAX? What are the benefits of using variables in DAX?

Reference answer

DAX or Data Analysis Expressions is a formula language used in Power BI, Power Pivot and Analysis Services to perform data calculations and analysis. It allows you to create calculated columns, measures and tables to enhance your data model. - Used for aggregations, calculations and data manipulation. - Works with tables and relationships in the data model. - Similar to Excel formulas but designed for relational data. DAX Syntax: MeasureName = VAR x = RETURN x DAX Example: TotalSalesWithTax = VAR SalesAmount = SUM(Sales[Amount]) RETURN SalesAmount * 1.1 Benefits of Using Variables in DAX - Improves readability of complex formulas. - Enhances performance by calculating values once and reusing them. - Simplifies complex calculations. - Makes debugging easier by testing parts of the formula individually.

108

How to share a dashboard with a user who doesn't have a Tableau license?

Reference answer

Follow few steps

109

What are some data visualization best practices?

Reference answer

To be a successful Power BI developer, mastering the art of data visualization is crucial. This means not just presenting data but transforming it into insightful and easily digestible visuals that can drive decision-making. Effective data visualization entails creative decision-making to communicate complex data in an intuitive and compelling manner, blending aesthetics and functionality to make data accessible and engaging to diverse audiences. The key to mastering this art lies in understanding the principles of design such as color, layout, and typography, along with the principles of data representation such as clarity, accuracy, and efficiency. Visualizations should not only present data accurately but also tell a story, guiding the viewer to insights through intentional design choices like highlighting trends, patterns, or anomalies. For example Choosing the right type of chart for the data - whether it's a bar chart for comparisons, a line chart for trends, or a heat map for density - can significantly affect how well the audience understands the message. TL;DR Effective data visualizations simplify complex data, allowing viewers to grasp difficult concepts or identify new patterns, leading to quicker and more informed decision-making.

110

Describe a report you built with multiple data sources. How did you handle data integration?

Reference answer

I built a sales report combining SQL Server, Salesforce, and Excel. I used Power Query to merge and clean data, created a star schema model, and used DAX for cross-source calculations. A date table unified time periods.

111

Difference Between Live Connection vs DirectQuery vs Import

Reference answer

- Import: Fast, offline - DirectQuery: Real-time, slower - Live Connection: Full model lives on SSAS

112

What is the concept of data profiling in Power BI?

Reference answer

Data profiling is the process of examining, understanding, and cleaning data, and ensures the quality and integrity of the data, which are essential for accurate reporting and analysis In Power BI, data profiling tasks are often performed in Power Query Editor, where you can visualize the distribution of data, see patterns, check for outliers, and validate against rules, among others.

113

What is Dual-axis in Tableau?

Reference answer

Dual-axis is used to show 2 measures in a single graph. It allows you to compare 2 measures at once. Many websites like Indeed use this Dual-axis to show the comparisons and growth rate.

114

Name some important tools of Power BI

Reference answer

Power BI Desktop Power BI Service Power BI Data Gateway Power BI Report Server Power BI Mobile Apps

115

How to create stacked bar chart in tableau?

Reference answer

A stacked bar chart can be created by following steps: - Drag a dimension to columns shelf. - Use “Measure Names” on colour in the marks card. - Right click on “Measure Names” and make it as a filter and select the checkboxes for the measures to display. - Now drag “Measure Values” to rows shelf and change the chart type to bar in marks card. Your stacked bar chart is ready now you can change the size and colours as per your creativeness.

116

What is grouping in Power BI Desktop?

Reference answer

In Power BI Desktop, you have the option to gather data together and group it (which is what grouping refers to). To do this, you select a range of elements by pressing Ctrl and clicking the elements. You then select the group option by right-clicking on the element. Grouping is also ideal for making changes to existing groups.

117

What is the difference between Power BI and Power Pivot?

Reference answer

Power BI and Power Pivot are both Microsoft products that are used for data analysis and reporting, but there are some key differences between the two. Power BI is designed for business intelligence and data visualization, while Power Pivot is a data modeling tool that is used to create data models within Excel.

118

Which chart will you use to compare the market share of different companies in a specific industry?

Reference answer

To compare the market share of companies, the most suitable visualizations are: - Stacked Bar Chart: Displays the total market size with each segment representing a company's share. This makes it easy to see the composition of the market and each company's contribution. - Grouped Bar Chart: Places bars for different companies side by side within each category (e.g., year, region). This is useful for making direct comparisons of market share between companies across multiple categories. - Pie Chart (or Donut Chart): Though less precise, it can also be used when you want to show the percentage share of each company in a single snapshot.

119

Explain Power BI Designer.

Reference answer

It is a combined solution offered to upload the reports and dashboards to the PowerBI.com website for reference. It consists of Power Pivot, Power Query, and Power Table.

120

What is Power Query?

Reference answer

Power Query is an ETL tool that allows: - Extracting data from various sources. - Transforming data (cleaning, merging, splitting). - Loading data into Power BI.

121

What are the different views available in Power BI Desktop?

Reference answer

Power BI has three distinct views, each serving a unique purpose: 1. Report View - Used to create and design reports and dashboards. - Allows you to drag visuals, charts and slicers in canvas. 2. Data View - Lets you view, explore and manage your data in tables. - You can create calculated columns, measures and explore row-level data. 3. Model View - Used to define relationships between tables and manage the data model. - Allows you to see table connections, create relationships and organize the model visually.

122

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

Reference answer

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

123

What is the difference between Power Query and Power Pivot in Power BI?

Reference answer

Power Query is used for importing and transforming data. It helps clean and shape data before it is loaded. Power Pivot is for data modeling. It allows users to create relationships, calculations, and use DAX for deeper analysis.

124

What are some common pitfalls to avoid when creating Tableau dashboards?

Reference answer

One common pitfall is creating cluttered dashboards with too many visual elements, which can overwhelm users. Another is neglecting data accuracy and consistency, leading to misleading insights. Lastly, failing to optimize performance can result in slow load times, frustrating users.

125

What are relationships in Power BI?

Reference answer

Relationships define how tables are linked in Power BI models: - One-to-Many (1:M) — Most common. - Many-to-Many (M:M) — Requires bridge tables. - One-to-One (1:1) — Used for specific cases.

126

Find % of Total Sales by Region.

Reference answer

We can write dax query like: Sales % by Region = DIVIDE( SUM(Sales[Amount]), CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region])) )

127

Explain Row Context and Filter Context.

Reference answer

In DAX, row context and filter context are two key concepts that affect how calculations are performed. Row Context: - Row context refers to the current row being processed in a table. It applies when DAX functions evaluate each row individually. - Example: When adding a calculated column to a sales table to calculate profit (sales amount minus cost), DAX applies the formula to each row separately, which is the row context. Filter Context: - Filter context is the set of filters applied to data before a calculation. These filters can come from slicers, report filters, or DAX functions like CALCULATE. - Example: If a report is filtered to show sales for a specific year, the filter context includes only data for that year. When calculating total sales, it sums only the sales for the selected year, respecting the filter context. ? In DAX, row context applies to calculations on individual rows. Filter context applies filters before a calculation, affecting the data considered.

128

What is the difference between Filters and Parameters in Tableau?

Reference answer

Parameters are like variables. They are complex and more powerful. Like a variable, a parameter can be used in calculations. So, that means, it only allows a single value. Parameters have the same UI options except for checkboxes because checkboxes don't have a single value. For example, we can create a parameter for interest rate and period, and then we can use these parameters to calculate interest and principal payments. Filters are used to provide the correct information to viewers after removing unnecessary data. There are various types of filters available in Tableau.

129

How would you set up a Power BI solution for a multi-branch company with location-specific access?

Reference answer

I would use Row-Level Security (RLS). First, I would create a table mapping users to branches. Then, define a DAX rule to filter data based on the user's email. Finally, I would assign roles in Power BI Service.

130

How one can get started with Power BI?

Reference answer

There are some resources to get assistance and get started with Power BI. They are as follows: Webinars Power BI Blog You can get started with an article on Power BI You can get started with a video on YouTube Last but not least, joining a related community and getting answered

131

What are dashboards in Power BI Service?

Reference answer

Dashboards in Power BI Service are a crucial feature for consolidating and displaying key metrics and insights at a glance. They allow users to create a single page, often called a canvas, that provides a real-time overview of the business through visualizations and metrics that are most important to stakeholders. Here's how it works: A Power BI dashboard is made up of tiles, which are snapshots of your data pinned from reports or direct queries. These tiles can be rearranged and resized on the dashboard to create a highly customized view. Dashboards can also incorporate elements like images, text boxes, and web content, making them not only functional but also visually appealing. An effective dashboard provides a high-level snapshot of the company's performance and can include interactive elements, such as drill-through features, to allow users to delve deeper into the data directly from the dashboard. This makes dashboards an excellent tool for executives or anyone needing quick insights without navigating through detailed reports. Using dashboards effectively enhances decision-making by providing stakeholders with a real-time, comprehensive view of key metrics and trends.

132

What are DAX variables (VAR/RETURN)? How do they improve readability and performance?

Reference answer

I use DAX variables to store intermediate results inside a measure so I can reuse them cleanly. The syntax follows this structure: VAR SalesLastYear = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(DateTable[Date])) RETURN DIVIDE([Total Sales] - SalesLastYear, SalesLastYear) Here, SalesLastYear stores the prior-year value once, and I reuse it in both the numerator and denominator. From a readability standpoint, variables make complex logic much easier to understand. Instead of nesting multiple CALCULATE or IF statements inside each other, I break the logic into named steps. When someone reads the measure later, they can follow the flow instead of decoding a long expression. From a performance perspective, variables help because Power BI evaluates them once and then reuses the result. If I reference the same calculation multiple times in a measure without VAR, the engine may evaluate that expression multiple times. With a variable, it computes it once and caches the result within that evaluation context. Variables in DAX are immutable. Once I define a variable, I cannot modify it later in the measure. They behave like constants. They are also lazily evaluated. That means Power BI only computes a variable if it is actually used in the RETURN expression. If I define a variable but never reference it, the engine won't waste time calculating it. Variables are not limited to scalar values. I can store tables in them as well. For example: VAR TopProducts = TOPN(10, Products, [Total Sales]) RETURN SUMX(TopProducts, [Total Sales]) In this case, TopProducts holds a table, and I iterate over it in the final calculation. For debugging, variables are extremely useful. If I suspect an intermediate calculation is wrong, I temporarily change the RETURN statement to return that variable directly. That lets me inspect its value without rewriting the entire measure. So I use variables for three main reasons: - To make measures easier to read and maintain. - To avoid recalculating the same expression multiple times. - To structure complex logic into clear, testable steps.

133

Describe the process of publishing and sharing Power BI reports and dashboards.

Reference answer

Look for: Familiarity with Power BI Service and collaboration features. What to Expect: Explanation of publishing reports to Power BI Service, sharing dashboards with users, configuring access permissions, and embedding reports in applications.

134

What is the order of operations in Tableau?

Reference answer

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

135

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

Reference answer

Whereas calculated columns are ideal for data sources you'd like to combine, calculated tables are suitable for data you don't want to share with other users. I'd use a calculated column to extract specific data from the columns I already have, and a calculated table to carry out calculations that wouldn't be contained in the final report.

136

What are filters in Power BI?

Reference answer

Page-level filters: These are applied on a particular page from various pages available within a report. Visualization-level filters: These are applied to both data and calculation conditions for particular visualizations. Report-level filters: These are applied to the entire report.

137

How do you handle data relationships in Power BI?

Reference answer

In Power BI, relationships between tables are established based on common fields, typically keys. Relationships can be one-to-one, one-to-many, or many-to-many. Managing relationships ensures data integrity and allows for accurate cross-table analysis.

138

Which kinds of data sources is Power BI compatible with?

Reference answer

The data sources that Power BI is compatible with are listed below: - Relational databases, such as MySQL, Oracle, and SQL Server - cloud-based services, such as Google Analytics, Salesforce, and Azure SQL Database - sources stored in files such as Excel, CSV, JSON, and XML - web-based resources (like OData feeds and REST APIs) - On-site data sources, such as Hadoop and SharePoint

139

Mention some advantages of Power BI.

Reference answer

It helps build an interactable data visualization in data centers It allows users to transform data into visuals and share them with anyone It establishes a connection for Excel queries and dashboards for fast analysis It provides quick and accurate solutions It enables users to perform queries on reports using simple English words

140

Could you elaborate on Power BI's conditional formatting concept?

Reference answer

Applying distinct formatting styles to data items according to their values or other conditions is made possible by the capability known as conditional formatting. A variety of graphic elements, including table cells, matrix cells, data bars, and colour scales, can be formatted conditionally. Conditional formatting is frequently used to visualise data quality issues, draw attention to patterns, and identify outliers.

141

What chart will be suitable to display the distribution of data points in a single variable?

Reference answer

A Histogram is the most suitable chart for showing the distribution of data points in a single variable. It divides the data into intervals (bins) and displays the frequency or count of data points in each bin. - Shows the overall shape of the data distribution. - Helps identify patterns, central tendency and outliers. - Ideal for continuous or numerical data.

142

What is a story in Tableau?

Reference answer

A story is a list that includes a series of dashboards and worksheets. It shows all the information that is stored in these dashboards and worksheets in an arranged manner. Individuals can easily find data relations and valuable insights for decision-making from these representations. The story is published on the web for the audience.

143

What is the minimum version of android os required to run tableau mobile?

Reference answer

Tableau mobile can be run on devices with android 7 or higher versions. Tableau mobile is used to view visualizations created on tableau desktop, tableau server, tableau online.

144

Explain how relationships in Power BI can be defined.

Reference answer

Relationships in Power BI can be defined manually and automatically. You can quickly determine relationships between tables using primary and foreign keys. Power BI automatically detects relationships between tables when enabled with the Power BI-specific automatic feature.

145

In what situation will you prefer to use a treemap over a heat map?

Reference answer

When we have to deal with large quantitative values having hierarchically structured data, we can prefer treemaps. Each rectangular set on the same hierarchy level denotes a data table column.

146

Name the work email addresses that are currently supported?

Reference answer

Work email addresses that are finishing with .org and .edu are currently supported.

147

Define a Stacked Bar chart.

Reference answer

A stacked bar chart consists of many bars layered horizontally, one on top of the other. The value of the data point determines how long the bar is. A stacked bar chart simplifies the task because it allows you to view changes in all the variables side by side. You can track changes in their aggregate and estimate future values.

148

What are the different filters in Tableau?

Reference answer

There are mainly three filters in Tableau which are used to restrict data pull. They are: - Normal Filter – it is used to restrict a string of data from the base on selected measure or dimension - Quick – it is used to change values dynamically across worksheets in a dashboard - Context – it creates a temporary data source for use in any worksheet without disturbing the main dataset Each of these filters has specific usage in any given reporting.

149

Have you worked with paginated reports? How do they differ from standard reports?

Reference answer

Yes! Paginated reports are pixel-perfect, designed for printing or export, suitable for detailed, page-oriented data (e.g., invoices). Standard reports are interactive and optimized for on-screen analysis.

150

How do you manage and use Power BI datasets and dataflows?

Reference answer

Look for: Proficiency in managing reusable datasets and dataflows to streamline data preparation and reporting. What to Expect: Discussion on creating and managing datasets, the advantages of dataflows for ETL processes, and strategies for reusing data models across multiple reports.

151

How do you create relationships between tables in Power BI Desktop?

Reference answer

In Model view, drag a field from one table to another to create a relationship. Power BI auto-detects cardinality and cross-filter direction. You can also manage relationships in the Manage Relationships dialog.

152

What is a TDE file?

Reference answer

TDE is Tableau Desktop Extension with extension .tde. TDE file points to a file that contains data from external sources like MS Excel, MS Access, or CSV files. TDE makes it easier to analyze and discover data.

153

What are the most common DAX Functions used?

Reference answer

Below are some of the most commonly used DAX function: SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT IF, AND, OR, SWITCH ISBLANK, ISFILTERED, ISCROSSFILTERED VALUES, ALL, FILTER, CALCULATE, UNION, INTERSECT, EXCEPT, NATURALINNERJOIN, NATURALLEFTEROUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY, VAR (Variables) GEOMEAN, MEDIAN, DATEDIFF

154

Describe Power BI and explain its significance to companies.

Reference answer

Microsoft created the Power BI package of business analytics tools, which helps companies visualise and share insights from their data. Businesses benefit from it because it increases their competitiveness and overall efficiency by enabling them to make well-informed decisions based on data-driven insights.

155

Practical differences between COUNT, COUNTA, and COUNTBLANK.

Reference answer

COUNT counts numeric values. COUNTA counts non-empty cells. COUNTBLANK counts empty cells.

156

What is a calculated Field?

Reference answer

A Calculated Field is a field created by the user to perform calculations on existing data in the dataset. It allows users to create new data based on formulas, functions, or conditions. Calculated fields help in deriving additional insights that are not directly available in the original data. For example, creating a Profit Ratio = Profit / Sales using a calculated field. They are widely used for custom metrics, conditional logic, and advanced data analysis in Tableau.

157

How can Power BI help organizations achieve ROI?

Reference answer

By providing real-time insights, predictive analytics, and interactive dashboards, organizations can make informed decisions faster, reduce costs, and increase efficiency.

158

What is the maximum no. of rows Tableau can utilize at one time?

Reference answer

The maximum number of rows or columns is indefinite because even though Tableau contains petabytes of data, it intelligently uses only those rows and columns which you need to extract for your purpose.

159

What data sources can Tableau connect to?

Reference answer

Tableau can connect to a wide range of data sources, including: - relational databases: Microsoft SQL Server, Oracle, MySQL, PostgreSQL, etc. - NoSQL databases: MongoDB, Cassandra, and Cloudera Impala - cloud-based warehouses: BigQuery, Azure, Snowflake, etc. - flat files: Excel spreadsheets, CSV files, and text files - web data: Google Analytics, web APIs, and HTML tables - Hadoop: Tableau has native support for Hadoop and can connect to Hadoop Distributed File System (HDFS), Apache Hive, and Apache Spark - other data sources: SAP, Teradata, IBM DB2, and Informatica, etc. In addition to these data sources, Tableau also has a data connector SDK that allows third-party developers to create custom connectors for other data sources.

160

What's the difference between Grouping and Binning in Power BI?

Reference answer

Grouping combines values into a single group manually. Binning automatically distributes values into equal-sized intervals.

161

What is the maximum no. of rows Tableau can utilize at one time?

Reference answer

Tableau is not restricted by the no. of rows in the table. Customers use Tableau to access petabytes of data because it only retrieves the rows and columns needed to answer your questions.

162

Describe a time when you had to communicate complex data insights to a non-technical audience.

Reference answer

I once presented a complex sales performance analysis to the marketing team. By using simple visualizations and avoiding technical jargon, I was able to clearly convey the key insights, leading to a strategic shift that increased campaign effectiveness by 25%.

163

How do you optimize Power BI performance?

Reference answer

- Reduce data size (remove unnecessary columns, use aggregations). - Optimize DAX formulas (use variables instead of repeated calculations). - Use DirectQuery instead of Import mode for large datasets. - Disable unnecessary visuals to improve dashboard loading time.

164

How are Excel and Power BI compatible?

Reference answer

Since you can use Excel's workbooks to create reports for Power BI, these two tools are compatible. Uploading workbooks from Excel to Power BI is also possible, as is sharing reports with other team members through Power BI, which makes viewing datasets easier.

165

What is aggregation and disaggregation of data?

Reference answer

Aggregation of data means displaying the measures and dimensions in an aggregated form. The aggregate functions available in the Tableau tool are: - SUM (expression): Adds up all the values used in the expression. Used only for numeric values. - AVG (expression): Calculates the average of all the values used in the expression. Used only for numeric values. - Median (expression): Calculates the median of all the values across all the records used in the expression. Used only for numeric values. - Count (expression): Returns the number of values in the set of expressions. Excludes null values. - Count (distinct): Returns the number of unique values in the set of expressions. Tableau, in fact, lets you alter the aggregation type for a view. Disaggregation of data means displaying each and every data field separately.

166

How do you manage many-to-many relationships?

Reference answer

Use a bridge table or enable composite models to handle many-to-many scenarios.

167

What are different data sources in Power BI?

Reference answer

Power BI supports a wide variety of data sources that you can connect to for building reports and dashboards. These can be broadly grouped as: 1. File Sources - Excel (.xlsx, .xlsm) - CSV (.csv) - XML - JSON 2. Database Sources - SQL Server - Oracle Database - MySQL - PostgreSQL 3. Online Services - Microsoft Azure - Power BI Datasets - Dynamics 365 - Google Analytics - Salesforce 4. Cloud & Big Data Sources - Hadoop (HDFS) - Spark - Google BigQuery - Amazon Athena - Azure Blob Storage 5. Other Sources - Web (URL data) - R Script / Python Script - APIs (through custom connectors)

168

What are Facts in Tableau?

Reference answer

Facts are numeric measures of data. They are stored in fact tables. Fact tables store the type of data that will be analyzed by dimension tables. Fact tables have foreign keys associated with dimension tables.

169

What kinds of relationships are there in Power BI?

Reference answer

In Power BI, there are three different kinds of relationships: One record in one table corresponds to one record in another when there is a one-to-one relationship. - One-to-many: Multiple records in one table are equivalent to a single record in another. - Many-to-many: One table's many records match multiple records in another table.

170

What is Discrete data in Tableau?

Reference answer

Discrete data roles consist of values that are separate and distinct. Discrete data roles can take individual values within a range. For Example – cancer patients in the hospital, no. of threads in a sheet, state. Discrete values are displayed as blue icons in the data window and blue pills on shelves. Discrete fields can be sorted.

171

Imagine the refresh schedule fails on a critical report. How would you approach the issue?

Reference answer

I would check the gateway connection and data source credentials first. Then review the refresh history in Power BI Service for error details. If it's a data source issue, I'd notify the team and set up alerts for future failures.

172

How can you integrate Power BI with other Microsoft products?

Reference answer

Power BI can be integrated with other Microsoft products, such as Excel, SharePoint, and Dynamics 365. This integration allows users to access and analyze data from these products directly within Power BI.

173

What information is needed to create a map in Power Map?

Reference answer

Power Map can display geographical visualizations. Therefore, some location data is needed—for example, city, state, country, or latitude and longitude.

174

How do you resolve issues with calculated fields in Tableau?

Reference answer

When dealing with issues in calculated fields in Tableau, I follow a systematic approach to identify and fix the problem. My process includes: 1. Understanding the calculation logic: I start by reviewing the calculated field formula to ensure that it aligns with the intended logic and business requirements. 2. Checking for syntax errors: In my experience, syntax errors are a common cause of issues in calculated fields. I carefully review the formula for any syntax mistakes, such as missing parentheses, incorrect operators, or typos in field names. 3. Verifying data types: I've found that mismatched data types can also cause issues in calculated fields. I verify that the data types used in the calculation are compatible and make necessary adjustments if needed. 4. Examining aggregation levels: From what I've seen, issues can arise when the aggregation level in the calculation doesn't match the view's granularity. I ensure that the aggregation level is appropriate for the intended use of the calculated field. 5. Testing the calculation: I test the calculated field by applying it to a worksheet and comparing the results with the expected output. If the results are incorrect, I revisit the formula and make any necessary adjustments. 6. Reviewing null values: I check if the calculated field contains any null values that may be causing issues. If needed, I modify the formula to handle null values appropriately. By following this approach, I can effectively resolve issues with calculated fields in Tableau.

175

How do you implement drill-through reports?

Reference answer

Enable drill-through by creating target pages and adding drill-through filters for detailed analysis.

176

How do you create a histogram in Tableau?

Reference answer

A histogram is a visualization that displays the distribution of a continuous variable by dividing the data into equal intervals (bins) and representing the frequency of observations within each bin. Histograms are useful for understanding the shape, center, and spread of a dataset. To create a histogram in Tableau, follow these steps:1. Drag the measure you want to analyze (e.g., Sales) onto the "Columns" shelf. 2. Right-click on the measure and select "Create" > "Bins." 3. Specify the bin size and click "OK" to create the bin field. 4. Drag the newly created bin field onto the "Rows" shelf. 5. Change the chart type to "Bar" from the "Marks" card. For example, if you have a dataset containing sales data, you could create a histogram to visualize the distribution of sales amounts across different intervals.

177

How can you restrict access to data for certain users in Power BI?

Reference answer

In Power BI, you have the option to restrict the access to data of certain users. This is achieved through the row security option, which works specifically at the row level.

178

How do you handle large datasets in Tableau?

Reference answer

For a 2-billion-row clickstream table, I built a summary table in Snowflake that aggregated by day and device. Tableau hit that 50-million-row summary via live connection for flexibility, and power users could still explore detail through drill-through links.

179

What are the different types of joins in Tableau?

Reference answer

The joins in Tableau are same as SQL joins. Take a look at the diagram below to understand it.

180

What is DAX in Power BI?

Reference answer

DAX (Data Analysis Expressions) is a formula language for creating calculated columns, measures, and tables in Power BI.

181

How can you schedule data refresh in Power BI?

Reference answer

To schedule data refresh in Power BI, you can use the Power BI Service to create a refresh schedule for each data source in the data model. The schedule can be set to refresh the data at a specific time or interval, such as daily, weekly, or monthly.

182

Name some commonly used tasks in the Query Editor.

Reference answer

Connect to data Shape and combine data Group rows Pivot columns Create custom columns Query formulas

183

What Kind Of Data Service Connect With Direct Query Mode?

Reference answer

SQL Server, Oracle, Teradata, SAP HANA, and other relational databases.

184

What is the difference between star schema and snowflake schema in Power BI data modeling?

Reference answer

A star schema has one fact table in the center with direct relationships to dimension tables. It is simpler and performs better. A snowflake schema has normalized dimension tables connected through multiple layers. It is more complex but can save space.

185

What is the difference between the rank_dense and rank_modified functions in Tableau?

Reference answer

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

186

What is query folding?

Reference answer

Query folding helps optimize performance by pushing data transformations back to the source database instead of performing them locally. This ensures that transformations are handled by the data source's more powerful processing capabilities, improving efficiency and performance in Power BI. This is important because it minimizes local processing load, reducing resource usage and improving response times, especially when working with large datasets or complex transformations.

187

What is query folding in Power BI?

Reference answer

When you need to extract and alter data that you've imported from several sources, the transformation stage requires query folding. One advantage of query folding is that because the transformations happen at the data source, Power Query has to do fewer imports.

188

How do you structure your Power BI workspace for collaboration?

Reference answer

I create separate workspaces for dev, test, and prod. I use shared datasets and dataflows for consistency. Permissions are set based on roles, and deployment pipelines automate promotion.

189

What is context filter in tableau?

Reference answer

Context Filter can improve the view performance of the dashboard when using more than one filter. A filter in tableau will be executed over all the rows in the dataset independent of others filters in place. By using a context filter we can reduce the size of dataset and then rest of the filters will be executed on the leftover dataset hence reducing the time of execution.

190

How do time intelligence functions like SAMEPERIODLASTYEAR or TOTALYTD work?

Reference answer

SAMEPERIODLASTYEAR shifts dates back by one year for comparison. TOTALYTD calculates a running total from the start of the year to the latest date in context. Both require a proper date table marked as a date table.

191

In Power BI, how do you make a drill-through report?

Reference answer

A drill-through filter, which enables users to go from a summary visualisation to a thorough view of the data, is added to a report page to generate a drill-through report. To generate a drill-through report, take the following actions: - Make a new report page with the drill-through information on it. - Establish a drill-through filter on the page and set up the navigation field. - Enhance the drill-through page with visualisations that show the detailed facts. - Include a visualisation action on the summary page that initiates the drill-through navigation.

192

What do you know about Power BI?

Reference answer

Power BI is a collection of business intelligence tools that extract valuable information from raw data through connecting, visualizing, and transforming it into a meaningful form. It provides various advanced features that help you create dashboard and live reports that can be shared on numerous platforms. Power BI can make you stand out in a competitive and highly categorized environment with its planners, visualization technique and decision-making process.

193

Tell Me 5 Timeintelligence Functions?

Reference answer

TOTALYTD, TOTALQTD, TOTALMTD, SAMEPERIODLASTYEAR, DATEADD.

194

How do you communicate complex data insights to non-technical stakeholders?

Reference answer

I believe in the power of storytelling through data. When presenting to non-technical stakeholders, I use simple language and focus on the key takeaways. For instance, at TCS, I created a dashboard that highlighted customer trends using color coding and simple charts. I always start with the main insights and then drill down into the details as needed, ensuring everyone understands the implications of the data. Gathering feedback post-presentation helps me improve future communications.

195

Can Tableau be installed on MacOS?

Reference answer

Yes, Tableau Desktop can be installed on both on Mac and Windows Operating System.

196

How to improve performance in tableau?

Reference answer

There are a number of ways to improve the performance and very basic trick among all is to use extract option on data source it is one of most powerful tools to improve the performance. Once you have completed the dashboarding then run the performance recorder from help menu, it will give you the specific sheets which are slowing the performance of your tableau. You should try to reduce the marks in your view. Try use less numbers of filters or if required then use include instead of exclude field. Use the context filter to filter huge chunks of data and also try to use cascade filters to reduce the query execution time.

197

What are some of the most important Power BI features?

Reference answer

Some of the most important Power BI features are: The ability to visualize data The option to share visualized data with others in the organization The option to use an omni-view to view all data gathered from all sources The option to display the output across several devices that can use Power BI

198

Advanced Visuals Use Cases

Reference answer

- Decomposition Tree for root cause analysis - KPI Cards for performance metrics - Paginated Reports for printable tables

199

What are content packs in Power BI? And why would you use one?

Reference answer

In Power BI, content packs are used to share objects, such as reports, dashboards, or datasets with individuals within your organization. The sharing takes place over the Power BI website and can be shared with multiple users. No one can change the original content in the content pack. Also, users have “read-only” access to the Power BI content shared with them.

200

What is the difference between USERELATIONSHIP and CROSSFILTER in DAX?

Reference answer

USERELATIONSHIP activates an inactive relationship temporarily within a measure. CROSSFILTER modifies the filter direction between two tables. Both are used to control relationship behavior in calculations.

DON'T WANT TO MISS A THING?

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

Good Interview Questions to Ask as a Tableau Developer | 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

Good Interview Questions to Ask as a Tableau Developer | SPOTO

Earn a certification to make your resume stand out.

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