1

参考回答

At IBM, I led a project to create a sales performance dashboard for our regional teams. The business requirement was to visualize sales trends across multiple dimensions. I utilized Tableau to integrate data from various sources, including CRM and ERP systems, and created interactive dashboards that allowed users to drill down into specific regions and products. This project led to a 20% increase in sales productivity as the teams could identify underperforming areas quickly and adjust their strategies accordingly.

2

参考回答

Some of the critical types of data sources that can be connected to Power BI include databases such as Access, Oracle, MySQL, SQL Server, Teradata, and PostgreSQL.

3

参考回答

I use a layered approach – data source layer, ETL (via Dataflows), semantic model (shared datasets), and report layer. I keep models centralized and reusable.

4

参考回答

Data extracts are sets of data generated from data sources. Schedules are scheduled updates made to extracts after the workbook has been published. This keeps the data updated. The server admins strictly control the schedules.

5

参考回答

A calculated column is a column that is created in a table using a DAX expression, while a calculated measure is a calculation that is performed on a column or set of columns in a table. Calculated columns are used to create new columns based on existing data, while calculated measures are used to perform calculations on existing data.

6

参考回答

Versioning of workbooks can be done in 2 ways in Tableau.

7

参考回答

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.

8

参考回答

The Multiple Line Chart or Line Chart with Multiple Series is ideal for showing share price trends over a year for multiple companies. Each line represents a different company making it easy to compare performance over time and observe fluctuations, trends and patterns. - Clearly shows changes in share prices across time. - Allows easy comparison between companies. - Highlights trends, peaks and dips for each company. This chart is particularly useful for analyzing and contrasting the performance of companies within the same industry over a period.

9

参考回答

Look for: Knowledge of Power BI integrations with various data sources and services. What to Expect: Discussion on integrating Power BI with tools like Excel, SQL Server, Azure services, and third-party applications using APIs and connectors.

10

参考回答

Every individual chart or visualization report generated is collected and represented on a single screen. Such an approach is called a Power BI Dashboard. A Dashboard in Power BI is used to depict a story.

11

参考回答

Power BI is available in different formats: Power BI desktop: You can download and install PowerBI Desktop on your personal computer where you can connect to the data source, transform your data, analyze and visualize it with templates. Power BI services: It is a cloud based service or SaaS (software as a service). You can connect to data here as well but the modeling is limited. Power BI mobile app: One can securely access dashboards and reports on any device with the PowerBI app which is available for iOs, Android and even Windows.

12

参考回答

Go to Modeling > New Parameter. Define the data type, range, and step. Power BI creates a slicer and calculated table. You can use selected value in DAX measures to simulate impact scenarios.

13

参考回答

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

14

参考回答

Visualization Capabilities: Tableau is known for its advanced and flexible data visualization features, making it strong for complex and interactive visuals. Power BI provides good visualizations but is generally more focused on business reporting. Cost: Power BI is more cost-effective, especially for organizations already using Microsoft products, while Tableau is relatively more expensive. Performance with Large Data: Tableau tends to handle large datasets and complex visual analysis more efficiently, whereas Power BI may require optimization for very large datasets. Integration: Power BI integrates seamlessly with Microsoft tools such as Excel, Azure, and SQL Server, while Tableau supports many data sources but is not tied to a specific ecosystem. Data Modeling and Calculations: Power BI uses DAX and Power Query for data modeling and transformations, while Tableau mainly uses calculated fields and focuses more on visual analytics.

15

参考回答

PowerBI Services is a cloud based service or SaaS (software as a service). It helps to connect to your data, analyse, visualize and share business insights with efficiency.

16

参考回答

Tableau Server is an on-premise solution where the organization installs and manages Tableau on its own servers. The company is responsible for maintenance, security, updates, and infrastructure management. It is mainly used by organizations that want full control over their data and environment. Tableau Cloud (formerly Tableau Online) is a fully hosted SaaS solution provided by Tableau. In this case, Tableau manages the servers, maintenance, upgrades, and security, and users can access dashboards through the internet without managing any infrastructure.

17

参考回答

To create a KPI (key performance indicator) in Power BI, you can use the "New Measure" option in the "Fields" pane and enter a DAX expression that defines the calculation. Once the KPI is created, you can format it to show a visual indicator of performance, such as a traffic light or gauge.

18

参考回答

The steps to connect to a custom SQL query within Tableau are: - Open Tableau. - Once you connect to your data, you must double-click the New Custom SQL option from your Data Source page. - A code editor will pop up. - You have to type your desired query and click the OK button.

19

参考回答

I use Power Query to clean data by removing duplicates, handling nulls, and standardizing formats. I document data quality issues and work with source teams to fix root causes. For incomplete data, I use default values or flag gaps.

20

参考回答

Power BI does not accept file sizes larger than 1 GB and doesn't mix imported data accessed from real-time connections. There are very few data sources that allow real-time connections to Power BI reports and dashboards. It only shares dashboards and reports with users logged in with the same email address. Dashboard doesn't accept or pass user, account, or other entity parameters.

21

参考回答

Dashboard is optimized for building better visualizations. There are different strategies that can boost the performance of a dashboard like: - Using extracts instead of live connections. - Reducing the number of marks and data points. - Optimizing filters and calculations. - Using context filters. - Minimizing the use of complex LOD expressions.

22

参考回答

The basic difference between the traditional BI tools and Tableau lies in the efficiency and speed. - The architecture of Traditional BI tools has hardware limitations. While Tableau does not have any sort of dependencies - The traditional BI tools work on complex technologies while Tableau uses simple associative search to make it dynamic. - Traditional BI tools do not support multi-thread, in-memory, or multi-core computing while Tableau supports all these features after integrating complex technologies. - Traditional BI tools have a pre-defined data view while Tableau does a predictive analysis for business operations.

23

参考回答

Power Query is a built-in tool available in Power BI Desktop that makes it easy to connect to data from almost any source—like Excel spreadsheets, CSV files, databases such as SQL or Oracle, or even data from the web or social media. Once connected, you can quickly clean, reshape, and transform your data, getting it ready for analysis without needing complicated coding. It's super user-friendly, with a simple, visual interface, though if you prefer, you can dive deeper and edit or write your own queries using its built-in 'M' language. Basically, Power Query saves tons of time by automating tedious data prep tasks.

24

参考回答

Self-service business intelligence (SSBI) is an approach that allows people across an organization—not just technical experts—to independently access, analyze, and visualize data without relying heavily on IT or specialized analysts. With SSBI tools, I can easily connect to data sources, create reports, and draw insights on my own, without always needing help from a dedicated analyst or developer. This approach speeds things up, reduces bottlenecks, and helps teams make better, faster decisions because the people who know the business best can explore and interpret data directly.

25

参考回答

Use a Matrix visualization with Region as rows, Month as columns and Sales as values. Syntax: Rows = Sales[Region] Columns = Sales[Month] Values = SUM(Sales[Amount])

26

参考回答

Incremental refresh lets you update only new or changed data instead of reloading everything. You define a range for historical and incremental data using parameters in Power BI Desktop. After publishing, it works in the Power BI Service.

27

参考回答

At a fintech client needing second-by-second trading insights, live was non-negotiable despite heavier queries. Conversely, for a marketing dashboard with 20M rows updated nightly, I chose an extract, scheduled a 2 a.m. refresh, and enabled aggregation during the extract. The result: dashboards opened in 3 seconds instead of 25, and DBAs were happy because peak-hour load disappeared.

28

参考回答

- Calculated Columns: Created in the data model using DAX expressions, calculated columns are stored in the data model and recalculated when data is refreshed. - Measures: Calculations performed on the fly using DAX expressions, measures are not stored in the data model and are recalculated based on the context of the report or dashboard.

29

参考回答

Gantt Chart displays the progress of value over the period. It consists of bars along with the time axis. It is a project management tool. Here, each bar is a measure of a task in the project framework.

30

参考回答

A Live Connection in Tableau means that Tableau connects directly to the original data source, such as a database or cloud platform, and queries the data in real time whenever a visualization is used. This ensures that users always see the most up-to-date data, but the performance of the dashboard depends on the speed and performance of the underlying database and network connection. Live connections are commonly used when organizations require real-time or frequently updated data. On the other hand, a Data Extract is a snapshot of the data stored in Tableau's optimized .hyper file format. The data is imported and stored locally or on Tableau Server, which allows Tableau to process queries much faster because the data is already optimized for analysis. Extracts are especially useful when working with large datasets or slower databases, as they improve dashboard performance and reduce the load on the source system. However, since extracts store a copy of the data, they must be refreshed periodically to keep the data up to date.

