Complete list of questions View answer Hide answer Power BI is mainly used by: View answer Hide answer Power BI provides variety of option to filter report, data and visualization. The following are the list of Filter types.
We know that Power BI visual have interactions feature, which makes filtering a report a breeze. Visual interactions are useful, but they come with some limitations:
View answer Hide answer Three important power BI tool are:
View answer Hide answer You can take the data and create robust reporting very easily. This assists in attracting new clients toward servicing and monitoring the customers already present. It also becomes possible to track information and set goals. Therefore, completely building an extraction, transformation and loading solution ultimately assists the management so they are able to make better decisions in the process. The return on investment when it comes to Power BI is also very high. Lastly, it makes some of the unwanted data into information, which can be utilized progressively. View answer Hide answer
View answer Hide answer Power BI Desktop is a free desktop application that can be installed right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and creating report with highly interactive visualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others. View answer Hide answer Here, are the main drawbacks of Power BI:
View answer Hide answer These are pre-built solutions build for popular services as a major part of the Power BI experience. View answer Hide answer Selection Pane helps you to take control over visuals which require to be displayed and which should not be displayed. It allows you to combine multiple visual pages in the group and is also used in bookmarking. View answer Hide answer Power BI is a cloud-based data sharing environment. Once you have developed reports using Power Query, Power Pivot and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which technically is an aspect of SharePoint online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers. Not only that, but your colleagues can interact with your reports to apply filters and slicers to highlight data. They are completed by Power BI, a simple way of sharing your analysis and insights from the Microsoft cloud. Power BI features allow you to:
View answer Hide answer There are three different views in Power BI, each of which serves a different purpose. Report View: Users can add visualizations and additional report pages and publish the same on the portal from here. Data View: Data shaping can be performed through Query Editor tools. Relationship View: Users can manage relationships between datasets in this view. View answer Hide answer Here are four primary reasons for using Power BI tool:
View answer Hide answer
View answer Hide answer The list of data sources for Power BI is extensive, but it can be grouped into the following:
View answer Hide answer When data is ingested into Power BI, it is basically stored in Fact and Dimension tables. Fact tables: The central table in a star schema of a data warehouse, a fact table stores quantitative information for analysis and is not normalized in most cases. Dimension tables: It is just another table in the star schema that is used to store attributes and dimensions that describe objects stored in a fact table. View answer Hide answer PowerBI embedded is an Azure-based cloud Service which enabled Web developers to create and integrate PowerBI reports. Users/Developers can create their reports using PowerBI desktop, without the need to write any code. Then, the PowerBI desktop report can be published to a PowerBI embedded workspace and consumed by end users View answer Hide answer It allows you to drill through the page, bookmarks, and selection pane. It allows you to create various tiles like web content, images, textbox, and integrate URLs. Allows you to set report layout to mobile view. View answer Hide answer Bookmark in Power BI helps you to capture the configured view of a report page in a specific time. This includes filter and state of visual which can use a short cut to come back to the report that you can add as a bookmark. View answer Hide answer Business intelligence is a technology-driven method. It helps you to analyze data and to provide actionable information which helps corporate executives, business managers, and other users to take decisive business decisions. View answer Hide answer Microsoft has two parts for Self-Service BI:
View answer Hide answer When users click on the Get Data icon in Power BI, a drop-down menu appears and it shows all data sources from which data can be ingested. Data can actually be directly ingested from any source including files in Excel, CSV, XML, JSON, PDF, and SharePoint formats and databases such as SQL, Access, SQL Server Analysis Services, Oracle, IBM, MySQL, and much more. Also, Power BI datasets and Power BI data flows are compatible. Data can also be taken in from Azure and other online sources. View answer Hide answer The following data sources that support DirectQuery in Power BI are as follows:
View answer Hide answer The following are the Building Blocks (or) key components of Power BI:
View answer Hide answer This function gives a difference between 2 dates based on the specified Date part. View answer Hide answer Data types of Dax are:
View answer Hide answer It returns date function as an integer. However, DATENAME function does the same thing, except it returns the name of the part of the date. View answer Hide answer Count function returns to count, excluding NULL values whereas Countd returns distinct values which exclude NULL values. View answer Hide answer This function returns the logical answers TRUE if the sub-string is the starting string for the superstring. If it is not, it will return false. View answer Hide answer INDEX function helps you to retrieve the index of the respective row. View answer Hide answer It is a formula expression language called (DAX) that can be used with various visualization tools like Power BI. It is also known as a functional language, where the full code is kept inside a function. View answer Hide answer DATEDD function helps you to convert any input to a date format. This input can number, string, or a data type input. View answer Hide answer LTRIM function helps you to remove the white space from the LEFT of the string. RTRIM helps you to remove it from the right the last index. View answer Hide answer SUMMARIZE()
SUMMARIZECOLUMNS
View answer Hide answer We can implement through the following DAX USERNAME(), USERPRICIPALNAME() View answer Hide answer It is a calculating expression of DAX which allows calculation on data stored in a new column. View answer Hide answer To do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX). It is formula language used to compute calculated column and calculated field.
Sample DAX formula syntax: For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount] column in the Sales table. View answer Hide answer If you want to calculate numeric values, then use MAX. However, if it is for non numeric values, then you should use MAXA. View answer Hide answer These are the only functions that allow you modify filter context of measures or tables.
Limitations:
View answer Hide answer Both SUM and SUMX are Aggreagate Functions where: SUM works on a Single Column vs SUMX can take the Table as Input SUMX has row-context where as SUM doesn’t have SUMX is an iterative Function where as SUM is not. View answer Hide answer CORR is a correlation function. It gives a correlation between two variables. It mostly ranges from -1 to 1. View answer Hide answer Below are the most important BI add-in to Excel:
View answer Hide answer The FILTER function returns a table with a filter condition applied for each of its source table rows. The FILTER function is rarely used in isolation, it’s generally used as a parameter to other functions such as CALCULATE.
View answer Hide answer STARTSWITH function returns the logical answers in a way, TRUE if the sub-string is the starting string for super-string. FALSE if not so. View answer Hide answer PERCENTILE function allows you to returns the data value of the specific percentile number. View answer Hide answer The main difference between the two is that: COVAR directly gives the same co-variance, whereas COVARP is the population covariance. View answer Hide answer Dynamic Top N will be achieved with RANKX Function and What-if Parameter. View answer Hide answer The only difference between two functions is that with District help you to calculate the null values. View answer Hide answer The main prerequisite is you need a date table, more specifically, a continuous date table with a whole range of dates (no breaks in the dates). That way you can calculate over that continuous line. You can build that date table using the M language in the Power Query Editor, use DAX or if you already have one in your model or data source you can bring it into Power BI. The second element you need is to define the relationship with the date table and the other appropriate tables. Remember all dates should be present without exception and you need a proper relationship for time intelligence to function the way you intend it to. View answer Hide answer VAR is the variance formula for population(n). VARP is the function of variance for sample(n-1). View answer Hide answer Sign function returns the direction of the values. If it returns 1, if positive then 1, if 0 then 0. View answer Hide answer If the value is not NULL iFNULL function result is the first expression, if it is not, then it will return the second expression. View answer Hide answer Below are some of the most commonly used DAX function:
View answer Hide answer RUNNING_AVG function gives the average value to all the cells/pane/region processed for. It works to give the average by making all those inclusive values accordingly. View answer Hide answer DATENAME function shows the name of the specific part of the date that is given. View answer Hide answer Calculated Columns
Calculated Tables
Measures
View answer Hide answer We need to use Append Queries option in Power Query Editor. If you want to append the 2 tables in Power BI Desktop we need to use DAX Function UNION by creating a new table by clicking New Table. View answer Hide answer ENDSWITH function helps you to return the logical result to the given string. In case If the sub-string is available at the end of the sub string, then it returns TRUE. View answer Hide answer The solution will involve:
Alternatively, CONTAINS may be used:
View answer Hide answer The Gather function in Power BI collects and transforms data. As with the case of Query Editor, the data is gathered using the Gather function from multiple sources and stored in a single location. This facilitates smooth and prompt data analysis. Following the collection, the data is transformed, which necessarily entails the removal of errors and any inconsistency. The end product of this process is clean data, which is aligned with the rest of the data stores in Power BI. View answer Hide answer MID function returns the string character from the specified index position. View answer Hide answer Below are some of the benefits:
View answer Hide answer The main prerequisite is you need a date table, more specifically, a continuous date table with a whole range of dates (no breaks in the dates). That way you can calculate over that continuous line. You can build that date table using the M language in the Power Query Editor, use DAX or if you already have one in your model or data source you can bring it into Power BI. The second element you need is to define the relationship with the date table and the other appropriate tables. Remember all dates should be present without exception and you need a proper relationship for time intelligence to function the way you intend it to. View answer Hide answer We can use DAX Formulas to find MTD, YTD and WTD as given below: View answer Hide answer Collect function excludes null value. It does aggregate spatial values. You can't transform data to another format. View answer Hide answer Here, are benefits of using DAX function:
View answer Hide answer Both are used to do the same function of calculating values; the only difference is DISTINCT () can calculate null values as well. View answer Hide answer Filters are applicable in:
View answer Hide answer It is a model that is made up of data types, tables, columns, and table relations. These data tables are typically constructed for holding data for a business entity. View answer Hide answer Power Pivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook. It lets you create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts. You can then further analyze the data so that you can make timely business decisions without requiring IT assistance. View answer Hide answer No, we cannot have more than one active relationship between two tables. However, can have more than one relationship between two tables but there will be only one active relationship and many inactive relationship. The dotted lines are inactive and continuous line are active. View answer Hide answer The main engine behind power pivot is the xVelocity in-memory analytics engine. It can handle large amount of data because it stores data in columnar databases, and in memory analytics which results in faster processing of data as it loads all data to RAM memory. View answer Hide answer Here are some of the differences:
View answer Hide answer Query folding is when steps defined in Power Query/Query Editor are translated into SQL and executed by the source database rather than the client machine. It’s important for processing performance and scalability, given limited resources on the client machine. View answer Hide answer Query parameters can be used to provide users of a local Power BI Desktop report with a prompt, to specify the values they’re interested in.
Parameters and templates can make it possible to share/email smaller template files and limit the amount of data loaded into the local PBIX files, improving processing time and experience . View answer Hide answer Changing Data Types, Filtering Rows, Choosing/Removing Columns, Grouping, Splitting a column into multiple columns, Adding new Columns ,etc. View answer Hide answer Power Query is a self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in. It allows users to pull data from various sources, manipulate said data into a form that suits their needs and load it into Excel. It is most optimum to use Power Query over Power Pivot as it lets you not only load the data but also manipulate it as per the users needs while loading. View answer Hide answer There are two destinations for output we get from power query:
View answer Hide answer Power query is a ETL Tool used to shape, clean and transform data using intuitive interfaces without having to use coding. It helps the user to:
View answer Hide answer 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. View answer Hide answer Yes, a SQL statement can be defined as the source of a Power Query/M function for additional processing/logic. This would be a good practice to ensure that an efficient database query is passed to the source and avoid unnecessary processing and complexity by the client machine and M function. View answer Hide answer For a data to be consumed in power map there should be location data like:
The primary requirement for the table is that it contains unique rows. It must also contain location data, which can be in the form of a Latitude/Longitude pair, although this is not a requirement. You can use address fields instead, such as Street, City, Country/Region, Zip Code/Postal Code, and State/Province, which can be geolocated by Bing. View answer Hide answer Power Map is an Excel add-in that provides you with a powerful set of tools to help you visualize and gain insight into large sets of data that have a geo-coded component. It can help you produce 3D visualizations by plotting upto a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time stamped, it can also produce interactive views that display, how the data changes over space and time. View answer Hide answer The data can either be available in Excel or it can be available remotely. For simplicity of setting up your data make sure the majority of your data is inside an Excel table where each of the columns is setup to a unique record. The segment headings or the column headings ought to have a message as opposed to genuine data with the objective that Power Map is there to decipher it in an accurate manner especially when it plots the geographic directions. The utilization of some of the important names makes the classification fields accessible in the Power Map Tour Editor Sheet. In order to utilize table structures, both time and geology within the Power Map have to incorporate the better part of the data within the table lines. In order to do this you might have to: • You wish to stack the data from an outside source. • In Excel click on the menu data > the association you need within the Get external data gathering. • Take the means or results within the wizard that begins. • On the last advance of the wizard, make certain Add this data to the Data Model is checked. View answer Hide answer Top N is not accessible for page-level filter and report level filter as they both are associated with different visuals. View answer Hide answer The 3 edit interaction options are Filter, Highlight, and None. Filter: It completely filter a visual/tile based on the filter selection of another visual/tile. Highlight: It highlight only the related elements on the visual/tile, gray out the non-related items. None: It ignore the filter selection from another tile/visual. View answer Hide answer With a data model local to the PBIX file (or Power Pivot workbook), the author has full control over the queries, the modeling/relationships, the metadata and the metrics. With a live connection to an Analysis Services database (cube) the user cannot create new metrics, import new data, change the formatting of the metrics, etc – the user can only use the visualization, analytics, and formatting available on the report canvas. With a direct query model in Power BI to SQL Server, for example, the author has access to the same features (and limitations) available to SSAS Direct Query mode.
View answer Hide answer Many to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred.
View answer Hide answer A DAX look can be valuable on a table sifting its lines at question time. Dynamic security include the utilization of USERNAME works in security job definition. Typically a table is made in the model that relates clients to explicit measurements and a job. View answer Hide answer We have Six types of Joins in Power BI which we use it in Power Query Editor: Inner Join Left Outer Join Right Outer Join Full Outer Join Left Anti Right Anti Inner Join: If we want only the matching records from both the tables then will use Inner join/Simple join Left Outer Join: If we want all the records from left table and only matching records from right table then will use left Outer join/left join. Right Outer Join: If we want to display all the records from right table and only matching records from left table then will Right Outer join/Right Join. Full Outer Join: If we want display all the records from both the tables then will use Full Outer Join Left Anti: Displays only the mismatched records from Left Table Right Anti: Displays only the mismatched records from the Right Table. View answer Hide answer Step 1: Click on Get Data in Power BI Desktop Step 2: Select SQL Server from the list Step 3: Fill the Details of the Server and Database Step 4: Click on Import or Direct Query based on the Requirement. View answer Hide answer A substance pack is an instant, predefined gathering of representations and reports utilizing your picked administration (for instance, Sales power). You’d utilize one when you need to get fully operational rapidly, rather than making a report without any preparation. View answer Hide answer By formatting data, users can help Power BI categorize and identify data, making it much easier to work with. Enter a custom formula to create a new column, including calculations using values from the other columns To create a new column, click on Add Custom Column In the new column name box, type the name of the column and add the formula to the custom column formula box; for example, [ShipDate] – [OrderDate] Select a column from the available columns list and click on Insert or double-click to add it to the custom column formula text box. Then, click on OK The new column is appended to the table, and the formula is visible in the Formula Bar Custom Column Formula: = Table.AddColumn(#"Sorted Rows", "DaysOrderToShip", each [ShipDate] - [OrderDate]) The above code is the formula to create a custom column, which calculates the days from when an order was placed to when it got shipped. View answer Hide answer Steps to go to Data Stories Gallery:
View answer Hide answer Yes, it makes a difference. When we click on a single data-point, the data gets selected and copied to the dashboard. The copied data can be pasted then anywhere according to the requirement of the users. View answer Hide answer You need to use Gauge chart to compare two different measure. View answer Hide answer No, it is not possible to access Power BI services on private or internal service cloud. However, by using Power BI desktop, you can connect with the on-premises data sources. View answer Hide answer You can use Power BI publisher for Excel to pin ranges, pivot tables and charts to Power BI.
The Publisher installs all necessary drivers on local machine to establish connectivity . View answer Hide answer Computing segments should be made with a DAX articulation. View answer Hide answer Power BI DAX content style is both Row and Filter. View answer Hide answer To download large extracts of data, we can host the excel file to a share point, which will generate a .xlsx link, which can be embedded to “Text” or “Button”. On clicking on the Text link or Button. The excel file gets downloaded directly which is hosted in share point or some other base location. View answer Hide answer There are mainly 2 reasons why we would have tables without relations in our model:
View answer Hide answer Power BI online contains an option for publishing on web that will generate a link address for the Power BI report. You can share these links to others, which is called embed code. View answer Hide answer We have to go to selection Pane in the menu bar and hide/unhide the report and the action can be passed to book mark. View answer Hide answer Power BI can apply Row Level Security roles to models.
View answer Hide answer Hybrid datasets and Streaming datasets can be used with streaming data tiles to create dashboards. View answer Hide answer The process of converting the steps in power query editor to SQL and executing it by the source database is called query collapsing. View answer Hide answer First upload a dataset and then upload the same, create multiple reports and infuse everything together as an appealing dashboard. View answer Hide answer In Power BI, you can store mainly two types of data. Fact Tables: The central table in a star schema of a data warehouse is a fact table that stores quantitative information for analysis, which is not normalized in most cases. Dimension Tables: It is a table in the star schema which helps you to store attributes and dimensions which describe objects that are stored in a fact table. View answer Hide answer Tile is an important feature of power BI services and can be said as a picture of the data which can be pinned to the dashboard. View answer Hide answer You can use Crossfiltering option in Power BI to address the Many to Many relationships. View answer Hide answer To hide and unhide specific report, you have to go to selection Pane in the menu bar, and press hides/unhide toggle button to bookmark. View answer Hide answer Import Mode Direct Query Mode View answer Hide answer Step 1. Create a hierarchy by grouping the required data from the data tab and pull that into Axis Tab and Enable drill down option by clicking on down arrow on the chart. Step 2. Pull all the hierarchical columns separately in to the axis pane in the order of their hierarchy and enable the drill down action by clicking on down arrow on the chart. Note: Both Step 1 and Step 2 will serve the same purpose. View answer Hide answer
View answer Hide answer Joins will be performed in Model Tab in Power BI Desktop. View answer Hide answer PowerBI currently supports different types of streaming datasets. You can directly stream data using a push URL to PowerBI.com service. PowerBI also supports streaming data sources from PubNub, which is an Infrastructure as a Service provider. The third option is to Azure Stream Analytics which is built on top of Azure Service Bus and Event Hub. You can select the streaming data to go-to PowerBI as your destination. Here is a sample report with streaming data. View answer Hide answer No, the gateway connects to its data source by using the provided connection information. In this sense, think of the gateway as a client application. It just needs to connect to the server that has the provided name. View answer Hide answer Power BI: It provides different features for the users to get started with data search in a unique way. Power BI Pro: It holds some extra features added to the Power BI features like higher storage capacity, data refresh scheduling and interactive live data sources. View answer Hide answer Graphs or visual which are not included in Power BI desktop are imported for better visualization. View answer Hide answer It is a programming language used in Power Query. It's a functional, case-sensitive language which is similar to other programming languages and easy to use. View answer Hide answer There are four main types of refresh in Power BI. Package refresh, model or data refresh, tile refresh and visual container refresh. This synchronizes your Power BI Desktop, or Excel, file between the Power BI service and OneDrive, or SharePoint Online. However, this does not pull data from the original data source. The dataset in Power BI will only be updated with what is in the file within OneDrive, or SharePoint Online. It referrs to refreshing the dataset, within the Power BI service, with data from the original data source. This is done by either using scheduled refresh, or refresh now. This requires a gateway for on-premises data sources. Tile refresh updates the cache for tile visuals, on the dashboard, once data changes. This happens about every fifteen minutes. You can also force a tile refresh by selecting the ellipsis (…) in the upper right of a dashboard and selecting Refresh dashboard tiles. Refreshing the visual container updates the cached report visuals, within a report, once the data changes. To know more about data refresh and understand how to implement data refresh, you can check the following link. View answer Hide answer Advanced Editor can be used to see the query that Power BI runs against data sources to import data. The query is written in M-code, the Power Query Formula Language To view the query code from Power BI Desktop, choose Edit Queries from the Home tab From either the Home or the View tab, click on Advanced Editor to work on the query. The Advanced Editor window opens, displaying the code for the currently selected query When we make transformations to our data in Query Editor, the steps are saved to the Applied Steps in the Query Settings These steps are also applied to the code in the Advanced Editor View answer Hide answer Dynamic Filtering in Power BI is done using the following steps: Once all the data are set up, publish a detail report to Power BI. Publish it to group workspace. Create a filter link Create a DAX calculated column. Public overview report View answer Hide answer When you click on single information point data gets select and copied to the clipboard. Moreover, the copied data can be pasted in any place according to your requirement. View answer Hide answer It is a stand alone application where we can make Power BI reports and then upload it to Powerbi.com, it does not require Excel. Actually, it is a combination of Power Query, Power Pivot, and Power View. View answer Hide answer Power Map can display visualizations which are geographical in nature. That's why some kind of location data is needed, for example, city, state, country or latitude and longitude. View answer Hide answer Yes, we can join two unique information source in the same Power Bi dashboard. We can also merge comparable reports in your Power Bi account into using single dashboard. View answer Hide answer Package Refresh Model/data Refresh Tile Refresh Visual Container Refresh View answer Hide answer Bidirectional cross-filtering in Power BI Desktop allows data modelers to determine how they want filters to flow for data using relationships between tables. With bidirectional cross-filtering, the filter context is propagated to a second related table on the other side of a table relationship. This can help data modelers solve the many-to-many problem without writing complicated DAX formulas. Thus, bidirectional cross-filtering simplifies the job for data modelers. View answer Hide answer You need to follow the below-given steps:
View answer Hide answer Toggling Action can be achieved in Power BI reports, when in case there are two are more dimensions. This can be showcased using an “Enlighten Slicer” in Power BI which can be imported form Market Place. View answer Hide answer Power BI Q&A is a natural language tool which helps in querying your data and get the results you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your questions and shows you a restated query of what it is looking from your data. Q&A was developed by Server and Tools, Microsoft Research and the Bing teams to give you a complete feeling of truly exploring your data. View answer Hide answer The following are the steps of dynamic filtering: Set all the data of a report ready to be published Publish it into group workspace Create a filter link Create a DAX calculated column Public overview report View answer Hide answer We recommend that you have the gateway as close to the data source as possible to avoid network latency. If you install the gateway on the actual data source, the introduced latency is minimized. View answer Hide answer Two types of connectivity modes used in Power BI are: View answer Hide answer On a report page, you can easily resize a responsive slicer to various sizes and shapes, and the data contained in it should be rearranged according to it. In case if the visual becomes too small to be useful, an icon representing the visual ability to take its place, thus saving the space on the report page. View answer Hide answer You can access Power BI for free. However, if you wish to use all the feature of Power BI, then you can use its pro subscription account. The subscription account offers an enhanced version of several features that are available with Power Bi free account. View answer Hide answer Power BI Desktop allows you to group the data into small chunks. For grouping, you should use Ctrl + click to select multiple elements in the visual. Right-click one of those elements which appear in groups window. View answer Hide answer Gateway acts a bridge between on-premises data sources and Azure cloud services. Personal Gateway:
On-Premises Gateway:
View answer Hide answer The only prerequisite for before connecting to a database is that the user need to configure firewall setting to allows remote connections. View answer Hide answer To attain this need to create Content Pack, Need to select Specific Group of people (User Email ids or Distribution lists) (OR) My Entire Organization in then we choose give access to Dashboards or Reports or Datasets. View answer Hide answer Increment refresh is a newly added data so that there is no need to truncate or load the entire data. View answer Hide answer It is a model that contains data writes, tables, sections, and table relations. These data tables help you to develop for holding data for a business substance. View answer Hide answer Dataset: The source used to create reports and visuals/tiles.
Report: An individual Power BI Desktop file (PBIX) containing one or more report pages.
Dashboard: a collection of visuals or tiles from different reports and, optionally, a pinned.
View answer Hide answer ToP N is not accessible for the Page and Report Level Filters because their channels are associated with different visuals. View answer Hide answer No, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services, and other data sources. You can also scheduled refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway – Personal. View answer Hide answer Microsoft has categories Power BI users as below: Consumers (also called as End-Users) of Power BI who gets insights of the data in the form of reports and used for decision making. Designers who Collect, Wangle, Explore, Transform, Model, and Evaluate Data and then design reports, publish reports to Power BI Web Service and create dashboards. Administrators who are responsible for User governance using Office 365 (like Provisioning of Power BI Access to workspaces Licenses) and Administering User Security (like assigning Power BI admin roles and assigning Premium capacity roles) Developers who helps Power BI consumers and designers to build integrating / embedding custom visuals in Power BI Reports and building streaming datasets. View answer Hide answer Join Queries are used as a consolidate inquiries in Power BI View answer Hide answer On-premise gateway acts as a bridge which helps you to transfer the data, which is on-premise (not on the cloud) safely and securely. View answer Hide answer The natural language search choice is language-based learning for communicating with information as a part of Power BI suite for Office 365 advertising. View answer Hide answer Raw Filter works only on Column where FILTER Function on Measure. View answer Hide answer Below are some of the ways through which we can leverage Power BI:
View answer Hide answer The way to identify the user is to create a DAX column and embed “username ()” or “principalusername ()”, which will retrieve information on the user has logged in. View answer Hide answer Alert works on data that is refreshed, Power BI looks for an alert, and it reaches the alert threshold or the limit then the alter will be triggered. View answer Hide answer Highlight the Visual and go to edit interactions and Click on None on the remaining visuals. View answer Hide answer Power View is a data visualization technology that lets you create interactive charts, graphs, maps, and other visuals which bring your data to life. Power View is available in Excel, SharePoint, SQL Server, and Power BI. The following pages provide details about different visualizations available in Power View:
View answer Hide answer Unpivot line is a choice to unpivot any data in the question proofreader. View answer Hide answer The following are the differences between Power BI and Tableau: Power BI focusses only on modeling and reporting, while Tableau is the best tool according to data visualization. Power BI is less expensive, while Tableau is very expensive. Power BI is associated with Microsoft Azure, while Tableau uses python Machine learning. Power BI has a simple and easy to use interface while Tableau has a customized dashboard. Power BI becomes slow while handling massive amounts of data, while Tableau easily handles any amount of data. View answer Hide answer Calculated Columns are DAX expressions that are computed during the model’s processing/refresh process for each row of the given column and can be used like any other column in the model. Calculated columns are not compressed and thus consume more memory and result in reduced query performance. They can also reduce processing/refresh performance if applied on large fact tables and can make a model more difficult to maintain/support giventhat the calculated column is not present in the source system. View answer Hide answer Power Bi provides you to very cool features of visual Interaction, by default this feature is enable, that’s means when you select any slicer value or click any visual by default all visuals get filtered on the basis of click or select value. And we can control this feature to using Edit Interactions. View answer Hide answer It is a parameter to filter the data into machines. View answer Hide answer No, we can't create more that one multiple dynamic connections. View answer Hide answer Data Editing helps you to change and reshape data in Power BI. View answer Hide answer Yes we can refresh our reports through Data Management gateway(for sharepoint), and Power BI Personal gateway(for Powerbi.com) View answer Hide answer If you are using the normal filter user cannot interact with the dashboard. On the other hand, slicer allows users to have an interaction with Reports as well as Dashboards. View answer Hide answer The latest version has more robust features, and it is famous with the name Power BI Desktop. This is an all in one solution for Power View, Power Pivot, and Power Query in the backend. Power BI offers many add-ins for Excel, which is useful for better visualizations. View answer Hide answer Incremental refresh feature mainly used for high-end scalability of data by publishing only on that workspace in Power BI Service where Premium capacity is needed. View answer Hide answer Z-order is a design strategy which is used for arranging visual over shapes. It can be defined as an implementation method which can be applied whenever reports have multiple elements. View answer Hide answer It is the main engine which is used in power pivot. It allows you to load the large set of data into Power BI data. View answer Hide answer Ready work on information that is revived ,when information is invigorated BI searches for a caution and on the off chance that it achieves the ready edge or the utmost, at that point the alarm will be activated. View answer Hide answer There are four main types of invigorating steps when it comes to Power BI. Bundle invigorate can model or revive your data. • Visual compartment - This type of invigorating is a visual compartment refresh stored in a report type within a report once the data starts to change. In order to find out if the data invigorate worked and view how to actualize the data, you can check on the accompanying connections. • Tile Invigorate - Tile invigorate refreshes the stores for the tile visuals on the dashboard once the data begins to change. This happens at regular type intervals. You may also constrain a tile for invigorating through the option of the ellipsis (which is three dots like this ...)on the upper right of the dashboard and choosing Refresh Dashboard Tiles. • Bundle Invigorate – This would then synchronize the Power BI Desktop or Excel document between the Power BI benefit and OneDrive, or SharePoint Online. This does not pull the data from the first data source though. When the data comes to Power BI it can refresh it once it is inside the OneDrive record. • Display/data revive – This refers to the type of revising to the dataset inside the Power BI benefit with data from the initial data source. This would either be finished by utilizing booked revive or invigorate now. That usually requires an entry point for the for the on-premises data sources, in the form of access tokens or login credentials. View answer Hide answer Power BI:
SQL Server Reporting Services:
View answer Hide answer No, we can't set multiple active relationships in Power BI. View answer Hide answer Below are some of the way through which SSRS can be integrated with Power BI:
View answer Hide answer A) Enable column titles B) Move titles above data C) Use first row as headers D) Promote top row Answer: C View answer Hide answer A) Gateway B) Power BI Desktop C) Apps D) Refresh service Answer: A View answer Hide answer A) Slicer B) IF(OR((([HireDate]-[TermDate])) >= 61,ISBLANK([TermDate])),0,1) C) IF(((([HireDate]-[TermDate])*-1) < 61),1,0) D) IF((([TermDate]-[HireDate])*-1) >= 61,0,1) Answer: A View answer Hide answer A) Previous Month = Sales[Today Month]-1 B) Previous Month = PREVIOUSMONTH(Sales[Today Month]) C) Previous Month = STARTOFMONTH(Sales[Today Month])-1 D) Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) Answer: D View answer Hide answer A) Power BI Service dashboard B) Power Bi Desktop Dashboard C) Power Bi Desktop Sheet D) Power BI Service Multiple sheet Answer: A View answer Hide answer View answer Hide answer A) Local sections returned by a question. B) Computed segments made with a DAX articulation. C) Measures made by a DAX articulation. D) Gatherings made inside a table utilizing the "New Group" Command in Power BI Desktop. Answer: B View answer Hide answer A) Right-click on the POPULATION column and choose FORMAT... B) Go to the FIELD FORMATTING category of the table's properties, choose the POPULATION field and tick the THOUSANDS SEPARATOR box C) You can't. D) Go to the underlying table in DATA view, select the POPULATION column, and on the MODELING tab of the ribbon tick the THOUSANDS SEPARATOR icon. Answer: D View answer Hide answer A) Removes the applied step that has errors. B) Removes the error warnings but keeps all data intact. C) Blanks the cell values which have errors. D) Removes any rows with errors. Answer: D View answer Hide answer A) Scatter Chart B) Bubble Chart C) Treemap D) Pie Chart Answer: B View answer Hide answer A) The Power BI desktop file opens. B) The report from which the tile was pinned opens. C) The Power BI desktop file gets downloaded. D) The tile you selected expands and takes the full space. Answer: D View answer Hide answer A) In Power BI Desktop, go into the Relationships see, select the table, and select Modeling and Synonyms. B) In the Power BI benefit, go into the Relationships see, select the table, and select Modeling and Synonyms. C) In Power BI Desktop go to the report - > select the visual, modelling, Q and A Terms. D) None of these Answer: A View answer Hide answer A) FINALBALANCE B) LASTNONBLANK C) BALANCE D) LATESTVALID Answer: B View answer Hide answer A) IF(OR((([HireDate]-[TermDate])*-1) >= 61,ISBLANK([TermDate])),0,1). B) You can reference another measure in a DAX expression by just typing an opening bracket ([). C) Every time you interact with your report, you are changing the context in which a measure calculates and displays its results. D) You can create a new measure by clicking on the New Measure button in the ribbon on Power BI Desktop’s Home tab. Answer: A View answer Hide answer A) You can not change over section information composes when altering an inquiry. B) You can not add computed segments to the information show. C) All inquiries inside the venture must be founded on a solitary source database. D) You can not add measures to the information demonstrate. Answer: A View answer Hide answer A) Capacity B) Dataframe C) Rundown D) Record Answer: B View answer Hide answer A) C B) C++ C) Q D) M Answer: D View answer Hide answer A)Category B)X Axis C)Y Axis D)Size Answer: A & C View answer Hide answer A) They can't edit any content in this dashboard or report. B) They can change any filters/slicers available on the reports connected to the dashboard and save their changes. C) People outside your organization can't see any data if role- or row-level security is implemented on on-premises Analysis Services tabular models. Answer: B View answer Hide answer A) SEARCH( “ex”, [ProductCode] ) B) FIND( “ex”, [ProductCode] ) Answer: A View answer Hide answer A) At the highest point of a dashboard in the Power BI benefit. B) By tapping on Modeling and Synonyms in Power BI work area. C) At the highest point of a report in the Power BI benefit. D) None of these. Answer: C View answer Hide answer A) Vertical stacking B) Stack-order C) a-order D) z-order Answer: D View answer Hide answer A) You must refresh the data manually after publishing to the web. B) You cannot refresh data after publishing to the web, the visuals are static. C) The user does not have the appropriate row level security permissions. D) It takes up to an hour for data to refresh. Answer: D View answer Hide answer A) Visual Level Filter B) Page Level Filter C) Report Level Filter D) Query Level Filter Answer: B View answer Hide answer A) 1 to 1 relationship B) One to many Relationship C) Many to Many Relationships D) Many to one Relationship Answer: B View answer Hide answer A) 1,2, and 3. B) 1,2, and 4. C) 2,3, and 4. D) 1,2,3, and 4. Answer: C View answer Hide answer A) Line B) Combo C) Bullet D) WaterFall Answer: D View answer Hide answer A) Pie Chart B) Scatter C) Bar Chart D) Line Chart Answer: B View answer Hide answer A) The inner or outer text for any valid HTML tag. B) The HTML for the page. C) Any parts of the HTML page rendered with the DATA_PACKET tab. D) One or more of the valid HTML tables on the web page. Answer: D View answer Hide answer A) Cross Table B) Matrix C) Line D) Guage Answer: B View answer Hide answer A) A connection between two tables must be characterized utilizing a solitary field from each table. B) No less than one section characterized in a table relationship must contain interesting qualities. C) You can characterize different connections between two tables in an information demonstrate however just a single of the connections can be set apart as dynamic. Answer: C View answer Hide answer A) local B) [blank] C) host D) localhost Answer: D View answer Hide answer A) One Page B) All Pages C) One Visualization D) Multiple Visualizations in same page Answer: B View answer Hide answer A) KPI Chart B) Guage Chart C) Combo Chart D) Stacked Bar Chart Answer: C View answer Hide answer How to Answer A business intelligence analyst can concentrate on various industries, such as finance, economics, IT, statistics, manufacturing, and more. Share with the interviewer which area you specialized in while obtaining your university degree, and briefly outline where your career journey has taken you so far. Make sure to demonstrate a keen interest in the company’s industry or business sphere. Answer Example “I’m a Finance Graduate specialized in Business Administration. My education has helped me greatly on my business intelligence career path, as my interest and expertise evolved in fields such as business law, microeconomics, and financial accounting.” View answer Hide answer The hiring authority wants to see that you have basic knowledge when it comes to the diagrams and charts that you will be using during your business analyst career. Some examples include: The interviewer wants to check your basic knowledge of charts you’ll be using in your BI analyst’s tasks. Some examples include: area charts; bar charts; clustered column charts; combo charts; doughnut charts; funnel charts; gauge charts; line charts; pie charts; scatter plots; waterfall charts. You are probably familiar with most of these, so just choose two options which you have experience with and can easily talk about. Answer Example “The two types of charts I use most often are area charts and bar charts. In my role as BI analyst, area charts have helped me display where a specific trend is headed in the future, which, in turn, makes planning easier. Bar charts, on the other hand, can show clearly which products are most popular among customers or display the number of unique visitors on a landing page based on various criteria.” View answer Hide answer How to Answer Agile software development has received a warm welcome from companies worldwide since its onset. Agile stimulates collaboration with a team’s clients and the end-users, enabling more cross-functional projects to run smoothly. However, there are still some who strongly prefer the structured development methodology of Waterfall, for example. So, before sharing your thoughts on Agile with the interviewer, make sure you know where the company stands on Agile. Answer Example “As far as I know, Agile software development is much more collaborative in comparison to other software development models. I believe Agile can be the best solution in many projects. However, maybe that’s not always the case. That said, I’d love to get familiar with the methodologies employed here. At the end of the day, it’s the end results that matter most, and not the methodologies behind the projects.” View answer Hide answer How to Answer Your BI analyst experience and skillset are closely related to the focus of your career. Depending on whether you are a data BI analyst, an IT BI analyst, or a strategic BI analyst, your answer to this question will be different. If you’re applying for a data-focused role, your technical skillset may include proficiency in data analysis software and visual presentation tools, such as Power BI. A BI analyst in the IT field would probably have exposure to some software development programs. While a strategic BI analyst would be well-familiar with business case analysis software and applications. Taking that into consideration, share with the interviewer the technical skills you will bring to the company. Answer Example “As a data BI analyst, I’ve been exposed to data mining and big data software, such as LIONsolver and Oracle. I’m highly skilled in Microsoft Excel which I use for data modeling and Power BI where I create rich visuals and client presentations.” View answer Hide answer Question: Shall we use Import method or Direct Query Method for our developement if we have all the tables in Oracle Server?
Question: What should we do share our report with the users within our organization? If we use import method, the secured data would be pushed to cloud which we don't want currently as we don't have license yet.
Question: If we use Direct Query method, we need to create Personal Gateway to connect to database so that we can see data in the reports.
Question: There are some limitations in the Direct Query Method e.g. Merge Two columns not supported in Direct Query. If have many limitations in Direct Query approach, is it worth doing the development using this approach?
Question: Is it safe if we publish the datamodel to the service and have on premise personal gateway to connect to db? Because I am putting tns entry of my database on services.
Check Other Interview Questions Join 1200+ companies in 75+ countries. Try the most candidate friendly skills assessment tool today. |