不想錯過任何事？

通過認證考試的技巧

最新考試新聞和折扣資訊

由我們的專家策劃和更新

是的，請向我發送時事通訊

查看其他面試題
1
參考答案
A calculated table is created using DAX expressions that define the rows and columns of the table. To create a calculated table, you can use the "New Table" option in Power BI Desktop and then enter the DAX expression that defines the table.
2
參考答案
Common DAX Aggregate Functions: - SUM: Adds up all numeric values in a column. For example: SUM(Sales[Amount]) - AVERAGE: Calculates the average of numeric values in a column. For example: AVERAGE(Sales[Amount]) - MIN: Returns the smallest value in a column. For example: MIN(Sales[Amount]) - MAX: Returns the largest value in a column. For example: MAX(Sales[Amount]) - COUNT: Counts the number of non-blank values in a column. For example: COUNT(Sales[OrderID]) - COUNTA: Counts all non-empty values including text, numbers and dates. For example: COUNTA(Sales[CustomerName]) - COUNTROWS:Counts the number of rows in a table or table expression. For example: COUNTROWS(Sales) - DISTINCTCOUNT: Counts unique values in a column. For example: DISTINCTCOUNT(Sales[CustomerID]) - PRODUCT: Returns the product of all values in a column. For example: PRODUCT(Sales[Quantity]) - MEDIAN: Returns the median value of a column. For example: MEDIAN(Sales[Amount]) - SUMX: Row-wise sum then aggregate the results. For example: SUMX(Sales, Sales[Quantity] * Sales[Price])
職涯加速

考取認證，讓履歷脫穎而出。

數據分析顯示，持有 IT 認證的從業者年薪平均比求職者高出 26%。在 SPOTO，您可以同時備考認證與準備面試，加速職涯成長。