31

参考回答

B) Power Query

32

参考回答

A clustered index is an index that determines the physical order of data in a table, while a non-clustered index is an index that does not determine the physical order of data in a table. Clustered indexes are typically used for tables that have a large number of rows and require fast data retrieval, while non-clustered indexes are used to improve query performance by creating a smaller subset of data for each query.

33

参考回答

Handling missing data in Tableau is an important aspect of data preparation, as it can impact the accuracy and quality of your analysis. In my experience, there are several ways to handle missing data in Tableau: 1. Using ZN function: The ZN function in Tableau can be used to replace null values with zeros. This is particularly useful when working with numerical data, as it ensures that calculations and aggregations are not impacted by missing values. 2. Using IFNULL function: The IFNULL function allows you to replace null values with a specified value. This can be helpful when you want to replace missing values with a default value or an average value, for example. 3. Removing rows with missing data: In some cases, it might be appropriate to remove rows with missing data altogether. This can be done using the data source filters in Tableau or by filtering the data directly in the visualization. 4. Interpolating missing values: Depending on the nature of the data, you might choose to interpolate missing values using a method such as linear interpolation. This can be done using Tableau's built-in forecasting feature or by creating a custom calculation. 5. Addressing missing data at the data source level: In some cases, it might be more efficient to handle missing data directly in the data source, such as using SQL queries or data preparation tools like Tableau Prep. By considering the context and nature of the missing data, I can choose the most appropriate method for handling it in Tableau, ensuring that my analysis is accurate and meaningful.

34

参考回答

I use a clean layout with consistent colors and fonts. Key KPIs are at the top, followed by charts. I limit visuals per page and use slicers for interactivity. White space improves readability.

35

参考回答

Yes, you can have a table in the Power BI model that does not have any relationships with other tables. There are two main reasons for using disconnected tables: - Parameter Tables: Used to present parameter values in slicers, allowing users to select different parameters for their analysis, such as different time periods or categories. - Placeholder for Measures: Serve as placeholders for metrics in the user interface. They help organize and display various measures without needing to relate them directly to other data tables. ? Disconnected tables are used for parameters or measures without relationships to other tables.

36

参考回答

The following data sources that support DirectQuery in Power BI are as follows: Amazon Redshift Azure Data Explorer AtScale (Beta) Azure SQL Database Azure HDInsight Spark Google BigQuery Azure SQL Data Warehouse HDInsight Interactive Query

37

参考回答

A tooltip is a visual component that provides additional information when the user hovers over a data point, while a drill-through is a visual component that allows users to navigate to a more detailed report or visualization. Tooltips are typically used to provide context for data, while drill-throughs are used to explore data in more detail.

38

参考回答

We can check the performance of Tableau in the following 2 ways.

39

参考回答

Tables should have the same columns. Merge methods include Left Outer, Right Outer, Full Outer, Inner, Left Anti, Right Anti.

40

参考回答

You should remove a collection of rows from the data set as soon as possible if you don't intend to use them. Create a Custom SQL query that filters out the entire sales table if you only want to get US sales or measure values from it. Consider using a Context Filter if the filter is worksheet-dependent. To conceal any fields you are not using in any of your worksheets, click the Down Arrow next to the word "Dimension" and choose "Hide All Unused Fields."

41

参考回答

A content pack in Power BI is a bundle of related dashboards, reports, and datasets packaged together, making it super easy to share insights within a team or across the organization. There are typically two types: service provider content packs, which are pre-built by external services like Salesforce or Google Analytics, and organizational content packs created internally within your company. For example, I might create a marketing content pack with reports and dashboards showing the results of recent campaigns, then share it with my entire marketing team so everyone can quickly access the same consistent insights. It's a simple way to ensure everyone stays on the same page.

42

参考回答

A dashboard in Power BI is basically a one-page summary that shows the most important visuals from your reports—like charts, graphs, or key metrics—in a single, easy-to-understand view. Dashboards help users quickly see what's going on in the business, spot trends, and identify issues without having to dig into multiple reports or spreadsheets. They're also interactive, so users can click visuals to explore more details. Another great thing about Power BI dashboards is that they work well on any device, so managers or team members can stay informed wherever they are.

43

参考回答

Power BI is a Business Intelligence (BI) tool by Microsoft that helps organizations analyze data and create interactive reports and dashboards. It allows: - Data connectivity from multiple sources. - Data transformation and modeling. - Visualization for better decision-making.

44

参考回答

We are given Sales and Profit fields in your dataset. Then we can create a calculated field using: [Profit Margin] = [Profit] / [Sales] Format the field as a percentage. This will show how much profit is made on each unit of sales.

45

参考回答

Power BI and Tableau are both popular business intelligence and data visualization tools, but there are some key differences between the two. Power BI is more tightly integrated with other Microsoft products, such as Excel and SharePoint, while Tableau is known for its flexibility and ease of use. Power BI is typically more affordable, while Tableau offers more advanced visualization capabilities.

46

参考回答

A bar-plot is a pictorial representation with the help of which we can understand the distribution of categorical variables.

47

参考回答

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

48

参考回答

Group can be created in a calculated field by choosing the calculated field > input the name of field in the dialog box > enter the calculation and click on ok. The calculation given below is an instance of this case: IF [Container]='Jumbo Box' then 'Big Containers' ELSEIF [Container]='Jumbo Drum' then 'Big Containers' ELSEIF [Container]='Large Box' then 'Big Containers' ELSEIF [Container]='Medium Box' then 'Midsize Containers' ELSEIF [Container]='Wrap Bag' then 'Midsize Containers' ELSEIF [Container]='Small Box' then 'Little Containers' ELSEIF [Container]='Small Pack' then 'Little Containers' END

49

参考回答

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

50

参考回答

I use Performance Analyzer to identify slow visuals, check DAX queries with DAX Studio, and review data model complexity. I then optimize by reducing columns, simplifying measures, and using aggregations.

51

参考回答

Integrating R or Python scripts within Tableau can greatly enhance its analytical capabilities. Tableau provides the ability to use R and Python via its Tableau Extensions API and Table Calculations functions. Here's how I typically integrate R or Python scripts in Tableau: For R:1. Install and configure Rserve: Rserve is an R package that allows Tableau to communicate with R. Install Rserve in your R environment, then run Rserve() to start the server. 2. Connect Tableau to Rserve: In Tableau, go to Help -> Settings and Performance -> Manage External Service Connection, and configure it to connect to your Rserve instance. 3. Use the SCRIPT_* functions: In Tableau, create a calculated field that uses the SCRIPT_* functions (e.g., SCRIPT_REAL, SCRIPT_INT, SCRIPT_STR) to embed your R script within the calculation. For Python:1. Install and configure TabPy: TabPy is a Python package that allows Tableau to communicate with Python. Install TabPy, then run it to start the server. 2. Connect Tableau to TabPy: In Tableau, go to Help -> Settings and Performance -> Manage External Service Connection, and configure it to connect to your TabPy instance. 3. Use the SCRIPT_* functions: In Tableau, create a calculated field that uses the SCRIPT_* functions (e.g., SCRIPT_REAL, SCRIPT_INT, SCRIPT_STR) to embed your Python script within the calculation. In both cases, the SCRIPT_* functions enable you to pass data from Tableau to R or Python, perform advanced analytics, and return the results to Tableau for visualization.

52

参考回答

There are two types of data connections in Tableau: LIVE: Live connection is a dynamic way to extract real-time data by directly connecting to the data source. Tableau directly creates queries against the database entries and retrieves the query results in a workbook. EXTRACT: A snapshot of the data, extract the file (.tde or .hyper file) contains data from a relational database. The data is extracted from a static source of data like an Excel Spreadsheet. You can schedule to refresh the snapshots which are done using the Tableau server. This doesn't need any connection with the database.

53

参考回答

You do not need to understand structured query language (SQL) to utilize Tableau. That said, knowledge of SQL can be helpful when using this tool to construct visualizations, especially if you're engaging with automation and databases.

54

参考回答

