1

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

7

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

- 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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

B) Power Query

32

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

39

Respuesta de referencia

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

40

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

47

Respuesta de referencia

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

48

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

63

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

71

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

77

Respuesta de referencia

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

78

Respuesta de referencia

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

79

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

82

Respuesta de referencia

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

Respuesta de referencia

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

84

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

88

Respuesta de referencia

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

Respuesta de referencia

- 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

Respuesta de referencia

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

91

Respuesta de referencia

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

Respuesta de referencia

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

93

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

96

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

| 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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

Streaming datasets Hybrid Datasets

108

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

Join Queries are used to consolidate inquiries in Power BI.

112

Respuesta de referencia

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

Respuesta de referencia

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

114

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

122

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

● 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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

136

Respuesta de referencia

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

137

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

141

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

All File Database Power BI Azure Online Services Other

145

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

149

Respuesta de referencia

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

150

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

159

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

No

171

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

181

Respuesta de referencia

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

Respuesta de referencia

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

183

Respuesta de referencia

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

184

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

Respuesta de referencia

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

¿NO QUIERES PERDERTE NADA?

¡Pase 100% la prueba de práctica de Cisco, PMP, CISA, CISM, AWS en OFERTA!
Obtener ahora

Obtenga una certificación para destacar su currículum.

¿NO QUIERES PERDERTE NADA?

¡Pase 100% la prueba de práctica de Cisco, PMP, CISA, CISM, AWS en OFERTA! Obtener ahora

Obtenga una certificación para destacar su currículum.

¡Pase 100% la prueba de práctica de Cisco, PMP, CISA, CISM, AWS en OFERTA!
Obtener ahora