1 100% 通過率
2 2 週題庫練習
3 通過認證考試
全球認可 100 萬+ 已認證 邊工作邊學習
制定學習計劃
3
參考答案
To create a custom visual in Power BI using Vue.js, you can use the "Custom Visual" feature to write JavaScript code that generates the visualization using the Vue.js framework. Once the code is written, you can add it to your report and use it like any other visual.
4
參考答案
B) Import
5
參考答案
- Implement Row-Level Security (RLS) in Power BI. - Define roles in Power BI Desktop (e.g., [Region] = USERPRINCIPALNAME() mapping). - Publish report to Power BI Service and assign roles to specific users.
6
參考答案
Use conditional formatting with a formula like COUNTIF($A$1:$A1, A1)>1 applied to the range.
7
參考答案
Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view.
8
參考答案
In general, Tableau supports the following join types: - inner join: An inner join returns only the rows that have matching values in both tables. - left join: A left join returns all the rows from the left table, and the matching rows from the right table. If there is no match in the right table, it returns NULL values. - right join: A right join returns all the rows from the right table and the matching rows from the left table. If there is no match in the left table, it returns NULL values. - full outer join: A full outer join returns all the rows from both tables. It includes the matching rows from both tables and the non-matching rows with NULL values for the missing columns.
9
參考答案
At a financial services firm, I led a project to create a real-time dashboard for monitoring key performance indicators. We faced data integration challenges from multiple sources, which I addressed by implementing a robust ETL process. I collaborated closely with the business team to ensure their requirements were met. Ultimately, the dashboard improved decision-making speed by 30%, resulting in a significant boost in operational efficiency.
10
參考答案
- Dataflows store and preprocess data before loading into reports. - Allows reuse of data models across different reports.
11
參考答案
Yes, it is used to measure and analyze the performance of each visual and DAX query in a Power BI report.
12
參考答案
A column chat visualizes the data as a set of rectangle columns, as their lengths are proportional to values when they represent the data. The horizontal axis shows the category to which they belong, and the vertical axis shows the values.
13
參考答案
The critical components of Power BI are mentioned below. Power Query Power Pivot Power View Power Map Power Q&A
14
參考答案
For a dashboard to load quickly, be responsive and offer a seamless user experience, its performance in Tableau must be optimized. Below are key techniques: 1. Data Source Optimization - Use extracts instead of live connections for large datasets. - Apply data source filters to restrict unnecessary rows. - Optimize joins and reduce custom SQL where possible. 2. Data Aggregation - Pre-aggregate data at the database level. - Summarize fields before bringing them into Tableau. 3. Filter Optimization - Prefer parameters over multiple quick filters when possible. - Use context filters for dependent filtering. - Minimize the number of quick filters and avoid using "Show All Values." 4. Parameter Optimization - Replace heavy filters with parameters when interactivity is required. 5. Sheet Optimization - Hide or remove unused sheets from the workbook. - Simplify visuals (avoid excessive marks, unnecessary detail). - Limit the number of sheets on a single dashboard. 6. Calculation Optimization - Minimize complex row-level calculations and use aggregated calculations. - Avoid redundant or nested calculations that slow query execution. - Use LOD Expressions wisely, as they can increase query time. 7. Dashboard Design Optimization - Reduce the number of visuals and marks displayed at once. - Use extract filters to limit data before loading. - Optimize images, maps and background graphics. 8. Performance Recording - Use Tableau's Performance Recording feature to identify bottlenecks. 9. Server and Publishing Optimization - For Tableau Server, schedule extract refreshes efficiently. - Use published data sources instead of creating duplicates across workbooks.
15
參考答案
Tableau Desktop is a paid product that offers extensive features for data analysis and visualization, including connectivity to a wide range of data sources and the ability to save work locally. Tableau Public is a free version with limited data source connectivity and requires users to save their work to Tableau's public servers, making it accessible to anyone on the internet.
16
參考答案
Tableau is a powerful data visualization tool whose four best features are– · Tableau allows real-time data analysis. · It provides advanced visualizations (different types of graphs and charts). · Collaboration of data is possible with Tableau. · Tableau also provides a data blending facility.
17
參考答案
Incremental refresh allows refreshing only new or changed data instead of the entire dataset, saving time and resources.
18
參考答案
Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet.
19
參考答案
A flow map will best fit this scenario. Flow maps allow us to visualize the traversal path and what changes happened with time.
20
參考答案
Answer: Use a Line Chart with Date on X-axis and Sales on Y-axis.
21
參考答案
Mindmajix instructor-led training completely prepares you for the certification. We provide two industry-specific projects in the course, which helps you have hands-on experience on all possible scenarios that are part of certification.
22
參考答案
I use an On-premises Data Gateway to connect Power BI Service to SQL Server. In Power BI Desktop, I select SQL Server as the data source and use Import or DirectQuery mode.
23
參考答案
CALCULATE() modifies calculations using filters. Syntax:
24
參考答案
Aggregation and disaggregation commands tableau to combine data based on user requirement. If you want to create any chart than there are specific requirements of the chart to be made such as 1 dimension or 2 dimension and 1 measure or 2 measure. And for measures one need to specify the aggregation that is sum, median, average etc. or else by default all the values will be shown as sum. And the user might want to see a different outcome from the chart. So, it is very important to use the correct aggregation method or to disaggregate the data if required.
25
參考答案
Power BI was introduced by Microsoft to combine the multiple data visualization features into one. Power BI is the new term for the data-driven industry and thus carries a lot of opportunities on its shoulders. It comes as a package of three major components: Power BI services Power BI Desktop Power BI mobile app With these three components, Power BI lets you create a data-driven insight into your business. Based on various roles, you can leverage Power BI to your benefits like creating reports, monitor progress, integrate APIs, and many more.
26
參考答案
Syntax: This is how the formula is written—the elements that comprise it. The syntax includes functions such as SUM (used when you want to add figures). If the syntax isn't correct, you'll get an error message. Functions: These are formulas that use specific values (also known as arguments) in a certain order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.
27
參考答案
The Advanced Editor displays the M code for all transformation steps. I use it to write custom M functions, optimize queries, or debug complex transformations. It provides full control over the data pipeline.
28
參考答案
Bookmarks in Power BI capture the current state of a report page, including filters, slicers, and the state of visuals. They are helpful when you want to showcase a particular view of your data or create a storytelling sequence in your report. For example You might create bookmarks to highlight different time periods or specific insights during a presentation. Using bookmarks enhances the storytelling aspect of your reports, allowing you to guide users through specific insights and findings effectively.
29
參考答案
Tableau Pulse is a feature in Tableau that provides automated and personalized insights from data using AI-driven analytics. It continuously monitors key metrics and automatically delivers insights to users about important changes, trends, or anomalies in the data. Instead of manually checking dashboards, users receive data-driven updates and summaries directly through notifications, emails, or integrations like Slack. Tableau Pulse focuses on metrics-based analysis, helping users track business performance more easily. This helps organizations make faster and more informed decisions by proactively highlighting important insights from their data.
30
參考答案
A semantic model is a structured data layer with defined relationships, measures, hierarchies, and metadata. It allows users to explore data without writing code. It improves reusability and consistency across reports.
31
參考答案
Performance testing in tableau is very important as it will let you know how your workbook will operate once you make it publish it into the real world scenarios. To perform the performance testing first step is to set up test environment in tableau server and disable any automated or scheduled extract refresh schedules. Second step is to capture performance metrics using Tabjolt or any other tool then upgrade the test environment and run Tabjolt to check workbook performance. If there is no difference in performance then use a subset of workbooks to again test the performance after doing an extract refresh.
32
參考答案
A dashboard in Tableau is a collection of multiple visualizations (worksheets), text, images and interactive elements combined in a single view. It is used to present different aspects of data together, allowing users to compare, monitor and interact with insights at once. Instead of looking at charts separately, a dashboard brings them together for storytelling and decision-making. - Combines multiple views: You can place bar charts, maps, line charts and tables in one place. - Interactive controls: Filters, parameters and actions like highlight or go-to URL make dashboards dynamic. - Real-time updates: Refreshes automatically when the underlying data source updates. - Device-specific layouts: Can be optimized for desktop, tablet or mobile. - Storytelling: Lets you connect multiple charts into a meaningful narrative for business insights.
33
參考答案
To use the Power BI service for free, you need a work email and a web browser. With this, you can explore data as well as create reports in Power BI Desktop. The mobile app can be downloaded from the following stores: Google Play, App Store, and Windows Store.
34
參考答案
A tableau dashboard is the final step in creating the visualization. First of all, create all the charts in different sheets and then click on add new dashboard in the bottom most tab from where you were adding new worksheets. You can also right click on the add new sheet button and there you can select add new dashboard instead of a sheet. There is one more way to add new dashboard, go to dashboard in toolbar then select new dashboard. After following any of the above three ways you will get a new dashboard where you can drag the required sheets from left panel to the dashboard one by one and start applying your creativity to create an understandable story.
35
參考答案
Look for: Experience with Power BI's AI capabilities like Q&A, Quick Insights, and AI visuals. What to Expect: Examples of using AI features to gain insights from data, such as natural language queries with Q&A, generating insights with Quick Insights, and using AI visuals like Key Influencers.
36
參考答案
In Tableau, a discrete value is a distinct value that can be counted (number of dogs in the park, number of rainbow colors, etc.), while a continuous value is a numeric value that can take on any value within a range (150.38 lbs, 6 ½ hours, etc.). Discrete values (in blue) are typically used for categorical data, while continuous values (in green) are used for numerical data.
37
參考答案
Context Filters are applied to the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau
38
參考答案
SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
39
參考答案
Power BI is available in various formats: - Power BI desktop: For the desktop version - Power BI mobile app: For using the visualizations on mobile OS and share it - Power BI services: For online SaaS
40
參考答案
I prioritize tasks by assessing project scope and deadlines, ensuring that critical tasks are addressed first. I use project management tools like Trello to track progress and facilitate collaboration, and I maintain regular communication with stakeholders to manage expectations and provide updates.
41
參考答案
Expect practical, scenario-based questions. For example, "How would you handle a slow dashboard?" or "How do you approach cleaning messy data before visualization?" Interviewers want to see how you apply your Tableau skills in everyday business situations.
42
參考答案
A stacked column chart is a chart that shows the composition of each category using stacked columns, while a stacked bar chart is a chart that shows the composition of each category using stacked bars. Stacked column charts are typically used to show changes over time, while stacked bar charts are used to compare values across categories.
43
參考答案
If a report runs slowly, I first try to isolate where the delay is coming from instead of immediately rewriting code. I start with Performance Analyzer in Power BI Desktop. I record a refresh and check how long each visual takes. Power BI breaks it down into DAX query time and visual rendering time. If the DAX query takes most of the time, the issue usually lies in the data model or measures. If rendering is slow, the visual may be pulling too much data or using complex interactions. Next, I check the data model. I look for unnecessary columns in large fact tables and remove any that are not used in visuals or calculations. I also verify data types; for example, IDs stored as text instead of integers increase memory usage. If Auto Date/Time is enabled while I already have a proper date table, I disable it to avoid hidden tables expanding the model. Then I review the DAX measures used in the slow visuals. If I see iterators like SUMX or COUNTX over large tables, I evaluate whether a simple aggregation like SUM or COUNT would work. Iterators often shift more work to the formula engine, which becomes expensive at scale. I also simplify CALCULATE expressions by using direct column filters instead of complex FILTER() logic wherever possible. Using variables (VAR) helps avoid recalculating the same expression multiple times. After that, I check the storage mode. If the model uses DirectQuery, every interaction sends queries back to the source system, which increases latency. If the dataset allows it, I switch to Import mode for better performance. In larger systems, I design a composite model with imported aggregation tables for summaries and DirectQuery only for detailed drillthrough. I also review Power Query to ensure query folding still works. If transformations break folding early, Power BI processes more data locally than necessary, increasing refresh time and memory load. If performance is still an issue, I use DAX Studio to analyze server timings and understand how much time the storage engine versus the formula engine consumes. That usually tells me whether the bottleneck is model design or DAX logic. That's the approach I follow: isolate the bottleneck, optimize the model, simplify calculations, and choose the right storage architecture.
44
參考答案
TreeMaps are a type of data visualization in Tableau that display hierarchical data as nested rectangles where the size and color of the rectangles indicate the values associated with the categories, revealing both the structure of the data and its quantitative aspects.
45
參考答案
I define roles in Power BI Desktop using DAX filters based on user attributes like email or region. In Power BI Service, I assign users to roles via workspace settings. For large teams, I use Azure AD groups for scalability.
46
參考答案
Tableau data server is a feature provided with Tableau server which allows its user to store Data extracts on one centralized server which can be accessed by different users to draw some visualization and analysis on data based on their understandings. This feature helps reducing the memory occupied by data storage because one extract can be used at multiple systems simultaneously.
47
參考答案
Joining data means combining two sets of data from a single source (an Excel sheet, for example). Blending data involves the usage of two different sources (an Excel sheet and an Access report).
48
參考答案
In my Tableau projects, I handle null and special values based on the data context and business needs. For measures, I often use ZN() or IFNULL() to replace nulls with zeros or default values - this ensures charts like KPIs or bar graphs display correctly. For dimensions, I use calculated fields to label nulls as "Unknown" or a relevant category. If the nulls aren't needed, I filter them out, especially to keep dashboards clean and focused. I also use visual options like "Show at default position" or tooltips to explain nulls when transparency is important. Overall, my approach balances clean visuals with accurate data storytelling.
49
參考答案
Tableau like other BI tools has a range of products: - Tableau Desktop: Desktop product is used to create optimized queries out from pictures of data. Once the queries are ready, you can perform those queries without the need to code. Tableau desktop encompasses data from various sources into its data engine and creates an interactive dashboard. - Tableau Server: When you have published dashboards using Tableau Desktop, Tableau servers help in sharing them throughout the organization. It is an enterprise-level feature that is installed on a Windows or Linux server. - Tableau Reader: Tableau Reader is a free feature available on Desktop that lets you open and views data visualizations. You can filter or drill down the data but restricts editing any formulas or performing any kind of actions on it. It is also used to extract connection files. - Tableau Online: Tableau online is also a paid feature but doesn't need exclusive installation. It comes with the software and is used to share the published dashboards anywhere and everywhere. - Tableau Public: Tableau public is yet another free feature to view your data visualizations by saving them as worksheets or workbooks on Tableau Server.
50
參考答案
Power Query is a self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in. It allows users to pull data from various sources, manipulate said data into a form that suits their needs and load it into Excel. It is most optimum to use Power Query over Power Pivot as it lets you not only load the data but also manipulate it as per the users needs while loading.
51
參考答案
RunningTotal = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales), Sales[Date] <= MAX(Sales[Date]) && Sales[CustomerID] = MAX(Sales[CustomerID])))
52
參考答案
Every column has these three lines. When you click on that,you can either sort that in ascending order or descending order.
53
參考答案
Use Append Queries in Power Query. Syntax: Combined Sales = Append(Online Sales, Store Sales)
54
參考答案
In DAX, VALUES and DISTINCT are used to get unique values, but they work slightly differently: - VALUES: Returns a single column or table (depending on the input) of unique values, including a blank row for null values. It's useful when you need to consider all unique entries, including blanks. - DISTINCT: Returns unique values by removing duplicates, but does not include a blank row for null values. ? VALUES returns unique values including blanks. DISTINCT removes duplicates without including blanks.
55
參考答案
Duration = DATEDIFF(Ticket[Date], COALESCE(Ticket[ResolutionDate], TODAY()), DAY)
56
參考答案
- Bookmarks allow users to capture and save a report's current state, including applied filters and slicers. - Useful for navigating between different report views dynamically.
57
參考答案
On the main page, you would have the “connect to” pane on the left side. From there, you can select “PDF File”
58
參考答案
Even if you don't have extensive knowledge of other BI tools, you may still be able to chat about the differences between Tableau and Excel charts. If you have experience with PowerBI, you can learn more about the comparative advantages and disadvantages by reading our PowerBI v. Tableau: Which Should You Choose in 2024? article. A few of the advantages of Tableau over other BI tools include: - a user-friendly interface: the drag-and-drop feature allows an inexperienced user to ramp up fairly easily and start building charts in minutes; - the wide range of data sources that are supported by the application: from relational databases to flat files to web sources, there are many ways to connect your data using Tableau; - design flexibility: Tableau's flexibility allows users to design custom visualizations; and - a supportive user community: the large and active community of users makes it easy to get your Tableau questions answered. One of the downsides of Tableau is its pricing model. At $70/user/month, that's an $840 license per user on an annual basis (before any sales discount is applied). It's not cheap!
59
參考答案
Power BI is a cloud-based data-sharing environment. Once you have developed reports using Power Query, Power Pivot, and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation.
60
參考答案
On-premises Data Gateway (standard) for multiple users and Personal Gateway for single-user scenarios. I use the standard gateway for enterprise deployments with scheduled refreshes and live queries.
61
參考答案
Tableau provides several ways to restrict data access to users, including user-level security, row-level security, and column-level security. Here is a brief overview of each approach: - User-level security: User-level security is used to restrict access to Tableau content based on user login credentials. With user-level security, you can define which users can access specific workbooks, views, and data sources within Tableau. - Row-level security: Row-level security is used to restrict access to specific rows of data within a dataset based on the user's login credentials. - Column-level security: Column-level security is used to restrict access to specific columns of data within a dataset based on the user's login credentials. By using user-level, row-level, and column-level security, you can ensure that only authorized users have access to specific data within your Tableau environment. This can help you to maintain data privacy, confidentiality, and security.
62
參考答案
Row-level security restricts the data that users view and access based on filters. To configure rowlevel security, users can define rules and roles within Power BI Desktop and publish them to Power BI Service. Also, the username() function can restrict data in the table to the current user. However, to enable row-level security, a Power BI Pro subscription account is essential, and Excel sheets can be used when converted to the .pbix file format. Following are the ways to implement Row Level Security in Power BI: Define roles and rules in Power BI Desktop Validate the roles within Power BI Desktop Manage security on your model Validating the role within the Power BI service
63
參考答案
Calculated fields in Tableau are row-level or aggregate expressions, similar to DAX measures. DAX is more powerful for time intelligence and filter context manipulation, while Tableau is more intuitive for quick calculations.
64
參考答案
Some commonly used tasks in the Query Editor are: Connect to Data: Get Data from various sources and Transform data. Shape Data: Transform your data according to requirement to clean and shape it Group Rows: You can group the values of many rows into one single value by summarizing Pivot Columns: Pivot columns and create a table with aggregated values
65
參考答案
To create a custom visual in Power BI using SVG and D3.js, you can use the "Custom Visual" feature to write JavaScript code that generates the visualization using the SVG format and the D3.js library. Once the code is written, you can add it to your report and use it like any other visual.
66
參考答案
In my previous role, I was asked to work with a team of data analysts and several business stakeholders to develop a Tableau dashboard for a retail client. The goal was to provide insights into customer purchasing behavior, sales trends, and inventory management. First, I arranged a kick-off meeting to gather the entire team and establish a clear understanding of the project requirements and desired outcomes. During this meeting, I listened carefully to each team member's input, asked questions to clarify their needs, and took diligent notes. I then created a mock-up of the dashboard and shared it with the team to gather feedback. After receiving the team's input, I identified areas that needed improvement and collaborated closely with the data analysts to ensure that the underlying data was accurate and up-to-date. Throughout the process, I maintained open lines of communication, providing regular updates on my progress and addressing any concerns that arose. Once the dashboard was complete, I organized a final review session where I walked the team through the dashboard, ensuring that it met their expectations and answered all key business questions. I also provided training to the team on how to use the dashboard, ensuring they were comfortable navigating and interpreting the data. The end result was a well-received dashboard that the retail client could use to make informed decisions on their sales and inventory strategies. By maintaining strong communication, being open to feedback, and staying focused on the project's goals, I was able to work effectively with the diverse team and deliver a successful Tableau dashboard.
67
參考答案
I often work with data from multiple systems - like Excel, SQL Server, and Google Sheets. First, I assess whether I can combine them within Tableau using data blending or joins, or if it's better to pre-join them outside Tableau using tools like Power Query or SQL views. When blending in Tableau, I ensure that the primary and secondary sources are properly related and avoid over-complicating the visual with too many secondary fields. I'm also careful with performance and consistency, often validating results by comparing row-level data from each source. This ensures reliable outputs, even from diverse inputs.
68
參考答案
UNION removes duplicates, UNION ALL keeps all rows.
69
參考答案
A Box Plot (also called a Box-and-Whisker Plot) is the best chart to visualize data distribution across quartiles. It summarizes the dataset using key statistics: - Box: Represents the Interquartile Range (IQR: Q1 to Q3). - Line inside the box: Median (Q2). - Whiskers: Extend to minimum and maximum values within a range. - Outliers: Plotted as individual points beyond whiskers. Box plots are useful for quickly identifying central tendency, spread, skewness and outliers making them ideal for statistical comparison across groups.
70
參考答案
A feature in Power BI Service to manage the lifecycle of content across development, test, and production stages.
71
參考答案
A table calculation is a specific field in Tableau based on data in a file. Tableau allows you to make basic calculations across a row or a column within a data set, or you can create more involved calculations that utilize multiple columns and rows simultaneously using specific parameters on which calculations you should perform first.
72
參考答案
On a Power BI final report page, a developer can resize a responsive slicer to various sizes and shapes, and the data collected in the container will be rearranged to find a match. If a visual report becomes too small to be useful, an icon representing the visual takes its place, saving space on the report page.
73
參考答案
Wrap the formula in IFERROR(formula, value_if_error) to return a custom value when an error occurs.
74
參考答案
I have used Tableau extensions like the DataRobot extension to integrate predictive analytics directly into dashboards, enhancing decision-making capabilities. Additionally, I developed a custom extension to automate data refreshes, significantly improving workflow efficiency.
75
參考答案
Bookmarks capture report states for navigation or storytelling. Selection panes control visibility of visuals. I combine them to create drill-through experiences or toggle between views.
76
參考答案
Using Power BI visualizations, you can apply customized visualizations like charts, KPIs, etc. from the rich library of PowerBI's custom visuals. It refrains the developers from creating it from scratch using JQuery or Javascript SDK. Once the custom visual is ready, it is tested thoroughly. Post testing, they are packaged in .pbiviz file format and shared within the organization. Types of visuals available in Power BI are: Custom visual files. Organizational files. Marketplace files.
77
參考答案
It connects Power BI Service to on-premise data sources. It supports live queries and scheduled refreshes. The gateway runs in the background and must stay online.
78
參考答案
Worksheet is a basic building block of performing data visualization. It has drag and drop fields that construct graphs, charts and tables. It has a feature of customization by which individuals can include filters, charts and manipulate the formatting inside the sheet. They can design unique visualizations with this feature. It is also possible to create computed fields, data blending and reference lines on a worksheet.
79
參考答案
Calculated columns are columns created in the data model using DAX expressions that perform calculations on each row of data. Measures are also created using DAX, but they aggregate data across multiple rows or tables in the data model. Measures are typically used in visualizations and reports to display aggregate values, such as totals or averages.
80
參考答案
A histogram is a chart that shows the distribution of data within a range of values, while a bar chart is a chart that shows the value of each category using bars. Histograms are typically used to show the frequency of data within a range, while bar charts are used to compare values across categories.
81
參考答案
It allows filters to flow both ways between tables. Useful for slicers affecting multiple related tables. But it can introduce circular dependencies or performance issues if used wrongly.
82
參考答案
Conformed Dimension: If any dimension is provided by various business areas, then such a dimension is termed a Conformed Dimension. Example – Time (9-5) for any company or hospital or college
83
參考答案
Tableau is smart enough to perform strategic acquisition because it can deliver knowledge-based insights with rich visuals that other tools fail to provide. Furthermore, it can conjointly arrange data for different purposes and improvise our methods for producing a crisp understanding of data.
84
參考答案
To create a custom visual in Power BI using Angular, you can use the "Custom Visual" feature to write TypeScript code that generates the visualization using the Angular framework. Once the code is written, you can add it to your report and use it like any other visual.
85
參考答案
A histogram is a visual representation with the help of which we can understand the distribution of numerical data.
86
參考答案
Yes, we can perform load testing in Tableau using TabJolt. It is a server performance testing Tableau server, and tableau does not support this third-party software directly. So, we can install this performance testing server using other open-source applications.
87
參考答案
Use a self-join on manager_id and salary, excluding the same employee.
88
參考答案
A flexible new tool under the Power BI umbrella is the Power BI Designer. It empowers users to create intuitive dashboards and reports that allow them to change their data's visual views easily. This tool is the most popular and best for better analytics and informed decision-making. This designer tool is a host of drag-and-drop features that enable you to place content exactly where you want it to be in a report.
89
參考答案
When it comes to data visualization tools, Power BI and Tableau are often compared due to their popularity. Although they have overlapping functionalities, key differences exist: Power BI: - Integration: Power BI integrates seamlessly with other Microsoft products, making it a suitable choice for organizations already using Microsoft services like Excel, Azure, and SQL Server. It's the tool of choice for Microsoft heavy offices - Cost: Power BI is generally more cost-effective, with flexible pricing options that cater to small and medium-sized businesses as well as large enterprises - Ease of Use: Power BI is known for its user-friendly interface, which is intuitive for users familiar with Microsoft products Tableau: - Advanced Visualization Capabilities: Tableau offers a wide variety of sophisticated visualization options and greater flexibility in designing dashboards. It is often preferred for its superior visual analytics - User Community and Support: Tableau has a robust user community and extensive resources for learning and troubleshooting, which can be advantageous for users seeking advanced support and training - Adoption in Large Businesses: Tableau is frequently chosen by large enterprises that require complex data visualization and analysis capabilities Knowing the differences between these two will aid in selecting the right tool based on the organization's infrastructure, budget, and visualization needs.
90
參考答案
To optimize Power BI reports for performance, follow these best practices: - Reduce the Amount of Data: Load to the data model only the columns you require for analysis. Remove unnecessary columns and filter out unnecessary rows. - Ensure Efficient Data Models: Design data models with proper relationships and avoid unnecessary columns and tables. - Use Aggregations: Aggregate data at the source to minimize the data processed by Power BI. - Simplify Visuals: Use fewer and simpler visuals to reduce rendering time. - Optimize DAX Calculations: Write efficient DAX formulas and avoid complex calculations on large datasets. - Limit Direct Queries: Use import mode instead of direct query mode when possible to improve performance. Power BI provides several optimization tools. Run the built-in Performance Analyzer to catch and address any lags before you publish the report. When using Direct Query, consider query reduction. You can apply it from the Optimization presets menu. It turns off cross-highlighting and cross-filtering and adds an Apply button to the filter pane. That way the data doesn't reload with every change you make. ? Optimize slow performance in Power BI reports by reducing the amount of data, designing efficient data models, simplifying visuals, aggregating data, optimizing DAX, and limiting direct queries.
91
參考答案
The bar chart visualizes the data as a set of rectangle bars, as their values are proportional to lengths when they represent the data. The vertical axis shows the category to which they belong to and the horizontal axis shows the values. So, the bar chart is a vertical version of the Column chart.
92
參考答案
Parameters are dynamic values, we can replace the constant values in calculations.
93
參考答案
Power BI primarily stores data in two secure locations within the Microsoft Azure environment: - Azure Blob Storage: This is where your actual data (the content you upload or import) is securely stored. - Azure SQL Database: This stores all metadata, system configurations, and artifacts related to Power BI, like data models and report definitions. All data stored in Power BI is protected through encryption and secure access controls, ensuring business information remains safe at all times.
94
參考答案
Use a dictionary and loop through the string, incrementing the count for each character.
95
參考答案
A dashboard is a single-page, real-time view of visuals from one or more reports. It helps users track performance at a glance.
96
參考答案
Managing Tableau Server performance involves monitoring metrics through Admin views and tools like TabMon, optimizing extracts and workbooks, and balancing user sessions. Regular updates, permission management, and proactive log monitoring ensure smooth operation. For high traffic, clustering and load balancing improve scalability.
97
參考答案
A slicer is a Power BI graphic feature that lets users choose particular values or ranges to filter data in a report. Compared to conventional filters, slicers offer a more interactive and user-friendly method of filtering data. Conversely, filters are not visible to the end user because they are applied directly to the data model or specific visualizations.
98
參考答案
Data extracts are the subsets of data created from data sources. Schedules are scheduled refreshes made on extracts after publishing the workbook. This keeps the data up-to-date. Schedules are strictly managed by the server administrators.
99
參考答案
A Power BI Gateway acts as a bridge between on-premises data sources and cloud-based Power BI Service, allowing secure data transfer.
100
參考答案
Data is shown as segments of a circle in a pie chart, where the sizes of the segments correspond to the values. A doughnut chart resembles a pie chart except that it has a hole in the middle that makes it look like a ring. The percentage of each group within the total is displayed in both charts. Nevertheless, doughnut charts can also have a label or a total value displayed in the centre hole for further information.
101
參考答案
To create a drill-through visualization in Power BI, you can use the "Drillthrough" feature to define the relationship between the two visualizations. Once the relationship is defined, you can add drill-through buttons to the original visualization that allow users to navigate to the drill-through visualization.
102
參考答案
Tiles are individual visual elements on a dashboard representing specific data metrics.
103
參考答案
It is a function that allows manipulating data using periods.
104
參考答案
There are multiple applications of Power BI; some of them are as follows: Business Analysis Data Analysis Database Administration IT Professional
105
參考答案
The primary components of Tableau Server are: - Application Server - Data engine - Repository - Data Server - Gateway - VizQL Server - Search and License - Backgrounder
106
參考答案
Tableau supports 7 various different data types: - String - Numerical values - Date and time values - Boolean values - Geographic values - Date values - Cluster Values
107
參考答案
Power BI and Excel are both used for data analysis, but they have significant differences: Data Relationships: - Excel: Supports single directional relationships (one-to-many). - Power BI: Supports bi-directional relationships for more complex data models. Cross-Filtering: - Excel: Does not support bi-directional cross-filtering. - Power BI: Enables bi-directional cross-filtering for interactive reports. Security: - Excel: Limited security features for data access and sharing. - Power BI: Robust security features. This includes Row-Level Security (RLS), to control data access based on user roles. Data Import Options: - Excel: Primarily uses single import mode. - Power BI: Offers multiple import options, including Import Mode and DirectQuery for real-time data connectivity. ? Use Excel for detailed data analysis, financial modeling, and ease of use. Power BI is superior for interactive visualizations, handling large datasets, and secure, collaborative reporting.
108
參考答案
In Tableau, measures can share a single axis so that all the marks are shown in a single pane. Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. We can blend multiple measures by simply dragging one measure or axis and dropping it onto an existing axis.
109
參考答案
Power BI supports: - Bar, Line, Pie Charts. - Tables & Matrices. - Maps & Scatter Plots. - Custom Visuals from the Marketplace.
110
參考答案
Power Query is available through getting & Transform in Excel 2016 or Power Pivot.
111
參考答案
Power BI Embedded is a feature that allows developers to embed Power BI visualizations and reports directly into their applications. This feature allows users to access Power BI reports and dashboards without leaving the application.
112
參考答案
A line chart is a chart that shows how a value changes over time, while an area chart is a chart that shows the composition of a category using an area. Line charts are typically used to show trends in data, while area charts are used to show the proportion of each category over time.
113
參考答案
Tableau does not have any security permissions or to protect the data in Tableau public. Whatever we shared in Tableau public those files, workbooks can be viewed by all users. There is no security option in Tableau public.
114
參考答案
First of all, download and install R to your system, then install a package known as Rserve using the command: install. packages (“Rserve”) and once installed you don't need to perform this step every time you are trying to use R from tableau. Whereas the next steps are required to be executed every time you want to connect R with tableau. Now use the command: library (Rserve) to import the library to current working environment and then type Rserve() in the command window to connect R with Tableau. Now switch to Tableau and under help menu and select “Manage R connection”, enter sever name as “Localhost” and a port of “6311”. Click on “Test Connection” button to make sure that everything is working fine and finally click on Ok to close.
115
參考答案
RLS (Row-Level Security) restricts data access. Types: Static and Dynamic. Implement by creating roles in Power BI Desktop and using DAX filters.
116
參考答案
Power BI Desktop helps you to group the data in your visuals into chunks. You can, however, define your groups and bins. For grouping, use Ctrl + click to select multiple elements in the visual. Right-click one of those elements and, from the menu that appears, choose Group. In the Groups window, you can create new groups or modify existing ones.
117
參考答案
Data Analysis Expression (DAX) is a library of formulas used for calculations and data analysis. This library comprises functions, constants, and operators to perform calculations and give results. DAX lets you use the data sets to their full potential and provide insightful reports. DAX is a functional language containing conditional statements, nested functions, value references, and much more. The formulas are either numeric (integers, decimals, etc.) or non-numeric (string, binary). A DAX formula always starts with an equal sign. A: Name of the project B: Start of the DAX formula C: DAX function (to add) D: Parentheses defining arguments E: Name of the table F: Name of the field G: Operator
118
參考答案
There are several ways to optimize Power BI report performance, including reducing the number of visuals on a page, using filters to limit the amount of data displayed, minimizing the use of calculated columns, and using incremental refresh to load only new or updated data.
119
參考答案
- Limited data export options: Power BI offers fewer formats for exporting reports. For specific export formats, you need to have a subscription. - Performance issues with large datasets: Power BI experience performance issues when working with large datasets. It impacts the efficiency of the data analysis process.
120
參考答案
Power BI offers a simple setup to connect, transform and visualize raw data from multiple sources. These data are further used to extract valuable information for business needs. Non-technical users can use Power BI tools to create dashboards and reports. Moreover, the secure cloud service of Power BI enables you to view the dashboard, report, and share them with the team and stakeholders. The AI feature of Power BI comes in the form of Power Query and Power Q&A. By easily giving voice commands, you can work with these features. Small businesses can use the Power BI desktop version to visualize their data without technical support.
121
參考答案
First, we'll create a calculated field and enter the following formula: SUM([Sales]) / SUM([Profit]) Next, drag the state field to the Rows shelf and the new calculation to the Columns shelf and over the Text label icon. Finally, sort the chart in ascending order. Your answer is the first state in the list.
122
參考答案
Use a subquery to compute the average revenue and then filter products where revenue > that average.
123
參考答案
Reduce visuals per page. Avoid complex DAX in visuals. Optimize filters and slicers.
124
參考答案
We can write dax query like: Avg Sales per Customer = DIVIDE( SUM(Sales[Amount]), DISTINCTCOUNT(Sales[CustomerID]) )
125
參考答案
It might be difficult to visualize covariance or correlation between numerous dimensions in Tableau since these metrics frequently use pairwise comparisons. To learn more about relationships, you can construct heatmaps and scatter plots. - Create a scatter plot matrix for pairwise comparisons. - Use a heatmap to represent relationships with color. - Calculate correlations using table calculations or custom formulas. - Add interactivity with parameters or filters.
126
參考答案
Beginners and experts both prefer Power BI, and the most preferred career options in this are: - Business analysts - Business owners or scientists - Business developers
127
參考答案
Filter: It thoroughly filters the visual/tile based on the filter selection of another variable. Highlight: Highlights only the related elements on the visual None: Ignores the filter selection from another tile/visual.
128
參考答案
Import mode loads data into Power BI's memory for fast performance. DirectQuery queries the source directly for real-time data but can be slower. Live Connection connects to an existing Analysis Services model for centralized governance.
129
參考答案
I try to reduce columns, limit visuals per page, and use star schema. I avoid complex DAX when possible. Aggregating data upstream helps a lot. Also, using import mode over DirectQuery improves speed.
130
參考答案
| Basis | Set | Bin | Group | |---|---|---|---| | Definition | Subset of data based on conditions or selection. | Divides continuous numerical data into intervals. | Combines multiple dimension members into one category. | | Nature | Dynamic (condition-based) or fixed (manual). | Fixed intervals or size defined by user. | Manual grouping and fixed unless edited. | | Purpose | Highlight, filter or compare specific data points. | Simplify continuous data for visualization like histograms. | Simplify and categorize categorical data for easier visualization. | | Data Type | Dimensions or measures. | Only measures (numerical data). | Only dimensions. | | Usage Example | Top 10 products by sales or customers in a region. | Age groups: 0–10, 11–20, 21–30, etc. | Combine "USA" and "Canada" as "North America". | | Calculation | Can be used in calculated fields for analysis. | Can be used in calculations after creating intervals. | Mainly for visualization and not directly used in calculations. |
131
參考答案
A calculated column in Power BI is a new column you create in your data model using DAX (Data Analysis Expressions) formulas. It performs calculations row by row and adds the results to an existing table. This feature is useful for adding new data fields based on existing data, enhancing your reports and analysis. ? A calculated column in Power BI uses DAX to add new fields to a table.
132
參考答案
AIR conducts enterprise-scale AI voice interviews and delivers structured scorecards to your ATS automatically.
133
參考答案
PowerBI service dashboard is a single-page canvas that uses visualizations to depict a story.
134
參考答案
Power BI is a data visualization tool developed by Microsoft. It enables users to establish connections with diverse data sources, transform and manipulate data, generate interactive reports and dashboards and share insights with others. Power BI is extensively used in organizations to analyze data and make informed decisions based on data-driven insights. BI stands for Business Intelligence which refers to collecting, analyzing and delivering business data to support decision-making in organizations This system uses a variety of tools, applications and practices to transform raw data and organise them into valuable insights. By doing so, companies can make informed decisions, spot trends and improve their overall performance. Power BI is a useful tool with many features. Some notable features include: - It enables users to visualize data and share that visualization with others. - Users are able to browse and examine data from all sources (in a unified view). - Users may scale across enterprises while benefiting from integrated governance and security. - Users can see an output once it has been generated on any device that supports the Power BI application. - Users can run queries on reports using basic English terms.
135
參考答案
Improve performance Improve readability Reduce complexity Simplify debugging
136
參考答案
The supported file extensions used in Tableau Desktop are: - Tableau Workbook (TWB): contains all worksheets, story points, dashboards, etc. - Tableau Data Source (TDS): contains connection information and metadata about your data source - Tableau Data Extract (TDE): contains data that has been extracted from other data sources. - Tableau Packaged Workbook (TWBX): contains a combination of the workbook, connection data, and metadata, and the data itself in the form of TDE. It can be zipped and shared. - Tableau Packaged Data Source (TDSX): contains a combination of different files. - Tableau Bookmark (TBM): to earmark a specific worksheet.
137
參考答案
The tool includes several different products, such as data analytics visualization with desktop and web versions, Tableau Server services, and Tableau Cloud services. These require a license and fees to use. However, you can also access free public and reader versions.
138
參考答案
Tableau categorizes data into seven different data types that you can use: Text or string values, Geographic values, Numerical values, Cluster group values, Date values, Boolean values, and Date and time values.
139
參考答案
Tableau is the most powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards.
140
參考答案
Parameters in Tableau allow you to set specific variables that can filter data and control how your data appears to viewers. You may create parameters based on a constant value or create more dynamic parameters using a list of variables that can change and adapt each time you modify data.
141
參考答案
I would facilitate a meeting with both departments to prioritize common metrics. If conflicts remain, I build a core dashboard with shared KPIs and add department-specific pages or bookmarks. Clear documentation of decisions helps avoid future issues.
142
參考答案
Continuous data roles consist of any value within the finite or infinite intervals. For Example – age, unit price, order quantity. Continuous values are displayed as green icons in the data window and green pills on shelves. Continuous fields cannot be sorted.
143
參考答案
Power query is a function that filters transforms, and combines the data extracted from various sources. It helps to import data from databases, files, etc and append data
144
參考答案
To ensure data accuracy, I always start by validating the data sources against known benchmarks. I use Tableau's data interpreter to clean any inconsistencies. I also collaborate with data analysts to conduct regular audits of the datasets. For example, at Infosys, I implemented a checklist for data validation that reduced errors in our dashboards by 30%. This focus on data integrity is crucial for making reliable business decisions.
145
參考答案
Data governance and compliance in Power BI involve ensuring data accuracy, consistency, and security. This includes: - Implementing data classification and labeling to identify sensitive data. - Defining and enforcing data access policies and permissions. - Monitoring and auditing data usage and report sharing. - Ensuring compliance with industry regulations and standards, such as GDPR and HIPAA.
146
參考答案
Filters help control what data is shown. You can filter at the visual, page, or report level. They help users focus on relevant insights without changing the actual data.
147
參考答案
| Basis | Worksheet | Dashboard | Story | Workbook | |---|---|---|---|---| | Definition | A single sheet for visualizing data (charts, graphs, tables). | A collection of multiple worksheets and objects in a single view. | A sequence of dashboards or worksheets arranged to tell a data story. | The file that contains all worksheets, dashboards, stories and data connections. | | Purpose | Analyze and visualize data in one view. | Combine multiple views for comprehensive analysis. | Present insights in a structured, narrative format. | Store and organize all Tableau content in one file. | | Components | Charts, tables, graphs, calculations. | Worksheets, images, filters and text objects. | Dashboards and worksheets arranged sequentially. | Worksheets, dashboards, stories, data connections and formatting. | | Use Case | Explore a single metric or dimension. | Monitor KPIs or multiple metrics together. | Explain trends, insights or findings to stakeholders. | Save, share and manage Tableau projects. |
148
參考答案
Simply click the down arrow in the auto-filter heading to remove "All" options from the auto-filter. You can scroll down to the dropdown menu labeled "Customize" and uncheck it.
149
參考答案
Read about it here --> https://lnkd.in/dG5QtAea
150
參考答案
A Group can be used to unite Fields into a new dimension. You can use groups to combine data from various dimension values, which appear as a new dimension field under Dimensions once they have been grouped. A dashboard's data quality can also be improved using a group. For example, suppose a visualization contains data values like the United States, USA, or the US. In that case, all of these values can be combined into a single Group to create a value like the USA.
151
參考答案
With the help of inner join, we can combine two tables where the resultant table is a combination of common records of both the tables.
152
參考答案
Misunderstanding filter context in Power BI can lead to significant issues in data analysis, primarily through the creation of measures and visualizations that produce inaccurate or misleading results. Common pitfalls include incorrect aggregation of data and discrepancies in visualizations due to conflicting filter contexts. Avoiding these pitfalls ensures the integrity and reliability of data analysis and reporting.
153
參考答案
A few familiar data sources are Excel, Power BI datasets, web, text, SQL server, and analysis services.
154
參考答案
PowerBI is a cloud based Business Intelligence tool to analyze and visualize raw data that can be fetched from a wide range of data sources. It consolidates business analytics with data visualization and helps any organization to make business decisions based on data.
155
參考答案
This happens when a user is trying to publish a workbook that is connected to an internal server or a file stored on a local drive, such as a SQL server that is within a company's network.
156
參考答案
Bookmarks capture the current state of a report page, including filters, slicers, and visuals, for storytelling and presentations.
157
參考答案
Tableau dashboard allows the representation of parameters in four ways only. They don't allow any multiple values like a filter can do. They only allow a single value.
158
參考答案
Get Data is a simple icon on Power BI used to import data from the source.
159
參考答案
Use INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) to return a value from a column to the left.
160
參考答案
Tableau is a leading visual analytics platform that turns raw data into interactive dashboards without requiring heavy coding. Companies choose it because analysts can connect to almost any data source, iterate visuals in minutes, and share results securely on Tableau Server. For instance, at my last job I replaced a weekly Excel report with a Tableau dashboard that auto-refreshed every hour, freeing four analyst hours per week and giving leadership real-time sales visibility. That blend of speed, clarity, and governance is why Tableau remains my preferred tool.
161
參考答案
Power BI Desktop is a free desktop application that can be installed right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and creating reports with highly interactive visualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others.
162
參考答案
No, it is not possible to convert a string type column into a number type column. When you do this, all the values would change to null.
163
參考答案
I decide between these modes based on three things: data volume, freshness requirements, and how much control I need over the model. Import mode loads data into Power BI's in-memory VertiPaq engine during refresh. Once imported, queries run against memory, which makes it the fastest option for report interaction. It supports the full DAX engine and all Power Query transformations. The trade-off is size and refresh dependency. The dataset must fit within capacity limits, 1 GB in Pro and much larger limits in Premium. Data is only as fresh as the last refresh. If the source changes every minute, Import won't reflect that until the next scheduled refresh. I choose Import when: - The dataset fits within memory limits. - Performance is critical. - Near real-time data isn't required. DirectQuery does not store data in Power BI. Every visual interaction sends a query to the source system in real time. That means the report always shows the latest data. The trade-off is performance and feature limitations. Query speed depends entirely on the source database. Complex visuals generate multiple queries. Some DAX functions are restricted, and heavy transformations are limited compared to Import mode. I use DirectQuery when: - The dataset is too large to import. - Real-time or near real-time access is required. - The source database is well-optimized and can handle frequent queries. Live Connection is similar in that Power BI does not store the data locally. However, instead of querying a relational database, it connects to an existing Analysis Services model or another published Power BI dataset. The semantic model lives elsewhere. The trade-off here is flexibility. I cannot modify the underlying model, add new tables, or perform Power Query transformations. I'm consuming a centrally managed model. The advantage is governance and reuse; multiple reports can rely on a single trusted dataset maintained by a central team. Since 2020, composite models have allowed combining Import and DirectQuery tables in the same model. For example, I might import dimension tables for fast filtering and keep a very large fact table in DirectQuery. I can also use dual storage mode for dimension tables so they behave as Import for some queries and DirectQuery for others. So my decision framework looks like this: - If performance matters most and data fits in memory -> Import. - If real-time access is required and the source can handle the load -> DirectQuery. - If the organization already maintains a governed semantic model -> Live Connection. - If I need both scale and speed -> Composite model with aggregation and dual storage strategy.
164
參考答案
Relationships between tables are defined in two ways: Manually – Relationships between tables are manually defined using primary and foreign keys. Automatic – When enabled, this automated feature of Power BI detects relationships between tables and creates them automatically.
165
參考答案
There are some limitations associated with context filters in Tableau. These are: - The context filter requires time when a data set contains a lot of data. - Working with context filters becomes challenging when the time-to-market is less. - Tableau's Context filter is not suitable for frequent change.
166
參考答案
Few advantages of using Power BI are : PowerBI can input a huge quantity of data Information can be visualized using powerful templates and visualizations Users get cutting edge intelligence technologies and powerful algorithms that are updated regularly User can have personalised dashboards which are easy to access and understand Users can perform queries on reports using DAX language
167
參考答案
Calculated fields are created using formulas based on other fields. These fields do not exist but are created by you. You can create these fields to: - Segment data - Convert the data type of a field, such as converting a string to a date. - Aggregate data - Filter results - Calculate ratios There are three main types of calculations that you can create: - Basic Calculations: Transform values of the data fields at the source level - Level of Detail (LOD) Expressions: Transform values of the data fields at the source level like basic calculations but with more granular access - Table Calculations: Transform values of the data fields only at the visualization level To create calculate fields: In Tableau, navigate to Analysis>Create a calculated field. Input details in the calculation editor. And, done!
168
參考答案
The order of operations, also called the query pipeline, is the order in which actions, or operations, are executed in Tableau. As you add filters to your dashboard, they will execute in the order determined by the order of operations. You'll notice that some operations can conflict with each other, leading to unexpected results. In the Superstore dataset, let's say we're interested in the top 10 customers by sales volume in New York City only. After applying the city and customer filters, we'll get a different list of top customers than what originally returned. That's because both filters are dimension filters so they get executed "at the same time." The idea is to set another filter level, in this case, the context filter, so the filters get applied in the correct order. To do that, right click on the City:New York City filter and select Add to Context. Your problem is now resolved.
169
參考答案
A table is a visual component that shows data in a tabular format, while a matrix is a visual component that shows data in a tabular format with subtotals and grand totals. Tables are typically used to show detailed data, while matrices are used to summarize data.
170
參考答案
Embedding any web page to the Tableau dashboard requires the following steps. - First, we have to go to our dashboard. - Under the 'Objects', we will look for the 'Webpage' option. - Double-click that option. - It will come up with a dialog box. - Paste or type your URL or website link in that dialog box. - We will see that the URL page is reflected in our dashboard.
171
參考答案
The IF function in Tableau is used to build calculated fields that test a given condition and return various values depending on whether it is true or false. This is a form of conditional logic. The IF function is valuable for introducing logic and control flow into your Tableau calculations, allowing you to tailor data processing and visualizations to your needs. To use the IF function in Tableau: - To use the IF function, go to the "Analysis" menu and select "Create calculated field". - Write the IF expression in the following format: IF condition THEN value_if_true ELSE value_if_false END - Use IF to apply conditional formatting such as changing the color of data points based on condition.
172
參考答案
The five fully automated steps cover from application to ranked, verified talent, with zero recruiter coordination required until you're ready to interview.
173
參考答案
Content Packs are pre-built datasets, reports, and dashboards shared within an organization.
174
參考答案
- .PBIX — Power BI Desktop files. - .PBIT — Power BI template files. - .CSV/.XLSX — Data import files. - .JSON — Custom data source files.
175
參考答案
FILTER, ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS.
176
參考答案
With Power BI, you have the option of producing custom visualizations, which are packages that feature code to help users visualize data. To create custom visuals, you need to use specific programming languages such as JQuery. JavaScript is another programming language that you can use to produce custom visuals.
177
參考答案
A heat map can be used for comparing categories with color and size. With heat maps, you can compare two different measures together. A tree map also does the same except it is considered a very powerful visualization as it can be used for illustrating hierarchical data and part-to-whole relationships.
178
參考答案
When users in Power BI click on the icon “Get Data”, a drop-down menu displays all data sources from which data can be ingested. Data can directly get ingests from sources such as Excel, XML, PDF, JSON, CSV, and SharePoint folder databases and formats such as SQL, SQL Server Analysis Services, IBM, Access, Oracle, MySQL, and much more.
179
參考答案
In Power BI Service, go to dataset settings and configure scheduled refresh under the 'Scheduled refresh' section.
180
參考答案
PowerBI has three versions currently: Microsoft PowerBI Free/ Desktop – It is for anybody who wants to see their business insights from the data with visualizations. Microsoft PowerBI Pro – It is the full version of PowerBI which enables unlimited viewing, reporting and sharing of reports which PowerBI Desktop doesn't support.
181
參考答案
Power BI is a business analytics tool by Microsoft that transforms data into interactive dashboards and reports, helping organizations make informed decisions.
182
參考答案
Drill-through filters allow users to drill down into more detailed data by clicking on a specific data point in a visualization. The filter context is passed to a second page or visualization that shows more detailed data related to the selected data point.
183
參考答案
If a Tableau dashboard isn't displaying data correctly, I would first check the data source connection to ensure it's live and properly configured. Next, I would review any filters applied to make sure they are set correctly. I'd also look into calculated fields for any errors and use the 'View Data' feature to verify data integrity. If the issue persists, I would consult Tableau's documentation or collaborate with a team member to find a solution, ensuring that I document my findings for future reference.
184
參考答案
Syntax This is how the formula is written—that is, the elements that comprise it. The Syntax includes functions such as SUM (used when you want to add figures). If the Syntax isn't correct, you'll get an error message. Functions These are formulas that use specific values (also known as arguments) in a particular order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.
185
參考答案
Dimensions are divided into 9 various categories
186
參考答案
Data modelling in Power BI is the process of structuring and organizing data so that it can be used effectively for analysis and reporting. It involves: - Creating tables (from data sources). - Defining calculated columns, measures and hierarchies. - Establishing relationships between tables. A key part of data modelling is creating relationships between two tables, which connect data using common fields like CustomerID or ProductID. These relationships can be: - One-to-Many (1:*): One record relates to multiple records like One Customer → Many Orders. - Many-to-Many (:); Multiple records relate to multiple records like Students ↔ Courses. - One-to-One (1:1): When each row in one table matches exactly one row in another like Employee → Employee ID.
187
參考答案
CALCULATE modifies the filter context of a measure. For example, CALCULATE(SUM(Sales[Amount]), Product[Category] = "Electronics") sums sales only for the Electronics category, overriding any existing filters.
188
參考答案
There are two destinations for output we get from power query: Load to a table in a worksheet. Load to the Excel Data Model.
189
參考答案
- Slicers: Visual tools used to filter data in reports. Slicers provide an interactive way for users to select specific values and refine the data displayed. - Filters: Applied to reports, pages, or visuals, filters control the data displayed by limiting the dataset based on specified criteria. Filters can be static or dynamic.
190
參考答案
I design reports assuming the user will not read documentation. The layout itself should guide them. First, I keep the structure consistent. Slicers stay in the same position across pages, usually at the top or left. Navigation buttons or page tabs follow a consistent pattern. I align colors with the company branding so the report feels familiar. I use progressive disclosure. The first page shows a high-level summary with key KPIs. Additional pages provide deeper analysis through drill-through or drill-down. I avoid overwhelming users with too much detail upfront. Every visual has a clear, descriptive title written in business language, not technical column names. Axis labels use familiar terms. I add data labels only where they add clarity. If a feature requires interaction, I guide the user. I may add a small text box explaining how to use slicers or drillthrough. I often include a "Reset Filters" button using bookmarks so users can quickly return to the default view. For mobile users, I configure the phone layout manually instead of relying on auto-generated layouts. That ensures KPIs stack logically and remain readable on smaller screens. Accessibility is a priority. I add alt text to all visuals for screen readers. I ensure sufficient color contrast and avoid conveying meaning through color alone. For example, I combine color with icons or labels. I also check tab order so keyboard navigation works properly. For major rollouts, I conduct short walkthrough sessions to explain how to use the dashboard. I also collect feedback through embedded forms or follow-up surveys to refine usability. Power BI supports features like alt text, keyboard navigation, and high-contrast mode. I make sure those are configured properly. My goal is simple: a non-technical user should understand what the dashboard shows and how to interact with it within a few minutes, without needing technical guidance.
191
參考答案
A slicer is a visual component that allows users to filter data based on a specific category, such as date, region, or product. A filter, on the other hand, is a data manipulation function that allows users to exclude or include certain data based on criteria defined by the user.
192
參考答案
In my experience, sets in Tableau are a powerful feature that allows you to create custom groups based on a specific condition or a range of values. I like to think of them as dynamic selections that can be used in calculations, filters, and visualizations. To create and use sets in Tableau, you can follow these steps: 1. First, right-click on the dimension you want to base your set on, and then choose "Create Set" from the context menu. 2. In the "Create Set" dialog box, you can define the set by selecting members or by using a condition. For example, you might create a set of top 10 customers by sales or a set of products with a specific category. 3. After creating the set, it will appear in the "Sets" section of the Data pane. You can then drag and drop the set onto your visualization or use it in calculations, filters, or other visual elements. 4. Sets can also be combined using operators like union, intersection, or difference to create more complex selections. For example, in my last role, I created a set of high-performing products by filtering on the profit margin. Then, I used this set in a visualization to compare the sales of high-performing products to other products, which helped the sales team focus on promoting the most profitable items.
193
參考答案
Tableau Prep is a data preparation tool used to clean, combine, and transform raw data before analysis in Tableau. It helps users prepare data through a visual and step-by-step workflow, making it easier to understand the data preparation process. Tableau Prep allows users to remove duplicates, handle missing values, change data types, split or merge fields, and join or union multiple datasets. By cleaning and preparing the data beforehand, it ensures that the data used in Tableau dashboards is accurate, consistent, and ready for analysis.
194
參考答案
A story is a sheet that contains a sequence of worksheets or dashboards that work together to convey information. You can create stories to show how facts are connected, provide context, demonstrate how decisions relate to outcomes, or simply make a compelling case. Each individual sheet in a story is called a story point.
195
參考答案
Calculated Columns are DAX expressions that are computed during the model's processing/refresh process for each row of the given column and can be used like any other column in the model.
196
參考答案
Yes. There are two main reasons why you can have disconnected tables: The table is used to present the user with parameter values to be exposed and selected in slicers. It uses the table as a placeholder for metrics in the user interface
197
參考答案
I use the Azure Data Lake Storage Gen2 connector in Power BI. I select the container and folder, then load or transform data. For large datasets, I use DirectQuery or incremental refresh.
198
參考答案
A few months back, I was working on a project where I had to create a complex dashboard incorporating multiple data sources. At one point, I realized that I needed to create a specific calculated field to reflect the right output, but I was unsure about the correct formula. To solve this issue, I first tried googling possible solutions and referring to Tableau's official documentation, but I was still stuck. Realizing that I needed more help, I decided to reach out to my colleagues who had faced a similar situation in the past. One of them pointed me in the right direction and suggested a new approach. I then combined their advice with some additional research to come up with a solution that fit the project's requirements perfectly. This experience taught me the importance of collaboration and utilizing available resources to overcome challenges in Tableau. It also motivated me to dive deeper into learning about calculated fields, ensuring I am better prepared for similar situations in the future.
199
參考答案
Data blending is an advanced joining of two different data sources. For example, one data source contains annual sales of a product in different countries and second data source contains countries and their monthly profit and loss values. A simple join won't work in this case because of different levels of segregation. First step will be to aggregate the values in second data source based on year and then perform a join. All these steps can be completed with great ease in tableau. Because tableau can identify the common field of country and year between two data sources and perform a post aggregate join by itself.
200
參考答案
A data transformation tool in Power BI that allows importing, cleaning, and reshaping data before analysis.


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.