Aggregation → The process of summarizing the data and viewing a single numeric value is called aggregation. Example – sum/avg of salary for each employee Disaggregation →The process of viewing each transaction for analyzing all the measures both dependently and independently. Example – individual salary transactions for each employee.

55

参考回答

Look for: Understanding of version control practices and report management. What to Expect: Discussion on using tools like OneDrive or SharePoint for version control, maintaining report documentation, and managing report updates and lifecycle.

56

参考回答

A typical Power BI workflow involves these core four steps: - Data Collection and Preparation: Use Power BI Desktop to connect to and import data from various sources. Then clean, transform, and organize the data, ensuring accuracy and readiness for analysis. - Creating Visualizations and Reports: Transform the prepared data into clear, meaningful visualizations and interactive reports that highlight key insights and patterns. - Publishing to Power BI Service: Upload reports from Power BI Desktop to Power BI Service (cloud platform), and then build interactive dashboards by selecting key visuals from your reports. - Sharing and Collaboration: Share published dashboards and reports securely with stakeholders, colleagues, or management via Power BI Service to foster informed decision-making and collaborative analysis.

57

参考回答

Stacked Bar Chart, composed of multiple bars stacked horizontally, one below the other. The length of the bar depends on the value in the data point. A stacked bar chart makes the work easier, they will help us to know the changes in all variables presented, side by side. We can watch the changes in their total and forecast future values.

58

参考回答

Power BI consists of five main components: - Power Query — Used for extracting, transforming, and loading (ETL) data. - Power Pivot — Data modeling tool for creating relationships and calculations. - Power View — Data visualization tool for creating interactive charts, graphs, and maps. - Power Map — Geospatial visualization tool for mapping data. - Power Q&A — Natural language processing feature that allows users to ask questions in plain English and get data insights.

59

参考回答

Power BI provides a variety of visualization types to represent data effectively. These include: - Bar and Column Charts: Vertical and horizontal bars to compare data across categories. - Line and Area Charts: Show trends over time or continuous data. - Pie and Donut Charts: Represent proportions or percentages of a whole. - Card and KPI Visuals: Display key metrics or single values prominently. - Tables and Matrices: Show detailed data in rows and columns. Matrices support hierarchical data. - Scatter and Bubble Charts: Display relationships and correlations between numeric values. - Maps: Geographical visualizations including basic maps, shape maps and ArcGIS maps. - Funnel Charts: Represent stages in a process like sales or conversions. - Gauge and Dial Charts: Show progress against a target or goal. - Waterfall Charts: Illustrate cumulative effects of sequential positive and negative values. - Decomposition Tree: Break down a measure across multiple dimensions interactively. - Ribbon Charts: Show ranking changes of categories over time. - Custom Visuals: Additional visuals imported from the Power BI marketplace for specialized needs.

60

参考回答

Dimensions are fields used to categorize or describe data. They are usually qualitative or categorical, such as Region, Product Name, or Customer Segment. Measures are fields used to perform calculations and analysis, and they usually contain numeric values, such as Sales, Profit, or Quantity. Dimensions are typically used to slice and organize the data, while measures are used to aggregate and analyze the data (like SUM, AVG, COUNT). In Tableau, dimensions are usually discrete, while measures are generally continuous by default.

61

参考回答

I start by understanding how much detail users actually need and how large the dataset is. That determines whether I use hierarchy drill-down, drill-through pages, or a more controlled layout. The simplest approach is a drill-down hierarchy inside a visual. For example, I create a hierarchy like Country -> State -> City -> Store. I add it to a matrix or chart. By default, users see the top level. When they click the drill-down icon, Power BI filters automatically to the selected value and shows the next level. This works well when the structure is clearly hierarchical. If users need a dedicated detail view with additional visuals, I create a drill-through page. On that page, I add a drill-through filter such as ProductID or CustomerID. From the summary page, users can right-click a data point and choose Drillthrough. Power BI navigates to the detail page already filtered to that selection. I include a back button so navigation feels seamless. When I want more control over the experience, I use bookmarks and buttons. I designed two layouts on the same page, one summary view and one detailed view. Then I create bookmarks that toggle visibility between them. Buttons switch between states. This approach works well when the user experience needs to feel like switching modes rather than navigating to another page. For lightweight contextual detail, I sometimes use report tooltips. I create a tooltip page with additional visuals and assign it to a summary visual. When users hover over a data point, they see detailed metrics without leaving the page. If the detail view pulls from a very large table, I design it carefully. A 50 million-row detail page should not load everything in Import mode unless the model supports it. I may use DirectQuery for the detail table or rely on aggregation tables so summary visuals stay fast while drill-level queries access detailed data only when needed. If navigation must work across separate Power BI reports, I configure cross-report drillthrough. That allows users to move from one published report to another while preserving filter context. In some cases, I add multiple drill-through fields so users can pass more than one filter value, for example, Product and Region together. I test these combinations to ensure the filter context behaves as expected. So my design basically depends on the use case: hierarchy for natural drill paths, drillthrough pages for focused detail views, bookmarks for controlled UI switching, and tooltips for quick context, all while keeping performance in mind for large datasets.

62

参考回答

Yes, one can create relational joins in tableau without creating a new table.

63

参考回答

I follow the 5-second rule: a viewer should grasp the key insight within 5 seconds. In my churn dashboard, the top left showed churn rate, top right trend, bottom section drill-down. Action filters let managers click a segment and instantly update detail views.

64

参考回答

There are different types of joins in Tableau: - Inner Join: An inner join returns only the rows that have matching values in both tables. Rows that do not have a match in the other table are excluded from the result. - Left Join: A left join returns all the rows from the left table and matching rows present in the right table. If there is no match in the right table, null values are included in the result. - Right Join: A right join returns all the rows from the right table and matching rows present in the left table. If there is no match in the left table, null values are included. - Full Outer Join: A full outer join returns all the rows where there is a match in either the left or right table. It includes all the rows from both tables and fills in null values where there is no match.

65

参考回答

A .twb is an xml document which contains all the selections and layout made you have made in your Tableau workbook. It does not contain any data. A .twbx is a 'zipped' archive containing a .twb and any external files such as extracts and background images.

66

参考回答

DAX (Data Analysis Expressions) is a formula language in Power BI used for: - Creating calculated columns, measures, and tables. - Performing aggregations and complex calculations. - Supporting filtering, ranking, and time intelligence functions. Example: Total Sales = SUM(Sales[SalesAmount])

67

参考回答

I built a nightly Python ETL that pulled CRM data, normalized country codes, and stored results in Redshift. Tableau then connected to a lean fact table rather than messy raw logs. The clean pipeline cut my workbook extract from 1.2 GB to 300 MB and eliminated manual clean-up steps for analysts, letting them focus on storytelling.

68

参考回答

Primarily, PowerBI uses two repositories to store its data: Azure Blob Storage and Azure SQL Database. Azure Blob Storage typically stores the data that is uploaded by the users. Azure SQL Database stores all the metadata and artifacts for the system itself.

69

参考回答

Data blending in Tableau is the process of combining data from multiple sources to create a single visualization. I used data blending to merge sales data from an Excel sheet with customer data from a SQL database, enabling a comprehensive analysis of sales performance by customer demographics.

70

参考回答

The published data source has connection information in it. It is independent of any workbook and can be accessed by multiple workbooks.

71

参考回答

The following pages provide details about different visualizations available in Power View: Charts Line charts Pie charts Maps Tiles Cards Images Tables Power View Multiples Visualizations Bubble and scatter charts Key performance indicators (KPIs)

72

参考回答

A .twb (Tableau Workbook) contains only the workbook structure such as worksheets, dashboards, and the connection to the data source. It does not contain the actual data. You can think of it as Workbook + Connection to data. A .twbx (Tableau Packaged Workbook) contains everything required to open the workbook, including the workbook, data extract, and other supporting files. It can be understood as Workbook + Data + Supporting files, which makes it easier to share with others.

73

参考回答

The practice of following data as it moves from its source to its destination, taking into account all changes and connections along the way, is known as data lineage. The lineage view in Power BI Service, which illustrates the relationships between datasets, reports, and dashboards, may be used to visualise data lineage in Power BI. Understanding the effects of modifications to the data model, guaranteeing data quality, and resolving problems all depend on data lineage.

74

参考回答

In a previous role, I worked on a project where we had to analyze a large dataset of customer transactions for an e-commerce company. The dataset had over a million rows and multiple fields, such as product details, purchase dates, and customer demographics. My task was to create visualizations that would help identify patterns and trends in customer behavior. First, I started by connecting Tableau to the company's SQL server to efficiently access the raw data. Before diving into visualization, I performed data cleaning and preprocessing, such as removing duplicates, filling missing values, and aggregating data at different levels. I used Tableau's built-in data blending and custom SQL features to ensure that the data was correctly formatted and structured for analysis. To deal with the large dataset, I focused on using Tableau's features that optimize performance, such as extracts, filters, and level of detail (LOD) expressions. I created extracts for subsets of data that I knew would be used frequently, which helped improve the responsiveness of the visualizations. I also applied filters to restrict the view to specific segments of data, allowing users to zoom in on areas of interest without overwhelming the system. When presenting my findings, I used interactive dashboards and story points to help the audience understand the trends and patterns I discovered. I adjusted the level of detail in the visualizations to balance granularity with clarity, making sure the main insights were easy to see. I also made use of custom tooltips and annotations to provide additional context where needed. Throughout the project, I continually monitored the performance of the dashboard and made adjustments as needed to maintain responsiveness and usability. This included optimizing calculations, reducing the number of marks on the view, and adjusting filters to ensure efficient use of system resources.

75

参考回答

In Tableau, you can perform joins by dragging and dropping tables from different data sources in the Data Source tab > "Drag tables here" area. After you've dropped the first table, right click on the table > Open. You'll see the join dialog box pop up. Drag your second data source in the area and select the join type you need. Exit out of the dialog box by clicking on x in the top left corner.

76

参考回答

Groups are created to visualize larger memberships using dimensions. Groups can create their own fields to categorize values in that specific dimension.

77

参考回答

Use Conditional Column in Power Query with rule: If Marks > 40 → Pass, Else → Fail. Syntax: Result = if [Marks] > 40 then "Pass" else "Fail"

78

参考回答

Use a list comprehension: [key for key, value in dict.items() if value % 2 == 0]

79

参考回答

Power BI Desktop is a desktop application that is used to create and publish reports and visualizations, while Power BI Service is a cloud-based service that allows users to view and interact with reports and dashboards created in Power BI Desktop.

80

参考回答

Add the ‘GroupBy' clause to SQL queries or create a calculated field in the data window to group fields. - Using groups in a calculation. You cannot reference ad-hoc groups in a calculation. - Blend data using groups created in the secondary data source: Only calculated groups can be used in data blending if the group was created in the secondary data source. - Use a group in another workbook. You can easily replicate a group in another workbook by copy and pasting a calculation.

81

参考回答

Sort both strings and compare, or use a frequency counter (dictionary) to compare character counts.

82

参考回答

The dashboard is like a single-page canvas on which you have various elements to create and visualize reports created by analyzing data. It comprises only the most important data from the reports to create a story. The visual elements present on the dashboard are called Tiles. You can pin these tiles from the reports to the dashboard. Clicking any element on the dashboard takes you to the report of a particular data set.

83

参考回答

Use =SUMIFS(SalesAmount, RegionRange, "West", MonthRange, "Jan")

84

参考回答

Yes, we can place an excel file in a shared location and we can use it to develop a report, but for better performance, we need to extract the file.

85

参考回答

Bins in Tableau are equal-sized containers used for storing data values matching the bin size, and they help systematically place the measure's value onto bins. For instance, you have a Tableau measure having the ages of employees ranging from 17 to 65, and you must bin the age data to examine how the employee's value breaks down as per these varying age groups.

86

参考回答

I've connected Tableau to everything from a simple Excel P&L to a 3-billion-row BigQuery table. Recently, I used the Salesforce native connector for near real-time case monitoring and a Web Data Connector to pull social-media sentiment, merging both into a single executive dashboard.

87

参考回答

I have used TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, DATESMTD, and DATESQTD for running totals, year-over-year comparisons, and period-over-period analysis.

88

参考回答

To create a dashboard in Tableau, follow these steps: Connect to Data: Launch Tableau and connect to the data source you want to visualize. Tableau supports various data sources, including spreadsheets, databases, cloud services, and more. Build Individual Worksheets: Create individual worksheets by dragging and dropping fields from the data pane onto the Rows and Columns shelves. Customize the visualization by choosing chart types, colors, labels, and formatting options. Create a New Dashboard: Once you have built the necessary worksheets, navigate to the dashboard tab by clicking on the "New Dashboard" option on the bottom left corner. Add Worksheets to Dashboard: Drag and drop the worksheets you created in step 2 onto the dashboard canvas. You can arrange them as desired and resize them to fit the layout. Add Objects and Filters: Enhance the dashboard by adding objects like text, images, and web pages. You can also add filters to enable interactivity and allow users to explore the data. Customize and Format: Format the dashboard to make it visually appealing and easy to understand. Tableau provides various formatting options for text, colors, size, and layout. Create Dashboard Interactions: Set up interactivity between different worksheets in the dashboard. For example, you can create filter actions to update one worksheet based on selections in another. Test and Refine: Preview the dashboard and test its functionality. Make any necessary adjustments to ensure that it provides the desired insights and meets your requirements. Save and Share: Once the dashboard is complete, save it in Tableau format (.twb) or publish it to Tableau Server or Tableau Online for sharing with others. By following these steps, you can create an interactive and visually appealing dashboard in Tableau, allowing users to explore and gain insights from your data visualization.

89

参考回答

- Workbooks: Workbooks contain one or more worksheets and dashboard elements. - Bookmarks: Contains a single worksheet that is easier to share. - Packaged Workbooks: Contains a workbook along with supporting local file data and background images. - Data Extraction Files: Extract files that contain a subset of data. - Data Connection Files: Small XML file with various connection information.

90

参考回答

Use Power Query transformations like Replace Values, Remove Rows, or Fill Down, or DAX functions like IFBLANK().

91

参考回答

Sometimes data file may contain some description at the top or bottom of the file. Tableau will not be able to understand the data as it is. After connecting to the data file, you need to turn on the data interpreter available in the left panel. It will remove the unwanted rows from the data source in tableau without making any effects on the file from where the data is being used.

92

参考回答

Report-level, Page-level, Visual-level, Drillthrough, and Slicer filters.

93

参考回答

A group is a combination of dimension members that make higher level categories. For example, if you are working with a view that shows average test scores by major, you may want to group certain majors together to create major categories.

94

参考回答

Tableau natively recognizes strings, numbers, dates, date-times, booleans, and geographic fields. For example, I once imported a CSV where product IDs looked numeric but were actually alphanumeric SKU codes. Tableau initially set them to number, which broke my groupings. A quick data-type correction to string fixed the issue and preserved leading zeros. Double-checking those assignments is one of my first steps whenever I open a new data source.

95

参考回答

With the help of a box-plot you can understand the relationship between a categorical variable and numerical variable.

96

参考回答

When working with a healthcare client, I started with a series of workshops to understand their operational challenges. I used a requirements matrix to prioritize their needs based on urgency and impact. This approach helped me tailor the Tableau dashboards to focus on key performance indicators that aligned with their patient care goals, ensuring stakeholder buy-in and project success.

97

参考回答

Below are a few extensions in Tableau: Tableau Desktop's latest version is 2021.3(as of, 7thSep 2021). LOD Expression stands for Level of Detail Expression, and it is used to run complex queries involving many dimensions at the data sourcing level. A heatmap is a graphical representation of data that uses the color-coding technique to represent different values of data. As the marks heat up due to their higher value, dark colors will be shown on the map. TreeMap is a visualization that organizes data hierarchically and shows them as a set of nested rectangles. The size and colors of rectangles are respective to the values of the data points they project. Parent rectangles will be tiled with their child elements.

98

参考回答

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

99

参考回答

| Basis | COUNT | COUNTD | |---|---|---| | Definition | Returns the total number of rows (including duplicates) for a given field. | Returns the number of distinct (unique) values for a given field. | | Usage | Useful when you want to know the total count of records or values, regardless of repetition. | Useful when you want to know how many unique entries exist in a field. | | Example | If a column has values: A, A, B, B, C → COUNT = 5 | For the same column → COUNTD = 3 (A, B, C). |

100

参考回答

In Power BI, dimension tables follow these rules to ensure effective data modeling: - Unique Keys: Each dimension table needs a unique key to connect with fact tables. - Descriptive Attributes: Include attributes that describe data, like names or categories. - Denormalization: Often denormalized to reduce the number of joins and improve performance. - Hierarchies: Include hierarchies (e.g., year, month, day) for detailed analysis. - Consistent Granularity: Ensure the level of detail matches that of the fact tables. ? Dimension tables in Power BI should have unique keys, descriptive attributes, hierarchies, and matching granularity with fact tables.

101

参考回答

Power BI uses the formula language DAX (Data Analysis Expressions) to create custom tables, measurements, and calculated columns. Though it was created especially to work with data models and carry out complex computations on big datasets, it is comparable to Excel formulas.

102

参考回答

Power Pivot is a data modeling component built into Power BI (and originally available in Excel) that allows you to create sophisticated data models from multiple sources. It lets you define relationships between tables, perform powerful calculations using the Data Analysis Expressions (DAX) language, and build measures or calculated columns. By compressing large datasets, Power Pivot helps Power BI handle more complex data efficiently, making your reports faster and easier to navigate, even when dealing with millions of rows of data. It's a critical tool in Power BI because it lets you build robust, flexible models that drive interactive and insightful reports.

103

参考回答

Discrete and continuous are types of dimension flow in Tableau. Discrete values are individual points that are counted as distinct values, separated from a batch. Example – number of states in a country. Continuous values allow a user to utilize values within a finite or infinite interval. Examples – stock price movements of a company.

104

参考回答

Data Blending is a method used to combine data from multiple data sources in Tableau when a direct join is not possible. In data blending, one data source acts as the primary source and the other acts as the secondary source. The data is combined based on common fields or linking fields between the two sources. Unlike joins, data blending happens at the visualization level, meaning the data remains in separate sources but is combined in the view. It is commonly used when working with data from different databases or systems.

105

参考回答

Several data sources can be connected to Power BI, which is grouped into three main types: Files It can import data from Excel (.xlsx, .xlxm), Power BI Desktop files (.pbix) and Comma-Separated Values (.csv). Content Packs These are a collection of related documents or files stored as a group. There are two types of content packs in Power BI:

106

参考回答

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

107

参考回答

Streaming datasets Hybrid Datasets

108

参考回答

The USERELATIONSHIP function in DAX activates an inactive relationship between two tables for the duration of a calculation. This allows you to use a different relationship than the currently active one in your data model. It is particularly useful when you have multiple relationships between tables and need to specify which one to use for a specific calculation.

109

参考回答

Some of the functions offered by the Power BI Query editor include: Data imports to a new group An option for managing parameters The option to handle columns, rows, and groups Column renaming and value replacement options The option to execute R Queries The option to use DAX formulas to add custom columns

110

参考回答

The sum function (Sum()) takes the data columns and aggregates them totally but the SumX function (SumX()) lets you filter the data which you are adding. SUMX(Table, Expression), where the table contains the rows for calculation. Expression is a calculation that will be evaluated on each row of the table.

111

参考回答

Join Queries are used to consolidate inquiries in Power BI.

112

参考回答

Power Pivot is an in-memory data modeling component that: - Supports large datasets efficiently. - Helps in creating relationships between tables. - Uses DAX (Data Analysis Expressions) for calculations.

113

参考回答

DAX is a formula language in Power BI used to: - Create calculated columns and measures. - Perform aggregations and filtering. - Support time intelligence functions.

114

参考回答

Power BI Desktop is supported on Windows 8 or newer versions of Windows. Download the Power BI Desktop version that matches the architecture (x86 or x64) of your Windows OS.

115

参考回答

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

116

参考回答

Below are some of the ways through which we can leverage Power BI: The Power BI Publisher for Excel: Can be used to pin Excel items (charts, ranges, pivot tables) to Power BI Service. Can be used to connect to datasets and reports stored in Power BI Service. Excel workbooks can be uploaded to Power BI and viewed in the browser like Excel Services. Excel reports in the Power BI service can be shared via Content Packs like other reports. Excel workbooks (model and tables) can be exported to service for PBI report creation. Excel workbook Power Pivot models can be imported to Power BI Desktop models.

117

参考回答

Creating dashboards is the final step of data visualization. There are different methods to build a dashboard, which are as follows: - Using drag and drop to arrange worksheets and objects. - Adding filters, parameters, and actions for interactivity. - Using containers to organize layout. - Applying formatting and design best practices.

118

参考回答

Power BI is a tool from Microsoft that lets you easily collect data from different places, analyze and visualize it, and build interactive dashboards and reports. Basically, it helps businesses turn raw data into understandable visuals, making it much simpler for teams to spot trends, track performance metrics, and make informed decisions. Power BI also includes powerful AI features and even lets users ask questions using everyday language, making data analysis intuitive, even if you're not highly technical.

119

参考回答

I use deployment pipelines for version control across dev, test, and prod. For individual reports, I save versions with date stamps in a shared repository. Power BI Service also tracks change history.

120

参考回答

A live connection allows Power BI to connect directly to a data source, such as a database or web service, and retrieve data in real-time. An imported dataset, on the other hand, is a copy of the data that is stored in the Power BI data model. Live connections are typically used for large datasets that are frequently updated, while imported datasets are used for smaller datasets that do not change frequently.

121

参考回答

SQL Server Analysis Services (SSAS) tabular and multidimensional, Power BI datasets, and Azure Analysis Services.

122

参考回答

There would be a lot of issues with raw data. Sometimes, we might have data in the form of a wide-format instead of a long format. If we would want to convert this wide form data into long-form data, we can use pivot.

123

参考回答

There was this one time I was working on a project for a retail client who wanted a Tableau dashboard to analyze their sales performance across different regions and product categories. I created what I thought was a comprehensive and visually appealing dashboard, with multiple charts and filters to help them drill down on the data. However, after presenting the initial version to the client, they expressed that the dashboard was too complex and they had difficulty understanding the relationships between the various charts. I realized that I may have focused too much on aesthetics and complexity while losing sight of the client's primary objective: ease of use and understanding. To rectify this, I scheduled a call with the client to discuss their specific concerns and gather their feedback on which aspects of the dashboard were most confusing or overwhelming. Based on their input, I restructured the dashboard to focus on the most crucial KPIs and relationships, while simplifying the overall design. I combined some related charts and used more straightforward visualization types, like bar and pie charts instead of the more complex ones I initially used. In the end, the client was much more satisfied with the revised dashboard and found it easier to understand the key insights they needed for their business. From this experience, I learned the importance of maintaining a balance between visual appeal and functionality, as well as actively seeking client feedback to ensure their needs are met throughout the development process.

124

参考回答

The ‘What If' parameter, now called a Numeric Range Parameter, in Power BI allows users to visualize different scenarios by dynamically changing parameter values. It's ideal for interactive reports, enabling users to see changes in visuals and calculations instantly. This is useful for scenario analysis and forecasting. With the ‘What If' parameter, users can simulate different situations. For example, they can adjust sales targets, costs, or other key metrics and see the impact on performance. To create one, select “New parameter” from the Modeling tab in Power BI Desktop, and choose “Numeric range”.

125

参考回答

Like DAX, M language (where “M” stands for mash-up) is a language that Power BI supports. M language is used to handle and filter the data, and, more specifically, to combine different data from various supported sources.

126

参考回答

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

127

参考回答

This platform automatically generates SQL queries based on the fields, filters, and aggregations used in a workbook. Writing SQL outside Tableau becomes necessary when dealing with complex joins, heavy transformations, large datasets, or performance-critical queries. Pre-aggregating data in SQL often improves dashboard speed and reduces load on Tableau.

128

参考回答

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

129

参考回答

● High cost compared to many other BI and visualization tools. ● Limited data preprocessing capabilities, so tools like SQL, Python, or ETL tools are often needed. ● Performance issues can occur when working with very large datasets. ● Limited support for advanced statistical analysis compared to programming tools like R or Python. ● Licensing and deployment complexity when managing Tableau Server or Tableau Cloud in large organizations.

130

参考回答

Parameters, sets, and groups are features that allow users to "slice and dice" the data in different ways. - Parameters: Parameters are user-defined values that allow users to customize their visualizations by changing values such as filters, calculations, and reference lines. Parameters provide flexibility and interactivity to visualizations by allowing users to dynamically adjust the data being displayed in a visualization. Users can also create parameter actions to further enhance the interactivity of their visualizations. - Sets: Sets are custom fields that group together similar data points based on a common condition. Sets can be used for filtering and for creating custom calculations based on the members of the set. Sets are created using a logical expression that defines the criteria for inclusion in the set. Once created, sets can be used in calculations, filters, and visualizations. - Groups: Groups allow users to group data points together based on a specific field. Groups are created by selecting individual values from a field and grouping them together under a single label. Groups are useful for creating hierarchical views of data and for simplifying complex visualizations. Groups can also be used for filtering and for creating custom calculations. While all three features allow users to customize their visualizations, their functions and application differ. Parameters provide flexibility and interactivity, sets allow for grouping of similar data points, and groups provide a way to group data points together based on a specific field.

131

参考回答

One significant difference benefitting data analysts and BI analysts in handling discrete data over continuous data is that data analysts can sort Discrete fields but cannot perform any sorting operations on Continuous data fields.

132

参考回答

Sets: The sets are used to compute a condition on which the dataset will be prepared. Data will be grouped together based on a condition. Fields which is responsible for grouping are known assets. For example – students having grades of more than 70%.

133

参考回答

Chop-chop ever-changing Dimension: Value in the dimension is rapidly changing for chop-chop ever-changing dimensions. Example – Age (It changes every second)

134

参考回答

Deployment pipelines give me a structured way to move Power BI content from Development to Test to Production. They support Application Lifecycle Management, but they are available only in Premium or Premium Per User environments. I typically set up three workspaces: Dev, Test, and Prod. In the Development workspace, I build and modify reports, datasets, and dataflows. Once the content is stable, I deploy it to the Test stage using the pipeline interface. In Test, business users or QA teams validate calculations, visuals, and security rules. After approval, I promote the content to Production. What gets deployed includes reports, dashboards, datasets, and dataflows. Workspace-level settings and permissions do not automatically move across stages. I manage those separately. One useful feature is deployment rules. I can define different data source connections per stage. For example, the Dev stage connects to a development database, while Production connects to the live database. I usually manage this through parameters or data source rules, so I don't manually edit connections every time I promote content. Pipelines also support selective deployment. If I modify only one dataset, I can deploy just that item instead of everything in the workspace. If I discover a fix directly in Production, I can use backward deployment to push that fix back to Dev to keep environments aligned. If the organization doesn't have Premium, I handle environment management manually. That can involve copying content between workspaces, scripting deployments through XMLA endpoints with tools like Tabular Editor, or integrating with Azure DevOps using Power BI REST APIs. So my approach is to treat Power BI development like software development: isolate environments, test before release, and manage connections and parameters systematically.

135

参考回答

Yes. Example: VAR TotalSales = SUM(Sales[Amount]) RETURN TotalSales * 0.1. Variables improve readability and performance by evaluating expressions once, avoiding repeated calculations.

136

参考回答

Junk Dimension: Junk values or unrelated dimensions are termed as Junk Dimension.

137

参考回答

There are 7 data types in Tableau: - Boolean (True/False) - Date (Individual Value) - Date and Time - Geography - Text or String - Decimal Number - Whole Number A visualization is typically made up of these seven types.

138

参考回答

In Tableau, data types define the nature and format of the data present in each column of a dataset. Tableau supports various data types to accommodate different types of data. Here are the main data types in Tableau: Integer: Whole numbers without decimal points, used for counting or ordinal values. Float: Numeric values with decimal points, used for continuous numerical data. String (Text): Alphanumeric characters, used for text data, names, labels, and categorical values. Boolean: Logical values representing True or False, used for binary data or conditional statements. Date: Dates without time information, used for date-based analysis and time series. Datetime: Dates with time information, used for more granular time-based analysis. Geographic Role: Special data type for geographical data, such as latitude and longitude, used for creating maps. Duration: Represents time duration, used for calculating time differences. Currency: Used to display currency symbols and values with proper formatting. Percentage: Used for percentage values with formatting to show percentage symbol. Whole Number (Discrete): Similar to Integer but treated as a discrete (categorical) dimension. Decimal Number (Discrete): Similar to Float but treated as a discrete (categorical) dimension. Ordinal: Categorical data with a specific order, used for data with inherent ranking. Measure Names: Special data type used for representing the names of measures in Tableau. Measure Values: Special data type used for representing the values of measures in Tableau. Each data type serves a specific purpose in Tableau and affects how the data is interpreted and displayed in visualizations. Choosing the correct data type is crucial for accurate analysis and effective data visualization in Tableau.

139

参考回答

Two main gateways that are used for Power BI reports include an on-premises gateway and a personal gateway. Whereas on-premises gateways enable several different users to refresh data, a personal gateway is only usable by one individual. Another gateway that can be used is the data management gateway, which can help the user refresh reports in Power BI even once they have been published. You could also use the personal gateway to refresh reports in PowerBI.com.

140

参考回答

- Row-Level Security (RLS) for access control. - Workspace permissions. - Data encryption and masking.

141

参考回答

I scripted a REST API job that published 50 regional workbooks overnight, set project permissions, and emailed links to managers—cutting manual deployment from 3 hours to 10 minutes.

142

参考回答

A bar chart is a chart that shows data using horizontal bars, while a column chart is a chart that shows data using vertical bars. Bar charts are typically used to compare values across categories, while column charts are used to show changes over time.

143

参考回答

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

144

参考回答

All File Database Power BI Azure Online Services Other

145

参考回答

We can abbreviate LOD Expression as Level of Detail Expression. Developers and BI analysts use this to execute complicated queries having multiple data dimensions at the sourcing level. LOD expressions also allow developers to determine values both from the source and visualization levels.

146

参考回答

You can access three critical connectivity modes in Power BI, Direct Query, Live Connection, and SQL Server Import: Direct Query can be used only when you choose to connect to specific data sources and stores metadata exclusively Live Connection is supported by specific data sources, such as SQL Server Analysis Services, Azure Analysis Services, and Power BI Datasets SQL Server Import lets you effortlessly use the entire Power BI Desktop range

147

参考回答

I have embedded Power BI reports into custom web applications using the JavaScript API and embed tokens. I configured Azure AD for authentication and used service principals for secure access.

148

参考回答

Yes, we can. Navigate to filter→ Right-click on it→ select customize→ uncheck the option “Show All”

149

参考回答

There are 4 types of core or built-in map visuals: Map (Basic) Filled Map Shape Map ArcGIS Maps

150

参考回答

In Power BI, I typically use three main types of filters to control what data shows up in my reports: - Report-level filters: These apply to every visual across all pages of the entire report. For example, I might use this to filter all visuals in a sales report to only show data from a specific region or time period. - Page-level filters: These filters apply only to visuals on a particular page. So if I have a marketing dashboard with multiple pages, I might apply a filter just to the "Campaign Performance" page to show results only from my latest campaigns. - Visualization-level filters: These affect just one specific visual. So, if I have a bar chart showing monthly revenue, I might use a visualization-level filter to focus that chart on just the top five performing products.

151

参考回答

Power BI offers distinct kinds of features to help you get started in searching for data in a completely new way. Power BI Pro, on the other hand, caters to some additional features like scheduling data, live data sources, storage capacity, complete interactivity, and much more.

152

参考回答

Since Power Map can show visualizations that relate to geographical data, the user should feed certain information to Power BI, including the city, country, or town that corresponds to the geographical location.

153

参考回答

Power Queries in Excel can be directed to load data into two primary destinations: worksheets and Excel data model tables. When data is loaded to a worksheet, it is placed directly into the cells of an Excel sheet, allowing for manual manipulation or further formula-based processing. On the other hand, when data is loaded into the Excel data model, it is stored in a more structured format that supports complex data analysis and can be utilized for creating PivotTables, PivotCharts, and using Power BI features. The choice between these two depends on the specific needs of your analysis and the complexity of the data handling required.

154

参考回答

I built a radial network chart of supply-chain dependencies overlaid on a geographic map. Clicking a port highlighted upstream supplier-to-factory paths, helping executives reroute shipments during a weather crisis—saving an estimated $1.5 M.

155

参考回答

There are primarily five different components of Power BI: - Power Pivot: It fetches raw data from multiple sources and cleans them to load to Power Query. - Power Query: It operates on loaded data. - Power Q&A: With this component, users can interact with reports and dashboards using simple natural language. - Power View: This component allows users to show their visualization skills and create interactive charts, graphs, and maps. - Power Map: It helps users find accurate geographic locations in datasets.

156

参考回答

Adding a Custom Color refers to a power tool in Tableau. Restart you Tableau desktop once you save .tps file. From the Measures pane, drag the one you want to add color to Color. From the color legend menu arrow, select Edit Colors. When a dialog box opens, select the palette drop-down list and customize as per requirement.

157

参考回答

Power Query in Power BI is a versatile tool for data connectivity and data preparation. It can perform a variety of tasks such as: - Filtering rows: Removing unwanted data based on specific criteria - Merging data: Combining multiple data sources into one unified dataset - Transforming data types: Changing data types to ensure consistency and accuracy - Pivot/Unpivot data: Reshaping data for better analysis and visualization - Grouping operations: Aggregating data to summarize information These tasks are essential for preparing data for analysis, and ensuring that your data is clean, accurate, and properly formatted for creating reliable reports and dashboards. Because of this, you might be asked about the functions of Power Query and how you use them in data preparation. A good response could be: "Power Query, accessible through the Query Editor in Power BI, is essential for data connectivity and preparation. It allows you to perform various tasks such as filtering rows to remove irrelevant data, merging multiple data sources to create a comprehensive dataset, transforming data types for consistency, pivoting and unpivoting data for better analysis, and grouping operations to aggregate data. These capabilities allow people to clean, transform, and shape data effectively before using it in reports." By detailing these tasks and their importance, you demonstrate a thorough understanding of Power Query's functionalities and their practical applications in data preparation.

158

参考回答

RLS restricts data access based on user roles, ensuring users see only authorized data.

159

参考回答

Fast query performance and data manipulation are made possible by the import mode, which imports data into the Power BI data model and stores it in memory. Conversely, DirectQuery mode sends queries straight to the data source rather than storing data in the data model. While dealing with huge datasets or real-time data can be advantageous in this mode, query performance may be slower than in the import mode.

160

参考回答

In Power BI Desktop, I can define relationships between two tables in one of two ways: - Manual relationships: I manually create a relationship by dragging and connecting fields (usually primary and foreign keys) from one table to another in the Model View. This gives me precise control over my data model. - Automatic relationships: Power BI automatically detects and creates relationships if the autodetect feature is enabled. While convenient, I usually double-check these relationships to make sure they're correct. It's important to make sure there are no duplicates or null values in the key columns I'm using; otherwise, the relationships won't work properly. Also, Power BI lets me define multiple relationships between the same two tables, but only one can be active at any given time. The active relationship is shown with a solid line, while inactive ones have dotted lines.

161

参考回答

TDE is a Tableau desktop file that contains a .tde extension. It refers to the file that contains data extracted from external sources like MS Excel, MS Access or CSV file. There are two aspects of TDE design that make them ideal for supporting analytics and data discovery. Firstly, TDE is a columnar store. The second is how they are structured which impacts how they are loaded into memory and used by Tableau. This is an important aspect of how TDEs are "architecture aware". Architecture-awareness means that TDEs use all parts of your computer memory, from RAM to hard disk, and put each part to work what best fits its characteristics.

162

参考回答

Level of Detail (LOD) expressions are a powerful feature in Tableau that allows you to perform calculations at different levels of granularity within a single visualization. This helps you gain deeper insights by analyzing data at various levels of detail without having to create separate worksheets. There are three types of LOD expressions in Tableau: 1. Include LOD: This expression calculates a measure at a more granular level than the view by including additional dimensions in the calculation. 2. Exclude LOD: This expression calculates a measure at a higher level of aggregation by excluding one or more dimensions from the calculation. 3. Fixed LOD: This expression calculates a measure at a specific level of granularity, independent of the dimensions in the view. To use LOD expressions in Tableau, you can follow these steps: 1. Create a calculated field by right-clicking in the Data pane and selecting "Create Calculated Field." 2. In the calculation editor, start your LOD expression with INCLUDE, EXCLUDE, or FIXED, followed by the dimensions you want to use in your expression, enclosed in curly braces ({}). 3. Add a colon (:) and then write the aggregation function you want to apply to the measure, such as SUM(), AVG(), or COUNT(). 4. Close the expression with a closing curly brace (}) and click "OK" to save the calculated field. For example, in a recent project, I used an INCLUDE LOD expression to calculate the average sales per product category for each customer. This allowed me to analyze the customers' preferences at a more granular level, which helped the marketing team develop targeted promotions and campaigns.

163

参考回答

Power BI reports can be shared with external users in a number of methods, such as: - Distributing a report by giving particular individuals or groups access via the Power BI Service. - Posting a report online, making it available to the general public. - Integrating a report using the Power BI Embedded service into a webpage or application.

164

参考回答

Filters in Power BI come in three varieties: - Visual-level filters: Applied to specific report page visualisations. - Filters at the page level: Applied to every visualisation on a particular report page. - Report-level filters: These are used for all of the report's visualisations.

165

参考回答

A story is a combination of worksheets or dashboards that convey a message as a whole. An example of this would be a combination of two worksheets that depict the employee performance of a company. While one worksheet has performance metrics and summaries of employees in the levels L1 to L3, the second one can have the same data of employees in the levels L3 and L4 (upper management). Since the employee performance is interdependent, this can provide a bird's eye view of the whole performance of the company's workforce. This is used when the parameters and measures are different between the worksheets.

166

参考回答

With Power BI's Q&A tool, users can ask questions about their data and get answers in the form of tables or visualisations using natural language queries. Q&A understands the user's purpose and generates the relevant query and visualisation depending on the data model by utilising machine learning and natural language processing.

167

参考回答

I use project management tools like Asana to track tasks and deadlines, ensuring nothing falls through the cracks. Additionally, I maintain detailed documentation of data sources and transformation processes, regularly updating it to ensure accuracy and completeness.

168

参考回答

A stacked chart is a chart that shows the total value of each category, broken down by subcategories, while a clustered chart is a chart that shows the value of each category side-by-side. Stacked charts are typically used to show the composition of a category, while clustered charts are used to compare values across categories.

169

参考回答

A new programming language is used in power query called M-Code. It is easy to use and similar to other languages. M-code is case-sensitive language.

170

参考回答

No

171

参考回答

The CALCULATE function in DAX modifies the filter context of an expression. This enable complex calculations and dynamic aggregations. By changing the filter context, CALCULATE allows you to evaluate an expression based on specific conditions or criteria. For example, you can use CALCULATE to sum sales amounts for a specific region or time period, regardless of other filters applied to the report. ? CALCULATE is the most powerful DAX function because it is the only one that can modify filter context.

172

参考回答

Implementing customized color in the Tableau project is a powerful tool of Tableau. First, save the file in .tps format. Then restart the Tableau Desktop. Navigate to the Measures pane and drag the color you wish to add from the 'Color'. Under the color legend menu, choose Edit Colors, which will open a new dialogue box. Pick your desired color from the palette drop-down list and customize the visualization as necessary.

173

参考回答

KPI (Key Performance Indicator) visualizes business performance using: - Target value (e.g., sales goal). - Actual value (e.g., achieved sales). - Indicator (e.g., color-coded trends).

174

参考回答

To connect to data in Power BI, you start by using the ‘Get Data' feature in Power BI Desktop. This allows you to connect to various data sources like Excel, SQL Server, SharePoint, and more. Once connected, you can either load the data directly to the data model or use Power Query Editor to clean and transform it. This process centralizes your data. It makes the data easier to analyze and visualize. This enhances your data insights and decision-making.

175

参考回答

The Gateway acts as an extension between azure cloud administration and on-premise data sources. There are three major types of Gateways listed as follows: On-premises data gateway Allows multiple users to connect to various on-premises data sources. You can use an on-premises data gateway with all supported services with a single gateway installation. For complex scenarios, this gateway is best suited. On-premises data gateway (personal mode) This data gateway allows one user to connect to sources that can't be shared with others. This gateway is best suited to scenarios in which you only create reports and don't need to share any data sources with others. The virtual network data gateway This data gateway allows multiple users to connect various data sources that are secured by virtual networks. For complex scenarios in which multiple people access multiple data sources, this data gateway is highly preferred.

176

参考回答

Power BI comes in three versions, each tailored to different needs: - Power BI Desktop: A free Windows application for individual report creation and data visualization. It offers robust features for transforming, modeling, and visualizing data - Power BI Pro: A subscription-based service that includes all the capabilities of Power BI Desktop plus additional features for collaboration, sharing, and integration with other services. It supports real-time dashboard updates and data sharing among team members - Power BI Premium: Designed for large organizations, it offers greater capacity, performance, and flexibility without per-user licensing requirements. Premium includes advanced administration and deployment controls and supports larger datasets and more frequent data refreshes The main differences are how they can scale to different organization sizes.

177

参考回答

I would identify common KPIs across units and create a core dataset. For unit-specific KPIs, I use separate pages or conditional visibility. I also implement dynamic measures using SWITCH or parameters to allow users to select their unit's view.

178

参考回答

Creating a story is effective in Tableau which is created by combining various charts to portray a plot of viewers. A story is a sheet that contains all the methods used to create those worksheets. To create a story: - Click the New Story on the dashboard. - Choose the right size of the story from the bottom-left corner or choose a custom size. - Start building the story by double-clicking the sheet and add it to the story point. - Add a caption to the story by clicking Add a caption. - You can update the highlights by clicking Update in the toolbar. You can also add layout options, format a story, or fit the story to your dashboard.

179

参考回答

No. There can be multiple inactive relationships, but only one active relationship between two tables in a Power Pivot data model. Dotted lines represent inactive relationships, and continuous lines represent active relationships.

180

参考回答

- Pre-packaged collections of reports, dashboards, and datasets. - Shared within an organization via Power BI Service.

181

参考回答

Tableau is preferred for complex visual analytics, large-scale data exploration, and when users need advanced chart types. It also excels in on-premises deployments without cloud dependency.

182

参考回答

Use Power BI Service deployment pipelines or Git repositories for report versioning.

183

参考回答

RELATED() fetches a single value from another table. RELATEDTABLE() returns a table of all related rows.

184

参考回答

In Tableau, there are two ways to connect to data: live connection and extract connection. The main difference between these two connection types is how Tableau interacts with the data source. A live connection means that Tableau is connected directly to the data source and queries the data source in real-time as you interact with the visualization. However, live connections can be slower and less efficient than extract connections when working with large data sets or complex queries. An extract connection, on the other hand, means that Tableau creates a static copy of the data source and stores it in a Tableau-specific format called a "data extract." This extract contains only the data that you need for your analysis, which can improve performance and reduce the load on the data source. Extracts can be refreshed or updated on a schedule, or manually as needed.

185

参考回答

Power BI Desktop is used to build and design reports. It runs on Windows. Power BI Service is the cloud platform where reports are shared and viewed by others. Collaboration and scheduled refreshes happen here.

186

参考回答

Data Analysis Expressions (DAX) is a formula language used in Power BI for creating calculated columns, measures, and custom tables. DAX is essential for performing complex calculations and aggregations, enabling users to create advanced analytics and metrics.

187

参考回答

Power Query is a powerful tool in Power BI that helps you connect to various data sources, combine data, and refine it for analysis. Here's what you can do with Power Query: - Connect to Data: Easily connect to a wide range of data sources such as Excel, databases, web pages, and cloud services. - Combine Data: Merge and append data from different sources to create a unified dataset. - Refine Data: Clean and transform your data by removing errors, changing data types, filtering rows, and adding custom columns. ? Power Query in Power BI allows you to connect to various data sources, combine and refine data, making it easy to prepare high-quality data for analysis and visualization.

188

参考回答

In Power BI, a scatter chart shows data as a set of points whose locations are based on the values of two variables. Usually, it is employed to show how two numerical variables are correlated. The size of the points, or bubbles, on a bubble chart, on the other hand, adds a third variable and expands upon the scatter chart. This third variable adds context and facilitates the understanding of intricate interactions between variables by enabling a bubble chart to depict an extra dimension of data.

189

参考回答

I worked on a project where we had to integrate disparate data sources with varying formats and quality. By implementing a robust data cleaning process and using Tableau's data blending features, we successfully created a unified dashboard that provided actionable insights, ultimately improving decision-making efficiency by 20%.

190

参考回答

In Tableau, a hierarchy is a logical arrangement of fields that represents a parent-child relationship between dimensions. It allows users to create drill-down or roll-up views of data, enabling them to explore data at different levels of granularity. Key points about hierarchies in Tableau: Parent-Child Relationship: Hierarchies are created by grouping related dimensions together to form a parent-child relationship. The hierarchy has one or more levels, with each level representing a different dimension. Drill-Down and Roll-Up: With hierarchies, users can drill down to view more detailed data or roll up to view aggregated data at higher levels. For example, a time hierarchy might have levels such as Year, Quarter, Month, and Day, allowing users to drill down from Year to Quarter, Month, and Day. Nested Structure: Hierarchies are represented as a nested structure in the Tableau data pane, with the parent dimension at the top and the child dimensions indented below. Creating Hierarchies: To create a hierarchy, users simply drag and drop dimensions onto each other in the data pane to form the desired parent-child relationship. Hierarchy Sorting: Tableau automatically sorts hierarchies in ascending or descending order based on the data. Users can also customize the sorting order if needed. Hierarchical Filters: When filtering data, hierarchical filters allow users to filter data at different levels within the hierarchy, making it easier to focus on specific subsets of data. Hierarchies in Tableau are useful for organizing and presenting data in a structured manner, allowing users to explore data at different levels of detail and gain insights from various perspectives. They are commonly used in data analysis and data visualization to provide users with a flexible and interactive way to navigate and analyze data at different hierarchical levels.

191

参考回答

Create a bridge table with distinct values from both tables. Link both original tables to the bridge. Use DAX functions like TREATAS or model it using composite models, depending on the complexity.

192

参考回答

In Tableau, data blending is the process of combining data from different sources or links to make a single view that can be used for analysis. It is used when there is no direct link between the data sources or a key that they both share. Tableau finds similar dimensions and makes sensible connections between the main and secondary data sources. This lets users work with complicated sets of data and get insights from data that can't be easily put together using standard joins. But there may be some limits to data blending, such as the possibility of data duplication and speed issues. Still, it is a powerful Tableau tool that lets you analyze many different datasets in depth.

193

参考回答

Extract connection seems more beneficial than Live connection because we can use it anytime without connecting to the database. We can also render visualizations without even a database connection.

194

参考回答

You will use a custom visual file if the prepackaged files don't fit the needs of your business. Developers create custom visual files, and you can import them and use them in the same way as you would the prepackaged files.

195

参考回答

With Power BI, hierarchies can be made by grouping relevant fields into parent-child hierarchies that let users drill down or up through the hierarchy's tiers. To form a hierarchy, take the following actions: Choose the table in the data model that has the hierarchy fields in it. To establish a hierarchy, drag the parent field onto the child field. Drag and drop more fields into the hierarchy as needed.

196

参考回答

I avoid jargon. I walk them through the visuals, show filters, and explain what each metric means. I focus on the impact, not the backend.

197

参考回答

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

198

参考回答

Power BI and Power View 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 View is a data exploration and visualization tool that is used to create interactive reports within Excel.

199

参考回答

To perform grouping in power bi, please select the fields you want to group, and right-click on it will open the context menu. Please select the Group option from the menu. Once you click on the group option, Power BI will automatically group those items, as shown below. That's it; we did the grouping. If you observe closely, the legend section is replaced by group, and colour is placed in the details section.

200

参考回答

Below are the most important BI add-in to Excel: Power Query: It helps in finding, editing and loading external data. Power Pivot: Its mainly used for data modeling and analysis. Power View: It is used to design visual and interactively reports. Power Map: It helps to display insights on 3D Map. Want to upskill yourself to get ahead in your career? Check out this video

すべての情報を見逃したくないですか？

100％合格！Cisco、PMP、CISA、CISM、AWS 模擬試験セール中！
今すぐ入手

認定資格を取得して、履歴書を際立たせましょう。

すべての情報を見逃したくないですか？

100％合格！Cisco、PMP、CISA、CISM、AWS 模擬試験セール中！ 今すぐ入手

認定資格を取得して、履歴書を際立たせましょう。

100％合格！Cisco、PMP、CISA、CISM、AWS 模擬試験セール中！
今すぐ入手